<div><div dir="auto">Hello Sabine,</div><div dir="auto"><br></div><div dir="auto">Thanks for bringing this up. We will look into it. </div><div dir="auto"><br></div><div dir="auto">Best,</div><div dir="auto">Ameya</div></div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 25 May 2020 at 15:12, Sabine Rei?er <sabine.reisser@mdc-berlin.de> wrote:<br></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; padding-left: 1ex; border-left-color: rgb(204, 204, 204);"><div>
<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:<wbr>4641652:1<br>
Slice: chromosome Chromosome 1-4641652 (1)<br>
DBD::mysql::st execute failed: Table
'bacteria_0_collection_core_47_100_<wbr>1.analysis' doesn't exist at
/home/sabine/bin/ensembl_api/src/<wbr>ensembl/modules/Bio/EnsEMBL/DBSQL/<wbr>AnalysisAdaptor.pm
line 128.<br>
DBD::mysql::st execute failed: Table
'bacteria_0_collection_core_47_100_<wbr>1.analysis' doesn't exist at
/home/sabine/bin/ensembl_api/src/<wbr>ensembl/modules/Bio/EnsEMBL/DBSQL/<wbr>AnalysisAdaptor.pm
line 128.</p>
<p>If I run in verbose mode I get</p>
<p>Species 'escherichia_coli_str_k_12_substr_<wbr>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" style="font-family: "Courier New", Courier, monospace; color: rgb(0, 0, 0);"><br>
</font></p>
<p><font size="-1" face="Courier New, Courier, monospace" style="font-family: "Courier New", Courier, monospace; color: rgb(0, 0, 0);">use
Bio::EnsEMBL::ApiVersion;</font></p>
<font size="-1" face="Courier New, Courier, monospace" style="font-family: "Courier New", Courier, monospace; color: rgb(0, 0, 0);">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_<wbr style="font-family: "Courier New", Courier, monospace;">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 style="font-family: monospace;">--
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 href="mailto:sabine.reisser@mdc-berlin.de" style="font-family: monospace;">sabine.reisser@mdc-berlin.de</a>
<a href="http://www.mdc-berlin.de" style="font-family: monospace;">www.mdc-berlin.de</a></pre>
</div>________________________________<wbr>_______________
<br>Dev mailing list Dev@ensembl.org
<br>Posting guidelines and subscribe/unsubscribe info: https://lists.ensembl.org/mailman/<wbr>listinfo/dev_ensembl.org
<br>Ensembl Blog: http://www.ensembl.info/
<br></blockquote></div></div>