chembl / chembl_webservices_2

Source code of the ChEMBL web services.
https://www.ebi.ac.uk/chembl/ws
Other
16 stars 3 forks source link

Missing data in organism classification #128

Closed juanfmx2 closed 6 years ago

juanfmx2 commented 7 years ago

Right now the WS of organism offers classifications only up to level 3 from the table ORGANISM_CLASS

https://www.ebi.ac.uk/chembl/api/data/organism.json

{
    "l1": "Eukaryotes",
    "l2": "Mammalia",
    "l3": "Rodentia",
    "oc_id": 1,
    "tax_id": 10030
},
{
    "l1": "Eukaryotes",
    "l2": "Mammalia",
    "l3": "Primates",
    "oc_id": 2,
    "tax_id": 9593
}

However, it is missing the l4 information that can be a list of synonyms when joining the table ORGANISM_SYNONYMS using the tax_id

{
    "l1": "Eukaryotes",
    "l2": "Mammalia",
    "l3": "Rodentia",
    "oc_id": 1,
    "tax_id": 10030,
    "l4_synonyms" : [
        "lesser long-tailed hamster",
        "Cricetulus longicaudatus",
        "long-tailed hamster",
        "long-tailed dwarf hamster"
    ]
},
{
    "l1": "Eukaryotes",
    "l2": "Mammalia",
    "l3": "Primates",
    "oc_id": 2,
    "tax_id": 9593,
    "l4_synonyms" : [
        "Gorilla gorilla",
        "western gorilla",
        "Gorilla gorilla (Savage, 1847)",
        "gorilla"
    ]
}
mnowotka commented 6 years ago

Done.