Schema for D. mojavensis ESTs - Alignment of D. mojavensis ESTs from GenBank

Database: DmojImproved Primary Table: genbank_est Row Count: 20,185

field	example	SQL type	info
`bin`	73	`smallint(5) unsigned`	range
`matches`	690	`int(10) unsigned`	range
`misMatches`	0	`int(10) unsigned`	range
`repMatches`	0	`int(10) unsigned`	range
`nCount`	0	`int(10) unsigned`	range
`qNumInsert`	0	`int(10) unsigned`	range
`qBaseInsert`	0	`int(10) unsigned`	range
`tNumInsert`	5	`int(10) unsigned`	range
`tBaseInsert`	160318	`int(10) unsigned`	range
`strand`	+	`char(2)`	values
`qName`	EB601029.1	`varchar(255)`	values
`qSize`	715	`int(10) unsigned`	range
`qStart`	1	`int(10) unsigned`	range
`qEnd`	691	`int(10) unsigned`	range
`tName`	improved_6498	`varchar(255)`	values
`tSize`	3406532	`int(10) unsigned`	range
`tStart`	52208	`int(10) unsigned`	range
`tEnd`	213216	`int(10) unsigned`	range
`blockCount`	6	`int(10) unsigned`	range
`blockSizes`	14,32,135,170,211,128,	`longblob`
`qStarts`	1,15,47,182,352,563,	`longblob`
`tStarts`	52208,52223,53163,97955,181...	`longblob`

Sample Rows

bin	matches	misMatches	nCount	qNumInsert	qBaseInsert	tNumInsert	tBaseInsert	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
73	690	0	0	0	0	5	160318	+	EB601029.1	715	1	691	improved_6498	3406532	52208	213216	6	14,32,135,170,211,128,	1,15,47,182,352,563,	52208,52223,53163,97955,181190,213088,
73	698	0	0	1	93	9	160255	+	EB609512.1	793	1	792	improved_6498	3406532	52208	213161	10	14,95,136,173,211,34,14,10,4,7,	1,15,110,339,512,723,757,771,781,785,	52208,52223,53163,97952,181190,213088,213123,213138,213149,213154,
73	603	1	1	2	95	6	128566	+	EB611628.1	855	35	735	improved_6498	3406532	52221	181392	7	97,136,173,178,5,7,9,	35,132,361,534,714,719,726,	52221,53163,97952,181190,181369,181375,181383,
587	693	4	0	3	18	2	18	-	EB615878.1	717	0	715	improved_6498	3406532	324768	325483	5	14,46,4,173,460,	2,16,78,83,257,	324768,324783,324846,324850,325023,
587	570	1	0	1	1	0	0	+	EB623527.1	737	1	573	improved_6498	3406532	367896	368467	2	187,384,	1,189,	367896,368083,
587	731	2	0	3	6	14	119	-	EB628905.1	817	3	742	improved_6498	3406532	386973	387825	15	5,6,7,4,8,4,6,6,5,4,11,13,9,99,546,	75,80,87,94,99,107,115,121,127,132,136,147,160,169,268,	386973,386980,386989,386997,387005,387014,387025,387032,387039,387045,387050,387062,387076,387086,387279,
588	756	1	0	3	6	17	87	+	EB634755.1	771	0	763	improved_6498	3406532	429205	430049	18	275,136,240,23,8,6,7,5,5,4,8,5,4,8,7,5,4,7,	0,275,411,651,674,682,688,695,700,705,709,717,722,727,739,746,751,756,	429205,429539,429676,429917,429941,429950,429957,429965,429971,429977,429982,429991,429997,430004,430019,430028,430034,430042,
588	511	4	6	0	0	2	440	-	DR033473.1	540	19	540	improved_6498	3406532	453974	454935	3	7,304,210,	0,7,311,	453974,454366,454725,
588	748	0	0	0	0	8	12852	-	EB622187.1	810	0	748	improved_6498	3406532	455176	468776	9	11,8,9,13,12,7,10,398,280,	62,73,81,90,103,115,122,132,530,	455176,455188,455197,455207,455221,455234,455242,455253,468496,
589	698	1	0	1	1	12	233	+	EB632105.1	758	0	700	improved_6498	3406532	551058	551990	13	207,97,322,15,4,12,6,8,4,5,5,5,9,	0,207,304,626,641,645,657,663,671,675,680,685,691,	551058,551330,551507,551905,551921,551926,551939,551946,551955,551960,551966,551973,551981,

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

D. mojavensis ESTs (genbank_est) Track Description


	Description This track shows the BLAT alignment of D. mojavensis Expressed Sequence Tags (ESTs) from GenBank dbEST against the D. mojavensis genome assembly. Methods D. mojavensis ESTs from the GenBank dbEST database were aligned against the D. mojavensis genome using BLAT. BLAT alignments are then filtered using pslCDnaFilter such that only matches with a minimum of 95% identity, 25% coverage are shown in this track. References Boguski MS, Lowe TM, Tolstoshev CM. dbEST--database for "expressed sequence tags". Nat Genet. 1993 Aug;4(4):332-3.

Description

Methods

References