Schema for mrnaOrientInfo
  Database: calJac1    Primary Table: mrnaOrientInfo    Row Count: 1,956   Data last updated: 2020-08-20
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 9smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom Contig0varchar(255) values Reference sequence chromosome or scaffold
chromStart 963089int(10) unsigned range Start position in chromosome
chromEnd 1212549int(10) unsigned range End position in chromosome
name EF215371varchar(255) values Accession of EST
intronOrientation 3smallint(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
        calJac1.all_mrna.qName (via mrnaOrientInfo.name)
      calJac1.refFlat.name (via mrnaOrientInfo.name)
      calJac1.refGene.name (via mrnaOrientInfo.name)
      calJac1.refSeqAli.qName (via mrnaOrientInfo.name)
      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)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
9Contig09630891212549EF21537130000
602Contig122779572281052EF21509240000
586Contig101156372157052EF21510800000
585Contig101831788718567EF21498300000
592Contig10210101851017765EF21486840000
585Contig102371327419601EF21507830000
585Contig102413471659700DQ82667180000
585Contig102582425533862EF21528320000
585Contig10263949013712EF21526920000
585Contig102952479925479EF21541300000

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