Chemical data can come from children
Chemical data information can come from children. For example: CHEBI:41981
does not have any record in the chemical_data table (SELECT * FROM chemical_data where compound_id = 41981
), but one of its children (CHEBI:29373) has the information (SELECT * FROM chemical_data where compound_id = 29373). Basically, the chemical_data is calculated taking into account the compound with the structures.default_structure = True
and as we know, the default_structure can be in children.
Then, we need to fix the above behaviour in the ontology, and then (hopefully) it will be resolved smoothly in the elasticsearch documents as well.