4ba0a7d92cc93673915bb6f24ae81435ea179ce3
hiram
  Wed Jan 31 17:02:58 2024 -0800
beginning to add a searchable table of genome meta data refs #23589;

diff --git src/hg/lib/genomeData.as src/hg/lib/genomeData.as
new file mode 100644
index 0000000..08c89c5
--- /dev/null
+++ src/hg/lib/genomeData.as
@@ -0,0 +1,41 @@
+table genomeData
+"SQL table for NCBI assembly_summary data."
+    (
+    string assemblyAccession;	"assemblyAccession"
+    string bioproject;	"bioproject"
+    string biosample;	"biosample"
+    string wgsMaster;	"wgsMaster"
+    string refseqCategory;	"refseqCategory"
+    uint taxId;	"taxId"
+    uint speciesTaxid;	"speciesTaxid"
+    string organismName;	"organismName"
+    string infraspecificName;	"infraspecificName"
+    string isolate;	"isolate"
+    string versionStatus;	"versionStatus"
+    string assemblyLevel;	"assemblyLevel"
+    string releaseType;	"releaseType"
+    string genomeRep;	"genomeRep"
+    string seqRelDate;	"seqRelDate"
+    string asmName;	"asmName"
+    string asmSubmitter;	"asmSubmitter"
+    string gbrsPairedAsm;	"gbrsPairedAsm"
+    string pairedAsmComp;	"pairedAsmComp"
+    string ftpPath;	"ftpPath"
+    string excludedFromRefseq;	"excludedFromRefseq"
+    string relationToTypeMaterial;	"relationToTypeMaterial"
+    ubyte assemblyType;	"assemblyType"
+    string phyloGroup;	"phyloGroup"
+    bigint genomeSize;	"genomeSize"
+    bigint genomeSizeUngapped;	"genomeSizeUngapped"
+    float gcPercent;	"gcPercent"
+    ushort repliconCount;	"repliconCount"
+    uint scaffoldCount;	"scaffoldCount"
+    uint contigCount;	"contigCount"
+    string annotationProvider;	"annotationProvider"
+    string annotationName;	"annotationName"
+    string annotationDate;	"annotationDate"
+    string totalGeneCount;	"totalGeneCount"
+    uint proteinCodingGeneCount;	"proteinCodingGeneCount"
+    string nonCodingGeneCount;	"nonCodingGeneCount"
+    string pubmedId;	"pubmedId"
+    )