Schema for mrnaOrientInfo
  Database: monDom4    Primary Table: mrnaOrientInfo    Row Count: 2,898   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 932smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 45600292int(10) unsigned range Start position in chromosome
chromEnd 45601397int(10) unsigned range End position in chromosome
name GU048816varchar(255) values Accession of EST
intronOrientation 1smallint(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)
      monDom4.all_mrna.qName (via mrnaOrientInfo.name)
      monDom4.refFlat.name (via mrnaOrientInfo.name)
      monDom4.refGene.name (via mrnaOrientInfo.name)
      monDom4.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
932chr14560029245601397GU04881610000
144chr17508678975119901U915711001240
1210chr18198110581981188FV52623501000
1427chr1110430884110434920GQ24084322000
1427chr1110430896110434965GU98478820000
2568chr2259988360259992259NM_001351536600240
1504chr1120539100120539184DM17603200000
1517chr1122228955122229482GU64708000000
1521chr1122711570122711659FV52662001000
1672chr1142496645142496742DM17613400000

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