Schema for mrnaOrientInfo
  Database: papAnu4    Primary Table: mrnaOrientInfo    Row Count: 1,248   Data last updated: 2019-01-11
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 587smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 292074int(10) unsigned range Start position in chromosome
chromEnd 295197int(10) unsigned range End position in chromosome
name DQ381400varchar(255) values Accession of EST
intronOrientation 4smallint(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)
      papAnu4.all_mrna.qName (via mrnaOrientInfo.name)
      papAnu4.refFlat.name (via mrnaOrientInfo.name)
      papAnu4.refGene.name (via mrnaOrientInfo.name)
      papAnu4.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
587chr1292074295197DQ38140040000
636chr167540316773109FJ34836060000
656chr193215239323172EU03575710000
83chr11087363510894283KX356076150000
716chr11718711417206550DQ38630030000
91chr11898996319006216KX35608070000
94chr12215026922151352KX35608300000
882chr13902512939025193MF19077900000
899chr14121116441243248GQ35254480000
926chr14476563244785469KX356074140000

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