Schema for mrnaOrientInfo
  Database: ailMel1    Primary Table: mrnaOrientInfo    Row Count: 185   Data last updated: 2019-12-04
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 600smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom GL192339.1varchar(255) values Reference sequence chromosome or scaffold
chromStart 1976714int(10) unsigned range Start position in chromosome
chromEnd 1980803int(10) unsigned range End position in chromosome
name HQ318070varchar(255) values Accession of EST
intronOrientation 4smallint(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
        ailMel1.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
600GL192339.119767141980803HQ31807040000
597GL192344.116710771685015GQ84913230000
594GL192348.112842491287516HM04780443100
598GL192348.118252821827473HQ31809530000
613GL192348.137914493791881KP94303700000
609GL192349.131723583180084KC66250590000
588GL192350.1423262423702KP94303900000
596GL192350.115158811523606DQ16651230000
596GL192350.115158811523606DQ85234030000
597GL192350.116883071689298DQ34912010000

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