Schema for estOrientInfo
  Database: bosTau3    Primary Table: estOrientInfo    Row Count: 1,789,247   Data last updated: 2016-06-03
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 749smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr11varchar(255) Reference sequence chromosome or scaffold
chromStart 21592338int(10) unsigned Start position in chromosome
chromEnd 21592922int(10) unsigned End position in chromosome
name AA908029varchar(255) Accession of EST
intronOrientation 0smallint(6) Orientation of introns with respect to EST
sizePolyA 0smallint(6) Number of trailing A's
revSizePolyA 6smallint(6) Number of trailing A's on reverse strand
signalPos 0smallint(6) Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint(6) PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        bosTau3.all_est.qName (via estOrientInfo.name)
      bosTau3.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
749chr112159233821592922AA90802900600
749chr112159359721594010AA90802800100
750chr112174974421750208AA90802500000
868chr113711432337115873AA961327-2016042
868chr113711432437115870AA9613282190430
931chr114544937345454345AA90802610000
1137chr117236218272362778AA9080190320044
840chr133344469733445122AA9613310017041
840chr133344469833445433AA9613290118041
840chr133344482433445122AA96133000000

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