# Annotate samples

Each row of the spreadsheet (Figure 1) corresponds to a single sample. The first column is the names of the .idat files and the remaining columns are the array probes. The table values are β-values, which correspond to the percentage methylation at each site. A β-value is calculated as the ratio of methylated probe intensity over the overall intensity at each site (the overall intensity is the sum of methylated and unmethylated probe intensities).

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

Figure 1. Spreadsheet after .idat file import: samples on rows (Sample IDs are based on file names), probes on columns, cell values are functionally normalized beta values (default settings)

Before we can perform any analysis, the study samples need to be organized into their experimental groups.

* Select **Add Sample Attributes** from the *Import* section of the *Illumina BeadArray Methylation* workflow
* Select **Add a Categorical Attribute** from the *Add Sample Attributes* dialog (Figure 2)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-53c41b9ff8e63b9b516969e533704be8c3f36801%2Ffigure10.png?alt=media)

Figure 2. Adding sample attributes. Adding Attributes from an Existing Column can be used to split file names into sections, based on delimiters (e.g. \_, -, space etc.). Adding a Numeric or Categorical Attribute enables the user to manually specify sample attributes

* Select **OK**

The *Create categorical attribute* dialog allows us to create groups for a categorical attribute. By default, two groups are created, but additional groups can be added.

* Set *Attribute name:* to *Cell Type*
* Rename the groups *B cells* and *LCLs*
* Drag and drop the samples from the *Unassigned* list to their groups as listed in the table below

| Sample ID                        | Cell Type |
| -------------------------------- | --------- |
| GSM2452106\_200483200025\_R04C01 | B cells   |
| GSM2452107\_200483200021\_R01C01 | B cells   |
| GSM2452108\_200483200021\_R02C01 | B cells   |
| GSM2452109\_200483200025\_R06C01 | B cells   |
| GSM2452110\_200483200025\_R07C01 | B cells   |
| GSM2452111\_200483200021\_R08C01 | B cells   |
| GSM2452112\_200483200021\_R06C01 | B cells   |
| GSM2452113\_200483200021\_R04C01 | B cells   |
| GSM2452114\_200483200025\_R01C01 | LCLs      |
| GSM2452115\_200483200025\_R03C01 | LCLs      |
| GSM2452116\_200483200021\_R03C01 | LCLs      |
| GSM2452117\_200483200025\_R05C01 | LCLs      |
| GSM2452118\_200483200025\_R02C01 | LCLs      |
| GSM2452119\_200483200021\_R07C01 | LCLs      |
| GSM2452120\_200483200021\_R05C01 | LCLs      |
| GSM2452121\_200483200025\_R08C01 | LCLs      |

There should now be two groups with eight samples in each group (Figure 3).

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-b4676063d66a82074a6427b56e68567bcc9cd053%2F2017-07-05%2011_55_18-Create%20categorical%20attribute.png?alt=media)

Figure 3. Adding Cell Type attribute as a categorical group

* Select **OK**
* Select **Yes** from the *Add another categorical attribute* dialog
* Set *Attribute name:* to *Gender*
* Rename the groups *Male* and *Female*
* Drag and drop the samples from the *Unassigned* list to their groups as listed in the table below

| Sample ID                        | Gender |
| -------------------------------- | ------ |
| GSM2452106\_200483200025\_R04C01 | Female |
| GSM2452107\_200483200021\_R01C01 | Female |
| GSM2452108\_200483200021\_R02C01 | Male   |
| GSM2452109\_200483200025\_R06C01 | Female |
| GSM2452110\_200483200025\_R07C01 | Female |
| GSM2452111\_200483200021\_R08C01 | Female |
| GSM2452112\_200483200021\_R06C01 | Female |
| GSM2452113\_200483200021\_R04C01 | Male   |
| GSM2452114\_200483200025\_R01C01 | Female |
| GSM2452115\_200483200025\_R03C01 | Female |
| GSM2452116\_200483200021\_R03C01 | Male   |
| GSM2452117\_200483200025\_R05C01 | Female |
| GSM2452118\_200483200025\_R02C01 | Female |
| GSM2452119\_200483200021\_R07C01 | Female |
| GSM2452120\_200483200021\_R05C01 | Female |
| GSM2452121\_200483200025\_R08C01 | Male   |

There should now be two groups with four samples in *Male* and twelve samples in *Female* (Figure 4).

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-03983c3bec6d746c349537f714de055d1b33794d%2F2017-07-05%2011_56_09-Create%20categorical%20attribute.png?alt=media)

Figure 4. Adding Gender attribute as a categorical group

* Select **OK**
* Select **No** from the *Add another categorical attribute* dialog
* Select **Yes** to save the spreadsheet

Two new columns have been added to spreadsheet *1 (Methylation)* with the cell type and gender of each sample (Figure 5).

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

Figure 5. Annotated beta values spreadsheet

## 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.