Schema for estOrientInfo

Schema for estOrientInfo

Database: bosTau4 Primary Table: estOrientInfo Row Count: 1,575,361
Format description: Extra information on ESTs - calculated by polyInfo program

field	example	SQL type	description
`bin`	753	`smallint unsigned`	Indexing field to speed chromosome range queries.
`chrom`	chr11	`varchar(255)`	Reference sequence chromosome or scaffold
`chromStart`	22132846	`int unsigned`	Start position in chromosome
`chromEnd`	22133430	`int unsigned`	End position in chromosome
`name`	AA908029	`varchar(255)`	Accession of EST
`intronOrientation`	0	`smallint`	Orientation of introns with respect to EST
`sizePolyA`	0	`smallint`	Number of trailing A's
`revSizePolyA`	6	`smallint`	Number of trailing A's on reverse strand
`signalPos`	0	`smallint`	Position of start of polyA signal relative to end of EST or 0 if no signal
`revSignalPos`	0	`smallint`	PolyA signal position on reverse strand if any

Connected Tables and Joining Fields


	bosTau4.all_est.qName (via estOrientInfo.name) bosTau4.gbCdnaInfo.acc (via estOrientInfo.name) bosTau4.gbSeq.acc (via estOrientInfo.name) bosTau4.gbStatus.acc (via estOrientInfo.name) bosTau4.imageClone.acc (via estOrientInfo.name) bosTau4.intronEst.qName (via estOrientInfo.name)

Sample Rows

bin	chrom	chromStart	chromEnd	name	intronOrientation	sizePolyA	revSizePolyA	signalPos	revSignalPos
753	chr11	22132846	22133430	AA908029	0	0	6	0	0
753	chr11	22134105	22134518	AA908028	0	0	1	0	0
755	chr11	22290252	22290716	AA908025	0	0	0	0	0
886	chr11	39476297	39477847	AA961327	-2	0	16	0	42
886	chr11	39476298	39477844	AA961328	2	19	0	43	0
959	chr11	49080309	49085281	AA908026	1	0	0	0	0
1276	chr11	90667866	90668462	AA908019	0	3	20	0	44
841	chr13	33678104	33678529	AA961331	0	0	17	0	41
841	chr13	33678105	33678840	AA961329	0	1	18	0	41
841	chr13	33678231	33678529	AA961330	0	0	0	0	0

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