d07b35a4251fd13b1857b2cc513fd42446bf30cc
max
  Thu Jan 16 04:09:56 2014 -0800
fixed some more typos in pubs as/sql files
diff --git src/hg/lib/pubsBlat.sql src/hg/lib/pubsBlat.sql
index f68ecc3..50ef4a0 100644
--- src/hg/lib/pubsBlat.sql
+++ src/hg/lib/pubsBlat.sql
@@ -3,19 +3,32 @@
   `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 
+  `publisher` varchar(255) NOT NULL, # publisher of article, for hgTracks feature filter
+  `pmid` varchar(255) NOT NULL, # PMID of article, for annoGrator output, avoids table join
+  `doi` varchar(255) NOT NULL, # doi of article, for annoGrator output, avoids table join
+  `issn` varchar(255) NOT NULL, # issn of journal 
+  `journal` varchar(255) NOT NULL, # name of journal
+  `title` varchar(255) NOT NULL, # title of article, for genome browser mouseover
+  `firstAuthor` varchar(255) NOT NULL, # first author family name of article, for genome browser
+  `year` varchar(255) NOT NULL, # year of article, for genome browser
+  `impact` varchar(255) NOT NULL, # impact factor of journal, for genome browser coloring, derived from official impact factors: max impact is 25, value is scaled to 0-255
+  `classes` varchar(255) NOT NULL, # classes assigned to journal article, for genome browser coloring
+  `locus` varchar(255) NOT NULL, # closest gene symbols, one or two, comma-separated
   KEY `name` (`name`(16)),
+  KEY `pmid` (`pmid`(16)),
+  KEY `doi` (`doi`(16)),
   KEY `chrom` (`chrom`(6)),
   KEY `chromStartAndName` (`chrom`(6), chromStart, name)
 );