Schema for xenoMrna

Database: apiMel1 Primary Table: xenoMrna Row Count: 3,210,609 Data last updated: 2016-02-16
On download server: MariaDB table dump directory

field	example	SQL type
`bin`	585	`smallint(5) unsigned`
`matches`	70	`int(10) unsigned`
`misMatches`	28	`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`	AY814824	`varchar(255)`
`qSize`	1310	`int(10) unsigned`
`qStart`	913	`int(10) unsigned`
`qEnd`	1011	`int(10) unsigned`
`tName`	Group1.1	`varchar(255)`
`tSize`	88047	`int(10) unsigned`
`tStart`	91	`int(10) unsigned`
`tEnd`	189	`int(10) unsigned`
`blockCount`	1	`int(10) unsigned`
`blockSizes`	98,	`longblob`
`qStarts`	913,	`longblob`
`tStarts`	91,	`longblob`

Connected Tables and Joining Fields


	apiMel1.all_est.qName (via xenoMrna.qName) apiMel1.all_mrna.qName (via xenoMrna.qName) apiMel1.xenoRefGene.name (via xenoMrna.qName) apiMel1.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	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
585	70	28	++	AY814824	1310	913	1011	Group1.1	88047	91	189	1	98,	913,	91,
585	73	23	+-	BX009083	1030	190	286	Group1.1	88047	92	188	1	96,	190,	87859,
585	72	21	++	AY071526	2019	1124	1217	Group1.1	88047	96	189	1	93,	1124,	96,
585	72	21	++	BT001820	1924	1028	1121	Group1.1	88047	96	189	1	93,	1028,	96,
585	73	20	++	DQ311394	2373	1102	1195	Group1.1	88047	96	189	1	93,	1102,	96,
585	77	19	++	EU210149	492	350	446	Group1.1	88047	96	192	1	96,	350,	96,
585	58	26	++	AY335555	957	867	951	Group1.1	88047	99	183	1	84,	867,	99,
585	58	26	++	AY335773	957	867	951	Group1.1	88047	99	183	1	84,	867,	99,
585	58	26	++	DQ895833	997	889	973	Group1.1	88047	99	183	1	84,	889,	99,
585	60	30	++	BC044286	1855	893	983	Group1.1	88047	99	189	1	90,	893,	99,

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