Returning all metabolites in a given clade, including possibly missing properties about lotus-web HOT 10 CLOSED

SELECT DISTINCT ?structure ?structureLabel ?structure_smiles ?structure_cas ?structure_inchikey ?organism ?organism_name WHERE {
  VALUES ?taxon {
    wd:Q55925442
  }
  ?organism (wdt:P171*) ?taxon;
    wdt:P225 ?organism_name.
  ?structure (p:P703/ps:P703) ?organism.
  OPTIONAL { ?structure wdt:P235 ?structure_inchikey. }
  OPTIONAL { ?structure wdt:P233 ?structure_smiles. }
  OPTIONAL { ?structure wdt:P231 ?structure_cas. }
  BIND (CONCAT(COALESCE(?structure_inchikey,""), COALESCE(?structure_smiles,""), COALESCE(?structure_cas,"")) AS ?key)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  FILTER (STRLEN(?key) > 1)
}
LIMIT 100000

SELECT DISTINCT ?structure ?structureLabel ?structure_smiles ?structure_cas ?structure_inchikey ?organism ?organism_name WHERE {
  VALUES ?taxon {
    wd:Q21754
  }
  ?organism (wdt:P171*) ?taxon;
    wdt:P225 ?organism_name.
  ?structure wdt:P233 ?structure_smiles;
    (p:P703/ps:P703) ?organism.
  OPTIONAL {
    ?structure wdt:P231 ?structure_cas;
      wdt:P235 ?structure_inchikey.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100000

SELECT DISTINCT ?structure ?structureLabel ?structure_smiles ?structure_cas ?structure_inchikey ?organism ?organism_name WHERE {
  VALUES ?taxon {
    wd:Q55925442
  }
  ?organism (wdt:P171*) ?taxon; # Include children taxa
    wdt:P225 ?organism_name. # Get organism name
  ?structure wdt:P233 ?structure_smiles; # Get the SMILES
    (p:P703/ps:P703) ?organism.   # Found in given taxon/taxa
  OPTIONAL {
    ?structure wdt:P231 ?structure_cas;
      wdt:P235 ?structure_inchikey.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100000

SELECT DISTINCT ?structure ?structureLabel ?structure_smiles ?structure_cas ?structure_inchikey ?organism ?organism_name WHERE {
  VALUES ?taxon {
    wd:Q55925442
  }
  ?organism (wdt:P171*) ?taxon;
    wdt:P225 ?organism_name.
  ?structure wdt:P233 ?structure_smiles;
    (p:P703/ps:P703) ?organism.
  OPTIONAL { ?structure wdt:P235 ?structure_inchikey. }
  OPTIONAL { ?structure wdt:P231 ?structure_cas. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100000

SELECT DISTINCT ?structure ?structureLabel ?structure_smiles ?structure_cas ?structure_inchikey ?organism ?organism_name WHERE {
  VALUES ?taxon {
    wd:Q55925442
  }
  ?organism (wdt:P171*) ?taxon;
    wdt:P225 ?organism_name.
  ?structure (p:P703/ps:P703) ?organism.
  OPTIONAL { ?structure wdt:P235 ?structure_inchikey. }
  OPTIONAL { ?structure wdt:P233 ?structure_smiles. }
  OPTIONAL { ?structure wdt:P231 ?structure_cas. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100