Knowledge base index
| Description | |
|---|---|
| Statistics | Number of triples: |
Fulltext index
| Description | |
|---|---|
| Statistics |
Number of distinct text records: Number of distinct word occurrences: Number of distinct entity occurrences: |
Basic settings
| Backend name | METRINKG |
|---|---|
| Backend slug | metrin-kg |
| Backend URL | https://qlever.earthmetabolome.org/api/metrin-kg |
| Is default: | Yes |
| Fill known prefixes: | Yes |
| Languages: | en |
| Default maximum | 100 rows |
| Default mode: | 3. SPARQL & context sensitive entities |
| Access Token |
Features
| Supported Keywords: | as, base, bind, by, construct, contains-entity, contains-word, data, delete, distinct, filter, from, graph, group, has-predicate, having, insert, internal, keywords, limit, minus, named, not, offset, optional, optional, order, prefix, select, service, sort, textlimit, union, using, values, where, with |
|---|---|
| Supported Functions: | asc, desc, avg, values, score, text, count, sample, min, max, average, concat, group_concat, langMatches, lang, regex, sum |
QLever UI Shortcuts:
| ctrl + enter | Send query to backend |
| tab | Jump to the next placeholder |
| ctrl + space | Invoke auto suggestions |
| ▲ or ▼ | Move through suggestions |
| enter | Choose the selected suggestion |
| esc | Close suggestion window |
| ctrl + f | Search in editor (supports RegEx) |
| ctrl + r | Search and replace in editor |
- ex:1 Among the SIRIUS structural annotations from Tabernaemontana coffeoides (Apocynaceae) seeds extract, which ones are reported in the Tabernaemontana genus?
- ex:2 Among the structural annotations from Tabernaemontana coffeoides (Apocynaceae) seeds extract, which ones contain an aspidospermidine substructure?
- ex:3 Filter the positive ionization mode features of Melochia umbellate annotated as [M+H]+ by SIRIUS to keep the ones for which a feature in negative ionization mode is detected with the same retention time (± 3 seconds) and a mass corresponding to the [M-H]- adduct (± 5 ppm).
- ex:4 For features from Melochia umbellata in positive ionization mode with SIRIUS annotations, get the ones for which a feature in negative ionization mode with the same retention time (± 3 sec) has the same SIRIUS annotation (2D InChIKey).
- ex:5 How many features have the same SIRIUS and ISDB annotation?
- ex:6 Search spectrally related features with and within the VGF151_E05 sample of a datura stramonium through counts of common peaks and loss. Return their species, family and genus names
- ex:7 Show chemical structures in Melochia umbellata extracts with structural annotations where the cosmic score is greater than 0.5 and the zodiac score is less than 0.8. For ISDB annotations, consider taxon scores greater than or equal to 6
- ex:8 Which features in the positive ionization mode have the most fragments and neutral losses in common with the feature identified as mzspec:MSV000087728:VGF143_H08_features_ms2_pos.mgf:scan:707
- ex:9 Which samples have features annotated as Aspidosperma_type alkaloids by CANOPUS with a probability score above 0.5, ordered by the decreasing count of features?
- ex:11 List interactions of all species which have an IUCN status (wdt:P141) of near threatened (wd:Q719675).
- ex:12 List traits of all species which have an IUCN status (wdt:P141) of near threatened (wd:Q719675).
- ex:13 List all metabolites produced by species with near threatened (wd:Q719675) IUCN status (wdt:P141) and with values available (or greater than a specific value) for trait 'Seed dry mass'.
- ex:14 List traits (and their values) of plants producing Diterpenoids
- ex:15 List of possible natural locations of organisms, which produce Bahamaolide A, (wd:Q75068439) which is an antifungal (https://doi.org/10.1021/np3001915).
- ex:16 List of possible natural locations of plants, which produce senkyunolide (wd:Q27251426) which is a thalide for cerebral disorders (https://doi.org/10.3390/molecules28083636).
- ex:17 List metabolites of plants that interact with plant parasite moth Orgyia postica (wd:Q7102162) .
- ex:18 List links between host-parasite and host-allelopathic interactions, where host is an agricultural crop, allelopath is usually a plant that inhibits growth of parasites which are usually insects. Inhibition happens by root/stem/leaf exudates of the allelopath.
- ex:19 A list of interactions depicting connections between parasatoids harmful for insects living as parasites on plants.
- ex:20 Natural producers (and their interactions that might be useful in agriculture) of Onpordopicrin (wd:Q27107580), which might exhibit antimicrobial and cytotoxic activities, especially against human-derived macrophages and against epidermoid carcinoma cells. There is limited scientific evidence to support these claims (https://www.sciencedirect.com/science/article/abs/pii/S138614251500685X).
- ex:21 List possible interactions of plants that can produce Norhyocyamine (wd:Q27107545), a plant secondary metabolite.
- ex:22 Retrieve data of 4 traits in leaf economics spectrum.
- ex:23 Retrieve metabolites of organisms with data available from 4 traits in leaf economics spectrum.
- Sorry, no examples found :(
Warning:
Query results:
Error:
Update successful!