Schema for xenoMrna
  Database: danRer5    Primary Table: xenoMrna    Row Count: 4,971,171   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 57int(10) unsigned
misMatches 15int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 55int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 54int(10) unsigned
strand ++char(2)
qName JO668508varchar(255)
qSize 400int(10) unsigned
qStart 189int(10) unsigned
qEnd 316int(10) unsigned
tName Zv7_NA1varchar(255)
tSize 126708int(10) unsigned
tStart 20139int(10) unsigned
tEnd 20265int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 51,21,longblob
qStarts 189,295,longblob
tStarts 20139,20244,longblob

Connected Tables and Joining Fields
        danRer5.all_est.qName (via xenoMrna.qName)
      danRer5.all_mrna.qName (via xenoMrna.qName)
      danRer5.refGene.name (via xenoMrna.qName)
      danRer5.refSeqAli.qName (via xenoMrna.qName)
      danRer5.xenoRefGene.name (via xenoMrna.qName)
      danRer5.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
585571500155154++JO668508400189316Zv7_NA11267082013920265251,21,189,295,20139,20244,
585464000021955+-HP878722255186236Zv7_NA11267085840760412324,5,21,186,210,215,66296,66529,68280,
58537297000057476+-CR7252441433212681Zv7_NA1126708110391118336649,2,132,88,121,77,212,261,263,395,483,604,8372,8473,10065,14280,15523,16240,
585771600001596+-FX113005593093Zv7_NA1126708110395111084224,69,0,24,15624,16244,
58518542001121752+-JO50153513780228Zv7_NA1126708110395112374333,125,69,0,34,159,14334,15523,16244,
58519468001221753+-AK0029781522170434Zv7_NA1126708110395112410370,123,69,170,242,365,14298,15525,16244,
58519866000021751+-JO440070110674338Zv7_NA1126708110395112410370,125,69,74,144,269,14298,15523,16244,
58521369000021751+-HP5940291201540822Zv7_NA1126708110395112428388,125,69,540,628,753,14280,15523,16244,
585255780015135876+-JL5551744914388Zv7_NA1126708110395116604451,88,125,69,4,106,194,319,10104,14280,15523,16244,
585239820017535894+-AB384127767258654Zv7_NA1126708110395116610457,70,125,69,258,390,460,585,10098,14298,15523,16244,

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