<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hello,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I am trying to analyse bacterial genomes via direct MySQL access to *<b>core</b>* databases according to <a href="http://ensemblgenomes.org/info/access/mysql">http://ensemblgenomes.org/info/access/mysql</a> <o:p></o:p></p><p class=MsoNormal>The datasets of my interest (e.g. bacteria_95_collection_core_28_81_1) are organised as “collection of species”, though they use the DB schema designed initially for single organism datasets. For example, table “genes” contains genes for all 19 species, without any note of species. How one could find out genes – species relationship from these “multi-species” datasets?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for your help,<o:p></o:p></p><p class=MsoNormal>Dmitry.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Dmitry Kuznetsov<o:p></o:p></p><p class=MsoNormal>+41 (21) 692-40-62<o:p></o:p></p><p class=MsoNormal><a href="mailto:Dmitry.Kuznetsov@isb-sib.ch">Dmitry.Kuznetsov@isb-sib.ch</a><o:p></o:p></p><p class=MsoNormal><a href="http://www.isb-sib.ch/">www.isb-sib.ch</a><o:p></o:p></p><p class=MsoNormal><img border=0 width=250 height=135 id="Picture_x0020_1" src="cid:image003.png@01D0F703.DD5E6D20" alt="https://www.isb-sib.ch/galleries/xmax-children-2013/asdfjhaskjhiuz3124kjhaskjh231487sdfjoasidfjaohj3487cskdjksh35sdjsk34921387432kj4nh123k09as8dasdfaskdfhaskdjfhksh2341kh/sib_logo.png"><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>