Schema for estOrientInfo
  Database: mm39    Primary Table: estOrientInfo    Row Count: 5,269,820   Data last updated: 2020-08-17
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 609smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 3147192int(10) unsigned Start position in chromosome
chromEnd 3147310int(10) unsigned End position in chromosome
name AA549021varchar(255) Accession of EST
intronOrientation 0smallint(6) Orientation of introns with respect to EST
sizePolyA 0smallint(6) Number of trailing A's
revSizePolyA 0smallint(6) Number of trailing A's on reverse strand
signalPos 25smallint(6) Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint(6) 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)
      mm39.all_est.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
609chr131471923147310AA549021000250
609chr131472473147301AA62400400000
609chr131472633147308AA68200200100
609chr132244453224739AA51761500000
609chr132261033226277AA538072000210
609chr132458533245898AA68200200100
609chr132460543246213AA62368900000
609chr132460543246215AA67293000200
611chr134171503417298AA17464900000
613chr136831273683506AA69112200000

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