Excuse me Andres, what does NAs mean?
These are my data, but I analyzed them as in the previous image (Transposed), but that way I could not reprex them.
Family <-tibble::tribble(
~index, ~Cyanobacteriaceae, ~Microcystaceae, ~Nostocaceae, ~Phormidiaceae, ~Un.Nostocales, ~Nodosilineaceae, ~Cyanobiaceae,
"1A", 1, 0, 0, 0, 0, 1, 1,
"1B", 0, 0, 0, 0, 0, 0, 0,
"1C", 1, 0, 0, 2, 0, 1, 1,
"1D", 0, 0, 1, 0, 0, 1, 0,
"1E", 1, 0, 1, 0, 0, 0, 0,
"1F", 1, 0, 0, 0, 0, 0, 17,
"1G", 1, 0, 0, 0, 0, 0, 2,
"1H", 1, 112, 1, 583, 0, 1, 0,
"2A", 0, 0, 1, 0, 0, 1, 2,
"2B", 1, 0, 0, 35, 0, 1, 29,
"2C", 0, 1, 0, 0, 0, 1, 0,
"2D", 3, 0, 0, 0, 0, 0, 0,
"2E", 0, 0, 1, 0, 0, 0, 0,
"2F", 0, 3, 0, 1, 0, 0, 1,
"2G", 0, 0, 0, 0, 0, 0, 0,
"2H", 0, 0, 9, 18, 0, 0, 17,
"3A", 0, 0, 44, 88, 0, 0, 0,
"3B", 0, 0, 572, 60, 0, 38, 0,
"3C", 0, 0, 0, 0, 0, 0, 0,
"3D", 0, 0, 0, 0, 0, 0, 0,
"3E", 0, 0, 0, 0, 0, 0, 0,
"3F", 0, 0, 0, 0, 0, 0, 0,
"3G", 0, 0, 0, 0, 0, 0, 0,
"3H", 0, 0, 0, 0, 0, 0, 0,
"4A", 0, 0, 0, 0, 0, 0, 27,
"4B", 0, 0, 0, 0, 0, 0, 12,
"4C", 0, 0, 0, 0, 0, 0, 0,
"4D", 0, 0, 0, 0, 0, 0, 0,
"4E", 0, 0, 0, 0, 0, 0, 8,
"4F", 0, 0, 0, 0, 0, 0, 0,
"4G", 0, 0, 0, 0, 0, 0, 8,
"4H", 0, 3, 16, 28, 0, 0, 14,
"5A", 0, 0, 0, 0, 0, 0, 0,
"5B", 0, 0, 0, 0, 0, 0, 0,
"5C", 0, 0, 0, 0, 0, 0, 0,
"5D", 0, 0, 0, 0, 0, 0, 0,
"5E", 0, 0, 0, 17, 0, 0, 0,
"5F", 0, 2, 0, 2, 0, 0, 10,
"5G", 0, 2, 0, 28, 0, 0, 0,
"5H", 0, 0, 0, 0, 0, 0, 0,
"6A", 0, 0, 37, 0, 0, 0, 0,
"6B", 0, 0, 0, 0, 0, 0, 0,
"6C", 0, 0, 0, 0, 0, 0, 0,
"6D", 0, 0, 0, 0, 0, 0, 0,
"6E", 0, 0, 0, 0, 0, 0, 0,
"6F", 0, 0, 0, 0, 0, 0, 4,
"6G", 0, 0, 0, 0, 0, 0, 0,
"6H", 0, 55, 0, 123, 0, 0, 33,
"7A", 0, 0, 0, 0, 0, 0, 0,
"7B", 0, 0, 0, 0, 0, 0, 0,
"7C", 0, 0, 0, 0, 0, 0, 0,
"7D", 0, 0, 0, 128, 0, 0, 2,
"7E", 0, 0, 0, 0, 0, 0, 0,
"7F", 0, 2, 0, 269, 0, 0, 3,
"7G", 0, 0, 0, 0, 0, 0, 5,
"7H", 0, 0, 0, 0, 0, 0, 0,
"8A", 0, 0, 0, 0, 0, 0, 16,
"8B", 0, 0, 0, 0, 0, 0, 3,
"8C", 0, 0, 0, 29, 0, 0, 0,
"8D", 0, 3, 0, 0, 0, 0, 0,
"8E", 0, 0, 0, 102, 0, 16, 2,
"8F", 0, 0, 0, 0, 0, 0, 0,
"8G", 0, 93, 45, 439, 0, 0, 34,
"8H", 0, 35, 0, 24, 0, 0, 17,
"9A", 0, 0, 1, 0, 0, 1, 0,
"9B", 0, 0, 1, 0, 0, 1, 0,
"9C", 0, 0, 0, 0, 1, 0, 0,
"9D", 0, 0, 1, 0, 0, 0, 0,
"9E", 0, 0, 0, 125, 0, 0, 0,
"9F", 0, 2, 8, 0, 0, 0, 31,
"9G", 0, 0, 0, 0, 0, 0, 20,
"9H", 0, 340, 3670, 2668, 33, 38, 0,
"10A", 0, 0, 1, 0, 0, 0, 32,
"10B", 0, 0, 0, 1, 0, 0, 14,
"10C", 0, 0, 0, 0, 0, 0, 0,
"10D", 0, 0, 0, 47, 0, 0, 0,
"10E", 0, 1, 0, 0, 0, 0, 0,
"10F", 0, 0, 0, 0, 0, 0, 4,
"10G", 0, 1, 0, 40, 0, 0, 0,
"10H", 0, 1, 0, 0, 1, 0, 0,
"11A", 0, 0, 1, 0, 0, 1, 0,
"11B", 0, 0, 1, 0, 1, 0, 0,
"11C", 0, 0, 1, 0, 0, 0, 0,
"11D", 0, 0, 1, 0, 0, 0, 0,
"11E", 0, 0, 1, 0, 0, 0, 0,
"11F", 0, 0, 0, 1, 0, 0, 0,
"11G", 0, 0, 0, 1, 0, 0, 0,
"11H", 0, 0, 0, 1, 0, 0, 0,
"12A", 0, 0, 0, 0, 0, 0, 0,
"12B", 0, 0, 0, 0, 0, 0, 0,
"12C", 0, 0, 0, 0, 0, 0, 0,
"12D", 0, 20, 77, 145, 0, 0, 22,
"12E", 0, 0, 0, 0, 0, 0, 0,
"12F", 0, 0, 0, 0, 0, 0, 2,
"12G", 0, 68, 2, 296, 0, 0, 0,
"12H", 0, 148, 280, 216, 0, 0, 28
)
Created on 2020-02-06 by the reprex package (v0.3.0)