Schema for estOrientInfo
  Database: taeGut2    Primary Table: estOrientInfo    Row Count: 92,026   Data last updated: 2014-04-17
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 chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 22084int(10) unsigned range Start position in chromosome
chromEnd 22657int(10) unsigned range End position in chromosome
name CK301502varchar(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
        hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      taeGut2.all_est.qName (via estOrientInfo.name)
      taeGut2.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585chr12208422657CK30150200000
589chr1632048635468CK31081140000
589chr1635179638664CK31708440000
589chr1653324654018CK31565200070
590chr1710426711201CK30248100000
590chr1711178711872CK31161500000
590chr1736056739079CK30980910000
590chr1755619755863CK30159100000
593chr110971431099069CK30319541000
600chr120407922040864CK30353502000

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