Schema for xenoMrna
  Database: monDom1    Primary Table: xenoMrna    Row Count: 6,335,230   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 45int(10) unsigned
misMatches 15int(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 X68158varchar(255)
qSize 2088int(10) unsigned
qStart 2int(10) unsigned
qEnd 62int(10) unsigned
tName scaffold_10006varchar(255)
tSize 12060int(10) unsigned
tStart 317int(10) unsigned
tEnd 377int(10) unsigned
blockCount 1int(10) unsigned
blockSizes 60,longblob
qStarts 2,longblob
tStarts 317,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)
      monDom1.all_mrna.qName (via xenoMrna.qName)
      monDom1.xenoRefFlat.name (via xenoMrna.qName)
      monDom1.xenoRefGene.name (via xenoMrna.qName)
      monDom1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
5854515000000++X681582088262scaffold_1000612060317377160,2,317,
5854212000000++AK0109472138865919scaffold_100201295376430154,865,376,
5854212000000++AK0858441937660714scaffold_100201295376430154,660,376,
5854212000000++BC0274262138848902scaffold_100201295376430154,848,376,
5857743000000+-M182162527751871scaffold_1002715603985181120,751,1042,
5857743000000+-M295411189798918scaffold_1002715603985181120,798,1042,
5857842000000+-AK3125421139809929scaffold_1002715603985181120,809,1042,
5857842000000+-AY8897151035705825scaffold_1002715603985181120,705,1042,
5857842000000+-BC0050082249745865scaffold_1002715603985181120,745,1042,
5857842000000+-BT0097741035705825scaffold_1002715603985181120,705,1042,

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