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

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
586chr1194087199924AK306029544000
586chr1194087199936AK305466517000
587chr1355943356032FZ42713700000
587chr1355995356017FZ42649300000
588chr1437963457999AK306358615000
588chr1468432474995AF038165120000
588chr1496155509890AK3059571612000
588chr1496155509895AK3060181618000
73chr1520539527663AK3055261115000
73chr1521425534458AY665280140000

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