Schema for estOrientInfo
  Database: oryCun2    Primary Table: estOrientInfo    Row Count: 36,900   Data last updated: 2014-03-21
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 1856smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 166668226int(10) unsigned range Start position in chromosome
chromEnd 166668423int(10) unsigned range End position in chromosome
name AA875808varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 1smallint(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
        hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      oryCun2.all_est.qName (via estOrientInfo.name)
      oryCun2.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
1856chr1166668226166668423AA87580801000
1243chr28629688986312564AB07261730000
735chr111972887619730052AF10945800000
1508chr12121058928121059369AF10946001100
836chr133292334732923836AF10946302000
901chr134150821541508501AF247145000210
1017chr135664627356647002AF254948000022
1189chr137925525679255651AF247147000220
972chr175076930650770847AF24714820000
1111chr176900860069008938AF46969000000

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