Schema for estOrientInfo
  Database: equCab1    Primary Table: estOrientInfo    Row Count: 38,104   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 588smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 445381int(10) unsigned range Start position in chromosome
chromEnd 446075int(10) unsigned range End position in chromosome
name CX601379varchar(255) values Accession of EST
intronOrientation 0smallint(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
        equCab1.all_est.qName (via estOrientInfo.name)
      equCab1.est.qName (via estOrientInfo.name)
      equCab1.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
588chr1445381446075CX60137900000
594chr112118621217002CX60277040000
594chr112118621217003CX60605940000
594chr112119601217255CX60256640200
594chr112126851217207CX59439030000
594chr112126861217170CX59420630000
594chr112147901217207CX59690010000
594chr112169161217382CX59959300000
594chr112169821217670CX60497400000
594chr112170431217644CX59584600000

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