Schema for estOrientInfo
  Database: petMar1    Primary Table: estOrientInfo    Row Count: 120,296   Data last updated: 2011-03-30
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom Contig12583varchar(255) values Reference sequence chromosome or scaffold
chromStart 11461int(10) unsigned range Start position in chromosome
chromEnd 11772int(10) unsigned range End position in chromosome
name AA618657varchar(255) values Accession of EST
intronOrientation 0smallint(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 estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      petMar1.all_est.qName (via estOrientInfo.name)
      petMar1.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585Contig125831146111772AA61865700000
585Contig1285178708201AA6186510180420
585Contig1351610921216AA61865200000
585Contig173311353713891AA618646-10000
585Contig173311381114094AA61864710000
585Contig27982753210074AA61864910000
585Contig28091764110180AA61864910000
585Contig298641438514662AA61865500000
585Contig3362141844487AA61864510100
585Contig39311005410337AA61864710000

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