> For the complete documentation index, see [llms.txt](https://knowledge.illumina.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledge.illumina.com/microarray/general/microarray-general-reference_material-list/000007467.md).

# How to filter or exclude a large list of SNPs in GenomeStudio

GenomeStudio provides filtering tools that can be used to display or exclude specific SNPs from the Full Data Table. This is particularly useful when working with large SNP lists and focusing on a subset of markers of interest.

The steps below demonstrate how to use a SNP list to either display only the selected SNPs or exclude them from the analysis view. In this example, a list of 27 SNPs from the GSA-24v3-0\_A2 manifest is used to either display only those 27 SNPs while excluding the remaining \~654,000 SNPs, or conversely, to exclude the 27 SNPs and display all remaining markers.

1. Select the SNPs of interest from the manifest file (.csv format).

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-bee264731cdff1385e76b94b499ddd275333f374%2Fimage1.jpg?alt=media\&token=e16f0ad4-0d5e-4e06-bb3b-b75ecd1c0c52)

**Figure 1.** GSA-24v3-0\_A2 manifest (.csv version).

2. Select the SNPs according to the Name header, **not** theIlmnID header.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-ee6b3db79451d2265cfc0d3d1bd00314ec466e0c%2Fimage2.jpg?alt=media\&token=561af99a-3df3-4a9a-a836-83c114c36f26)

**Figure 2.** Name column in the GSA-24v3-0\_A2 manifest (.csv version).

3. Generate a .txt file (tab delimited text file) with 2 columns (Figure 3).
   * Insert the selected SNP names into the first column of an empty excel sheet. Label the header of the first column: Name
   * Label the header of the second column with any name that is not a name that already exists in the GenomeStudio Full Data Table, to which the column will be imported. In the following example, the second column will be named XXXXX.
   * Assign to all SNPs the same number or letter. In the current example all SNPs will be assigned the number 1.
   * Save the excel sheet as a tab delimited text file (.txt format) then close it. It is important to close the file, otherwise it cannot be imported into GenomeStudio.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-84786d9edf9f83f4d6eaa79f8635292bd85ca2b7%2Fimage3.jpg?alt=media)

**Figure 3.** Example of a .txt file with two columns.

4. Import the created .txt file into the GenomeStudio Full Data Table (Figure 4).
   1. Select the icon for Import columns into the table (left-pointing arrow symbol) in the GenomeStudio Full Data Table.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-351d6db754f64dfe1a86fa7c952bc54e95ba12f0%2Fimage4.jpg?alt=media)

**Figure 4.** Full Data Table in GenomeStudio.

2. Browse to the folder location where the generated .txt file is saved, choose the file, and select OK.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-86dacc8404af7b372a181da35286b717f033bbbc%2Fimage5.jpg?alt=media)

**Figure 5.** GenomeStudio - Importing Files window.

3. The second column of the generated .txt file is now imported into GenomeStudio Full Data Table (Figure 6). The imported SNPs are marked with the number 1 in the additional column XXXXX.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-eafb54adf079264f538d0a64aa5824344e9f765b%2Fimage6.jpg?alt=media)

**Figure 6.** Full Data Table with the imported additional XXXXX column.

5. Filter the GenomeStudio Full Data Table for the SNPs that have been assigned number 1, according to the instructions for Filtering Rows on page 38 of the [GenomeStudio 2008.1 Framework User Guide](https://support.illumina.com/content/dam/illumina-support/documents/documentation/software_documentation/genomestudio/genomestudio-2-0/genomestudio-2008-1-framework-user-guide-11318815-a.pdf) as shown in Figure 8.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-7b803d04fe5ae83af073e5644c098c8fcbfc702b%2Fimage7.jpg?alt=media)

**Figure 7.** Full Data Table with the Filter rows button highlighted.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-418e2f02f41bc269712daa62ca3ae8aada41614d%2Fimage8.jpg?alt=media)

**Figure 8.** Settings to apply to the Filter Table Rows window to filter for selected SNPs.

Only the SNPs of interest are now displayed in the GenomeStudio Full Data Table (Figure 9).

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-1c573333620c5f1ecf61e3c7e52614bfbac2aa50%2Fimage9.jpg?alt=media)

**Figure 9.** Filtered Full Data Table in GenomeStudio.

6. Alternatively, exclude the SNPs list (SNPs assigned with number 1 in this example) from the GenomeStudio Full Data Table, by selecting the Not checkbox in the Filter Table Rows window.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-241259943fa60c7c54a2a6819221de3c46330b84%2Fimage10.jpg?alt=media)

**Figure 10.** Settings to apply to the Filter Table Rows window to exclude selected SNPs.

The selected SNPs of interest are now excluded from the GenomeStudio Full Data Table.

![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-b6540518a089171f10ab89b4dd5bcf5fe4031ff1%2Fimage11.jpg?alt=media)

**Figure 11.** Filtered Full Data Table in GenomeStudio.

\
\
\ <br>

|                                                                                                                                                                                                                                                                                                                                                                   |
| :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: |
| *For any feedback or questions regarding this article (Illumina Knowledge Article #7467), contact Illumina Technical Support* [*techsupport@illumina.com*](mailto:techsupport@illumina.com?subject=Question%2FFeedback%20Regarding%20Illumina%20Knowledge%20Article%20#000007467%20-%20Microarray%20\&body=Dear%20Illumina%20Technical%20Support,%0D%0A%0D%0A)*.* |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://knowledge.illumina.com/microarray/general/microarray-general-reference_material-list/000007467.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
