Schema for mrnaOrientInfo
  Database: canFam6    Primary Table: mrnaOrientInfo    Row Count: 5,799   Data last updated: 2021-05-18
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 592smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 1012047int(10) unsigned range Start position in chromosome
chromEnd 1016269int(10) unsigned range End position in chromosome
name AB012223varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 18smallint(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
        canFam6.all_mrna.qName (via mrnaOrientInfo.name)
      canFam6.refFlat.name (via mrnaOrientInfo.name)
      canFam6.refGene.name (via mrnaOrientInfo.name)
      canFam6.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
592chr110120471016269AB012223018000
77chr149777234981944AB0122230180440
631chr160782206113929HM15453140000
80chr174607517833195AB012223-1180310
10chr11044990210600828AB0122230180310
686chr11336365713367878AB0122230180440
87chr11469987614866689AB154172217000
87chr11470077814866689AB116145117000
715chr11710208017103574LC223817024000
718chr11744601617449325DQ44907210000

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