Schema for estOrientInfo
  Database: ci1    Primary Table: estOrientInfo    Row Count: 1,217,314   Data last updated: 2016-05-29
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom Scaffold_1varchar(255) Reference sequence chromosome or scaffold
chromStart 1696int(10) unsigned Start position in chromosome
chromEnd 4224int(10) unsigned End position in chromosome
name BW317769varchar(255) Accession of EST
intronOrientation 5smallint(6) Orientation of introns with respect to EST
sizePolyA 0smallint(6) Number of trailing A's
revSizePolyA 0smallint(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
        ci1.all_est.qName (via estOrientInfo.name)
      ci1.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
585Scaffold_116964224BW31776950000
585Scaffold_117093800BW083661-40000
585Scaffold_117093822BW21883248000
585Scaffold_117144218BW24203250000
585Scaffold_137985471BW19363940000
585Scaffold_141756371BW03241850000
585Scaffold_141846396BW43178550000
585Scaffold_145416048AV98386430000
585Scaffold_145416401AV871842-40000
585Scaffold_145446346BM96247940000

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