Entering edit mode
5.2 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: