Entering edit mode
                    6.3 years ago
        moh.uaf2356
        
    
        •
    
    0
    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
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.
Show us what (code) you have tried.