# Filter loci with the interactive filter

The list, *LCLs vs B cells,* includes differentially methylated loci for locations across the genome; however, in many cases we may want to focus on loci located in particular regions of the genome. To filter our list to include only regions of interest, we can use the annotations provided by Illumina and the interactive filter in Partek Genomics Suite.

* Select **LCLs\_Vs\_B\_cells** from the spreadsheet tree
* Right-click on the *Gene Symbol* column
* Select **Insert Annotation** (Figure 1)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-37abc7034c8545dd567d28968825fb27e01579e9%2Fimage2017-12-26%2011_38_44.png?alt=media)

Figure 1. Adding an annotation column to the ANOVA results

* Select the **Add as categorical** option
* Select **Relation\_to\_UCSC\_CpG\_Island** (Figure 2)

CpG islands are regions of the genome with an atypically high frequency of CpG sites. CpG islands and their surrounding regions (termed shelf and shore) include many gene promoters and altered methylation in these regions can have a disproportionate effect on gene expression. For example, hyper-methylation of promoter CpG islands is a common mechanism for down-regulating gene expression in cancer.

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-54f860a53c7ed836769b8640d98d64cf1691602b%2Fimage2017-12-26%2011_40_17.png?alt=media)

Figure 2. Adding chromosome location to ANOVA results

* Select **OK** to add *Relation\_to\_UCSC\_CpG\_Island* as a column in next to *3. Gene Symbol*
* Select (![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-0ab6c0750bffb9763676535d1cb057a3d2db0c45%2Fsave%20icon.png?alt=media)) from the quick action bar to save the *ANOVA-2way (ANOVA Results)* spreadsheet with the added annotation

Now, we can filter probes by their relation to CpG islands.

* Select (![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-7f7de8359902ff1937fa80d15fc65413d93f1081%2Finteractive%20filter%20icon.png?alt=media)) from the quick action bar to invoke the interactive filter
* Select **4. Relation\_to\_UCSC\_CpG\_Island** for *Column*

For categorical columns, the interactive filter displays each category of the selected column as a colored bar. For *4. Relation\_to\_UCSC\_CpG\_Island,* each bar represents one of the categories of the UCSC annotation . To filter out a category, left-click on its bar. Right clicking on a bar will include only the selected category. A pop up balloon will show the category label as you mouse over each bar.

* Right-click the Island column to filter out other columns (Figure 3)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-08d75d8bb5a976da0c7425bc26dc183adf653e83%2Fimage2017-12-26%2012_28_35.png?alt=media)

Figure 3. Using Interactive Filter tool to filter out probes by annotation. When pointed to a categorical column, the Interactive Filter tool summarises the content of the column by a column chart. Left-click to exclude a category (two columns were excluded, so they are grayed out), right-click to include only

The yellow and black bar on the right-hand side of the spreadsheet panel shows the fraction of excluded cells in black and included cells in yellow. Right-clicking this bar brings up an option to clear the filter.

Now that we have filtered out probes that are not in CpG islands, we will create a spreadsheet containing only these probes.

* Right click on the *LCLs vs. B cells* spreadsheet in the spreadsheet tree panel (Figure 4)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-c8989f621d82ba38dc4e54bc0c5520b0ac68dcf8%2Fimage2017-12-26%2012_29_34.png?alt=media)

Figure 4. Cloning a filtered spreadsheet creates a new spreadsheet with only the included cells

* Select **Clone**
* Rename the new spreadsheet *LCLs\_vs\_B\_cells\_CpG\_Islands* using the *Clone Spreadsheet* dialog
* Select **mvalues** from the *Create new spreadsheet as a child spreadsheet:* drop-down menu (Figure 5)
* Select **OK**

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-24a910dab131bc3086ef0f3f04e2b1a136a118b2%2Fimage2017-12-26%2011_59_50.png?alt=media)

Figure 5. Renaming and configuring filtered spreadsheet

* Select (![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-0ab6c0750bffb9763676535d1cb057a3d2db0c45%2Fsave%20icon.png?alt=media)) from the quick action bar to save the filtered spreadsheet
* Specify a name for the spreadsheet, we chose *LCLs\_vs\_B\_cells\_CpG\_Islands,* using the *Save File* dialog
* Select **Save** to save the spreadsheet

You may want to save the project before proceeding to the next section of the tutorial.

## Additional Assistance

If you need additional assistance, please visit [our support page](http://www.partek.com/support) to submit a help ticket or find phone numbers for regional support.