Schema for xenoMrna

Database: droVir2 Primary Table: xenoMrna Row Count: 3,512,506 Data last updated: 2016-02-16
On download server: MariaDB table dump directory

field	example	SQL type
`bin`	585	`smallint(5) unsigned`
`matches`	67	`int(10) unsigned`
`misMatches`	14	`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`	FQ233356	`varchar(255)`
`qSize`	1045	`int(10) unsigned`
`qStart`	1	`int(10) unsigned`
`qEnd`	82	`int(10) unsigned`
`tName`	scaffold_10001	`varchar(255)`
`tSize`	9183	`int(10) unsigned`
`tStart`	149	`int(10) unsigned`
`tEnd`	230	`int(10) unsigned`
`blockCount`	1	`int(10) unsigned`
`blockSizes`	81,	`longblob`
`qStarts`	1,	`longblob`
`tStarts`	149,	`longblob`

Connected Tables and Joining Fields


	droVir2.all_est.qName (via xenoMrna.qName) droVir2.all_mrna.qName (via xenoMrna.qName) droVir2.xenoRefFlat.name (via xenoMrna.qName) droVir2.xenoRefGene.name (via xenoMrna.qName) droVir2.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	67	14	++	FQ233356	1045	1	82	scaffold_10001	9183	149	230	1	81,	1,	149,
585	69	13	++	AJ311501	1516	1	83	scaffold_10001	9183	149	231	1	82,	1,	149,
585	69	13	++	AK236486	1562	7	89	scaffold_10001	9183	149	231	1	82,	7,	149,
585	69	13	++	BC154743	2086	7	89	scaffold_10001	9183	149	231	1	82,	7,	149,
585	70	12	++	CT025457	2529	2344	2426	scaffold_10001	9183	149	231	1	82,	2344,	149,
585	69	13	++	FQ211544	184	7	89	scaffold_10001	9183	149	231	1	82,	7,	149,
585	69	13	++	FQ223150	1002	2	84	scaffold_10001	9183	149	231	1	82,	2,	149,
585	69	13	++	FQ224447	643	1	83	scaffold_10001	9183	149	231	1	82,	1,	149,
585	69	13	++	FQ224513	179	1	83	scaffold_10001	9183	149	231	1	82,	1,	149,
585	69	13	++	FQ225235	941	2	84	scaffold_10001	9183	149	231	1	82,	2,	149,

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