Schema for mrnaOrientInfo
  Database: calJac4    Primary Table: mrnaOrientInfo    Row Count: 1,847   Data last updated: 2020-09-21
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 634smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 6468068int(10) unsigned range Start position in chromosome
chromEnd 6468127int(10) unsigned range End position in chromosome
name MF191410varchar(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
        calJac4.all_mrna.qName (via mrnaOrientInfo.name)
      calJac4.refFlat.name (via mrnaOrientInfo.name)
      calJac4.refGene.name (via mrnaOrientInfo.name)
      calJac4.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
634chr164680686468127MF19141000000
634chr164683556468413MF19140900000
634chr164685256468584MF19140800000
634chr164686576468716MF19140600000
634chr164687736468832MF19140000000
1080chr16496362864963693MF19140700000
1097chr16711688267117795HE96224200000
1125chr17089893070899004MF19140500000
1125chr17090138370901458MF19140400000
1145chr17351945073526277EF21508630000

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