query-91e3b5ec839bdd4b6e9a3645d19e7c66
title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: What are examples of organisms where compounds were found in an organism sharing the same parent taxon, but not the organism itself?
SELECT DISTINCT ?compound ?compoundLabel ?taxonname_with_compound ?taxonname_without_compound ?parent_taxon WITH{
SELECT DISTINCT ?compound ?taxon_with_compound ?parent_taxon
WHERE {
?compound wdt:P235 ?inchikey.
SERVICE bd:sample { ?compound wdt:P703 ?taxon_with_compound. bd:serviceParam bd:sample.limit 1000 }
?taxon_with_compound wdt:P171 ?parent_taxon.
}
} AS %taxon_with_compound
WITH
{
SELECT DISTINCT ?taxon_without_compound ?parent_taxon ?compound
WHERE {
INCLUDE %taxon_with_compound
?taxon_without_compound wdt:P171 ?parent_taxon.
FILTER (?taxon_with_compound != ?taxon_without_compound)
}
} AS %taxon2
WHERE {
INCLUDE %taxon_with_compound
INCLUDE %taxon2
FILTER NOT EXISTS {?compound wdt:P703 ?taxon_without_compound.}
?taxon_with_compound wdt:P225 ?taxonname_with_compound.
?taxon_without_compound wdt:P225 ?taxonname_without_compound.
?compound rdfs:label ?compoundLabel.
FILTER(LANG(?compoundLabel) = "en").
}
LIMIT 10000
Query found at
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/de
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/en
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/fr
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/it
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/nl
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/ru