Schema for estOrientInfo
  Database: panTro5    Primary Table: estOrientInfo    Row Count: 18,464   Data last updated: 2016-09-22
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 626smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 5444369int(10) unsigned range Start position in chromosome
chromEnd 5457520int(10) unsigned range End position in chromosome
name AU298520varchar(255) values Accession of EST
intronOrientation 3smallint(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
        hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      panTro5.all_est.qName (via estOrientInfo.name)
      panTro5.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
626chr154443695457520AU29852030000
626chr154444315455680AU29773420000
626chr154444785455682AU29840020000
626chr154445865457519AU29685430000
647chr181805488192849AU29858760000
647chr181806478192852AU29791960000
647chr181806778192848AU29785760000
647chr181814108192851AU29759340000
647chr181821708192849AU297247300170
647chr181821938192851AU29835840000

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