Schema for xenoMrna
  Database: droYak2    Primary Table: xenoMrna    Row Count: 2,598,416   Data last updated: 2016-02-15
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 3508int(10) unsigned
misMatches 326int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 7int(10) unsigned
qBaseInsert 794int(10) unsigned
tNumInsert 13int(10) unsigned
tBaseInsert 4178int(10) unsigned
strand +-char(2)
qName BT100228varchar(255)
qSize 5315int(10) unsigned
qStart 96int(10) unsigned
qEnd 4724int(10) unsigned
tName chr2Lvarchar(255)
tSize 22324452int(10) unsigned
tStart 7976int(10) unsigned
tEnd 15988int(10) unsigned
blockCount 15int(10) unsigned
blockSizes 123,133,779,1192,106,643,44...longblob
qStarts 96,388,521,1300,2492,2598,3...longblob
tStarts 22308464,22309719,22311567,...longblob

Connected Tables and Joining Fields
        droYak2.all_est.qName (via xenoMrna.qName)
      droYak2.all_mrna.qName (via xenoMrna.qName)
      droYak2.xenoRefFlat.name (via xenoMrna.qName)
      droYak2.xenoRefGene.name (via xenoMrna.qName)
      droYak2.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
5853508326007794134178+-BT1002285315964724chr2L2232445279761598815123,133,779,1192,106,643,443,109,122,9,43,9,15,21,87,96,388,521,1300,2492,2598,3241,3684,3793,4106,4117,4165,4183,4206,4637,22308464,22309719,22311567,22312404,22313653,22314025,22314730,22315507,22315679,22315843,22315852,22315910,22315929,22315975,22 ...
5853519383005756134268+-X054265269184676chr2L223244527976161461430,117,124,133,24,751,1192,106,643,443,109,122,21,87,18,48,195,346,479,504,1255,2447,2553,3196,3639,3748,4169,4589,22308306,22308337,22308464,22309719,22311567,22311595,22312404,22313653,22314025,22314730,22315507,22315679,22315975,22316389,
5853551328007285143808+-AY051654439324166chr2L223244528456161431627,104,124,133,779,1192,106,643,443,109,122,9,43,9,15,21,2,29,176,327,460,1239,2431,2537,3180,3623,3732,4045,4056,4104,4122,4145,22308309,22308337,22308464,22309719,22311567,22312404,22313653,22314025,22314730,22315507,22315679,22315843,22315852,22315910,22 ...
5853388288008397144014+-BT100129444064079chr2L223244528456161461630,20,42,93,779,1192,106,643,443,109,122,9,43,9,15,21,6,36,184,274,373,1152,2344,2450,3093,3536,3645,3958,3969,4017,4035,4058,22308306,22308337,22308465,22309729,22311567,22312404,22313653,22314025,22314730,22315507,22315679,22315843,22315852,22315910,22 ...
5853220273000072555+-FJ629585352013494chr2L22324452865114699899,779,1192,106,643,443,109,122,1,100,879,2071,2177,2820,3263,3372,22309753,22311567,22312404,22313653,22314025,22314730,22315507,22315679,
5853222271000072555+-FJ634679351813494chr2L22324452865114699899,779,1192,106,643,443,109,122,1,100,879,2071,2177,2820,3263,3372,22309753,22311567,22312404,22313653,22314025,22314730,22315507,22315679,
58512723000000+-AY051654439338604010chr2L22324452867088201150,3860,22315632,
58512723000000+-BT100129444037733923chr2L22324452867088201150,3773,22315632,
58512723000000+-BT100228531539214071chr2L22324452867088201150,3921,22315632,
58516368360012921153296+-EZ97682156908084201chr2L223244528916146841681,762,132,237,66,165,90,273,102,48,138,98,127,117,3,33,808,892,1687,1834,2116,2248,2461,2575,2893,3169,3274,3574,3672,4048,4165,4168,22309768,22311567,22312420,22312564,22312852,22312990,22313179,22313299,22313656,22314180,22314291,22314570,22314730,22315049,22 ...

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