# Methylation data file

**URL:** <https://forum.depmap.org/t/methylation-data-file/1236>\
**Category:** Q&A\
**Created:** [March 4, 2022, 9:57am UTC](https://forum.depmap.org/t/methylation-data-file/1236 "2022-03-04T09:57:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luis](https://avatars.discourse-cdn.com/v4/letter/l/3e96dc/32.png) [@Luis](https://forum.depmap.org/u/Luis)\
**Post date:** [March 4, 2022, 9:57am UTC](https://forum.depmap.org/t/methylation-data-file/1236/1 "2022-03-04T09:57:05Z")

</div>

Hi everyone,  
I have downloaded the “Methylation\_(1kb\_upstream\_TSS)\_subsetted\_NAsdropped.csv” file for a particular cell line and tried to open it in Excel. It shows up as continuous text and when I change text to columns (separated by comma), it does not look correctly formatted. Is there a way to have this data in two columns only, one with the gene/coordinates and the other with the methylation values? Moreover, which genome build was used for obtaining the coordinate positions of CpG sites?

Thanks a lot in advance.

Best regards.

---

<div class="post-metadata">

**Author:** ![pmontgom](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/pmontgom/32/4_2.png) [@pmontgom](https://forum.depmap.org/u/pmontgom)\
**Post date:** [March 18, 2022, 8:01pm UTC](https://forum.depmap.org/t/methylation-data-file/1236/2 "2022-03-18T20:01:18Z")

</div>

No, today the portal doesn’t have the ability to format the file in that way.

If “Custom Downloads” doesn’t support the transform you want, you might find it easier to transform the file into the format you’d like starting with the original file which can be downloaded from the “Download Files” section: [DepMap Data Downloads](https://depmap.org/portal/download/all/?releasename=CCLE+2019&filename=CCLE_RRBS_TSS1kb_20181022.txt.gz)

Thanks,  
Phil

---

<div class="post-metadata">

**Author:** ![Luis](https://avatars.discourse-cdn.com/v4/letter/l/3e96dc/32.png) [@Luis](https://forum.depmap.org/u/Luis)\
**Post date:** [March 21, 2022, 3:06pm UTC](https://forum.depmap.org/t/methylation-data-file/1236/3 "2022-03-21T15:06:45Z")

</div>

Hi Phil,

Thanks a lot for your reply.

I have already downloaded the original file and formatted according to our needs. It is fine now.

Could you please help to clarify one issue for me? Some coordinate entries in the original file (_CCLE\_RRBS\_TSS1Kb\_20181022.txt_) have associated more than one CpG site at a time. The methylation frequency in these entries is the **average** of the methylation frequencies of those sites? Is there a paper that describes these datasets and how they were produced?

Thank you very much in advance.

Best regards,

![image007.png](https://canada1.discourse-cdn.com/flex035/uploads/depmap/original/1X/208b7037129583d1b9e046ad7c482dcb202f66f1.png)

![image008.png](https://canada1.discourse-cdn.com/flex035/uploads/depmap/original/1X/379e55e1f0bdb30ecd6c8a555e62a5465349a275.png)

![image009.jpg](https://canada1.discourse-cdn.com/flex035/uploads/depmap/original/1X/f464dd1c7c382c015b3fc53eebe1cd1aadffee61.jpeg)

---

<div class="post-metadata">

**Author:** ![pmontgom](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/pmontgom/32/4_2.png) [@pmontgom](https://forum.depmap.org/u/pmontgom)\
**Post date:** [March 21, 2022, 3:28pm UTC](https://forum.depmap.org/t/methylation-data-file/1236/4 "2022-03-21T15:28:41Z")

</div>

I believe these data published as part of the paper [Next-generation characterization of the Cancer Cell Line Encyclopedia | Nature](https://www.nature.com/articles/s41586-019-1186-3) and the generation of the data is described in the supplemental text.

Thanks,  
Phil