Schema for xenoMrna
  Database: danRer4    Primary Table: xenoMrna    Row Count: 5,439,838   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 129int(10) unsigned
misMatches 42int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 0int(10) unsigned
tBaseInsert 0int(10) unsigned
strand +-char(2)
qName DQ836027varchar(255)
qSize 551int(10) unsigned
qStart 244int(10) unsigned
qEnd 415int(10) unsigned
tName chr1varchar(255)
tSize 70589895int(10) unsigned
tStart 7148int(10) unsigned
tEnd 7319int(10) unsigned
blockCount 1int(10) unsigned
blockSizes 171,longblob
qStarts 244,longblob
tStarts 70582576,longblob

Connected Tables and Joining Fields
        danRer4.all_est.qName (via xenoMrna.qName)
      danRer4.all_mrna.qName (via xenoMrna.qName)
      danRer4.refGene.name (via xenoMrna.qName)
      danRer4.refSeqAli.qName (via xenoMrna.qName)
      danRer4.xenoRefGene.name (via xenoMrna.qName)
      danRer4.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
58512942000000+-DQ836027551244415chr170589895714873191171,244,70582576,
5854410000000+-AK199719277357chr17058989571547208154,3,70582687,
585489000000+-AK192251278158chr17058989571547211157,1,70582684,
585489000000+-AK208210278158chr17058989571547211157,1,70582684,
5852986800211734088+-AK03490321610483chr170589895715411608430,90,102,144,0,30,201,339,70578287,70578489,70579799,70582597,
5853307500211734088+-BC043327229662584chr170589895715411647469,90,102,144,62,131,302,440,70578248,70578489,70579799,70582597,
58542310800211744174+-BC0040092632273921chr1705898957154118595126,69,90,102,144,273,399,468,639,777,70578036,70578248,70578489,70579799,70582597,
58542310800211744174+-BC027077243175723chr1705898957154118595126,69,90,102,144,75,201,270,441,579,70578036,70578248,70578489,70579799,70582597,
58581825900410801151055+-BC0303293902112168chr17058989571545928612111,102,3,152,72,22,84,126,69,90,102,144,11,122,224,227,379,451,971,1520,1646,1715,1886,2024,70530609,70532396,70532823,70533125,70533555,70535403,70556112,70578036,70578248,70578489,70579799,70582597,
73912990000000++EU1762011327253472chr254031504020289685202899041219,253,20289685,

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