Schema for xenoMrna
  Database: dp3    Primary Table: xenoMrna    Row Count: 2,425,699   Data last updated: 2016-02-15
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 197int(10) unsigned
misMatches 20int(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 AY113345varchar(255)
qSize 3012int(10) unsigned
qStart 754int(10) unsigned
qEnd 971int(10) unsigned
tName chr2varchar(255)
tSize 30711475int(10) unsigned
tStart 1606int(10) unsigned
tEnd 1823int(10) unsigned
blockCount 1int(10) unsigned
blockSizes 217,longblob
qStarts 754,longblob
tStarts 30709652,longblob

Connected Tables and Joining Fields
        dp3.all_est.qName (via xenoMrna.qName)
      dp3.all_mrna.qName (via xenoMrna.qName)
      dp3.xenoRefFlat.name (via xenoMrna.qName)
      dp3.xenoRefGene.name (via xenoMrna.qName)
      dp3.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
58519720000000+-AY1133453012754971chr230711475160618231217,754,30709652,
58513545001100+-EZ6031071056384565chr230711475160717872108,72,384,493,30709688,30709796,
5855211000000+-EZ603108262196259chr23071147517241787163,196,30709688,
58591930400263254++FJ6333721357531339chr23071147546825959315,23,1185,53,75,154,4682,4701,4774,
58592530400263254++AY11901816291351427chr23071147546825965315,23,1191,135,157,236,4682,4701,4774,
58510146000000+-EU413436781451598chr230711475477649231147,451,30706552,
5858649000000++HP473238430293428chr230711475477749121135,293,4777,
5859057000000++AF3970141323160307chr230711475477749241147,160,4777,
58515279000000++BX037181466136367chr230711475477750081231,136,4777,
5852871810021292129++HP437825784154751chr230711475477753743147,72,249,154,400,502,4777,5023,5125,

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