Schema for mrnaOrientInfo
  Database: panTro6    Primary Table: mrnaOrientInfo    Row Count: 6,930   Data last updated: 2018-07-25
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 353int(10) unsigned range Start position in chromosome
chromEnd 12294int(10) unsigned range End position in chromosome
name AK305957varchar(255) values Accession of EST
intronOrientation 9smallint(6) range Orientation of introns with respect to EST
sizePolyA 16smallint(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)
      panTro6.all_mrna.qName (via mrnaOrientInfo.name)
      panTro6.refFlat.name (via mrnaOrientInfo.name)
      panTro6.refGene.name (via mrnaOrientInfo.name)
      panTro6.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585chr135312294AK305957916000
585chr135312299AK306018922000
585chr12294330047AK3055261115000
585chr12382936841AY665280140000
585chr13961945507AK306494915200
585chr18932591864AK306758112000
9chr19979401064692AK3060819540770
9chr19979401070535AK30659513540770
9chr19979401070575AK30502613260490
74chr112834991325677AK3057002319000

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