Schema for mrnaOrientInfo
  Database: dasNov3    Primary Table: mrnaOrientInfo    Row Count: 49   Data last updated: 2018-03-26
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 AAGV03245900varchar(255) values Reference sequence chromosome or scaffold
chromStart 224int(10) unsigned range Start position in chromosome
chromEnd 351int(10) unsigned range End position in chromosome
name DQ402973varchar(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
        dasNov3.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
585AAGV03245900224351DQ40297300000
586JH562474140199149408DQ40294870000
588JH562563487094488419DQ40304861000
586JH564077146954148630DQ40302342000
585JH565304100939107869EF54386310000
588JH567025424985425159DQ09664800000
598JH56785817692301788893DQ40307350000
611JH56807235136153514247HM80396800000
9JH5682019842311055829DQ11365500000
587JH568334298616310672DQ40299851000

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