Schema for estOrientInfo
  Database: bosTau9    Primary Table: estOrientInfo    Row Count: 1,627,451   Data last updated: 2019-03-07
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 703smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr10varchar(255) Reference sequence chromosome or scaffold
chromStart 15566639int(10) unsigned Start position in chromosome
chromEnd 15567335int(10) unsigned End position in chromosome
name AA908027varchar(255) Accession of EST
intronOrientation 0smallint(6) Orientation of introns with respect to EST
sizePolyA 26smallint(6) Number of trailing A's
revSizePolyA 0smallint(6) Number of trailing A's on reverse strand
signalPos 43smallint(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
        bosTau9.all_est.qName (via estOrientInfo.name)
      bosTau9.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
703chr101556663915567335AA9080270260430
744chr112091726420917848AA90802900600
744chr112091852320918936AA90802800100
745chr112107493621075400AA90802500000
874chr113797109237972642AA961327-2016042
874chr113797109337972639AA9613282190430
945chr114730078447305756AA90802610000
1255chr118789257787893173AA9080190320044
842chr133377123433771659AA9613310017041
842chr133377123533771970AA9613290118041

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