Schema for xenoMrna
  Database: oviAri1    Primary Table: xenoMrna    Row Count: 5,525,770   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 73smallint(5) unsigned
matches 2437int(10) unsigned
misMatches 346int(10) unsigned
repMatches 0int(10) unsigned
nCount 4int(10) unsigned
qNumInsert 9int(10) unsigned
qBaseInsert 1225int(10) unsigned
tNumInsert 23int(10) unsigned
tBaseInsert 127074int(10) unsigned
strand ++char(2)
qName CR861421varchar(255)
qSize 4435int(10) unsigned
qStart 107int(10) unsigned
qEnd 4119int(10) unsigned
tName chr1varchar(255)
tSize 299839927int(10) unsigned
tStart 2965int(10) unsigned
tEnd 132826int(10) unsigned
blockCount 24int(10) unsigned
blockSizes 84,85,90,110,207,216,207,10...longblob
qStarts 107,219,304,568,678,885,110...longblob
tStarts 2965,4119,6059,7065,11912,1...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)
      oviAri1.all_est.qName (via xenoMrna.qName)
      oviAri1.all_mrna.qName (via xenoMrna.qName)
      oviAri1.refGene.name (via xenoMrna.qName)
      oviAri1.refSeqAli.qName (via xenoMrna.qName)
      oviAri1.xenoRefFlat.name (via xenoMrna.qName)
      oviAri1.xenoRefGene.name (via xenoMrna.qName)
      oviAri1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
732437346049122523127074++CR86142144351074119chr129983992729651328262484,85,90,110,207,216,207,108,105,78,140,20,85,114,88,223,30,104,135,144,189,129,72,24,107,219,304,568,678,885,1101,1308,1416,1521,1600,1740,1760,1845,1959,2174,3102,3133,3237,3372,3516,3819,3963,4095,2965,4119,6059,7065,11912,12366,13002,13332,14245,14625,15943,16728,16749,16955,17843,20258,129026,129736,130008,131045,131775,1 ...
7325153490410336724128739++CR8594266333726307chr129983992729651345722584,85,90,110,207,216,207,108,105,78,140,20,85,114,88,223,30,104,135,144,189,129,72,24,81,72,184,269,533,643,850,1066,1273,1381,1486,1565,1705,1725,1810,1924,2139,3067,3098,3202,3337,3481,3784,3928,4060,6226,2965,4119,6059,7065,11912,12366,13002,13332,14245,14625,15943,16728,16749,16955,17843,20258,129026,129736,130008,131045,131775,1 ...
732365395046115524127033++BC1057484414663985chr129983992729761327732573,3,110,90,108,207,216,207,108,105,79,2,143,85,114,87,220,30,3,102,135,140,193,129,75,66,139,142,252,518,626,833,1049,1256,1364,1469,1548,1550,1708,1793,1907,2125,3050,3080,3083,3185,3320,3460,3767,3910,2976,3054,4094,6059,7067,11912,12366,13002,13332,14245,14625,14949,15945,16749,16955,17843,20261,129026,129102,129738,130008,131 ...
732345411057115824127036++U907254413663985chr129983992729761327732573,3,106,92,108,207,216,207,108,105,79,2,143,85,114,87,220,30,3,102,135,140,193,129,74,66,139,142,250,518,626,833,1049,1256,1364,1469,1548,1550,1708,1793,1907,2125,3050,3080,3083,3185,3320,3460,3767,3911,2976,3054,4094,6057,7067,11912,12366,13002,13332,14245,14625,14949,15945,16749,16955,17843,20261,129026,129102,129738,130008,131 ...
732386414047121125127064++BC0238064421784093chr129983992729761328442673,3,110,89,108,207,216,207,108,105,79,2,143,85,114,88,219,30,3,102,135,144,189,129,74,42,78,151,154,264,530,638,845,1061,1268,1376,1481,1560,1562,1720,1805,1919,2138,3062,3092,3095,3197,3332,3476,3779,3923,4051,2976,3054,4094,6059,7067,11912,12366,13002,13332,14245,14625,14949,15945,16749,16955,17843,20262,129026,129102,129738,130008,131 ...
732386414047121125127064++BC02564844691194134chr129983992729761328442673,3,110,89,108,207,216,207,108,105,79,2,143,85,114,88,219,30,3,102,135,144,189,129,74,42,119,192,195,305,571,679,886,1102,1309,1417,1522,1601,1603,1761,1846,1960,2179,3103,3133,3136,3238,3373,3517,3820,3964,4092,2976,3054,4094,6059,7067,11912,12366,13002,13332,14245,14625,14949,15945,16749,16955,17843,20262,129026,129102,129738,130008,131 ...
732386414047121125127064++BC0277794431924107chr129983992729761328442673,3,110,89,108,207,216,207,108,105,79,2,143,85,114,88,219,30,3,102,135,144,189,129,74,42,92,165,168,278,544,652,859,1075,1282,1390,1495,1574,1576,1734,1819,1933,2152,3076,3106,3109,3211,3346,3490,3793,3937,4065,2976,3054,4094,6059,7067,11912,12366,13002,13332,14245,14625,14949,15945,16749,16955,17843,20262,129026,129102,129738,130008,131 ...
732464419048325726128711++BC0277886256926236chr129983992729761345742773,3,110,89,108,207,216,207,108,105,79,2,143,85,114,88,219,30,3,102,135,144,189,129,74,42,83,92,165,168,278,544,652,859,1075,1282,1390,1495,1574,1576,1734,1819,1933,2152,3076,3106,3109,3211,3346,3490,3793,3937,4065,6153,2976,3054,4094,6059,7067,11912,12366,13002,13332,14245,14625,14949,15945,16749,16955,17843,20262,129026,129102,129738,130008,131 ...
58551711500538179427++EZ7670521060471060chr1299839927297913038825,63,45,108,207,18,145,21,47,159,267,499,607,814,848,1039,2979,4125,6094,7067,11912,12366,12399,13017,
58513073810074881415697++BC1551103307592235chr12998399272979203641525,78,39,108,207,216,207,111,107,74,138,81,108,87,102,59,171,297,525,633,840,1056,1263,1374,1481,1557,1719,1800,1914,2133,2979,4125,6094,7067,11912,12366,13002,13332,14248,14630,15945,16753,16955,17843,20262,

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