Schema for estOrientInfo
  Database: ci2    Primary Table: estOrientInfo    Row Count: 1,171,057   Data last updated: 2016-05-25
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 603smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr03pvarchar(255) Reference sequence chromosome or scaffold
chromStart 2411584int(10) unsigned Start position in chromosome
chromEnd 2413254int(10) unsigned End position in chromosome
name AB091080varchar(255) Accession of EST
intronOrientation 3smallint(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
        ci2.all_est.qName (via estOrientInfo.name)
      ci2.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
603chr03p24115842413254AB09108030000
604chr04q26047102606532AB09108240000
592chr05q10050761006072AB09108710000
628chr05q56399365640354AB09108500000
598chr10p17346641736187AB09108120007
586scaffold_197136646137063AB09108300000
585scaffold_239760976409AB0910840001116
590scaffold_36702258702953AB09108610000
586chr01p152731153039AJ49512800000
587chr01p283182284604AJ49457810000

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