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

molecule hierarchy not present within molecule API #160

Closed FionaEBI closed 6 years ago

FionaEBI commented 6 years ago

Hi Juan, For the TransQST platform, I notice that for two compounds there is no molecule hierarchy present within the 'molecule' web services API. These are: 'CHEMBL2110557'& 'CHEMBL1201289' for 'RUBIDIUM CHLORIDE' & 'CLINDAMYCIN PALMITATE'. As far as I can tell from directly querying the chembl database in sql then both these molecules have a parent_chemblid and molecule_chemblid present - so it doesn't appear to be a curation issue. See the screenshots below: screen shot 2018-06-26 at 14 35 56 screen shot 2018-06-26 at 14 36 11

And the sql query direct on the database: screen shot 2018-06-26 at 14 38 40 screen shot 2018-06-26 at 14 38 47

Thanks for your help! Fiona

FionaEBI commented 6 years ago

Thinking about this further, I realise that this issue is to do with the compound being a virtual parent compound ie one that has no bioactivity data associated with it (the bioactivity data is associated with the salt, not the parent). I previously had a email conversation with Anna @agaulton about this, and she said that a parent compound is only present in the molecule hierarchy if it has associated bioactivity data (which is not true for virtual parent compounds).

However, this means that it looks odd for a few compounds within the TransQST platform that have no parent_chembl_id - see screenshot. Perhaps this needs further thought? screen shot 2018-06-26 at 15 03 49

juanfmx2 commented 6 years ago

closing and opening chembl/chembl_data#72 to continue the discussion