Schema for mrnaOrientInfo
  Database: caeJap1    Primary Table: mrnaOrientInfo    Row Count: 12   Data last updated: 2014-09-01
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 877smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chrUnvarchar(255) values Reference sequence chromosome or scaffold
chromStart 38354037int(10) unsigned range Start position in chromosome
chromEnd 38354732int(10) unsigned range End position in chromosome
name AY589600varchar(255) values Accession of EST
intronOrientation 1smallint(6) range Orientation of introns with respect to EST
sizePolyA 35smallint(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 8smallint(6) range PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        caeJap1.all_mrna.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
877chrUn3835403738354732AY589600135008
877chrUn3835403738354732AY589601135008
959chrUn4905746649060196AY589600935008
959chrUn4905746649060196AY589601535008
1173chrUn7707447377075624AY5896091380580
155chrUn8641758186667670AY589604815008
1304chrUn9434733494350885AY5896092380580
1408chrUn107996361107998537AY589614423000
1408chrUn107996544107998537AY589615321000
1408chrUn107997155107998537AY589616221008

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