Schema for intronEst

Database: ornAna2 Primary Table: intronEst Row Count: 3,521 Data last updated: 2016-01-27
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`bin`	588	`smallint(5) unsigned`	range	Indexing field to speed chromosome range queries.
`matches`	151	`int(10) unsigned`	range	Number of bases that match that aren't repeats
`misMatches`	1	`int(10) unsigned`	range	Number of bases that don't match
`repMatches`	0	`int(10) unsigned`	range	Number of bases that match but are part of repeats
`nCount`	0	`int(10) unsigned`	range	Number of 'N' bases
`qNumInsert`	1	`int(10) unsigned`	range	Number of inserts in query
`qBaseInsert`	10	`int(10) unsigned`	range	Number of bases inserted in query
`tNumInsert`	2	`int(10) unsigned`	range	Number of inserts in target
`tBaseInsert`	77803	`int(10) unsigned`	range	Number of bases inserted in target
`strand`	-	`char(2)`	values	+ or - for strand. First character query, second target (optional)
`qName`	DW586808	`varchar(255)`	values	Query sequence name
`qSize`	267	`int(10) unsigned`	range	Query sequence size
`qStart`	38	`int(10) unsigned`	range	Alignment start position in query
`qEnd`	200	`int(10) unsigned`	range	Alignment end position in query
`tName`	chrUn_DS180971v1	`varchar(255)`	values	Target sequence name
`tSize`	568384	`int(10) unsigned`	range	Target sequence size
`tStart`	433565	`int(10) unsigned`	range	Alignment start position in target
`tEnd`	511520	`int(10) unsigned`	range	Alignment end position in target
`blockCount`	3	`int(10) unsigned`	range	Number of blocks in alignment
`blockSizes`	38,88,26,	`longblob`		Size of each block
`qStarts`	67,105,203,	`longblob`		Start of each block in query.
`tStarts`	433565,511395,511494,	`longblob`		Start of each block in target.

Connected Tables and Joining Fields


	hgFixed.gbCdnaInfo.acc (via intronEst.qName) hgFixed.gbSeq.acc (via intronEst.qName) hgFixed.imageClone.acc (via intronEst.qName) ornAna2.all_est.qName (via intronEst.qName) ornAna2.estOrientInfo.name (via intronEst.qName)

Sample Rows

bin	matches	misMatches	qNumInsert	qBaseInsert	tNumInsert	tBaseInsert	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
588	151	1	1	10	2	77803	-	DW586808	267	38	200	chrUn_DS180971v1	568384	433565	511520	3	38,88,26,	67,105,203,	433565,511395,511494,
591	291	1	2	2	1	688	-	DW586533	335	41	335	chrUn_DS181237v1	2391570	871804	872784	4	53,106,80,53,	0,54,160,241,	871804,871857,872651,872731,
587	254	0	1	9	3	1449	-	DW586730	412	73	336	chrUn_DS181372v1	838734	337515	339218	4	62,70,100,22,	76,138,208,317,	337515,338261,339086,339196,
587	261	9	1	1	2	1439	+	DW586489	393	61	332	chrUn_DS181372v1	838734	337515	339224	4	62,70,30,108,	61,123,193,224,	337515,338261,339086,339116,
590	269	0	0	0	3	5417	-	DW586891	409	68	337	chrUn_DS181649v1	999446	693420	699106	4	90,145,6,28,	72,162,307,313,	693420,694707,694960,699078,
585	305	0	0	0	2	1748	+	DW586894	411	105	410	chrUn_DS187102v1	38408	2381	4434	3	130,83,92,	105,235,318,	2381,3005,4342,
585	148	0	0	0	2	689	+	DW586481	399	189	337	chrUn_DS215809v1	4932	786	1623	3	67,45,36,	189,256,301,	786,930,1587,
585	140	1	1	7	2	696	-	DW586674	421	33	181	chrUn_DS215809v1	4932	786	1623	3	67,46,28,	240,307,360,	786,930,1595,
736	286	7	0	0	2	8662	+	DW586519	305	12	305	chrX5	27786739	19861234	19870189	3	101,66,126,	12,113,179,	19861234,19869255,19870063,
642	580	1	2	2	8	9513	-	EE678071	608	25	608	chr10	11243762	7514324	7524418	9	13,123,78,117,170,34,26,16,4,	0,13,136,214,331,502,537,563,579,	7514324,7514753,7515691,7517967,7519156,7524334,7524370,7524397,7524414,

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