Schema for estOrientInfo
  Database: rn3    Primary Table: estOrientInfo    Row Count: 1,268,623   Data last updated: 2018-12-26
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 594smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 1301390int(10) unsigned Start position in chromosome
chromEnd 1301718int(10) unsigned End position in chromosome
name AA686370varchar(255) Accession of EST
intronOrientation 0smallint(6) Orientation of introns with respect to EST
sizePolyA 1smallint(6) Number of trailing A's
revSizePolyA 0smallint(6) Number of trailing A's on reverse strand
signalPos 8smallint(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
        hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      rn3.all_est.qName (via estOrientInfo.name)
      rn3.est.qName (via estOrientInfo.name)
      rn3.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
594chr113013901301718AA68637001080
595chr113997051400097AA96412500000
597chr116972661697656AA96412500000
600chr120788572079151AA89407200000
601chr121208742121265AA96412500000
602chr122363202237254AA87492600000
602chr122363362236715AA859893000020
602chr122363622236696AA85030700000
602chr122363632236696AA94460800000
602chr122363642236661AA85030600000

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