Schema for xenoMrna
  Database: bosTau4    Primary Table: xenoMrna    Row Count: 6,093,765   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 74int(10) unsigned
misMatches 9int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 11int(10) unsigned
tNumInsert 3int(10) unsigned
tBaseInsert 41119int(10) unsigned
strand ++char(2)
qName HP553033varchar(255)
qSize 3425int(10) unsigned
qStart 2107int(10) unsigned
qEnd 2201int(10) unsigned
tName chr1varchar(255)
tSize 161106243int(10) unsigned
tStart 5976int(10) unsigned
tEnd 47178int(10) unsigned
blockCount 4int(10) unsigned
blockSizes 24,10,19,30,longblob
qStarts 2107,2131,2141,2171,longblob
tStarts 5976,45193,45761,47148,longblob

Connected Tables and Joining Fields
        bosTau4.all_est.qName (via xenoMrna.qName)
      bosTau4.all_mrna.qName (via xenoMrna.qName)
      bosTau4.refGene.name (via xenoMrna.qName)
      bosTau4.refSeqAli.qName (via xenoMrna.qName)
      bosTau4.xenoRefFlat.name (via xenoMrna.qName)
      bosTau4.xenoRefGene.name (via xenoMrna.qName)
      bosTau4.xenoRefSeqAli.qName (via xenoMrna.qName)
      hgFixed.gbCdnaInfo.acc (via xenoMrna.qName)
      hgFixed.gbMiscDiff.acc (via xenoMrna.qName)
      hgFixed.gbSeq.acc (via xenoMrna.qName)
      hgFixed.gbWarn.acc (via xenoMrna.qName)
      hgFixed.imageClone.acc (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
58574900111341119++HP553033342521072201chr1161106243597647178424,10,19,30,2107,2131,2141,2171,5976,45193,45761,47148,
58574900111341119++HP553034343821072201chr1161106243597647178424,10,19,30,2107,2131,2141,2171,5976,45193,45761,47148,
58574900111341119++HP553038342121032197chr1161106243597647178424,10,19,30,2103,2127,2137,2167,5976,45193,45761,47148,
58574900111341119++HP553039343421032197chr1161106243597647178424,10,19,30,2103,2127,2137,2167,5976,45193,45761,47148,
58574900111341119++HP553040330219712065chr1161106243597647178424,10,19,30,1971,1995,2005,2035,5976,45193,45761,47148,
58574900111341119++HP553041328919712065chr1161106243597647178424,10,19,30,1971,1995,2005,2035,5976,45193,45761,47148,
5856922350013113947++BC131999101219949chr116110624327286421603666,77,184,19,688,765,27286,27952,41976,
5856932340013113947++BC132001100919949chr116110624327286421603666,77,184,19,688,765,27286,27952,41976,
5857252000013113947++BC14014597315943chr116110624327288421603667,65,193,15,685,750,27288,27955,41967,
5857252000013113947++BC14316797315943chr116110624327288421603667,65,193,15,685,750,27288,27955,41967,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.