Schema for mrnaOrientInfo
  Database: gorGor5    Primary Table: mrnaOrientInfo    Row Count: 909   Data last updated: 2019-09-20
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 73smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom CYUI01000001v1varchar(255) values Reference sequence chromosome or scaffold
chromStart 485469int(10) unsigned range Start position in chromosome
chromEnd 567129int(10) unsigned range End position in chromosome
name HM486757varchar(255) values Accession of EST
intronOrientation 6smallint(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
        gorGor5.all_mrna.qName (via mrnaOrientInfo.name)
      gorGor5.refFlat.name (via mrnaOrientInfo.name)
      gorGor5.refGene.name (via mrnaOrientInfo.name)
      gorGor5.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
73CYUI01000001v1485469567129HM48675760000
688CYUI01000001v11357430713603823DQ885673170000
727CYUI01000001v11864585818652403DQ885703100240
724CYUI01000003v11828956018294366U7691330000
733CYUI01000003v11949685119501049AF16478930000
600CYUI01000005v120658712068262AB44565500000
600CYUI01000005v120943492096710AB44562000000
601CYUI01000005v121175722120008AB44568300000
739CYUI01000005v12021242120212531FV52634800000
602CYUI01000013v123339662334047FV52711600000

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