Schema for xenoMrna
  Database: monDom4    Primary Table: xenoMrna    Row Count: 5,609,113   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 178int(10) unsigned
misMatches 23int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 2int(10) unsigned
tBaseInsert 6285int(10) unsigned
strand +-char(2)
qName AY491058varchar(255)
qSize 648int(10) unsigned
qStart 24int(10) unsigned
qEnd 225int(10) unsigned
tName chr1varchar(255)
tSize 748055161int(10) unsigned
tStart 685int(10) unsigned
tEnd 7171int(10) unsigned
blockCount 3int(10) unsigned
blockSizes 57,74,70,longblob
qStarts 24,81,155,longblob
tStarts 748047990,748052566,748054406,longblob

Connected Tables and Joining Fields
        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)
      monDom4.all_est.qName (via xenoMrna.qName)
      monDom4.all_mrna.qName (via xenoMrna.qName)
      monDom4.refGene.name (via xenoMrna.qName)
      monDom4.refSeqAli.qName (via xenoMrna.qName)
      monDom4.xenoRefFlat.name (via xenoMrna.qName)
      monDom4.xenoRefGene.name (via xenoMrna.qName)
      monDom4.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
58517823000026285+-AY49105864824225chr17480551616857171357,74,70,24,81,155,748047990,748052566,748054406,
585243750012147766+-DQ3729644710339chr17480551616858769569,49,56,74,70,0,90,139,195,269,748046392,748047183,748047991,748052566,748054406,
58530160000047745+-BC15737316130361chr17480551616858791597,64,56,74,70,0,97,161,217,291,748046370,748047168,748047991,748052566,748054406,
58534339000047745+-AY2700355140382chr174805516168588125118,64,56,74,70,0,118,182,238,312,748046349,748047168,748047991,748052566,748054406,
58533351000047745+-U824425160384chr174805516168588145120,64,56,74,70,0,120,184,240,314,748046347,748047168,748047991,748052566,748054406,
585252930016337808+-AF0520602078239647chr174805516168588384144,57,74,70,239,446,503,577,748046323,748047990,748052566,748054406,
58547467000058282+-AL83282831190541chr174805516168595086120,157,64,56,74,70,0,120,277,341,397,471,748045653,748046310,748047168,748047991,748052566,748054406,
58549392000058282+-CT030628186988673chr174805516168595526161,160,64,56,74,70,88,249,409,473,529,603,748045609,748046307,748047168,748047991,748052566,748054406,
58551379000058282+-U92702301536628chr174805516168595596171,157,64,56,74,70,36,207,364,428,484,558,748045602,748046310,748047168,748047991,748052566,748054406,
58551379000058282+-U92704288036628chr174805516168595596171,157,64,56,74,70,36,207,364,428,484,558,748045602,748046310,748047168,748047991,748052566,748054406,

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