Query 1
Execution time: 10ms
PREFIX n: <https://nap.nprod.net/>
SELECT ?organism ?pharmacy ?genus ?species ?family ?number ?pharmacology ?pharmacology_name ?worktype ?qualitativeResult ?compound ?compound_name
WHERE {
?organism a n:organism ;
n:participatesIn <https://nap.nprod.net/citation/140723>.
?pharmacy n:has_organism ?organism ;
n:number ?number .
OPTIONAL { ?pharmacy n:has_pharmacology ?pharmacology .
?pharmacology n:name ?pharmacology_name . }
OPTIONAL { ?pharmacy n:has_worktype ?worktype . }
OPTIONAL { ?pharmacy n:has_qualitativeresult ?qualitativeResult . }
OPTIONAL { ?organism n:genusname ?genus . }
OPTIONAL { ?organism n:speciesname ?species . }
OPTIONAL { ?organism n:familyname ?family . }
OPTIONAL { ?pharmacy n:has_participant ?compound .
?compound a n:compound ;
n:name ?compound_name . }
}
ORDER BY ?organism ?number