c4500309e004c1ccdcf8741930bba103e7cd8631 max Mon Mar 12 13:14:39 2012 -0700 trying to make necessary changes to all.joiner and .sql files for qa diff --git src/hg/lib/t2g.sql src/hg/lib/t2g.sql index 6f79ca3..8a54645 100644 --- src/hg/lib/t2g.sql +++ src/hg/lib/t2g.sql @@ -1,19 +1,19 @@ #Text to Genome project feature table, in bed12+ format, additional field seqIds CREATE TABLE `t2g` ( `chrom` varchar(255) NOT NULL, # chromosome `chromStart` int(10) unsigned NOT NULL, # start position on chromosome `chromEnd` int(10) unsigned NOT NULL, # end position on chromosome - `name` varchar(255) NOT NULL, #name of feature + `name` varchar(255) NOT NULL, # displayId of article `score` int(10) unsigned NOT NULL, # score of feature `strand` char(1) NOT NULL, # strand of feature `thickStart` int(10) unsigned NOT NULL, # start of exons `thickEnd` int(10) unsigned NOT NULL, #end of exons `reserved` int(10) unsigned NOT NULL, # no idea `blockCount` int(10) unsigned NOT NULL, # number of blocks `blockSizes` longblob NOT NULL, # size of blocks `chromStarts` longblob NOT NULL, # A comma-separated list of block starts - `seqIds` longblob NOT NULL, # comma-separated list of sequenceIds used to generate this feature, require a trailing comma at the end + `seqIds` longblob NOT NULL, # comma-separated list of sequenceIds used to generate this feature, links out to hgFixed.t2gSequenceAnnot KEY `name` (`name`(16)), KEY `chrom` (`chrom`(6)), KEY `chromStartAndName` (`chrom`(6), chromStart, name) );