Schema for estOrientInfo
  Database: panTro6    Primary Table: estOrientInfo    Row Count: 18,111   Data last updated: 2018-03-29
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 622smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 4890627int(10) unsigned range Start position in chromosome
chromEnd 4903796int(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)
      panTro6.all_est.qName (via estOrientInfo.name)
      panTro6.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
622chr148906274903796AU29852030000
622chr148906894901956AU29773420000
622chr148907364901958AU29840020000
622chr148908444903795AU29685430000
642chr175654467577747AU29858760000
642chr175655457577750AU29791960000
642chr175662127577746AU29785750000
642chr175663087577749AU29759340000
642chr175670687577747AU297247300170
642chr175695457577737AU29754221000

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