Spreadsheet: 0a44974a-3262-4281-bf7e-07114012b307
Sheet: Pivot Table

Sum of Count | Column Labels
Row Labels | CAN | ELA | ELD | FLV | FNS | HCF | [NAME] | HPP | ICF | IMH | MAG | MAH | MAW | MED | MIC | MOV | ORF | ORM | POM | PON | SCA | SEC | TBB | TKM | WOB | WOE | WOG | WOL | WOP | XDA | XDE | XDM | XDO | XDS | XDY | [NAME] | XYM | XYV | XYX | Grand Total
Acetobacter |  |  |  |  |  |  | 1 |  |  |  |  |  | 21 |  |  |  |  | 9 |  |  | 2 |  | 106 | 1 |  | 24 |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 1 | 168
Acinetobacter |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Alcaligenes |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Bacteriovorax |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Bordetella |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Brenneria |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Brochothrix |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Burkholderia |  | 1 | 4 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
Cellvibrio |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Chryseobacterium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Clostridium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Comamonas |  | 2 | 2 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
Commensalibacter |  |  | 1 | 1 |  |  |  |  |  |  |  | 10 |  |  | 9 | 1 |  |  |  |  | 2 | 9 | 1 | 17 | 23 | 2 |  |  |  | 17 |  |  |  | 1 | 3 |  |  |  |  | 97
Corynebacterium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Delftia |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Dysgonomonas |  |  |  | 1 | 1 | 3 | 1 |  | 2 |  |  |  |  |  | 1 |  |  |  | 1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 13
Empedobacter |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
Enterobacteriaceae Group Orbus |  | 4 |  | 21 | 1 | 73 | 148 | 77 | 56 | 44 |  |  |  | 63 |  | 70 |  |  | 1 |  | 22 |  | 3 | 1 | 34 | 7 | 30 | 70 | 50 | 36 | 9 | 79 | 141 | 1 | 19 | 8 | 1 |  |  | 1069
Enterococcus |  |  |  |  | 4 |  | 1 | 1 |  |  |  |  |  |  | 45 |  |  |  | 2 | 15 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 74
Erysipelothrix |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Finegoldia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Flavobacterium |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Gluconobacter |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Haemophilus |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Kerstersia |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Ketogulonicigenium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Kurthia |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
LachnospiraceaeIncertaeSedis |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Lactobacillus |  | 4 |  |  |  |  | 1 |  |  |  | 5 | 13 | 63 | 3 | 3 |  |  | 1 |  |  |  | 4 | 3 | 8 | 22 | 46 | 57 |  | 6 | 2 | 1 |  | 2 |  | 1 | 6 | 1 |  | 1 | 253
Lactococcus |  | 7 |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Leucobacter |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Leuconostoc |  | 27 |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 5 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 45
Mesorhizobium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Microbacterium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Morganella |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Mycetocola |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Neisseria |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Ochrobactrum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
PaeniPaenibacillus |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Propionibacterium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
[NAME] |  |  |  |  | 2 |  | 1 |  | 16 |  |  |  |  | 1 |  |  | 8 | 3 |  |  | 5 |  |  |  |  |  |  |  |  | 16 | 58 | 9 | 29 | 80 | 11 | 59 | 85 | 35 | 11 | 429
Pseudomonas |  | 1 |  |  | 2 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 2 |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
Ralstonia |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Serratia |  | 17 | 26 | 22 |  |  |  |  |  | 1 |  |  | 1 | 3 | 1 |  | 3 | 20 |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 3 | 2 | 61 | 177
Shigella | 39 |  |  |  |  |  |  |  |  |  |  | 104 |  |  |  |  | 1 |  |  |  |  |  | 8 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154
Staphylococcus |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Stenotrophomonas |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Streptococcus |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Unclassified_Alcaligenaceae |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Unclassified_Alphaproteobacteria |  | 1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Unclassified_Betaproteobacteria |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Unclassified_Burkholderiales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Unclassified_Clostridia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Unclassified_Clostridiales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Unclassified_Comamonadaceae |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Unclassified_Comamonadaceae/Variovorax | 25 |  |  |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
Unclassified_Enterobacteriaceae | 1 |  |  |  | 1 |  | 1 |  | 3 |  |  |  |  |  | 1 | 2 | 3 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Unclassified_Gammaproteobacteria |  |  |  |  | 3 | 2 | 1 |  |  |  | 1 |  |  |  | 4 |  |  |  |  | 1 |  | 1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Unclassified_Lachnospiraceae |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Unclassified_Neisseriaceae |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Unclassified_Paenibacillaceae |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Unclassified_Rhizobiaceae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Unclassified_Ruminococcaceae |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Unclassified_Xanthomonadaceae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Vagococcus |  |  |  |  | 22 | 7 |  | 6 |  |  | 70 |  |  |  | 2 | 1 |  |  | 60 | 50 | 1 | 76 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 297
Variovorax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Weissella |  |  | 1 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Erwinia |  |  | 6 | 13 |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
Pantoea |  | 5 | 31 |  |  |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
Grand Total | 65 | 82 | 71 | 63 | 69 | 85 | 171 | 84 | 87 | 87 | 77 | 144 | 85 | 70 | 79 | 84 | 26 | 52 | 67 | 77 | 88 | 91 | 223 | 36 | 84 | 79 | 87 | 70 | 57 | 72 | 68 | 88 | 173 | 82 | 34 | 82 | 90 | 38 | 76 | 3243