Schema for mrnaOrientInfo
  Database: cerSim1    Primary Table: mrnaOrientInfo    Row Count: 48   Data last updated: 2016-09-09
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 AKZM01053786varchar(255) values Reference sequence chromosome or scaffold
chromStart 3639int(10) unsigned range Start position in chromosome
chromEnd 85520int(10) unsigned range End position in chromosome
name AY948648varchar(255) values Accession of EST
intronOrientation 0smallint(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
        cerSim1.all_mrna.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
585AKZM01053786363985520AY94864800000
1114JH7677236937730169402766AM28618900000
77JH76772847398704878984AB017201000220
10JH7677281344794513712057EF49177000000
108JH7677293689912037235067JN65587901000
12JH7677312958829930567874D63575000170
109JH7677323822417538481514AB042633010000
103JH7677363159870531821189EF49175102000
792JH7677372719927727213408AM28625900000
10JH76773993124049673695AY94857301000

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