Schema for mrnaOrientInfo
  Database: fr3    Primary Table: mrnaOrientInfo    Row Count: 2,061   Data last updated: 2020-08-19
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 586smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom HE591497varchar(255) values Reference sequence chromosome or scaffold
chromStart 256623int(10) unsigned range Start position in chromosome
chromEnd 256709int(10) unsigned range End position in chromosome
name FV526919varchar(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
        fr3.all_mrna.qName (via mrnaOrientInfo.name)
      fr3.refFlat.name (via mrnaOrientInfo.name)
      fr3.refGene.name (via mrnaOrientInfo.name)
      fr3.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)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
586HE591497256623256709FV52691900000
590HE591604660251661753AJ54884430000
585HE591655104218110404AJ13139390000
588HE591655469902475620AJ62872970000
588HE591655469902476308AJ62872480000
588HE591655469902476308AJ62872590000
585HE591688129717256AB24617221000
585HE5916881118126411AB246172290000
585HE591688112109123151AY28841210000
587HE591693308078309674EF19574900000

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