Schema for estOrientInfo
  Database: priPac1    Primary Table: estOrientInfo    Row Count: 42,452   Data last updated: 2016-04-16
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chrUnvarchar(255) values Reference sequence chromosome or scaffold
chromStart 46550int(10) unsigned range Start position in chromosome
chromEnd 47426int(10) unsigned range End position in chromosome
name AA193982varchar(255) values Accession of EST
intronOrientation 2smallint(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)
      priPac1.all_est.qName (via estOrientInfo.name)
      priPac1.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585chrUn4655047426AA19398221000
586chrUn197845199196AA19202110000
605chrUn27125372713261AA19206430000
609chrUn32383953239726AA19388820000
618chrUn43892324390628AA19372150000
620chrUn46111354611593AA193915070270
622chrUn49778694978989AA19394733000
626chrUn54078695408273AA11620120000
626chrUn54191535419653AA19183500000
629chrUn57700035770281AA19388600000

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