Schema for mrnaOrientInfo
  Database: panPan3    Primary Table: mrnaOrientInfo    Row Count: 843   Data last updated: 2020-06-16
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 645smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 7907211int(10) unsigned range Start position in chromosome
chromEnd 7907316int(10) unsigned range End position in chromosome
name FV526201varchar(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)
      panPan3.all_mrna.qName (via mrnaOrientInfo.name)
      panPan3.refFlat.name (via mrnaOrientInfo.name)
      panPan3.refGene.name (via mrnaOrientInfo.name)
      panPan3.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
645chr179072117907316FV52620100000
645chr179072737907295FV52461800000
645chr179072737907295FW31351500000
796chr12777509327775148MF19063500000
890chr14004714140047205MF19066000000
999chr15432342354347168EF692499110000
1075chr16430627664306298FW31344100000
1121chr17029128070291303FW31347400000
1179chr17786339677877613E017938220380
1179chr17786400177877359E0179270000

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