Schema for xenoMrna
  Database: dm1    Primary Table: xenoMrna    Row Count: 1,867,749   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 45int(10) unsigned
misMatches 12int(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 AK117529varchar(255)
qSize 1789int(10) unsigned
qStart 945int(10) unsigned
qEnd 1002int(10) unsigned
tName chr2Lvarchar(255)
tSize 22217931int(10) unsigned
tStart 8727int(10) unsigned
tEnd 8784int(10) unsigned
blockCount 1int(10) unsigned
blockSizes 57,longblob
qStarts 945,longblob
tStarts 8727,longblob

Connected Tables and Joining Fields
        dm1.all_est.qName (via xenoMrna.qName)
      dm1.all_mrna.qName (via xenoMrna.qName)
      dm1.refGene.name (via xenoMrna.qName)
      dm1.refSeqAli.qName (via xenoMrna.qName)
      dm1.xenoRefGene.name (via xenoMrna.qName)
      dm1.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
5854512000000++AK11752917899451002chr2L2221793187278784157,945,8727,
585240123000000++EU21180256825388chr2L22217931881791801363,25,8817,
5857236000000+-AK0836722004214322chr2L2221793112551126591108,214,22205272,
5857236000000+-BC0434582340539647chr2L2221793112551126591108,539,22205272,
5859552001105184+-BC097696232910521304chr2L222179311255112782257,90,1052,1214,22205149,22205290,
58519210800293321575+-AK08438632873791612chr2L222179311255114426372,120,108,379,529,1504,22203505,22203670,22205272,
58519210800293421575+-BC00601729491121346chr2L222179311255114426372,120,108,112,262,1238,22203505,22203670,22205272,
58520413500288821536+-BC070788505814512678chr2L222179311255114426396,135,108,1451,1589,2570,22203505,22203658,22205272,
585169104002216622878+-BC07292436882222661chr2L2221793112551157023126,57,90,222,2409,2571,22202229,22205149,22205290,
585213141002213022797+-D5055038061352619chr2L2221793112551157023126,120,108,135,1536,2511,22202229,22203670,22205272,

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