Schema for xenoMrna
  Database: anoCar1    Primary Table: xenoMrna    Row Count: 5,177,047   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 587smallint(5) unsigned
matches 773int(10) unsigned
misMatches 139int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 1int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 2int(10) unsigned
strand +-char(2)
qName AY138806varchar(255)
qSize 1173int(10) unsigned
qStart 183int(10) unsigned
qEnd 1096int(10) unsigned
tName scaffold_0varchar(255)
tSize 16654889int(10) unsigned
tStart 284228int(10) unsigned
tEnd 285142int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 882,30,longblob
qStarts 183,1066,longblob
tStarts 16369747,16370631,longblob

Connected Tables and Joining Fields
        anoCar1.all_mrna.qName (via xenoMrna.qName)
      anoCar1.xenoRefFlat.name (via xenoMrna.qName)
      anoCar1.xenoRefGene.name (via xenoMrna.qName)
      anoCar1.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
587773139001112+-AY13880611731831096scaffold_0166548892842282851422882,30,183,1066,16369747,16370631,
58730247010000+-FJ4181723720350scaffold_0166548892842552846051350,0,16370284,
587768119000000+-AJ314853140051938scaffold_0166548892842552851421887,51,16369747,
587740147000000+-AK04646420146111498scaffold_0166548892842552851421887,611,16369747,
587740147000000+-BC14031512372201107scaffold_0166548892842552851421887,220,16369747,
587728159000000+-EU28341212812181105scaffold_0166548892842552851421887,218,16369747,
587740144000033+-M9765614613061190scaffold_0166548892842552851424572,23,5,284,306,878,901,906,16369747,16370320,16370344,16370350,
587744143000000+-X6231436153301217scaffold_0166548892842552851421887,330,16369747,
587747146000000+-L0291516994161309scaffold_0166548892842552851481893,416,16369741,
587752132000000+-AB38493611901951079scaffold_0166548892842582851421884,195,16369747,

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