How to arrange data for phylum column as annotation_row
0
0
Entering edit mode
5.3 years ago

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
R pheatmap • 1.0k views
ADD COMMENT
0
Entering edit mode

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.

ADD REPLY
0
Entering edit mode

Show us what (code) you have tried.

ADD REPLY

Login before adding your answer.

Traffic: 2634 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6