<html><head></head><body><div>Hi Malcom, </div><div><br></div><div>You'll need to access our metadata databases in order to retrieve these information, you can find the `ensembl_metadata_104` database on our public server:<br><br></div><div>`mysql --host=ensembldb.ensembl.org --port=3306 --user=anonymous`</div><div><br></div><div>Database hold a organism <-> genome (s) association per release, where you'll find your information. </div><div><br></div><div>To access programmatically I would invite you to use our dedicated PERL API available here <a href="https://github.com/Ensembl/ensembl-metadata">https://github.com/Ensembl/ensembl-metadata</a> </div><div>If you only need to retrieve information for a particular release, please have a look at our set of useful script to retrieve data <a href="https://github.com/Ensembl/ensembl-metadata/tree/release/104/misc_scripts">https://github.com/Ensembl/ensembl-metadata/tree/release/104/misc_scripts</a></div><div><br></div><div>More info about our PERL software stack available here <a href="https://www.ensembl.org/info/docs/index.html">https://www.ensembl.org/info/docs/index.html</a></div><div><br></div><div>Hope that will help you to sort things out. </div><div><br></div><div>Marc</div><div><br></div><div><br></div><div>On Sun, 2021-06-06 at 20:47 +0000, Cook, Malcolm wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div>Dear Ensembl Devs,<br></div><div><br></div><div>I am looking for programmatic way to access in tabular form the data behind these two pages:<br></div><div><br></div><div> [Species List](<a href="https://www.ensembl.org/info/about/species.html">https://www.ensembl.org/info/about/species.html</a>)<br></div><div> [Table of assemblies](<a href="https://www.ensembl.org/info/website/archives/assembly.html">https://www.ensembl.org/info/website/archives/assembly.html</a>)<br></div><div><br></div><div>Preferably a SQL query on remotely accessible mysql server.<br></div><div><br></div><div>Additionally, if it were possible to include the name used by UCSC for the assembly, if available.... (perhaps this is the same as asking for NCBI's alternate name)<br></div><div><br></div><div>Thanks for any tips and suggestions.<br></div><div><br></div><div>Malcolm Cook<br></div><div>Database Applications Manager<br></div><div>Stowers Institute for Medical Research<br></div><div>Kansas City, MO USA I<br></div><div><br></div><div><br></div><div>_______________________________________________<br></div><div>Dev mailing list <a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><br></div><div>Posting guidelines and subscribe/unsubscribe info: <a href="https://lists.ensembl.org/mailman/listinfo/dev_ensembl.org">https://lists.ensembl.org/mailman/listinfo/dev_ensembl.org</a><br></div><div>Ensembl Blog: <a href="http://www.ensembl.info/">http://www.ensembl.info/</a><br></div></blockquote><div><br></div><div><span><pre>-- <br></pre><div data-evo-paragraph="" class="" style="width: 71ch;" data-evo-signature-plain-text-mode="">Marc Chakiachvili</div><div data-evo-paragraph="" class="" style="width: 71ch;" data-evo-signature-plain-text-mode=""><br></div><div data-evo-paragraph="" class="" style="width: 71ch;">Ensembl Production Project Leader - Genomics Technology Infrastructure</div><div data-evo-paragraph="" class="" style="width: 71ch;"><br></div><div data-evo-paragraph="" class="" style="width: 71ch;">European Bioinformatics Institute (EMBL-EBI)</div><div data-evo-paragraph="" class="" style="width: 71ch;">European Molecular Biology Laboratory</div><div data-evo-paragraph="" class="" style="width: 71ch;">Wellcome Trust Genome Campus</div><div data-evo-paragraph="" class="" style="width: 71ch;">Hinxton</div><div data-evo-paragraph="" class="" style="width: 71ch;">Cambridge CB10 1SD</div><div data-evo-paragraph="" class="" style="width: 71ch;">United Kingdom</div></span></div></body></html>