How to arrange data for phylum column as annotation_row
I have this kind of data i want to create heat map with pheatmap, I want to use x as a row sides , and i want add phylum column as annotation row. but i am confused how to arrange data
x Phylum HL HR ML MR LL LR RL RR
Bacillus Firmicutes 3.640681 4 2.157895 3 4.11667 6.386111 0.95 3.636207
Achromobacter Proteobacteria -0.5201 -1 3.210526 4 2.85 -1.00278 -0.31667 -0.95
Burkholderia Proteobacteria -0.5201 2 3.210526 0 -0.95 1.10833 -0.31667 -0.95
Rhizobium Proteobacteria -0.104002 -1 -1 2 -0.95 -1.00278 -0.31667 1.67069
Cupriavidus Proteobacteria -0.5201 0 -1 -1 -0.95 -0.100278 1.58333 1.67069
Parvibaculum Proteobacteria -0.5201 2 -1 0 -0.95 -1.00278 0.95 -0.95
Enterobacter Proteobacteria -0.5201 -1 0.052632 -1 -0.95 1.10833 0.95 -0.29483
Actinomadura Actinobacteria -0.5201 -1 1.105263 1 -0.95 2.163889 -0.95 -0.95
Gemella Firmicutes 0.728136 1 -1 -1 -0.95 -1.00278 -0.95 -0.29483
Sinorhizobium Proteobacteria -0.10402 -1 0.052632 -1 2.85 0.052778 -0.95 -0.95
Streptosporangium Proteobacteria 0.312058 -1 1.105263 0 0.316677 -1.00278 -0.95 -0.95
Azospirillum Proteobacteria 1.144214 -1 -1 -1 0.31667 -1.00278 -0.31667 -0.95
Microbispora Actinobacteria -0.10402 0 1.105263 0 0.31667 -1.00278 -0.95 -0.95
Micromonospora Actinobacteria -0.5201 1 -1 -1 -0.95 -1.00278 -0.31667 1.015517
Salmonella Proteobacteria -0.5201 -1 -1 -1 -0.95 -1.00278 0.316667 1.67069
Filimonas Spirochaetes -0.5201 1 -1 -1 0.316667 2.1638889 -0.95 -0.95
Aeromicrobium Proteobacteria -0.5201 -1 -1 0 -0.95 -1.00278 2.21667 -0.95
Actinomyces Actinobacteria -0.5201 -1 -1 -1 0.316667 -1.00278 -0.95 2.35862
Streptococcus Firmicutes -0.5201 -1 -1 -1 0.316667 -1.00278 -0.95 2.325862
Micrococcus Actinobacteria 0.728136 0 -1 -1 -0.95 0.052778 -0.95 -0.95
• 1,413 views
•
link
0 answers
No answers yet.
Log in to answer this question.
your text is unreadable. please post in proper formatting. You can do this by selecting the text and clicking the 101010 button. When you compose or edit a post that button is in your toolbar.
can you share your email please
Show us what (code) you have tried.
can you share your email please ?