Hi!<div><br></div><div>Yes, the meta table of the Drosophila_virilis_core_64_12 database has multiple records, as shown below:</div><div><br></div><div><div><font class="Apple-style-span" face="'courier new', monospace">+---------+------------+------------------------+--------------------------------------------------------+</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| meta_id | species_id | meta_key | meta_value |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">+---------+------------+------------------------+--------------------------------------------------------+</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 1 | NULL | schema_type | core |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 2 | NULL | schema_version | 64 |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 3 | NULL | patch | patch_63_64_a.sql|schema_version |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 4 | NULL | patch | patch_63_64_b.sql|add_operons |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 5 | NULL | patch | patch_63_64_c.sql|is_ref_added_to_alt_allele |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 6 | NULL | patch | patch_63_64_d.sql|linkage_type change in ontology_xref |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 7 | 1 | species.taxonomy_id | 7244 |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 8 | 1 | species.common_name | Drosophila virilis Sturtevant, 1916 |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 9 | 1 | species.classification | virilis |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 10 | 1 | species.classification | virilis group |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 11 | 1 | species.classification | Drosophila |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 12 | 1 | species.classification | Drosophiliti |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 13 | 1 | species.classification | Drosophilina |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 14 | 1 | species.classification | Drosophilini |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 15 | 1 | species.classification | Drosophilinae |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 16 | 1 | species.classification | Drosophilidae |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 17 | 1 | species.classification | Ephydroidea |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 18 | 1 | species.classification | Acalyptratae |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 19 | 1 | species.classification | Schizophora |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 20 | 1 | species.classification | Cyclorrhapha |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 21 | 1 | species.classification | Eremoneura |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 22 | 1 | species.classification | Muscomorpha |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 23 | 1 | species.classification | Brachycera |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 24 | 1 | species.classification | Diptera |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 25 | 1 | species.classification | Endopterygota |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 26 | 1 | species.classification | Neoptera |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 27 | 1 | species.classification | Pterygota |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 28 | 1 | species.classification | Dicondylia |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 29 | 1 | species.classification | Insecta |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 30 | 1 | species.classification | Hexapoda |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 31 | 1 | species.classification | Pancrustacea |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 32 | 1 | species.classification | Mandibulata |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 33 | 1 | species.classification | Arthropoda |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 34 | 1 | species.classification | Panarthropoda |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 35 | 1 | species.classification | Protostomia |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 36 | 1 | species.classification | Coelomata |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 37 | 1 | species.classification | Bilateria |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 38 | 1 | species.classification | Eumetazoa |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 39 | 1 | species.classification | Metazoa |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 40 | 1 | species.classification | Opisthokonta |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 41 | 1 | species.classification | Eukaryota |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 42 | 1 | species.classification | cellular organisms |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">| 43 | 1 | assembly.default | v1 |</font></div><div><font class="Apple-style-span" face="'courier new', monospace">| 44 | 1 | assembly.mapping | supercontig:v1|chunk:v1 |</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">+---------+------------+------------------------+--------------------------------------------------------+</font></div><div><br></div>On Thursday, October 27, 2011, Anne Parker wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Diogo<br>
<br>
Did you load the Drosophila taxonomy into the meta table? That's what's used by the webcode to sort the species in the dropdown list - if there are no entries, or the entries are wrong, the species will be ignored.<br>
<br>
Cheers<br>
<br>
Anne<br>
<br>
<br>
On 27 Oct 2011, at 10:38, Diogo Costa wrote:<br>
<br>
> Hello!<br>
><br>
> In the process of my masters dissertation I created a mirror of Ensembl web site in a local server. It is up and running except for BLAST and search functionality.<br>
><br>
> I've been trying to insert a new species (Drosophila virilis, from FlyBase), but have been unsuccessful so I was wondering if someone could give some pointers!<br>
><br>
> I've tried to follow the instructions on these two sites:<br>
><br>
> - Ensembl doc:<br>
> <a href="http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl-doc/loading_sequence_into_ensembl.txt?revision=1.5&root=ensembl&pathrev=MAIN" target="_blank">http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl-doc/loading_sequence_into_ensembl.txt?revision=1.5&root=ensembl&pathrev=MAIN</a><br>
><br>
> - Loading an Ensembl species database from scratch<br>
> <a href="http://www.warelab.org/blog/?p=218" target="_blank">http://www.warelab.org/blog/?p=218</a><br>
><br>
> I have the genome sequences by scaffold and chromossomes and the CDS in FASTA format. Following the "Loading chromosome sequences and faking the assembly" section of the second link, I adjusted the script given to suit my data. I've managed to insert the data into the MySQL database.<br>
><br>
> Then, I followed the instructions on <a href="http://www.ensembl.org/info/docs/webcode/species/index.html" target="_blank">http://www.ensembl.org/info/docs/webcode/species/index.html</a> to make the specie information available from the website.<br>
><br>
> However, the specie doesn't show up in the list of species (yes, I have deleted config/packed/* and config/config.packed and restarted the server).<br>
> When accessing the URL manually (http://..../Drosophila_virilis/Info/Index) I don't get any error in the log file.<br>
><br>
> The server is running on top of Fedora 14, if it makes any difference..<br>
><br>
> I don't really know what I can do, or what other information I need to give to Ensembl.<br>
><br>
> Is this not the way to go?<br>
><br>
> Sorry for the long email,<br>
> Diogo Costa<br>
> Portugal<br>
> _______________________________________________<br>
> Dev mailing list <a href="javascript:;" onclick="_e(event, 'cvml', 'Dev@ensembl.org')">Dev@ensembl.org</a><br>
> List admin (including subscribe/unsubscribe): <a href="http://lists.ensembl.org/mailman/listinfo/dev" target="_blank">http://lists.ensembl.org/mailman/listinfo/dev</a><br>
> Ensembl Blog: <a href="http://www.ensembl.info/" target="_blank">http://www.ensembl.info/</a><br>
<br>
Anne Parker<br>
Ensembl Web Production Manager<br>
<a href="http://www.ensembl.org" target="_blank">http://www.ensembl.org</a><br>
<br>
<br>
<br>
<br>
<br>
--<br>
The Wellcome Trust Sanger Institute is operated by Genome Research<br>
Limited, a charity registered in England with number 1021457 and a<br>
company registered in England with number 2742969, whose registered<br>
office is 215 Euston Road, London, NW1 2BE.<br>
</blockquote></div>