d07b35a4251fd13b1857b2cc513fd42446bf30cc max Thu Jan 16 04:09:56 2014 -0800 fixed some more typos in pubs as/sql files diff --git src/hg/lib/pubsBingBlatPsl.sql src/hg/lib/pubsBingBlatPsl.sql index efa1e7b..bddb0d0 100644 --- src/hg/lib/pubsBingBlatPsl.sql +++ src/hg/lib/pubsBingBlatPsl.sql @@ -1,28 +1,28 @@ #publications track sequence matches as PSL plus two additional fields -CREATE TABLE `pubsBlatPsl` ( +CREATE TABLE `pubsBingBlatPsl` ( matches int unsigned not null, # Number of bases that match that aren't repeats misMatches int unsigned not null, # Number of bases that don't match repMatches int unsigned not null, # Number of bases that match but are part of repeats nCount int unsigned not null, # Number of 'N' bases qNumInsert int unsigned not null, # Number of inserts in query qBaseInsert int unsigned not null, # Number of bases inserted in query tNumInsert int unsigned not null, # Number of inserts in target tBaseInsert int unsigned not null, # Number of bases inserted in target strand char(2) not null, # + or - for query strand. second +/- for genomic strand qName varchar(255) not null, # sequence ID: 10 digits articleId, 3 digits file Id, 4 digits serial number qSize int unsigned not null, # Query sequence size qStart int unsigned not null, # Alignment start position in query qEnd int unsigned not null, # Alignment end position in query tName varchar(255) not null, # Target sequence name tSize int unsigned not null, # Target sequence size tStart int unsigned not null, # Alignment start position in target tEnd int unsigned not null, # Alignment end position in target blockCount int unsigned not null, # Number of blocks in alignment blockSizes longblob not null, # Size of each block qStarts longblob not null, # Start of each block in query. tStarts longblob not null, # Start of each block in target. articleId bigint(20) DEFAULT NULL, # articleId of article in hgFixed.pubsBingArticle # Indices KEY `tName` (`tName`(32),`tStart`,`tEnd`), KEY `articleId` (`articleId`) )