Schema for mrnaOrientInfo
  Database: canFam4    Primary Table: mrnaOrientInfo    Row Count: 6,036   Data last updated: 2020-05-06
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 615smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 3943956int(10) unsigned range Start position in chromosome
chromEnd 3948177int(10) unsigned range End position in chromosome
name AB012223varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 18smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 44smallint(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
        canFam4.all_mrna.qName (via mrnaOrientInfo.name)
      canFam4.refFlat.name (via mrnaOrientInfo.name)
      canFam4.refGene.name (via mrnaOrientInfo.name)
      canFam4.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
615chr139439563948177AB0122230180440
623chr150450435080782HM15453140000
679chr11240922812413449AB0122230180440
86chr11381158613978482AB154172217000
86chr11381249713978482AB116145117000
708chr11621418016215676LC223817024000
88chr11642364716762618AB0122230180440
711chr11655893316562268DQ44907210000
715chr11711519117130739J0506950000
92chr12016617120523442X51448170000

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