contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA898105" and tax_phylum = "Bacteroidota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8526650 | 8526650 | PRJNA898105_P_NODE_4887_length_274_cov_1.532338_g4687_i0 | PRJNA898105 | 4887 | 274 | 1.532338 | 4.19860612 | Algoriphagus | 246875 | Bacteria | Bacteria | 171 | 4.46e-49 | NR | WP_092730310.1 | 279824 | g4687 | i0 | 95.5 | 2.94525547445255 | 89 | 4 | 97.4 | 0 | 3 | 269 | 190 | 278 | WP_092730310.1 class II fumarate hydratase [Algoriphagus alkaliphilus] | diamond | 807 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Algoriphagus | Algoriphagus alkaliphilus | |
| 21275807 | 21275807 | PRJNA898105_P_NODE_6737_length_248_cov_1.685714_g6537_i0 | PRJNA898105 | 6737 | 248 | 1.685714 | 4.18057072 | Bacteroidota | 976 | Bacteria | Bacteria | 131 | 2.8200000000000002e-36 | NR | HEY1114057.1 | 1869212 | g6537 | i0 | 81.5 | 3.94354838709677 | 81 | 15 | 98 | 0 | 5 | 247 | 42 | 122 | HEY1114057.1 NAD(P)-binding domain-containing protein [Chitinophagaceae bacterium] | diamond | 978 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 23826037 | 23826037 | PRJNA898105_P_NODE_8359_length_241_cov_0.916667_g8159_i0 | PRJNA898105 | 8359 | 241 | 0.916667 | 2.20916747 | Marinilabiliales bacterium | 2053303 | Bacteria | Bacteria | 139 | 2.38e-36 | NR | PLW92735.1 | 2053303 | g8159 | i0 | 82.5 | 6.97095435684647 | 80 | 14 | 99.6 | 0 | 240 | 1 | 422 | 501 | PLW92735.1 MAG: catalase/peroxidase HPI [Marinilabiliales bacterium] | diamond | 1680 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Marinilabiliales bacterium | |||
| 26612412 | 26612412 | PRJNA898105_P_NODE_5741_length_258_cov_1.572973_g5541_i0 | PRJNA898105 | 5741 | 258 | 1.572973 | 4.05827034 | Ferruginibacter sp. HRS2-29 | 2487334 | Bacteria | Bacteria | 114 | 3.33e-30 | NR | WP_255154460.1 | 2487334 | g5541 | i0 | 96.6 | 0.686046511627907 | 59 | 2 | 68.6 | 0 | 1 | 177 | 80 | 138 | WP_255154460.1 hypothetical protein [Ferruginibacter sp. HRS2-29] | diamond | 177 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter sp. HRS2-29 | |
| 26675574 | 26675574 | PRJNA898105_P_NODE_7401_length_245_cov_1.680233_g7201_i0 | PRJNA898105 | 7401 | 245 | 1.680233 | 4.11657085 | Crocinitomicaceae bacterium | 2026728 | Bacteria | Bacteria | 60.1 | 3.8e-9 | NR | MDD2982808.1 | 2026728 | g7201 | i0 | 85.3 | 1.67755102040816 | 34 | 5 | 41.6 | 0 | 2 | 103 | 99 | 132 | MDD2982808.1 DUF1573 domain-containing protein [Crocinitomicaceae bacterium] | diamond | 411 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Crocinitomicaceae | Crocinitomicaceae bacterium | ||
| 27245353 | 27245353 | PRJNA898105_P_NODE_6323_length_250_cov_0.870056_g6123_i0 | PRJNA898105 | 6323 | 250 | 0.870056 | 2.17514 | Phocaeicola abscessus | 555313 | Bacteria | Bacteria | 158 | 1.2299999999999996e-43 | NR | WP_019208349.1 | 555313 | g6123 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 2 | 250 | 72 | 154 | WP_019208349.1 ABC transporter ATP-binding protein [Phocaeicola abscessus] | diamond | 249 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola abscessus | |
| 27340354 | 27340354 | PRJNA898105_P_NODE_4103_length_287_cov_1.439252_g3903_i0 | PRJNA898105 | 4103 | 287 | 1.439252 | 4.13065324 | Alloprevotella sp. | 1872471 | Bacteria | Bacteria | 199 | 1.0999999999999999e-58 | NR | MBF0965001.1 | 1872471 | g3903 | i0 | 100 | 1.98606271777003 | 95 | 0 | 99.3 | 0 | 3 | 287 | 495 | 589 | MBF0965001.1 hypothetical protein [Alloprevotella sp.] | diamond | 570 | 199 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Alloprevotella | Alloprevotella sp. | |
| 27876990 | 27876990 | PRJNA898105_P_NODE_5365_length_265_cov_1.604167_g5165_i0 | PRJNA898105 | 5365 | 265 | 1.604167 | 4.25104255 | Hallella colorans | 1703337 | Bacteria | Bacteria | 139 | 4.029999999999999e-40 | NR | WP_116615627.1 | 1703337 | g5165 | i0 | 100 | 0.735849056603774 | 65 | 0 | 73.6 | 0 | 3 | 197 | 72 | 136 | WP_116615627.1 secondary thiamine-phosphate synthase enzyme YjbQ [Hallella colorans] | diamond | 195 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Hallella | Hallella colorans | |
| 28603308 | 28603308 | PRJNA898105_P_NODE_5207_length_268_cov_1.558974_g5007_i0 | PRJNA898105 | 5207 | 268 | 1.558974 | 4.17805032 | Phocaeicola coprocola | 310298 | Bacteria | Bacteria | 46.2 | 0.00227 | NR | WP_302562358.1 | 310298 | g5007 | i0 | 80.8 | 0.582089552238806 | 26 | 5 | 29.1 | 0 | 2 | 79 | 191 | 216 | WP_302562358.1 dihydroorotate dehydrogenase, partial [Phocaeicola coprocola] | diamond | 156 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola coprocola | |
| 28603310 | 28603310 | PRJNA898105_P_NODE_7347_length_246_cov_0.890173_g7147_i0 | PRJNA898105 | 7347 | 246 | 0.890173 | 2.18982558 | Ferruginibacter sp. | 1940288 | Bacteria | Bacteria | 142 | 1.5e-38 | NR | MEP7237605.1 | 1940288 | g7147 | i0 | 90.1 | 4.9390243902439 | 81 | 8 | 98.8 | 0 | 3 | 245 | 9 | 89 | MEP7237605.1 DUF1015 family protein [Ferruginibacter sp.] | diamond | 1215 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter sp. | |
| 28698116 | 28698116 | PRJNA898105_P_NODE_7687_length_244_cov_0.900585_g7487_i0 | PRJNA898105 | 7687 | 244 | 0.900585 | 2.1974274 | Hallella colorans | 1703337 | Bacteria | Bacteria | 80.5 | 1.48e-15 | NR | WP_116616419.1 | 1703337 | g7487 | i0 | 100 | 0.491803278688525 | 40 | 0 | 49.2 | 0 | 1 | 120 | 356 | 395 | WP_116616419.1 glycine C-acetyltransferase [Hallella colorans] | diamond | 120 | 80.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Hallella | Hallella colorans | |
| 28894926 | 28894926 | PRJNA898105_P_NODE_7588_length_244_cov_2.672515_g7388_i0 | PRJNA898105 | 7588 | 244 | 2.672515 | 6.5209366 | Bacteroidota | 976 | Bacteria | Bacteria | 155 | 8.77e-45 | NR | WP_045971217.1 | 1603293 | g7388 | i0 | 93.8 | 5.97540983606557 | 81 | 5 | 99.6 | 0 | 244 | 2 | 166 | 246 | WP_045971217.1 aspartate carbamoyltransferase catalytic subunit [Flavobacterium sp. 316] | diamond | 1458 | 156 | 0.993589743589744 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. 316 | |
| 29550243 | 29550243 | PRJNA898105_P_NODE_6290_length_250_cov_1.480226_g6090_i0 | PRJNA898105 | 6290 | 250 | 1.480226 | 3.700565 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 165 | 7.039999999999998e-47 | NR | MBK7557065.1 | 1869212 | g6090 | i0 | 92.7 | 1.968 | 82 | 6 | 98.4 | 0 | 248 | 3 | 259 | 340 | MBK7557065.1 RagB/SusD family nutrient uptake outer membrane protein [Chitinophagaceae bacterium] | diamond | 492 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 29676380 | 29676380 | PRJNA898105_P_NODE_6170_length_251_cov_0.865169_g5970_i0 | PRJNA898105 | 6170 | 251 | 0.865169 | 2.17157419 | Prevotella sp. S7-1-8 | 1284775 | Bacteria | Bacteria | 145 | 1.05e-39 | NR | WP_036893653.1 | 1284775 | g5970 | i0 | 95.8 | 1.69721115537849 | 71 | 3 | 84.9 | 0 | 1 | 213 | 349 | 419 | WP_036893653.1 MFS transporter [Prevotella sp. S7-1-8] | diamond | 426 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. S7-1-8 | |
| 29676381 | 29676381 | PRJNA898105_P_NODE_6690_length_249_cov_0.875000_g6490_i0 | PRJNA898105 | 6690 | 249 | 0.875 | 2.17875 | Sphingobacterium nematocida | 1513896 | Bacteria | Bacteria | 181 | 2.64e-56 | NR | WP_079640796.1 | 1513896 | g6490 | i0 | 98.8 | 0.987951807228916 | 82 | 1 | 98.8 | 0 | 3 | 248 | 44 | 125 | WP_079640796.1 thioredoxin family protein [Sphingobacterium nematocida] | diamond | 246 | 181 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium nematocida | |
| 29707865 | 29707865 | PRJNA898105_P_NODE_8170_length_242_cov_0.911243_g7970_i0 | PRJNA898105 | 8170 | 242 | 0.911243 | 2.20520806 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 119 | 4.2e-29 | NR | MCI6278966.1 | 2030927 | g7970 | i0 | 69.6 | 4.89669421487603 | 79 | 24 | 97.9 | 0 | 238 | 2 | 154 | 232 | MCI6278966.1 insulinase family protein [Bacteroidales bacterium] | diamond | 1185 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 29929535 | 29929535 | PRJNA898105_P_NODE_4091_length_287_cov_1.710280_g3891_i0 | PRJNA898105 | 4091 | 287 | 1.71028 | 4.9085036 | uncultured Hymenobacter sp. | 170016 | Bacteria | Bacteria | 128 | 6.63e-33 | NR | WP_375416031.1 | 170016 | g3891 | i0 | 78.9 | 0.794425087108014 | 76 | 16 | 79.4 | 0 | 59 | 286 | 29 | 104 | WP_375416031.1 hypothetical protein [uncultured Hymenobacter sp.] | diamond | 228 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | uncultured Hymenobacter sp. | |
| 30182035 | 30182035 | PRJNA898105_P_NODE_6372_length_250_cov_0.870056_g6172_i0 | PRJNA898105 | 6372 | 250 | 0.870056 | 2.17514 | Epilithonimonas zeae | 1416779 | Bacteria | Bacteria | 162 | 4.88e-47 | NR | WP_248877587.1 | 1416779 | g6172 | i0 | 96.3 | 1.968 | 82 | 3 | 98.4 | 0 | 3 | 248 | 90 | 171 | WP_248877587.1 N-acetylmuramoyl-L-alanine amidase [Epilithonimonas zeae] | diamond | 492 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Epilithonimonas | Epilithonimonas zeae | |
| 30284976 | 30284976 | PRJNA898105_P_NODE_6192_length_251_cov_0.865169_g5992_i0 | PRJNA898105 | 6192 | 251 | 0.865169 | 2.17157419 | Flavobacterium | 237 | Bacteria | Bacteria | 79.7 | 7.15e-17 | NR | WP_039108245.1 | 1423323 | g5992 | i0 | 59 | 1.45816733067729 | 61 | 25 | 72.9 | 0 | 249 | 67 | 70 | 130 | WP_039108245.1 hypothetical protein [Flavobacterium sp. AED] | diamond | 366 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. AED | |
| 30655988 | 30655988 | PRJNA898105_P_NODE_7893_length_243_cov_0.905882_g7693_i0 | PRJNA898105 | 7893 | 243 | 0.905882 | 2.20129326 | uncultured Algoriphagus sp. | 417365 | Bacteria | Bacteria | 102 | 6.07e-26 | NR | WP_339879276.1 | 417365 | g7693 | i0 | 96.4 | 0.691358024691358 | 56 | 2 | 69.1 | 0 | 170 | 3 | 1 | 56 | WP_339879276.1 hypothetical protein [uncultured Algoriphagus sp.] | diamond | 168 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Algoriphagus | uncultured Algoriphagus sp. | |
| 30687535 | 30687535 | PRJNA898105_P_NODE_5433_length_264_cov_1.586387_g5233_i0 | PRJNA898105 | 5433 | 264 | 1.586387 | 4.18806168 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 124 | 3.1999999999999993e-31 | NR | HEY4643384.1 | 1898104 | g5233 | i0 | 70.1 | 1.96590909090909 | 87 | 26 | 98.9 | 0 | 1 | 261 | 252 | 338 | HEY4643384.1 anti-CBASS Acb1 family protein [Bacteroidota bacterium] | diamond | 519 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30972132 | 30972132 | PRJNA898105_P_NODE_8234_length_241_cov_1.488095_g8034_i0 | PRJNA898105 | 8234 | 241 | 1.488095 | 3.58630895 | Flavobacterium sp. J372 | 2898436 | Bacteria | Bacteria | 154 | 5.73e-43 | NR | WP_257868525.1 | 2898436 | g8034 | i0 | 97.5 | 0.995850622406639 | 80 | 2 | 99.6 | 0 | 1 | 240 | 272 | 351 | WP_257868525.1 TolC family protein [Flavobacterium sp. J372] | diamond | 240 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. J372 | |
| 31319635 | 31319635 | PRJNA898105_P_NODE_5355_length_265_cov_2.380208_g5155_i0 | PRJNA898105 | 5355 | 265 | 2.380208 | 6.3075512 | Hallella colorans | 1703337 | Bacteria | Bacteria | 154 | 6.259999999999998e-42 | NR | WP_116616881.1 | 1703337 | g5155 | i0 | 100 | 0.99622641509434 | 88 | 0 | 99.6 | 0 | 264 | 1 | 63 | 150 | WP_116616881.1 DUF4954 family protein [Hallella colorans] | diamond | 264 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Hallella | Hallella colorans | |
| 31509637 | 31509637 | PRJNA898105_P_NODE_4376_length_283_cov_1.214286_g4176_i0 | PRJNA898105 | 4376 | 283 | 1.214286 | 3.43642938 | Porphyromonas sp. HMSC | 1924944 | Bacteria | Bacteria | 191 | 1.5699999999999996e-55 | NR | WP_070467200.1 | 1739394 | g4176 | i0 | 98.9 | 0.996466431095406 | 94 | 1 | 99.6 | 0 | 282 | 1 | 358 | 451 | WP_070467200.1 ABC transporter ATP-binding protein [Porphyromonas sp. HMSC065F10] | diamond | 282 | 191 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. HMSC065F10 | |
| 31770133 | 31770133 | PRJNA898105_P_NODE_8297_length_241_cov_0.916667_g8097_i0 | PRJNA898105 | 8297 | 241 | 0.916667 | 2.20916747 | Prevotellaceae | 171552 | Bacteria | Bacteria | 95.9 | 4.4899999999999997e-23 | NR | KGF17026.1 | 1284775 | g8097 | i0 | 97.9 | 1.19502074688797 | 48 | 1 | 59.8 | 0 | 186 | 43 | 102 | 149 | KGF17026.1 hypothetical protein HMPREF1640_08315 [Prevotella sp. S7-1-8] | diamond | 288 | 95.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. S7-1-8 | |
| 31991560 | 31991560 | PRJNA898105_P_NODE_6518_length_249_cov_1.346591_g6318_i0 | PRJNA898105 | 6518 | 249 | 1.346591 | 3.35301159 | Flavobacterium | 237 | Bacteria | Bacteria | 125 | 1.11e-32 | NR | WP_144218829.1 | 237 | g6318 | i0 | 67.1 | 2.90361445783133 | 82 | 27 | 98.8 | 0 | 247 | 2 | 109 | 190 | WP_144218829.1 MULTISPECIES: BT4734/BF3469 family protein [Flavobacterium] | diamond | 723 | 126 | 0.992063492063492 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 32110556 | 32110556 | PRJNA898105_P_NODE_5238_length_268_cov_1.215385_g5038_i0 | PRJNA898105 | 5238 | 268 | 1.215385 | 3.2572318 | Hallella colorans | 1703337 | Bacteria | Bacteria | 171 | 8.18e-49 | NR | WP_116616102.1 | 1703337 | g5038 | i0 | 96.6 | 0.996268656716418 | 89 | 3 | 99.6 | 0 | 267 | 1 | 328 | 416 | WP_116616102.1 ComEC/Rec2 family competence protein [Hallella colorans] | diamond | 267 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Hallella | Hallella colorans | |
| 32522129 | 32522129 | PRJNA898105_P_NODE_7099_length_247_cov_0.885057_g6899_i0 | PRJNA898105 | 7099 | 247 | 0.885057 | 2.18609079 | uncultured Porphyromonas sp. | 159274 | Bacteria | Bacteria | 139 | 5.219999999999999e-37 | NR | WP_296163501.1 | 159274 | g6899 | i0 | 98.4 | 0.753036437246964 | 62 | 1 | 75.3 | 0 | 247 | 62 | 413 | 474 | WP_296163501.1 Gfo/Idh/MocA family protein [uncultured Porphyromonas sp.] | diamond | 186 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | uncultured Porphyromonas sp. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;