Schema for mrnaOrientInfo
  Database: canFam2    Primary Table: mrnaOrientInfo    Row Count: 6,328   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 646smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 8072683int(10) unsigned range Start position in chromosome
chromEnd 8108427int(10) unsigned range End position in chromosome
name HM154531varchar(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
        canFam2.all_mrna.qName (via mrnaOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
646chr180726838108427HM15453140000
1chr11674304816909853AB154172217000
1chr11674394216909853AB116145117000
1chr11674394316909650AY50956310000
733chr11947880719481925DQ44907210000
737chr12002918220044726J0506950000
11chr12306725423423773X51448170000
804chr12871470328736967U396635160370
814chr13012644330126594AF31741600000
13chr13877710339263723AY095485711000

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