Schema for estOrientInfo
  Database: ci3    Primary Table: estOrientInfo    Row Count: 1,145,688   Data last updated: 2015-08-26
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 608smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr12varchar(255) Reference sequence chromosome or scaffold
chromStart 3086618int(10) unsigned Start position in chromosome
chromEnd 3086930int(10) unsigned End position in chromosome
name AB091084varchar(255) Accession of EST
intronOrientation 0smallint(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 11smallint(6) Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 16smallint(6) PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        ci3.all_est.qName (via estOrientInfo.name)
      ci3.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
608chr1230866183086930AB0910840001116
598chr417496791750096AB09108300000
605chr426950602696882AB09108240000
591chr5800099801095AB09108710000
619chr545463394546757AB09108500000
586chrUn_NW_004190369v1197667199190AB09108120007
585chrUn_NW_004190371v13044131752AB09108032000
585chrUn_NW_004190510v185899284AB09108600000
585chr16914370548AJ49457810000
587chr1349210350787AJ49397820000

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