Schema for xenoMrna
  Database: droAna2    Primary Table: xenoMrna    Row Count: 3,395,334   Data last updated: 2016-02-15
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 192int(10) unsigned
misMatches 117int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 98int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 99int(10) unsigned
strand ++char(2)
qName EZ957631varchar(255)
qSize 582int(10) unsigned
qStart 151int(10) unsigned
qEnd 558int(10) unsigned
tName scaffold_10009varchar(255)
tSize 13469int(10) unsigned
tStart 92int(10) unsigned
tEnd 500int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 108,201,longblob
qStarts 151,357,longblob
tStarts 92,299,longblob

Connected Tables and Joining Fields
        droAna2.all_mrna.qName (via xenoMrna.qName)
      droAna2.xenoRefFlat.name (via xenoMrna.qName)
      droAna2.xenoRefGene.name (via xenoMrna.qName)
      droAna2.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
58519211700198199++EZ957631582151558scaffold_1000913469925002108,201,151,357,92,299,
5857417001872455++AB189723212913551533scaffold_1001752236451191316,21,54,1355,1371,1479,645,826,1137,
58587140011421206+-EU9418833243246scaffold_10020158541455514862233,68,3,178,992,1231,
585122190011461210+-CU2312813778295scaffold_10020158541455514906275,66,8,229,948,1233,
585145240011201201+-HP639856594228517scaffold_100201585414555149252100,69,228,448,929,1230,
585138160011761236+-EZ532353772422752scaffold_100201585414555149452115,39,422,713,909,1260,
585208270032133220+-EZ934047415223442792scaffold_10020158541455515010433,116,18,68,2344,2411,2539,2724,844,909,1036,1231,
585208270032143220+-HP486452506831633612scaffold_10020158541455515010433,116,18,68,3163,3230,3358,3544,844,909,1036,1231,
585208270032143220+-HP486453533931633612scaffold_10020158541455515010433,116,18,68,3163,3230,3358,3544,844,909,1036,1231,
585208270032143220+-HP486454505931543603scaffold_10020158541455515010433,116,18,68,3154,3221,3349,3535,844,909,1036,1231,

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