Data item to associate with a concentration

[ddooley]

I am wondering how you encode datums about concentrations. I'm guessing you just have separate tabular columns in a database for that? For example:

In an RDF graph view could I have an instance of a "concentration data item" which "is about" the concentration above?

In a pesticide ontology I was thinking of this structure that provides information about active ingredients of pesticides (where "has active ingredient" is a subproperty of "has part":

So here the concentration data item references an instance of a chemical its about, and that instance is part of the pesticide (or active ingredient of it). Would this be criticized as leaving implicit (via the part of relation) what is bearing the concentration?
(Note the concentration datum wouldn't "inhere in" the instance of the chemical.)
[edit:] P.s. I ask this of you folks knowing how pesticide chemicals end up in concentrations in food samples along with nutrients so a strong alignment of data capture as well as generic "concentration of" semantics seems appropriate.

[ddooley]

Put another way, if you have a concentration value and unit in your database, how exactly do you represent that in a graph database?

[LilyAndres]

Hi @ddooley, sorry for the slow reply, let us know if this helps.

Put another way, if you have a concentration value and unit in your database, how exactly do you represent that in a graph database?"

We currently manage reference to CDNO concentration IDs as we do for annotating any data points in relation to ontology terms. We primarily use relational schema for curating crop-related data.
Within this our model is of the form:

Where Ontology_register can refer to any record in any table (in any database if generalised) and have an one or more ontology term assigned.

 
For example

And

[LilyAndres]

@ddooley I hope this helped, please let us know if you have any other questions.

[ddooley]

I get the gist of how you enable a variety of things to be referenced - nutrients, plants, and anatomical parts of plants. But what does a concentration datum look like?

[LilyAndres]

@Graham-J-King do you have any example?

[LilyAndres]

Apologies for the late reply @ddooley

According to @Graham-J-King (as he is working with the associations)

Short answer = 0.285 😊
Longer answer = here is an example with just one (CDNO) term associated with the trait_descriptor_id field.

Of course we can make more sophisticated queries with a FoodON (NCBI/PO) term associated with the plant_accession column, OM term with trait_descriptor.units field etc.

Please let us know if you have any questions.