Schema for xenoMrna

Database: droMoj2 Primary Table: xenoMrna Row Count: 3,280,322 Data last updated: 2016-02-16
On download server: MariaDB table dump directory

field	example	SQL type
`bin`	585	`smallint(5) unsigned`
`matches`	107	`int(10) unsigned`
`misMatches`	64	`int(10) unsigned`
`repMatches`	0	`int(10) unsigned`
`nCount`	0	`int(10) unsigned`
`qNumInsert`	1	`int(10) unsigned`
`qBaseInsert`	27	`int(10) unsigned`
`tNumInsert`	1	`int(10) unsigned`
`tBaseInsert`	27	`int(10) unsigned`
`strand`	++	`char(2)`
`qName`	X66695	`varchar(255)`
`qSize`	3500	`int(10) unsigned`
`qStart`	528	`int(10) unsigned`
`qEnd`	726	`int(10) unsigned`
`tName`	scaffold_1038	`varchar(255)`
`tSize`	1046	`int(10) unsigned`
`tStart`	27	`int(10) unsigned`
`tEnd`	225	`int(10) unsigned`
`blockCount`	2	`int(10) unsigned`
`blockSizes`	126,45,	`longblob`
`qStarts`	528,681,	`longblob`
`tStarts`	27,180,	`longblob`

Connected Tables and Joining Fields


	droMoj2.all_mrna.qName (via xenoMrna.qName) droMoj2.xenoRefFlat.name (via xenoMrna.qName) droMoj2.xenoRefGene.name (via xenoMrna.qName) droMoj2.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
585	107	64	1	27	1	27	++	X66695	3500	528	726	scaffold_1038	1046	27	225	2	126,45,	528,681,	27,180,
585	94	2	0	0	0	0	++	EZ421277	514	276	372	scaffold_1038	1046	753	849	1	96,	276,	753,
585	94	2	0	0	0	0	++	EZ421554	514	276	372	scaffold_1038	1046	753	849	1	96,	276,	753,
585	106	4	0	0	0	0	++	AK256035	110	0	110	scaffold_1038	1046	845	955	1	110,	0,	845,
585	94	2	0	0	0	0	+-	EZ421277	514	276	372	scaffold_1039	1033	178	274	1	96,	276,	759,
585	94	2	0	0	0	0	+-	EZ421554	514	276	372	scaffold_1039	1033	178	274	1	96,	276,	759,
585	75	39	0	0	0	0	+-	HP477402	2643	849	963	scaffold_1040	1317	87	201	1	114,	849,	1116,
585	75	39	0	0	0	0	+-	HP532335	2057	605	719	scaffold_1040	1317	87	201	1	114,	605,	1116,
585	75	39	0	0	0	0	+-	HP532337	2507	1055	1169	scaffold_1040	1317	87	201	1	114,	1055,	1116,
585	75	39	0	0	0	0	+-	HP564707	2268	19	133	scaffold_1040	1317	87	201	1	114,	19,	1116,

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