Schema for mrnaOrientInfo
  Database: rn4    Primary Table: mrnaOrientInfo    Row Count: 103,425   Data last updated: 2020-08-22
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 594smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 1306645int(10) unsigned range Start position in chromosome
chromEnd 1307637int(10) unsigned range End position in chromosome
name AY389467varchar(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 25smallint(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 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)
      rn4.all_mrna.qName (via mrnaOrientInfo.name)
      rn4.mgcFullMrna.qName (via mrnaOrientInfo.name)
      rn4.mgcGenes.name (via mrnaOrientInfo.name)
      rn4.mrnaRefseq.mrna (via mrnaOrientInfo.name)
      rn4.mrnaRefseq.refseq (via mrnaOrientInfo.name)
      rn4.refFlat.name (via mrnaOrientInfo.name)
      rn4.refGene.name (via mrnaOrientInfo.name)
      rn4.refSeqAli.qName (via mrnaOrientInfo.name)
      rn4.rgdGene2ToRefSeq.value (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
594chr113066451307637AY389467000250
595chr113453511419334DQ08354320000
595chr114141761419334FJ97166450000
599chr119451531963661DQ08354320000
601chr121506182155593BC0790766250450
602chr122879802304638BC0884176260440
602chr122891442304638M2668660000
602chr122892722304638D11475600260
603chr123783522379556FQ226937017000
603chr123949462436572BC09792910550790

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