7f33fb42a1fb58a02a3f798e56332e5beac65133 max Sat Mar 17 13:21:09 2012 -0700 renaming all publications tracks tables to pubsXXXX diff --git src/hg/lib/pubsSequenceAnnot.sql src/hg/lib/pubsSequenceAnnot.sql new file mode 100644 index 0000000..1a3afea --- /dev/null +++ src/hg/lib/pubsSequenceAnnot.sql @@ -0,0 +1,13 @@ +#Text to Genome project sequence data table +CREATE TABLE t2gSequence ( + articleId bigint not null, # identifier of the article where the sequence was found + fileId int not null, # identifier of the file where the sequence was found + seqId bigint not null, # unique identifier of this sequence within a file + fileDesc varchar(2000) not null, # description of file where sequence was found + sequence longblob not null, # sequence + snippet longblob not null, # flanking characters around sequence in article + locations varchar(5000), # comma-sep list of genomic locations where this sequence matches + #Indices + KEY seqIdIdx(seqId), + KEY artIdIdx(articleId) +);