Schema for mrnaOrientInfo
  Database: petMar3    Primary Table: mrnaOrientInfo    Row Count: 3,567   Data last updated: 2020-08-19
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 638smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom PIZI01000001v1varchar(255) values Reference sequence chromosome or scaffold
chromStart 6957882int(10) unsigned range Start position in chromosome
chromEnd 6964904int(10) unsigned range End position in chromosome
name AY130404varchar(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
        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)
      petMar3.all_mrna.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
638PIZI01000001v169578826964904AY13040440000
655PIZI01000001v191918969194911KU68073500000
655PIZI01000001v191938859193944KT23576400000
658PIZI01000001v196034309603775KU72661810000
665PIZI01000001v11057728710584865KT46256460000
717PIZI01000001v11738942117402240EU08658720000
775PIZI01000001v12496577225007142JN2420007130370
612PIZI01000002v135393453575343EU08967460000
615PIZI01000002v140169064023036D55629200220
84PIZI01000002v11166001111676887FJ46177750000

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