Schema for all

Schema for all_est

Database: sacCer2 Primary Table: all_est Row Count: 35,005 Data last updated: 2020-09-01
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`bin`	585	`smallint(5) unsigned`	range	Indexing field to speed chromosome range queries.
`matches`	438	`int(10) unsigned`	range	Number of bases that match that aren't repeats
`misMatches`	2	`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`	1	`int(10) unsigned`	range	Number of 'N' bases
`qNumInsert`	3	`int(10) unsigned`	range	Number of inserts in query
`qBaseInsert`	4	`int(10) unsigned`	range	Number of bases inserted in query
`tNumInsert`	0	`int(10) unsigned`	range	Number of inserts in target
`tBaseInsert`	0	`int(10) unsigned`	range	Number of bases inserted in target
`strand`	+	`char(2)`	values	+ or - for strand. First character query, second target (optional)
`qName`	AA417516	`varchar(255)`	values	Query sequence name
`qSize`	452	`int(10) unsigned`	range	Query sequence size
`qStart`	0	`int(10) unsigned`	range	Alignment start position in query
`qEnd`	445	`int(10) unsigned`	range	Alignment end position in query
`tName`	2micron	`varchar(255)`	values	Target sequence name
`tSize`	6318	`int(10) unsigned`	range	Target sequence size
`tStart`	1277	`int(10) unsigned`	range	Alignment start position in target
`tEnd`	1718	`int(10) unsigned`	range	Alignment end position in target
`blockCount`	4	`int(10) unsigned`	range	Number of blocks in alignment
`blockSizes`	331,84,13,13,	`longblob`		Size of each block
`qStarts`	0,332,418,432,	`longblob`		Start of each block in query.
`tStarts`	1277,1608,1692,1705,	`longblob`		Start of each block in target.

Connected Tables and Joining Fields


	hgFixed.gbCdnaInfo.acc (via all_est.qName) hgFixed.gbMiscDiff.acc (via all_est.qName) hgFixed.gbSeq.acc (via all_est.qName) hgFixed.gbWarn.acc (via all_est.qName) hgFixed.imageClone.acc (via all_est.qName) sacCer2.all_mrna.qName (via all_est.qName) sacCer2.est.qName (via all_est.qName) sacCer2.estOrientInfo.name (via all_est.qName) sacCer2.intronEst.qName (via all_est.qName) sacCer2.xenoRefGene.name (via all_est.qName) sacCer2.xenoRefSeqAli.qName (via all_est.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	438	2	1	3	4	0	0	+	AA417516	452	0	445	2micron	6318	1277	1718	4	331,84,13,13,	0,332,418,432,	1277,1608,1692,1705,
585	442	5	0	9	25	3	15	-	AA417479	472	0	472	chrI	230208	51172	51634	11	14,5,4,12,16,8,13,15,11,20,329,	0,23,29,34,54,71,80,94,110,123,143,	51172,51194,51199,51203,51221,51237,51245,51258,51273,51284,51305,
586	457	1	0	7	14	3	5	-	AA417480	472	0	472	chrI	230208	146594	147057	8	5,4,10,8,10,20,40,361,	0,6,11,25,34,46,70,111,	146594,146599,146603,146615,146623,146634,146656,146696,
586	381	0	1	1	1	2	4	+	AA417481	390	7	390	chrI	230208	160869	161255	3	24,342,16,	7,32,374,	160869,160896,161239,
586	279	5	3	0	0	0	0	-	AA417477	287	0	287	chrI	230208	187934	188221	1	287,	0,	187934,
587	450	0	0	0	0	0	0	-	AA417529	450	0	450	chrII	813178	315422	315872	1	450,	0,	315422,
587	347	1	0	1	2	1	1	-	AA417450	350	0	350	chrII	813178	382319	382668	2	46,302,	0,48,	382319,382366,
588	54	0	0	0	0	0	0	+	AA417466	54	0	54	chrII	813178	492461	492515	1	54,	0,	492461,
590	77	0	0	0	0	0	0	-	AA417449	77	0	77	chrII	813178	731439	731516	1	77,	0,	731439,
590	325	1	2	2	2	0	0	+	AA417475	336	0	330	chrII	813178	768589	768917	3	298,10,20,	0,299,310,	768589,768887,768897,

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