Schema for mrnaOrientInfo
  Database: ornAna2    Primary Table: mrnaOrientInfo    Row Count: 1,040   Data last updated: 2020-02-05
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 10smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 15718757int(10) unsigned range Start position in chromosome
chromEnd 16166940int(10) unsigned range End position in chromosome
name JQ350810varchar(255) values Accession of EST
intronOrientation 2smallint(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)
      ornAna2.all_mrna.qName (via mrnaOrientInfo.name)
      ornAna2.refFlat.name (via mrnaOrientInfo.name)
      ornAna2.refGene.name (via mrnaOrientInfo.name)
      ornAna2.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
10chr11571875716166940JQ35081020000
593chr1011675081173672JQ35081820000
624chr1051750355175153FZ42719400000
624chr1051754265175547FZ42719600000
618chr1144419824442105FZ42723700000
1006chr35519799555198085JQ35081100000
752chr42197571321976221AF38129910100
752chr42197571521976224AF38131011100
752chr42199296921993468AF38132400000
752chr42199296921993468AY0557780280470

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