Schema for estOrientInfo
  Database: felCat4    Primary Table: estOrientInfo    Row Count: 926   Data last updated: 2016-04-09
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 948smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chrB4varchar(255) values Reference sequence chromosome or scaffold
chromStart 47625337int(10) unsigned range Start position in chromosome
chromEnd 47626552int(10) unsigned range End position in chromosome
name AF034791varchar(255) values Accession of EST
intronOrientation 5smallint(6) range Orientation of introns with respect to EST
sizePolyA 59smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 0smallint(6) range Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint(6) range PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        felCat4.all_est.qName (via estOrientInfo.name)
      felCat4.intronEst.qName (via estOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
948chrB44762533747626552AF034791559000
902chrX4158300841583254AF197970125000
902chrX4160006641601023AF197970225000
903chrX4173425241734700AF1979690110300
638chrA169997417000125AW646939000010
666chrA11062837710628813AW64675500000
819chrA13073968930744301AW64692400000
977chrA15138453151385019AW64675400000
1001chrA15462487454625184AW64675301000
1681chrA1143727317143727755AW64676400000

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