<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi everyone,</p>
<p>I'm trying to access E. coli genes via the API. <br>
</p>
<p>The output I get is</p>
<p>The API version used is 100<br>
chromosome:ASM584v2:Chromosome:1:4641652:1<br>
Slice: chromosome Chromosome 1-4641652 (1)<br>
DBD::mysql::st execute failed: Table
'bacteria_0_collection_core_47_100_1.analysis' doesn't exist at
/home/sabine/bin/ensembl_api/src/ensembl/modules/Bio/EnsEMBL/DBSQL/AnalysisAdaptor.pm
line 128.<br>
DBD::mysql::st execute failed: Table
'bacteria_0_collection_core_47_100_1.analysis' doesn't exist at
/home/sabine/bin/ensembl_api/src/ensembl/modules/Bio/EnsEMBL/DBSQL/AnalysisAdaptor.pm
line 128.</p>
<p>If I run in verbose mode I get</p>
<p>Species 'escherichia_coli_str_k_12_substr_mg1655' (id:99) loaded
from database 'bacteria_0_collection_core_47_100_1'.</p>
<p>Maybe I'm missing something in the installation?</p>
<p>It would be great if someone could give me a hint.</p>
<p>Please find my code below. <br>
</p>
<p>Cheers</p>
<p>Sabine<br>
</p>
<p><font face="Courier New, Courier, monospace"><br>
</font></p>
<p><font size="-1" face="Courier New, Courier, monospace">use
Bio::EnsEMBL::ApiVersion;</font></p>
<font size="-1" face="Courier New, Courier, monospace">printf( "The
API version used is %s", software_version() ); <br>
use Bio::EnsEMBL::Registry;<br>
<br>
my $registry = 'Bio::EnsEMBL::Registry';<br>
$registry->load_registry_from_db(<br>
-host => 'mysql-eg-publicsql.ebi.ac.uk',<br>
-port => 4157,<br>
);<br>
<br>
my $sp_EC = 'escherichia_coli_str_k_12_substr_mg1655';<br>
my $group = 'Core';<br>
<br>
my $slice_adaptor = $registry->get_adaptor($sp_EC, $group,
"slice");<br>
$slices = $slice_adaptor->fetch_all('toplevel');<br>
foreach my $slice (@$slices) {<br>
print $slice->name(), "\n";<br>
my $coord_sys = $slice->coord_system()->name();<br>
my $seq_region = $slice->seq_region_name();<br>
my $start = $slice->start();<br>
my $end = $slice->end();<br>
my $strand = $slice->strand();<br>
<br>
print "Slice: $coord_sys $seq_region $start-$end
($strand)\n"; <br>
foreach my $gene ( @{ $slice->get_all_Genes() } ) {<br>
print $gene->stable_id(), "\n";<br>
}<br>
}</font><br>
<br>
<p><br>
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Dr. Sabine Reißer
Postdoctoral researcher
Bioinformatics of RNA Structure and Transcriptome Regulation
Berlin Institute for Medical Systems Biology
Max Delbrück Center for Molecular Medicine in the Helmholtz Association
Hannoversche Str. 28, 10115 Berlin, Germany
Tel.: +49 30 9406-3294
<a class="moz-txt-link-abbreviated" href="mailto:sabine.reisser@mdc-berlin.de">sabine.reisser@mdc-berlin.de</a>
<a class="moz-txt-link-abbreviated" href="http://www.mdc-berlin.de">www.mdc-berlin.de</a></pre>
</body>
</html>