Cogent.Db.Ensembl Cookbook Example Returns 'Programmingerror', New Bug?
1
0
Entering edit mode
10.8 years ago
a1ultima ▴ 850

I get an error using PyCogent to query EnsEMBl's database - I suspect this is a new bug resulting from either a new update in EnsEMBL or PyCogent.

When trying to reproduce the code for the PyCogent Cookbook's Querying Ensembl doc page ("Selecting Gene's" section) I get "ProgrammingError".

enter image description here

Here's the failing cookbook code (I indicate the line where error occurs):

#!/usr/bin/python
import os

#----------------------------------------------------------
# Interrogating a Genome
#----------------------------------------------------------
from cogent.db.ensembl import HostAccount, Genome
human = Genome(Species='human', Release=Release, account=account)

#----------------------------------------------------------
# Selecting Genes
#----------------------------------------------------------
brca1 = human.getGeneByStableId(StableId='ENSG00000012048') #<--- ERRORS OUT HERE
print brca1.Description

Here's the error:

ProgrammingError: (ProgrammingError) (1146, "Table 'homo_sapiens_variation_74_37.flanking_sequence' doesn't exist") 'DESCRIBE flanking_sequence' ()

Extra info:

  • Python 2.7.3
  • PyCogent 1.5.1-2
  • Ubuntu 12.04
  • Ensmbl release 74
ensembl database • 2.5k views
ADD COMMENT
1
Entering edit mode
ADD REPLY
1
Entering edit mode
10.8 years ago
Emily 24k

Your error message suggests that you're looking at Ensembl 70, whereas you state you're looking at Ensembl 74. I'm not familiar with PyCogent but I'd guess that your error is the result of a disconnect between the database you're looking for and the database you have.

ADD COMMENT
0
Entering edit mode

unfortunately changing that did not fix the problem, i did actually experiment with many ensembl release versions and must have pasted an error message from an upstream trial'n'error - thanks for pointing that out though, very observant!

ADD REPLY

Login before adding your answer.

Traffic: 923 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6