Schema for mrnaOrientInfo
  Database: saiBol1    Primary Table: mrnaOrientInfo    Row Count: 61   Data last updated: 2016-04-25
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 667smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom JH378105varchar(255) values Reference sequence chromosome or scaffold
chromStart 10770275int(10) unsigned range Start position in chromosome
chromEnd 10774869int(10) unsigned range End position in chromosome
name AY665215varchar(255) values Accession of EST
intronOrientation 11smallint(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
        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)
      saiBol1.all_mrna.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
667JH3781051077027510774869AY665215110000
836JH3781053295300532954902DQ14387310000
75JH37810625848592709139U8795170000
98JH3781072711744127210935AY665243240000
102JH3781083051668730539954EF692507110000
14JH3781084704111947419849AY665246160000
87JH3781091504031615080689AY665223150000
700JH3781121509591415098396DQ14387220000
840JH3781123344767633514894AF14075980000
589JH378113583162598506AY74061460000

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