Schema for estOrientInfo
  Database: droYak1    Primary Table: estOrientInfo    Row Count: 11,398   Data last updated: 2016-04-08
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 588smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr2Lvarchar(255) values Reference sequence chromosome or scaffold
chromStart 412558int(10) unsigned range Start position in chromosome
chromEnd 413294int(10) unsigned range End position in chromosome
name BQ705641varchar(255) values Accession of EST
intronOrientation 1smallint(6) range Orientation of introns with respect to EST
sizePolyA 0smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 0smallint(6) range Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint(6) range PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        droYak1.all_est.qName (via estOrientInfo.name)
      droYak1.est.qName (via estOrientInfo.name)
      droYak1.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
588chr2L412558413294BQ70564110000
595chr2L13254411325477BQ70586902000
597chr2L16078571609175BQ70516020000
602chr2L22529922253589BQ70526700000
602chr2L22594952260092BQ70526700000
603chr2L23846392385403BQ70514420000
604chr2L25928792593794BQ70549310000
606chr2L27799122782924BQ70587023000
606chr2L27799832783071BQ705271210260
606chr2L28822872882856BQ705614319000

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