Adding assay data
To add assay data into your results table. Select and open a NGS Result document in the Experiment folder, click Sequences in the viewer tab and click Add assay data.
Select the assay data document to be added from your file system by double clicking the selected file or click Open. Note that we only support Excel Workbook (*.xlsx). Excel 97-2003 Workbook (*.xls) and CSV UTF-8 (Comma delimited)(*.csv) type files.
Choose the columns to match the rows by in the dropdown for both the NGS Result and assay data documents. In the following example, the rows will be match by the "Name" column header of both 15 sequences Annotated & Clustered (NGS Result document) and 310718 Isoelectric and solubility.xlsx (assay data document).
Check the preview to make sure that the rows are matched correctly and click the Add Assay Data button to add your assay data into the NGS Result table. Note that we only show the preview of the first 20 rows.
The assay data will be added to the far right end of the NGS Result table.
The NGS result table with added assay data can be filtered using SQL search queries. To filter your results on the added assay data values, specify a query with conditions in the form:
"FileName:Column" comparative operator <Value>
Once you have inputted your filter syntax, hit Enter or click the Filter button.
Examples of filtering on assay data values
To search for sequences that meet the condition of having a Solubility level of more than 100 mg/mL, use an SQL filter query in the form:
"310718 Isoelectric and solubility:Solubility (mg/mL)" > 100
In this example, 310718 Isoelectric and solubility is the File name, Solubility (mg/mL) is the field we are filtering on, > is the operator, and 100 is the value.
Note that single quotes are only used for column type STRING.
To learn more about SQL filtering please refer to the following article.