Schema for xenoMrna

Database: droPer1 Primary Table: xenoMrna Row Count: 3,132,563 Data last updated: 2016-02-16
On download server: MariaDB table dump directory

field	example	SQL type
`bin`	73	`smallint(5) unsigned`
`matches`	77	`int(10) unsigned`
`misMatches`	7	`int(10) unsigned`
`repMatches`	0	`int(10) unsigned`
`nCount`	0	`int(10) unsigned`
`qNumInsert`	0	`int(10) unsigned`
`qBaseInsert`	0	`int(10) unsigned`
`tNumInsert`	5	`int(10) unsigned`
`tBaseInsert`	353666	`int(10) unsigned`
`strand`	++	`char(2)`
`qName`	BC015259	`varchar(255)`
`qSize`	3404	`int(10) unsigned`
`qStart`	2887	`int(10) unsigned`
`qEnd`	2971	`int(10) unsigned`
`tName`	super_0	`varchar(255)`
`tSize`	11822988	`int(10) unsigned`
`tStart`	4215	`int(10) unsigned`
`tEnd`	357965	`int(10) unsigned`
`blockCount`	6	`int(10) unsigned`
`blockSizes`	15,3,11,16,2,37,	`longblob`
`qStarts`	2887,2902,2905,2916,2932,2934,	`longblob`
`tStarts`	4215,4301,4886,55458,55564,...	`longblob`

Connected Tables and Joining Fields


	droPer1.xenoRefFlat.name (via xenoMrna.qName) droPer1.xenoRefGene.name (via xenoMrna.qName) droPer1.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

bin	matches	misMatches	qNumInsert	qBaseInsert	tNumInsert	tBaseInsert	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
73	77	7	0	0	5	353666	++	BC015259	3404	2887	2971	super_0	11822988	4215	357965	6	15,3,11,16,2,37,	2887,2902,2905,2916,2932,2934,	4215,4301,4886,55458,55564,357928,
73	104	11	3	4759	4	312278	++	HP483880	7023	738	5612	super_0	11822988	4882	317275	5	24,24,18,23,26,	738,4783,5534,5563,5586,	4882,33775,39359,39831,317249,
73	104	11	3	4759	4	312278	++	HP483881	7019	734	5608	super_0	11822988	4882	317275	5	24,24,18,23,26,	734,4779,5530,5559,5582,	4882,33775,39359,39831,317249,
73	104	11	3	4765	4	312278	++	HP483882	7025	734	5614	super_0	11822988	4882	317275	5	24,24,18,23,26,	734,4785,5536,5565,5588,	4882,33775,39359,39831,317249,
73	104	11	3	4765	4	312278	++	HP483883	7029	738	5618	super_0	11822988	4882	317275	5	24,24,18,23,26,	738,4789,5540,5569,5592,	4882,33775,39359,39831,317249,
73	104	11	3	4769	4	312278	++	HP483885	7033	738	5622	super_0	11822988	4882	317275	5	24,24,18,23,26,	738,4793,5544,5573,5596,	4882,33775,39359,39831,317249,
73	104	11	3	4769	4	312278	++	HP483886	7029	734	5618	super_0	11822988	4882	317275	5	24,24,18,23,26,	734,4789,5540,5569,5592,	4882,33775,39359,39831,317249,
73	104	11	3	4775	4	312278	++	HP483887	7039	738	5628	super_0	11822988	4882	317275	5	24,24,18,23,26,	738,4799,5550,5579,5602,	4882,33775,39359,39831,317249,
73	105	11	3	4751	4	312277	++	HP483888	7012	734	5601	super_0	11822988	4882	317275	5	25,24,18,23,26,	734,4772,5523,5552,5575,	4882,33775,39359,39831,317249,
73	104	11	3	4775	4	312278	++	HP483889	7035	734	5624	super_0	11822988	4882	317275	5	24,24,18,23,26,	734,4795,5546,5575,5598,	4882,33775,39359,39831,317249,

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