c6c78fad34eec2a1aedc5726fad5050fc274730d
max
  Thu Jan 9 06:49:36 2014 -0800
adding field descriptions, rm #12212
diff --git src/hg/lib/pubsBingBlat.sql src/hg/lib/pubsBingBlat.sql
new file mode 100644
index 0000000..f68ecc3
--- /dev/null
+++ src/hg/lib/pubsBingBlat.sql
@@ -0,0 +1,21 @@
+#publications blat feature table, in bed12+ format, additional field seqIds and seqRanges
+CREATE TABLE `pubsBlat` (
+  `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, # internal articleId, article that matches here
+  `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 clue
+  `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
+  `tSeqTypes` varchar(255) NOT NULL, # comma-seq list of matching sequence db (g=genome, p=protein, c=cDNA)
+  `seqIds` blob NOT NULL, # comma-separated list of matching seqIds
+  `seqRanges` blob NOT NULL, # ranges start-end on sequence that matched, one for each seqId 
+  KEY `name` (`name`(16)),
+  KEY `chrom` (`chrom`(6)),
+  KEY `chromStartAndName` (`chrom`(6), chromStart, name)
+);