Schema for xenoMrna
  Database: droPer1    Primary Table: xenoMrna    Row Count: 3,132,563   Data last updated: 2016-02-15
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 73smallint(5) unsigned
matches 77int(10) unsigned
misMatches 7int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 5int(10) unsigned
tBaseInsert 353666int(10) unsigned
strand ++char(2)
qName BC015259varchar(255)
qSize 3404int(10) unsigned
qStart 2887int(10) unsigned
qEnd 2971int(10) unsigned
tName super_0varchar(255)
tSize 11822988int(10) unsigned
tStart 4215int(10) unsigned
tEnd 357965int(10) unsigned
blockCount 6int(10) unsigned
blockSizes 15,3,11,16,2,37,longblob
qStarts 2887,2902,2905,2916,2932,2934,longblob
tStarts 4215,4301,4886,55458,55564,...longblob

Connected Tables and Joining Fields
        droPer1.xenoRefFlat.name (via xenoMrna.qName)
      droPer1.xenoRefGene.name (via xenoMrna.qName)
      droPer1.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
7377700005353666++BC015259340428872971super_0118229884215357965615,3,11,16,2,37,2887,2902,2905,2916,2932,2934,4215,4301,4886,55458,55564,357928,
731041100347594312278++HP48388070237385612super_0118229884882317275524,24,18,23,26,738,4783,5534,5563,5586,4882,33775,39359,39831,317249,
731041100347594312278++HP48388170197345608super_0118229884882317275524,24,18,23,26,734,4779,5530,5559,5582,4882,33775,39359,39831,317249,
731041100347654312278++HP48388270257345614super_0118229884882317275524,24,18,23,26,734,4785,5536,5565,5588,4882,33775,39359,39831,317249,
731041100347654312278++HP48388370297385618super_0118229884882317275524,24,18,23,26,738,4789,5540,5569,5592,4882,33775,39359,39831,317249,
731041100347694312278++HP48388570337385622super_0118229884882317275524,24,18,23,26,738,4793,5544,5573,5596,4882,33775,39359,39831,317249,
731041100347694312278++HP48388670297345618super_0118229884882317275524,24,18,23,26,734,4789,5540,5569,5592,4882,33775,39359,39831,317249,
731041100347754312278++HP48388770397385628super_0118229884882317275524,24,18,23,26,738,4799,5550,5579,5602,4882,33775,39359,39831,317249,
731051100347514312277++HP48388870127345601super_0118229884882317275525,24,18,23,26,734,4772,5523,5552,5575,4882,33775,39359,39831,317249,
731041100347754312278++HP48388970357345624super_0118229884882317275524,24,18,23,26,734,4795,5546,5575,5598,4882,33775,39359,39831,317249,

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