Schema for xenoMrna
  Database: droYak1    Primary Table: xenoMrna    Row Count: 3,683,043   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 89int(10) unsigned
misMatches 11int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 4int(10) unsigned
tBaseInsert 886int(10) unsigned
strand +-char(2)
qName AJ720766varchar(255)
qSize 2728int(10) unsigned
qStart 2600int(10) unsigned
qEnd 2700int(10) unsigned
tName chr2Lvarchar(255)
tSize 22678881int(10) unsigned
tStart 1int(10) unsigned
tEnd 987int(10) unsigned
blockCount 5int(10) unsigned
blockSizes 20,20,18,19,23,longblob
qStarts 2600,2620,2640,2658,2677,longblob
tStarts 22677894,22678135,22678376,...longblob

Connected Tables and Joining Fields
        droYak1.all_est.qName (via xenoMrna.qName)
      droYak1.all_mrna.qName (via xenoMrna.qName)
      droYak1.xenoRefFlat.name (via xenoMrna.qName)
      droYak1.xenoRefGene.name (via xenoMrna.qName)
      droYak1.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
585891100004886+-AJ720766272826002700chr2L226788811987520,20,18,19,23,2600,2620,2640,2658,2677,22677894,22678135,22678376,22678620,22678857,
58570500004906+-AK0381553564236311chr2L226788815986519,20,8,10,18,236,255,275,283,293,22677895,22678135,22678386,22678620,22678858,
5858311001104884+-BC057401401839094013chr2L226788819987620,20,2,20,18,14,3909,3929,3949,3961,3981,3999,22677894,22678135,22678374,22678376,22678617,22678858,
58548400002447+-AF320126423741504202chr2L22678881243742314,17,21,4150,4164,4181,22678139,22678379,22678617,
58548400002447+-BC067057443741834235chr2L22678881243742314,17,21,4183,4197,4214,22678139,22678379,22678617,
58545300002452+-AK076420489425492597chr2L22678881243743317,20,11,2549,2566,2586,22678138,22678376,22678627,
58546500002452+-BC057356406332503301chr2L22678881243746320,20,11,3250,3270,3290,22678135,22678376,22678627,
58546500002452+-BC080313406732483299chr2L22678881243746320,20,11,3248,3268,3288,22678135,22678376,22678627,
58555600002442+-AJ720766272826002661chr2L22678881243746320,20,21,2600,2620,2640,22678135,22678376,22678617,
58555600002442+-BC057401401838743935chr2L22678881243746320,20,21,3874,3894,3914,22678135,22678376,22678617,

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