Schema for mrnaOrientInfo
  Database: equCab1    Primary Table: mrnaOrientInfo    Row Count: 32,719   Data last updated: 2020-08-21
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 665smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 10559301int(10) unsigned range Start position in chromosome
chromEnd 10575844int(10) unsigned range End position in chromosome
name AJ439892varchar(255) values Accession of EST
intronOrientation 2smallint(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
        equCab1.all_mrna.qName (via mrnaOrientInfo.name)
      equCab1.refFlat.name (via mrnaOrientInfo.name)
      equCab1.refGene.name (via mrnaOrientInfo.name)
      equCab1.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
665chr11055930110575844AJ43989220000
665chr11057715610577295AJ43989300000
665chr11059383210605005AJ31990730000
697chr11478611914802971AF359386100000
698chr11483802814854871X662181100220
785chr12621454626216397AY24676230000
788chr12672673726732821D30688700260
788chr12672673726732821NM_001082523700260
839chr13331420233356375EU0148938270490
839chr13331420233356375NM_0011016528270490

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