Schema for mrnaOrientInfo
  Database: canFam5    Primary Table: mrnaOrientInfo    Row Count: 6,131   Data last updated: 2020-08-18
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 4920235int(10) unsigned range Start position in chromosome
chromEnd 4955941int(10) unsigned range End position in chromosome
name HM154531varchar(255) values Accession of EST
intronOrientation 4smallint(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
        canFam5.all_mrna.qName (via mrnaOrientInfo.name)
      canFam5.refFlat.name (via mrnaOrientInfo.name)
      canFam5.refGene.name (via mrnaOrientInfo.name)
      canFam5.refSeqAli.qName (via mrnaOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)
      hgFixed.refLink.mrnaAcc (via mrnaOrientInfo.name)
      hgFixed.refSeqStatus.mrnaAcc (via mrnaOrientInfo.name)
      hgFixed.refSeqSummary.mrnaAcc (via mrnaOrientInfo.name)
      knownGeneV39.kgXref.refseq (via mrnaOrientInfo.name)
      knownGeneV39.knownToRefSeq.value (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
622chr149202354955941HM15453140000
635chr166261386675096AB0122230180440
86chr11363348213799972AB154172217000
86chr11363438513799972AB116145117000
707chr11603214216033638LC223817024000
88chr11624163716580511AB0122230180310
709chr11637689616380246DQ44907210000
714chr11693284416948387J0506950000
92chr12000005720356878X51448170000
781chr12569055825711049U396636160370

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