AgReFed::Search

Query
Help

Search Query [WIP]

The SUBA™️ query language is a sophisticated but simple query language that understands relationships between tables. Thus you can find information based not only on the target table column values but how it relates to other data in the dataset.

For example to find plots that have MS/MS peptides that belong to proteins that indicate "aspartate degradation" and have a yield greater that 7.0 and has NVDI all greater than .1" try: peptides.proteins.mapcave_bin like "%degradation.aspartate%" AND crop_yield > 7.0 AND nvdis all (NVDI > .1)

Target Table:

Per Page:

Order by:

Select fields:

SUBA Query Help

The SUBA query language is a simple but powerful query language that understands relationships between tables. For example the following query joins 4 tables and ask the question "Are there any plots with yields greater that 7.0 that have MS/MS proteins involved in aspartate degradation?"


curl -X POST "https://webapps.plantenergy.uwa.edu.au/agrefed_dale/suba/query" \
    -H "Content-Type: application/x-www-form-urlencoded" \
    -d "query=peptides.proteins.mapcave_bin like '%25degradation.aspartate%25' AND crop_yield > 7.0" \
    -d "per_page=10" -d "entity_name=Plot" # just enough percent encoding to make it work

Or from javascript...


var formData = new FormData();
formData.append("query", "peptides.proteins.mapcave_bin like '%degradation.aspartate%' AND crop_yield > 7.0");
fetchData.append("per_page", 10);
fetchData.append("entity_name", "Plot");
fetch("https://webapps.plantenergy.uwa.edu.au/agrefed_dale/suba/query", 
    {method: 'POST', body: formData}).then(resp => resp.json()).then(json => console.log(json));

Some more examples can be found here.