Schema for mrnaOrientInfo
  Database: panPan2    Primary Table: mrnaOrientInfo    Row Count: 832   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 654smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 9141312int(10) unsigned range Start position in chromosome
chromEnd 9141417int(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)
      panPan2.all_mrna.qName (via mrnaOrientInfo.name)
      panPan2.refFlat.name (via mrnaOrientInfo.name)
      panPan2.refGene.name (via mrnaOrientInfo.name)
      panPan2.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
654chr191413129141417FV52620100000
654chr191413749141396FV52461800000
654chr191413749141396FW31351500000
1011chr15591145455935191EF692499110000
1090chr16619465666194678FW31344100000
1136chr17227388972273912FW31347400000
149chr17994385479958070E017938220380
149chr17994445979957816E0179270000
1433chr1111204126111204201DM17611000000
1433chr1111204126111204201FV52643900000

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