Schema for xenoMrna

Database: monDom1 Primary Table: xenoMrna Row Count: 6,335,230 Data last updated: 2016-02-16
On download server: MariaDB table dump directory

field	example	SQL type
`bin`	585	`smallint(5) unsigned`
`matches`	45	`int(10) unsigned`
`misMatches`	15	`int(10) unsigned`
`repMatches`	0	`int(10) unsigned`
`nCount`	0	`int(10) unsigned`
`qNumInsert`	0	`int(10) unsigned`
`qBaseInsert`	0	`int(10) unsigned`
`tNumInsert`	0	`int(10) unsigned`
`tBaseInsert`	0	`int(10) unsigned`
`strand`	++	`char(2)`
`qName`	X68158	`varchar(255)`
`qSize`	2088	`int(10) unsigned`
`qStart`	2	`int(10) unsigned`
`qEnd`	62	`int(10) unsigned`
`tName`	scaffold_10006	`varchar(255)`
`tSize`	12060	`int(10) unsigned`
`tStart`	317	`int(10) unsigned`
`tEnd`	377	`int(10) unsigned`
`blockCount`	1	`int(10) unsigned`
`blockSizes`	60,	`longblob`
`qStarts`	2,	`longblob`
`tStarts`	317,	`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) monDom1.all_mrna.qName (via xenoMrna.qName) monDom1.xenoRefFlat.name (via xenoMrna.qName) monDom1.xenoRefGene.name (via xenoMrna.qName) monDom1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows

bin	matches	misMatches	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
585	45	15	++	X68158	2088	2	62	scaffold_10006	12060	317	377	1	60,	2,	317,
585	42	12	++	AK010947	2138	865	919	scaffold_10020	1295	376	430	1	54,	865,	376,
585	42	12	++	AK085844	1937	660	714	scaffold_10020	1295	376	430	1	54,	660,	376,
585	42	12	++	BC027426	2138	848	902	scaffold_10020	1295	376	430	1	54,	848,	376,
585	77	43	+-	M18216	2527	751	871	scaffold_10027	1560	398	518	1	120,	751,	1042,
585	77	43	+-	M29541	1189	798	918	scaffold_10027	1560	398	518	1	120,	798,	1042,
585	78	42	+-	AK312542	1139	809	929	scaffold_10027	1560	398	518	1	120,	809,	1042,
585	78	42	+-	AY889715	1035	705	825	scaffold_10027	1560	398	518	1	120,	705,	1042,
585	78	42	+-	BC005008	2249	745	865	scaffold_10027	1560	398	518	1	120,	745,	1042,
585	78	42	+-	BT009774	1035	705	825	scaffold_10027	1560	398	518	1	120,	705,	1042,

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