Schema for xenoMrna
  Database: nomLeu2    Primary Table: xenoMrna    Row Count: 6,853,555   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 754int(10) unsigned
misMatches 23int(10) unsigned
repMatches 0int(10) unsigned
nCount 24int(10) unsigned
qNumInsert 3int(10) unsigned
qBaseInsert 123int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 116int(10) unsigned
strand ++char(2)
qName AK021982varchar(255)
qSize 2088int(10) unsigned
qStart 0int(10) unsigned
qEnd 924int(10) unsigned
tName ADFV01134425varchar(255)
tSize 126038int(10) unsigned
tStart 2226int(10) unsigned
tEnd 3143int(10) unsigned
blockCount 4int(10) unsigned
blockSizes 374,350,59,18,longblob
qStarts 0,493,845,906,longblob
tStarts 2226,2716,3066,3125,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)
      nomLeu2.xenoRefFlat.name (via xenoMrna.qName)
      nomLeu2.xenoRefGene.name (via xenoMrna.qName)
      nomLeu2.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
5857542302431231116++AK02198220880924ADFV01134425126038222631434374,350,59,18,0,493,845,906,2226,2716,3066,3125,
585854000000++DQ925676366277366ADFV011344251260383308333172189,277,33083,
5851071000000++AY364250157314571565ADFV0113442512603833092332001108,1457,33092,
585240150000146065+-JO5339518870255ADFV0113442512603833092794122149,106,0,149,46626,92840,
585240150000146065+-JO53395212180255ADFV0113442512603833092794122149,106,0,149,46626,92840,
5851704900133146101+-JO688102142057309ADFV0113442512603833092794122150,69,57,240,46626,92877,
5854585001396246457++AK000078217011351994ADFV0113442512603833092800123106,339,18,1135,1241,1976,33092,79263,79994,
5854585001396246457++AK225205217011351994ADFV0113442512603833092800123106,339,18,1135,1241,1976,33092,79263,79994,
585323770000261106++BC077956242815741974ADFV0113442512603833092945983106,183,111,1574,1680,1863,33092,79263,94487,
585318820000261106++BC154850241715861986ADFV0113442512603833092945983106,183,111,1586,1692,1875,33092,79263,94487,

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