Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for imageClone
  Database: bosTau4    Primary Table: imageClone    Row Count: 696,942
Format description: GenBank IMAGE clone info
fieldexampleSQL type description
imageId 252897int IMAGE ID
acc AF520790char(12) GenBank accession
type mRNAenum('EST','mRNA') Full length ('mRNA') or EST ('EST')
direction 0enum('5','3','0') Read direction ('5','3','0')

  Connected Tables and Joining Fields
        bosTau4.all_est.qName (via imageClone.acc)
      bosTau4.all_mrna.qName (via imageClone.acc)
      bosTau4.estOrientInfo.name (via imageClone.acc)
      bosTau4.gbCdnaInfo.acc (via imageClone.acc)
      bosTau4.gbSeq.acc (via imageClone.acc)
      bosTau4.gbStatus.acc (via imageClone.acc)
      bosTau4.intronEst.qName (via imageClone.acc)
      bosTau4.mgcFullMrna.qName (via imageClone.acc)
      bosTau4.mgcGenes.name (via imageClone.acc)
      bosTau4.mrnaOrientInfo.name (via imageClone.acc)
      bosTau4.refFlat.name (via imageClone.acc)
      bosTau4.refGene.name (via imageClone.acc)
      bosTau4.refLink.mrnaAcc (via imageClone.acc)
      bosTau4.refSeqAli.qName (via imageClone.acc)
      bosTau4.refSeqStatus.mrnaAcc (via imageClone.acc)
      bosTau4.refSeqSummary.mrnaAcc (via imageClone.acc)
      bosTau4.xenoMrna.qName (via imageClone.acc)

  Sample Rows
 
imageIdacctypedirection
252897AF520790mRNA0
261239AF520791mRNA0
267151AF520792mRNA0
548060AF520793mRNA0
40370AF520794mRNA0
347003AF520795mRNA0
288935AF520796mRNA0
294877AF520797mRNA0
8458375EU366483mRNA0
24166AY730278mRNA0

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