Schema for xenoMrna
  Database: tetNig1    Primary Table: xenoMrna    Row Count: 6,128,225   Data last updated: 2016-02-27
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 792int(10) unsigned
misMatches 318int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 2int(10) unsigned
qBaseInsert 747int(10) unsigned
tNumInsert 2int(10) unsigned
tBaseInsert 12965int(10) unsigned
strand +-char(2)
qName AB075940varchar(255)
qSize 3369int(10) unsigned
qStart 84int(10) unsigned
qEnd 1941int(10) unsigned
tName chr1varchar(255)
tSize 16827091int(10) unsigned
tStart 0int(10) unsigned
tEnd 14075int(10) unsigned
blockCount 3int(10) unsigned
blockSizes 72,528,510,longblob
qStarts 84,228,1431,longblob
tStarts 16813016,16825381,16826581,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)
      tetNig1.all_mrna.qName (via xenoMrna.qName)
      tetNig1.xenoRefGene.name (via xenoMrna.qName)
      tetNig1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
585792318002747212965+-AB0759403369841941chr116827091014075372,528,510,84,228,1431,16813016,16825381,16826581,
5856554190065437108422+-AB11338452442251842chr1168270911051096018102,72,69,159,311,124,147,90,225,450,594,690,873,1184,1560,1752,16717490,16717715,16745165,16750022,16784802,16820195,16820571,16826896,
5856774360055049108383+-AY01375652482251842chr11682709110510960110102,20,155,221,72,180,87,39,147,90,225,450,470,625,969,1041,1221,1323,1560,1752,16717490,16717715,16791116,16806435,16809567,16809964,16815980,16818076,16820571,16826896,
5856774360055049108383+-BC08232649423261943chr11682709110510960110102,20,155,221,72,180,87,39,147,90,326,551,571,726,1070,1142,1322,1424,1661,1853,16717490,16717715,16791116,16806435,16809567,16809964,16815980,16818076,16820571,16826896,
585522315004555799911+-AY01381245674531845chr116827091114100862890,143,37,161,184,106,20,96,453,588,731,1029,1190,1572,1678,1749,16726229,16726364,16727149,16781185,16820195,16823661,16826480,16826881,
585522315004555799911+-BC06480850479072299chr116827091114100862890,143,37,161,184,106,20,96,907,1042,1185,1483,1644,2026,2132,2203,16726229,16726364,16727149,16781185,16820195,16823661,16826480,16826881,
585539346003506799863+-BC10103726154441835chr116827091114100862877,55,171,218,184,106,20,54,444,521,576,962,1180,1562,1668,1781,16726229,16756615,16784508,16784895,16820195,16823661,16826480,16826923,
585539346003507799863+-AF15252526164441836chr116827091114100862877,55,171,218,184,106,20,54,444,521,576,963,1181,1563,1669,1782,16726229,16756615,16784508,16784895,16820195,16823661,16826480,16826923,
585539346003507799863+-BC10103526164441836chr116827091114100862877,55,171,218,184,106,20,54,444,521,576,963,1181,1563,1669,1782,16726229,16756615,16784508,16784895,16820195,16823661,16826480,16826923,
585539346003507799863+-BC10103826164441836chr116827091114100862877,55,171,218,184,106,20,54,444,521,576,963,1181,1563,1669,1782,16726229,16756615,16784508,16784895,16820195,16823661,16826480,16826923,

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