Schema for mrnaOrientInfo
  Database: xenTro9    Primary Table: mrnaOrientInfo    Row Count: 31,162   Data last updated: 2020-08-20
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 589smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 628366int(10) unsigned range Start position in chromosome
chromEnd 629455int(10) unsigned range End position in chromosome
name BC168815varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 109smallint(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)
      xenTro9.all_mrna.qName (via mrnaOrientInfo.name)
      xenTro9.refFlat.name (via mrnaOrientInfo.name)
      xenTro9.refGene.name (via mrnaOrientInfo.name)
      xenTro9.refSeqAli.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
589chr1628366629455BC1688150109000
589chr1651455652529BC0900850430630
73chr1652993655826BC1006100380600
76chr132010014109655BC1351201615000
77chr148541705081713BC091038825000
9chr150428005396681BC1604273310530
77chr150677615227735BC157548115000
77chr150677635190311BC08781610000
631chr160833926083475FV52737700000
631chr160834416083462FV52465401000

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