c6c78fad34eec2a1aedc5726fad5050fc274730d
max
  Thu Jan 9 06:49:36 2014 -0800
adding field descriptions, rm #12212
diff --git src/hg/lib/pubsBingSequenceAnnot.sql src/hg/lib/pubsBingSequenceAnnot.sql
new file mode 100644
index 0000000..548da98
--- /dev/null
+++ src/hg/lib/pubsBingSequenceAnnot.sql
@@ -0,0 +1,15 @@
+#publications track sequence data table
+CREATE TABLE pubsSequenceAnnot (
+    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
+    annotId bigint not null,    # articleId(10)+fileId(3)+seqId(5), refd by pubsSequenceAnnot
+    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 annotIdx(annotId),
+    KEY artIdIdx(articleId)
+);