Schema for mrnaOrientInfo
  Database: rheMac10    Primary Table: mrnaOrientInfo    Row Count: 390,343   Data last updated: 2019-07-17
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 7983int(10) unsigned range Start position in chromosome
chromEnd 8218int(10) unsigned range End position in chromosome
name JU481255varchar(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
        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)
      rheMac10.all_mrna.qName (via mrnaOrientInfo.name)
      rheMac10.refFlat.name (via mrnaOrientInfo.name)
      rheMac10.refGene.name (via mrnaOrientInfo.name)
      rheMac10.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585chr179838218JU48125500000
585chr1843026664JU47515720000
585chr184588777JU34176700007
585chr1863026620JV64822420000
585chr1882410339JU32719100000
585chr1882726606JV04674820200
585chr191569548JV46463901000
585chr1955913552JV46463810000
585chr11033326661JU32430920000
585chr17158874165JV62167340000

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