Schema for xenoMrna
  Database: priPac1    Primary Table: xenoMrna    Row Count: 2,097,926   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 73smallint(5) unsigned
matches 103int(10) unsigned
misMatches 13int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 2int(10) unsigned
qBaseInsert 255int(10) unsigned
tNumInsert 5int(10) unsigned
tBaseInsert 496095int(10) unsigned
strand +-char(2)
qName BC006628varchar(255)
qSize 2090int(10) unsigned
qStart 1240int(10) unsigned
qEnd 1611int(10) unsigned
tName chrUnvarchar(255)
tSize 174852139int(10) unsigned
tStart 4542int(10) unsigned
tEnd 500753int(10) unsigned
blockCount 6int(10) unsigned
blockSizes 29,25,3,21,11,27,longblob
qStarts 1240,1283,1308,1311,1332,1584,longblob
tStarts 174351386,174489844,1744901...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)
      priPac1.all_est.qName (via xenoMrna.qName)
      priPac1.all_mrna.qName (via xenoMrna.qName)
      priPac1.xenoRefFlat.name (via xenoMrna.qName)
      priPac1.xenoRefGene.name (via xenoMrna.qName)
      priPac1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
73103130022555496095+-BC006628209012401611chrUn1748521394542500753629,25,3,21,11,27,1240,1283,1308,1311,1332,1584,174351386,174489844,174490101,174493330,174499627,174847570,
73103130022555496095+-BC053333280913501721chrUn1748521394542500753629,25,3,21,11,27,1350,1393,1418,1421,1442,1694,174351386,174489844,174490101,174493330,174499627,174847570,
73103130022555496095+-BC071269282714051776chrUn1748521394542500753629,25,3,21,11,27,1405,1448,1473,1476,1497,1749,174351386,174489844,174490101,174493330,174499627,174847570,
73103130022555496095+-BC075733262612251596chrUn1748521394542500753629,25,3,21,11,27,1225,1268,1293,1296,1317,1569,174351386,174489844,174490101,174493330,174499627,174847570,
731052400116345426++AK048453342418591989chrUn17485213914860360415721,15,3,38,9,12,31,1859,1881,1896,1899,1937,1946,1958,14860,15000,15024,351810,356114,356940,360384,
5853461750073977928++AY33260751193521270chrUn1748521391585617305854,45,11,105,108,69,72,57,352,475,529,589,721,865,964,1213,15856,16019,16121,16224,16399,16582,16723,17248,
5853461750073977928++AY33260826041321050chrUn1748521391585617305854,45,11,105,108,69,72,57,132,255,309,369,501,645,744,993,15856,16019,16121,16224,16399,16582,16723,17248,
585471261005153082190++BC04540336682292491chrUn1748521391585618778981,64,143,66,75,78,60,57,108,229,505,569,742,841,916,1030,1090,2383,15856,16263,16370,16582,16723,16862,17143,17248,18670,
585185108002583192++AK3088291636570921chrUn1748521391601916504445,11,103,134,570,624,684,787,16019,16121,16224,16370,
5852671200053517797++CR85556922954261164chrUn1748521391601917203845,18,6,5,103,137,13,60,426,474,495,501,540,643,844,1104,16019,16115,16134,16142,16224,16370,16610,17143,

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