Customize the data table returned with your query

How to customize the data table returned with your query.

Knowledge graph queries can be notoriously complex, spanning multiple datasets and modalities. Each query can be associated with hundred of data properties and thousands of data points.

For computational scientists gone are the days spending hours wrangling data and fighting SQL table joins.

For translational and discovery scientists quickly validate your hypothesis and build a compelling biological narrative with the data that matters the most.

Specify the data properties and their order to be displayed in the table within seconds. Save the table layout and reuse it with subsequent queries. This custom table can be accessed with queries generated via natural language or query language.

Adding a Custom Data Table

Once you have launched a query you can customize the data returned in the table.

Select "Add Custom Data Table" from the Quick Actions Tool Bar.

Add New Data Table will allow you to customize a new data able. Load Data Table will allow you to select a previously saved data table.

Each concept and relationship within your query is associated with data properties.

When you add a new data table, by default it will display the display name or the first data property associated with the concepts and relationships in your query.

Adding and Removing Columns

To adjust the columns in the table select "Edit Columns". This will display a list of all of the concepts and relationships in your query. Select a concept to see the available data properties. Use the checkbox to select data properties you would like to see in the table. Deselect any properties that you would like to remove from the table.

Adding and Removing Columns

For example a query to return genes that are upregulated in the disease endometrium adenocarcinoma can be written as follows

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

Let's say you want to create a table that will display the Gene, logR, Padjusted value, differential expression dataset name, and disease that the experimental group was diagnosed with. By editing the columns you can select the specific data properties you would like to display in the table.

Under the "upregulates" relationship the data properties for logR and P adjusted can be selected and displayed in the table.

Adjusting Column Order

Select "Reorder Columns" to re-organize the order of columns. Drag the columns into your preferred order.

Adjusting the order of columns

Saving Data Table Layout

Once you have configured the data displayed and order of columns you can save this layout to use with subsequent queries.

Select "Save Query" , provide a name and description.

Saved layouts are accessible when adding new data tables. Select "Add Custom Data Table" followed by Load Data Table to access all of your previously saved layouts.

To filter the properties in the data table use the Query Editor. Learn more about the Query Editor here.