Schema for xenoMrna
  Database: droVir1    Primary Table: xenoMrna    Row Count: 4,047,077   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 73smallint(5) unsigned
matches 40int(10) unsigned
misMatches 0int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 124281int(10) unsigned
strand ++char(2)
qName AK031719varchar(255)
qSize 3221int(10) unsigned
qStart 1487int(10) unsigned
qEnd 1527int(10) unsigned
tName scaffold_0varchar(255)
tSize 8062012int(10) unsigned
tStart 48269int(10) unsigned
tEnd 172590int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 16,24,longblob
qStarts 1487,1503,longblob
tStarts 48269,172566,longblob

Connected Tables and Joining Fields
        droVir1.all_mrna.qName (via xenoMrna.qName)
      droVir1.xenoRefFlat.name (via xenoMrna.qName)
      droVir1.xenoRefGene.name (via xenoMrna.qName)
      droVir1.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
7340000001124281++AK031719322114871527scaffold_0806201248269172590216,24,1487,1503,48269,172566,
58515924004214042806+-BT01596039278963219scaffold_080620124972852717536,24,21,78,24,896,1465,1537,3048,3195,8009295,8011185,8011210,8012129,8012260,
585106916300919881433016++BT012472337813221scaffold_0806201249842840901542,40,45,30,24,165,88,75,65,221,84,142,27,160,24,1,516,673,831,1266,1320,1509,1597,1672,1737,1958,2042,2541,2658,3197,49842,69507,69610,69681,70161,70203,74005,75023,75362,75485,77825,82893,83352,83494,84066,
734440000166229++CR859058629013491397scaffold_0806201267780134057223,25,1349,1372,67780,134032,
58510711500000935390++AY880250122511222scaffold_08062012740051106161088,65,221,84,137,153,215,3,111,144,1,89,154,375,459,596,749,964,967,1078,74005,75362,75485,77825,82893,84429,90555,91029,110287,110472,
585113616000001035315++AY880249130011297scaffold_08062012740051106161188,75,65,221,84,141,149,215,3,111,144,1,89,164,229,450,534,675,824,1039,1042,1153,74005,75023,75362,75485,77825,82893,83500,90555,91029,110287,110472,
585118516200001135264++AY880248135111348scaffold_08062012740051106161288,75,65,221,84,141,149,215,51,3,111,144,1,89,164,229,450,534,675,824,1039,1090,1093,1204,74005,75023,75362,75485,77825,82893,83500,90555,101975,102056,110287,110472,
585722298003156735564++EF5451261302931269scaffold_0806201274020110604869,54,222,84,108,156,213,114,93,177,231,453,537,675,831,1155,74020,75373,75485,77826,82894,84428,90557,110490,
585753297002150735549++DQ66718913771771377scaffold_0806201274020110619873,65,222,84,108,156,213,129,177,250,315,537,621,759,915,1248,74020,75362,75485,77826,82894,83495,90557,110490,
585753297002243735549++DQ66719214701771470scaffold_0806201274020110619873,65,222,84,108,156,213,129,177,250,315,537,621,852,1008,1341,74020,75362,75485,77826,82894,83495,90557,110490,

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