Schema for estOrientInfo
  Database: oryLat2    Primary Table: estOrientInfo    Row Count: 703,832   Data last updated: 2016-04-29
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 678smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 12288055int(10) unsigned Start position in chromosome
chromEnd 12289043int(10) unsigned End position in chromosome
name AB163431varchar(255) Accession of EST
intronOrientation 2smallint(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 22smallint(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)
      oryLat2.all_est.qName (via estOrientInfo.name)
      oryLat2.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
678chr11228805512289043AB163431200220
825chr13158466531585149AB03320600000
599chr1219438681945358AB09550110000
672chr131145459911457308AB09549640000
672chr151141870711421672AB03320540000
676chr161203262912034508AB095497200220
748chr212139064521391122AB04657300000
689chr221371589613716479AB03320310000
782chr52587945125880128AB09550030000
699chr61500372115004245AB03320201100

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