c8f3ff3c555def2c55f0c498fe0eb24df8c29b6c hiram Fri Feb 2 11:35:26 2024 -0800 name changed to asmSummary refs #23589 diff --git src/hg/lib/genomeData.sql src/hg/lib/genomeData.sql deleted file mode 100644 index fb2ec78..0000000 --- src/hg/lib/genomeData.sql +++ /dev/null @@ -1,47 +0,0 @@ -# genomeData.sql was originally generated by the autoSql program, which also -# generated genomeData.c and genomeData.h. This creates the database representation of -# an object which can be loaded and saved from RAM in a fairly -# automatic way. - -#SQL table for NCBI assembly_summary data. -CREATE TABLE genomeData ( - assemblyAccession varchar(255) NOT NULL, # assemblyAccession - bioproject varchar(255), # bioproject - biosample varchar(255), # biosample - wgsMaster varchar(255), # wgsMaster - refseqCategory varchar(255), # refseqCategory - taxId int unsigned NOT NULL, # taxId - speciesTaxid int unsigned NOT NULL, # speciesTaxid - organismName varchar(255) NOT NULL, # organismName - infraspecificName varchar(255), # infraspecificName - isolate varchar(255), # isolate - versionStatus varchar(255) NOT NULL, # versionStatus - assemblyLevel varchar(255) NOT NULL, # assemblyLevel - releaseType varchar(255) NOT NULL, # releaseType - genomeRep varchar(255) NOT NULL, # genomeRep - seqRelDate varchar(255) NOT NULL, # seqRelDate - asmName varchar(255) NOT NULL, # asmName - asmSubmitter varchar(255), # asmSubmitter - gbrsPairedAsm varchar(255), # gbrsPairedAsm - pairedAsmComp varchar(255), # pairedAsmComp - ftpPath varchar(255), # ftpPath - excludedFromRefseq varchar(255), # excludedFromRefseq - relationToTypeMaterial varchar(255), # relationToTypeMaterial - assemblyType tinyint unsigned NOT NULL, # assemblyType - phyloGroup varchar(255) NOT NULL, # phyloGroup - genomeSize bigint NOT NULL, # genomeSize - genomeSizeUngapped bigint NOT NULL, # genomeSizeUngapped - gcPercent float NOT NULL, # gcPercent - repliconCount smallint unsigned NOT NULL, # repliconCount - scaffoldCount int unsigned NOT NULL, # scaffoldCount - contigCount int unsigned NOT NULL, # contigCount - annotationProvider varchar(255) NOT NULL, # annotationProvider - annotationName varchar(255) NOT NULL, # annotationName - annotationDate varchar(255) NOT NULL, # annotationDate - totalGeneCount varchar(255), # totalGeneCount - proteinCodingGeneCount int unsigned, # proteinCodingGeneCount - nonCodingGeneCount varchar(255), # nonCodingGeneCount - pubmedId varchar(255), # pubmedId - #Indices - PRIMARY KEY(assemblyAccession) -);