Entering edit mode

2.3 years ago

junghyunshim
•
0

Hi, I have made successfully a heatmap of gene expression comprising of about 600 genes. The 600 genes were clustered and the order is changed from input data list. In the heatmap, I can't see the order because the 600 gene names are overlapped. Now I would like to see or download the new list of the genes in excel or text. Kindly let me know how to do it. Thanks!^^

Which heatmap function did you use? This is important. For example, here is how to do it with pheatmap: A: extract dendrogram cluster from pheatmap

Thanks for your reply. I used the script as below.

And I followed the script which you attached, I don't get anything.

I used the heatmap.2 as below.

I got it using below.

I can get the list only. How can I get all the matrix according to the list? I copied and pasted the list to excel and get the matrix data from the original file using v-lookup. It took a while for re-arranging the list from R to one column of excel. Thanks!!!

Okay, cool, so, everything is now okay?

Thanks. it is getting better.

However I can get the list only. How can I get all the matrix according to the list?

I copied and pasted the list to excel and get the matrix data from the original file using v-lookup. It took a while for re-arranging the list from R to one column of excel.

You mean to re-order the data matrix based on the indices? The indices relate to your original matrix. So, you should be able to do something like: