Schema for mrnaOrientInfo
  Database: canFam1    Primary Table: mrnaOrientInfo    Row Count: 5,919   Data last updated: 2020-08-20
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 630smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 5974522int(10) unsigned range Start position in chromosome
chromEnd 5978748int(10) unsigned range End position in chromosome
name AB012223varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 18smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 41smallint(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
        canFam1.all_mrna.qName (via mrnaOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
630chr159745225978748AB0122230180410
645chr179432217978974HM15453140000
10chr190838789700415AB012223-1180440
83chr11049060810784412AB012223018000
669chr11103271911036927AB012223018000
705chr11573980115744025AB0122230180440
1chr11662449216791256AB154172217000
1chr11662514716791053AY50956310000
1chr11662536416791256AB116145117000
1chr11662538316791053KC15295210000

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