search

ebi-chebi / ChEBI

Chemical Entities of Biological Interest (ChEBI) is a freely available dictionary of molecular entities focused on ‘small’ chemical compounds.
https://www.ebi.ac.uk/chebi
Creative Commons Attribution 4.0 International
43 stars 10 forks source link

SPECIES_ORIGINS - Multiple species names for same taxon #2858

Open muthuvenkat opened 10 years ago

muthuvenkat commented 10 years ago

This query returns 58 unique entries where different names apparently are used for the same taxon id:

select distinct c1.species_text, c2.species_text, c1.species_accession from compound_origins c1, compound_origins c2 where lower(trim(c1.species_text)) != lower(trim(c2.species_text)) and c1.species_accession = c2.species_accession;

Reported by: khaug

muthuvenkat commented 8 years ago

@G-Owen , @khaug all of them are synonyms, so in a way its not wrong, but we can fix it to make it consistent. origins.txt

adekker2 commented 7 years ago

Trying to fix those are well doable when the mismatch is created from a typo. Unfortunately many are just synonyms because of how the citation calls the species at that particular publication. On top of that there is the challenge of Species name without taxon. All these situations are now the accepted norm. Is it ok for your group?

khaug commented 7 years ago

How many entries does the query return now? Can we just do a direct database update on what's there? In regards to how important this is, I had completely forgotten that this case existed