Schema for xenoMrna

Database: caePb1 Primary Table: xenoMrna Row Count: 2,969,697 Data last updated: 2016-02-16
On download server: MariaDB table dump directory

field	example	SQL type
`bin`	585	`smallint(5) unsigned`
`matches`	760	`int(10) unsigned`
`misMatches`	178	`int(10) unsigned`
`repMatches`	0	`int(10) unsigned`
`nCount`	0	`int(10) unsigned`
`qNumInsert`	5	`int(10) unsigned`
`qBaseInsert`	67	`int(10) unsigned`
`tNumInsert`	6	`int(10) unsigned`
`tBaseInsert`	1087	`int(10) unsigned`
`strand`	+-	`char(2)`
`qName`	AF150958	`varchar(255)`
`qSize`	1089	`int(10) unsigned`
`qStart`	84	`int(10) unsigned`
`qEnd`	1089	`int(10) unsigned`
`tName`	chrUn	`varchar(255)`
`tSize`	207333000	`int(10) unsigned`
`tStart`	19625	`int(10) unsigned`
`tEnd`	21650	`int(10) unsigned`
`blockCount`	7	`int(10) unsigned`
`blockSizes`	237,73,146,126,143,120,93,	`longblob`
`qStarts`	84,324,397,549,676,831,996,	`longblob`
`tStarts`	207311350,207311640,2073120...	`longblob`

Connected Tables and Joining Fields


	caePb1.all_mrna.qName (via xenoMrna.qName) caePb1.xenoRefFlat.name (via xenoMrna.qName) caePb1.xenoRefGene.name (via xenoMrna.qName) caePb1.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	nCount	qNumInsert	qBaseInsert	tNumInsert	tBaseInsert	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
585	760	178	0	5	67	6	1087	+-	AF150958	1089	84	1089	chrUn	207333000	19625	21650	7	237,73,146,126,143,120,93,	84,324,397,549,676,831,996,	207311350,207311640,207312054,207312630,207312865,207313071,207313282,
585	62	28	0	0	0	0	0	+-	M19971	1378	837	927	chrUn	207333000	57635	57725	1	90,	837,	207275275,
585	1437	336	49	5	212	17	2913	+-	AF166168	2234	0	2034	chrUn	207333000	78791	83526	18	99,93,108,138,144,168,88,84,77,274,2,208,135,95,8,61,4,36,	0,99,192,306,444,588,827,915,1008,1085,1359,1361,1590,1830,1925,1933,1994,1998,	207249474,207249834,207249977,207250661,207250846,207251096,207251454,207251851,207251993,207252118,207252425,207252609,20725283 ...
585	1478	355	49	7	461	17	2853	+-	AF166167	2527	0	2343	chrUn	207333000	78791	83526	18	99,93,108,138,144,168,88,84,77,274,2,208,135,95,8,62,51,48,	0,99,192,306,444,588,827,915,1008,1085,1359,1361,1590,1830,1925,1933,2076,2295,	207249474,207249834,207249977,207250661,207250846,207251096,207251454,207251851,207251993,207252118,207252425,207252609,20725283 ...
585	66	36	0	0	0	0	0	+-	AB170093	1414	855	957	chrUn	207333000	91067	91169	1	102,	855,	207241831,
585	66	36	0	0	0	0	0	+-	AB173982	1611	857	959	chrUn	207333000	91067	91169	1	102,	857,	207241831,
585	66	36	0	0	0	0	0	+-	AF065389	1405	812	914	chrUn	207333000	91067	91169	1	102,	812,	207241831,
585	66	36	0	0	0	0	0	+-	AF121344	3175	852	954	chrUn	207333000	91067	91169	1	102,	852,	207241831,
585	66	36	0	0	0	0	0	+-	AK013350	3141	802	904	chrUn	207333000	91067	91169	1	102,	802,	207241831,
585	66	36	0	0	0	0	0	+-	AK015705	1116	559	661	chrUn	207333000	91067	91169	1	102,	559,	207241831,

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