✏️Modify Queries using the Query Editor

How to edit queries using the Query Editor

Once a query has been submitted, the Query Editor can be used to further refine the query as an alternative to writing in Query Language. This will enable you to update the query on basis of the data properties associated with any of the relationships and concepts within your query.

For example the biological question "Which genes are upreulgated in tumor samples diagnosed with endometrium adenocarcinoma?" Translates to the query

(Gene)<- upregulates <-(DifferentialExpressionDataset)-> experimental group includes ->(TumorSample)-> pathologically confirmed to be ->(Disease{displayName="endometrium adenocarcinoma"})

Let's say you want to update the logR and p-adjusted cut off values associated with "upregulates" and update the disease to be "Liver Cancer"

Select "Query Editor" below the search bar to open the tool. A dialog will appear that will allow you to modify all of the data properties associated with the concepts and relationships within the query.

The modified query would be

(Gene)<- upregulates { logR > 1 & padj < 0.05 } <-(DifferentialExpressionDataset)-> experimental group includes ->(TumorSample)-> pathologically confirmed to be ->(Disease { displayName="Liver Cancer" })code

Let's walk through how we generated the modified query.

Configuring a Data Property

Scroll through the dialog to identify the concept or relationships you would like to add a property to.

Fill in the subsequent inputs

Data Property

This input will display all of the data properties available for you to use scoped to a specific concept or relationship.

Property type

  • Number (numerical values)

  • Text (text based values)

Operator

If the property is a Text Select from

  • Equals

  • Not Equals

  • Regex Match

If the property is a Number select from

  • Less than or equal

  • Greater than or equal

  • Not Equals

  • Less than

  • Greater than

  • Equals

Value

  • Use this input to type in the value you would like to filter on. This must be an exact match.

Adding multiple Data Properties to a Concept or Relationship

Multiple data property filters can be added to each concept or relationship by selecting " Add Property".

Once all of the properties have been configured submit the query to obtain your refined answer.

Last updated