import pandas as pddf2 = pd.read_csv("https://ftp.ncbi.nlm.nih.gov/genomes/GENOME_REPORTS/overview.txt",sep="\t",low_memory=False)df2_bacteria = df2[df2['Kingdom'].isin(['Bacteria'])]df2_bacteria_of_interest = df2_bacteria[df2_bacteria['#Organism/Name'].isin(['Klebsiella pneumoniae','Escherichia coli','Acinetobacter baumannii','Enterobacter','Salmonella enterica','Staphylococcus aureus'])]df2_bacteria_of_interest| #Organism/Name | Kingdom | Group | SubGroup | Size (Mb) | Chrs | Organelles | Plasmids | BioProjects | |
|---|---|---|---|---|---|---|---|---|---|
| 656 | Acinetobacter baumannii | Bacteria | Pseudomonadota | Gammaproteobacteria | 3.98023 | 3 | - | 11 | 8036 |
| 24757 | Enterobacter | Bacteria | Pseudomonadota | Gammaproteobacteria | 6.09531 | 1 | - | 8 | 403 |
| 26034 | Escherichia coli | Bacteria | Pseudomonadota | Gammaproteobacteria | 5.5946 | 3 | - | 18 | 35445 |
| 36753 | Klebsiella pneumoniae | Bacteria | Pseudomonadota | Gammaproteobacteria | 5.68232 | 2 | - | 13 | 17592 |
| 63039 | Salmonella enterica | Bacteria | Pseudomonadota | Gammaproteobacteria | 4.95138 | 88 | - | 9 | 14621 |
| 67623 | Staphylococcus aureus | Bacteria | Terrabacteria group | Bacillota | 2.82136 | 1 | - | 10 | 15720 |