Schema for xenoMrna
  Database: danRer3    Primary Table: xenoMrna    Row Count: 6,245,651   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 73smallint(5) unsigned
matches 511int(10) unsigned
misMatches 212int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 9int(10) unsigned
tNumInsert 2int(10) unsigned
tBaseInsert 122544int(10) unsigned
strand +-char(2)
qName AK074741varchar(255)
qSize 2231int(10) unsigned
qStart 245int(10) unsigned
qEnd 977int(10) unsigned
tName chr1varchar(255)
tSize 55805710int(10) unsigned
tStart 9149int(10) unsigned
tEnd 132416int(10) unsigned
blockCount 3int(10) unsigned
blockSizes 160,395,168,longblob
qStarts 245,405,809,longblob
tStarts 55673294,55767542,55796393,longblob

Connected Tables and Joining Fields
        danRer3.all_est.qName (via xenoMrna.qName)
      danRer3.all_mrna.qName (via xenoMrna.qName)
      danRer3.refGene.name (via xenoMrna.qName)
      danRer3.refSeqAli.qName (via xenoMrna.qName)
      danRer3.xenoRefGene.name (via xenoMrna.qName)
      danRer3.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
7351121200192122544+-AK0747412231245977chr15580571091491324163160,395,168,245,405,809,55673294,55767542,55796393,
7351221100192122544+-CR85768333557551487chr15580571091491324163160,395,168,755,915,1319,55673294,55767542,55796393,
7351321000192122544+-AF10526727317441476chr15580571091491324163160,395,168,744,904,1308,55673294,55767542,55796393,
7351321000192122544+-AF11117826447931525chr15580571091491324163160,395,168,793,953,1357,55673294,55767542,55796393,
7351321000192122544+-AK29014423973121044chr15580571091491324163160,395,168,312,472,876,55673294,55767542,55796393,
7351321000192122544+-AY35846225797241456chr15580571091491324163160,395,168,724,884,1288,55673294,55767542,55796393,
7351321000192122544+-BC10694725456391371chr15580571091491324163160,395,168,639,799,1203,55673294,55767542,55796393,
7353019300192122544+-AK13253123615351267chr15580571091491324163158,397,168,535,693,1099,55673294,55767540,55796393,
7353019300192122544+-AK14931223985651297chr15580571091491324163158,397,168,565,723,1129,55673294,55767540,55796393,
7353019300192122544+-AK16466837828001532chr15580571091491324163158,397,168,800,958,1364,55673294,55767540,55796393,

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