contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA665531" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1162259 | 1162259 | PRJNA665531_P_NODE_17761_length_248_cov_0.880000_g17525_i0 | PRJNA665531 | 17761 | 248 | 0.88 | 2.1824 | Pedobacter indicus | 2292082 | Bacteria | Bacteria | 162 | 1.76e-44 | NR | WP_118194358.1 | 2292082 | g17525 | i0 | 95.1 | 2.9758064516129 | 82 | 4 | 99.2 | 0 | 248 | 3 | 272 | 353 | WP_118194358.1 TonB-dependent receptor [Pedobacter indicus] | diamond | 738 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Albibacterium | Albibacterium indicum | |
| 5732980 | 5732980 | PRJNA665531_P_NODE_5525_length_464_cov_1.682864_g5289_i0 | PRJNA665531 | 5525 | 464 | 1.682864 | 7.80848896 | Flavobacterium tegetincola | 150172 | Bacteria | Bacteria | 202 | 1.1900000000000001e-63 | NR | WP_026978546.1 | 150172 | g5289 | i0 | 95 | 0.65301724137931 | 101 | 5 | 65.3 | 0 | 304 | 2 | 1 | 101 | WP_026978546.1 3-hydroxyanthranilate 3,4-dioxygenase [Flavobacterium tegetincola] | diamond | 303 | 202 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium tegetincola | |
| 7007822 | 7007822 | PRJNA665531_P_NODE_10986_length_314_cov_1.278008_g10750_i0 | PRJNA665531 | 10986 | 314 | 1.278008 | 4.01294512 | Pedobacter sp. CG_S7 | 3143930 | Bacteria | Bacteria | 162 | 8.62e-48 | NR | WP_354329929.1 | 3143930 | g10750 | i0 | 80 | 3.02866242038217 | 105 | 20 | 99.4 | 1 | 3 | 314 | 109 | 213 | WP_354329929.1 LytR/AlgR family response regulator transcription factor [Pedobacter sp. CG_S7] | diamond | 951 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. CG_S7 | |
| 19756524 | 19756524 | PRJNA665531_P_NODE_9116_length_347_cov_1.770073_g8880_i0 | PRJNA665531 | 9116 | 347 | 1.770073 | 6.14215331 | Flavobacteriaceae bacterium Ap0902 | 2684397 | Bacteria | Bacteria | 213 | 6.439999999999998e-69 | NR | MXV39296.1 | 2684397 | g8880 | i0 | 93 | 0.985590778097983 | 114 | 8 | 98.6 | 0 | 4 | 345 | 1 | 114 | MXV39296.1 30S ribosomal protein S8 [Flavobacteriaceae bacterium Ap0902] | diamond | 342 | 213 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium Ap0902 | ||
| 22306591 | 22306591 | PRJNA665531_P_NODE_15318_length_264_cov_2.418848_g15082_i0 | PRJNA665531 | 15318 | 264 | 2.418848 | 6.38575872 | Emticicia sp. C21 | 2302915 | Bacteria | Bacteria | 159 | 3.98e-46 | NR | WP_116985618.1 | 2302915 | g15082 | i0 | 84 | 0.920454545454545 | 81 | 13 | 92 | 0 | 22 | 264 | 194 | 274 | WP_116985618.1 formylglycine-generating enzyme family protein [Emticicia sp. C21] | diamond | 243 | 159 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia sp. C21 | |
| 26669679 | 26669679 | PRJNA665531_P_NODE_19121_length_242_cov_0.911243_g18885_i0 | PRJNA665531 | 19121 | 242 | 0.911243 | 2.20520806 | Alloprevotella sp. oral taxon 473 | 712469 | Bacteria | Bacteria | 162 | 1.08e-45 | NR | WP_009436197.1 | 712469 | g18885 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 241 | 2 | 321 | 400 | WP_009436197.1 hypothetical protein [Alloprevotella sp. oral taxon 473] | diamond | 240 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Alloprevotella | Alloprevotella sp. oral taxon 473 | |
| 27334504 | 27334504 | PRJNA665531_P_NODE_19143_length_242_cov_0.911243_g18907_i0 | PRJNA665531 | 19143 | 242 | 0.911243 | 2.20520806 | Flavobacterium sp. GT3R68 | 2594437 | Bacteria | Bacteria | 129 | 2.51e-33 | NR | WP_126745139.1 | 2594437 | g18907 | i0 | 82.3 | 1.94628099173554 | 79 | 14 | 97.9 | 0 | 238 | 2 | 226 | 304 | WP_126745139.1 trigger factor [Flavobacterium sp. GT3R68] | diamond | 471 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. GT3R68 | |
| 27745114 | 27745114 | PRJNA665531_P_NODE_17484_length_249_cov_0.875000_g17248_i0 | PRJNA665531 | 17484 | 249 | 0.875 | 2.17875 | Pedobacter sp. CAN_A7 | 2787722 | Bacteria | Bacteria | 169 | 1.77e-46 | NR | WP_196859816.1 | 2787722 | g17248 | i0 | 96.3 | 0.987951807228916 | 82 | 3 | 98.8 | 0 | 248 | 3 | 852 | 933 | WP_196859816.1 SusC/RagA family TonB-linked outer membrane protein [Pedobacter sp. CAN_A7] | diamond | 246 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. CAN_A7 | |
| 27839407 | 27839407 | PRJNA665531_P_NODE_17564_length_249_cov_0.875000_g17328_i0 | PRJNA665531 | 17564 | 249 | 0.875 | 2.17875 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 146 | 1.21e-38 | NR | MBL0133609.1 | 1869212 | g17328 | i0 | 86.6 | 0.987951807228916 | 82 | 11 | 98.8 | 0 | 248 | 3 | 1380 | 1461 | MBL0133609.1 gliding motility-associated C-terminal domain-containing protein [Chitinophagaceae bacterium] | diamond | 246 | 146 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27902530 | 27902530 | PRJNA665531_P_NODE_14645_length_271_cov_0.924242_g14409_i0 | PRJNA665531 | 14645 | 271 | 0.924242 | 2.50469582 | Alloprevotella sp. | 1872471 | Bacteria | Bacteria | 184 | 4.39e-53 | NR | RKV74551.1 | 1872471 | g14409 | i0 | 100 | 2.98892988929889 | 90 | 0 | 99.6 | 0 | 271 | 2 | 141 | 230 | RKV74551.1 MAG: TonB-dependent receptor, partial [Alloprevotella sp.] | diamond | 810 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Alloprevotella | Alloprevotella sp. | |
| 27934357 | 27934357 | PRJNA665531_P_NODE_7445_length_390_cov_1.586751_g7209_i0 | PRJNA665531 | 7445 | 390 | 1.586751 | 6.1883289 | uncultured Capnocytophaga sp. | 159273 | Bacteria | Bacteria | 265 | 2.67e-82 | NR | WP_314894113.1 | 159273 | g7209 | i0 | 100 | 1 | 130 | 0 | 100 | 0 | 390 | 1 | 420 | 549 | WP_314894113.1 heavy metal translocating P-type ATPase [uncultured Capnocytophaga sp.] | diamond | 390 | 265 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | uncultured Capnocytophaga sp. | |
| 28735817 | 28735817 | PRJNA665531_P_NODE_19127_length_242_cov_0.911243_g18891_i0 | PRJNA665531 | 19127 | 242 | 0.911243 | 2.20520806 | Flavobacterium | 237 | Bacteria | Bacteria | 126 | 1.8599999999999998e-32 | NR | WP_396177295.1 | 239 | g18891 | i0 | 77.5 | 1.97107438016529 | 80 | 18 | 99.2 | 0 | 242 | 3 | 21 | 100 | WP_396177295.1 O-antigen ligase family protein [Flavobacterium sp.] | diamond | 477 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 29114744 | 29114744 | PRJNA665531_P_NODE_17248_length_250_cov_0.870056_g17012_i0 | PRJNA665531 | 17248 | 250 | 0.870056 | 2.17514 | Capnocytophaga | 1016 | Bacteria | Bacteria | 152 | 4.24e-43 | NR | WP_002667886.1 | 1017 | g17012 | i0 | 86.7 | 2.988 | 83 | 11 | 99.6 | 0 | 2 | 250 | 27 | 109 | WP_002667886.1 tryptophan--tRNA ligase [Capnocytophaga gingivalis] | diamond | 747 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | Capnocytophaga gingivalis | |
| 29481105 | 29481105 | PRJNA665531_P_NODE_19350_length_241_cov_0.916667_g19114_i0 | PRJNA665531 | 19350 | 241 | 0.916667 | 2.20916747 | Paenimyroides baculatum | 2608000 | Bacteria | Bacteria | 158 | 2.03e-46 | NR | WP_150011662.1 | 2608000 | g19114 | i0 | 100 | 2.98755186721992 | 80 | 0 | 99.6 | 0 | 1 | 240 | 58 | 137 | WP_150011662.1 NYN domain-containing protein [Paenimyroides baculatum] | diamond | 720 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Paenimyroides | Paenimyroides baculatum | |
| 29733757 | 29733757 | PRJNA665531_P_NODE_13910_length_278_cov_1.107317_g13674_i0 | PRJNA665531 | 13910 | 278 | 1.107317 | 3.07834126 | Flavihumibacter sp. UBA7668 | 1946542 | Bacteria | Bacteria | 152 | 1.8799999999999994e-42 | NR | WP_290789542.1 | 1946542 | g13674 | i0 | 80.4 | 1.98561151079137 | 92 | 18 | 99.3 | 0 | 278 | 3 | 136 | 227 | WP_290789542.1 galactokinase [Flavihumibacter sp. UBA7668] | diamond | 552 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Flavihumibacter | Flavihumibacter sp. UBA7668 | |
| 29765434 | 29765434 | PRJNA665531_P_NODE_17491_length_249_cov_0.875000_g17255_i0 | PRJNA665531 | 17491 | 249 | 0.875 | 2.17875 | Pedobacter agri | 454586 | Bacteria | Bacteria | 79.3 | 3.84e-15 | NR | WP_316795137.1 | 454586 | g17255 | i0 | 53.4 | 0.879518072289157 | 73 | 32 | 85.5 | 1 | 2 | 214 | 310 | 382 | WP_316795137.1 metallophosphoesterase [Pedobacter agri] | diamond | 219 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter agri | |
| 30271313 | 30271313 | PRJNA665531_P_NODE_12572_length_292_cov_2.831050_g12336_i0 | PRJNA665531 | 12572 | 292 | 2.83105 | 8.266666 | Cytophagaceae bacterium | 2026729 | Bacteria | Bacteria | 51.2 | 3.66e-5 | NR | HWZ21745.1 | 2026729 | g12336 | i0 | 35.2 | 0.729452054794521 | 71 | 43 | 69.9 | 1 | 263 | 60 | 118 | 188 | HWZ21745.1 hypothetical protein [Cytophagaceae bacterium] | diamond | 213 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Cytophagaceae bacterium | ||
| 30271317 | 30271317 | PRJNA665531_P_NODE_17512_length_249_cov_0.875000_g17276_i0 | PRJNA665531 | 17512 | 249 | 0.875 | 2.17875 | Flavobacterium tegetincola | 150172 | Bacteria | Bacteria | 104 | 2.4299999999999994e-24 | NR | WP_026976546.1 | 150172 | g17276 | i0 | 65.9 | 1.90361445783133 | 82 | 28 | 98.8 | 0 | 3 | 248 | 119 | 200 | WP_026976546.1 GNAT family N-acetyltransferase [Flavobacterium tegetincola] | diamond | 474 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium tegetincola | |
| 30315263 | 30315263 | PRJNA665531_P_NODE_17952_length_247_cov_0.885057_g17716_i0 | PRJNA665531 | 17952 | 247 | 0.885057 | 2.18609079 | Chryseobacterium | 59732 | Bacteria | Bacteria | 147 | 1.6799999999999994e-42 | NR | RZJ37258.1 | 1871047 | g17716 | i0 | 92.1 | 2.74493927125506 | 76 | 6 | 92.3 | 0 | 229 | 2 | 142 | 217 | RZJ37258.1 MAG: sorbosone dehydrogenase family protein, partial [Chryseobacterium sp.] | diamond | 678 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. | |
| 30555214 | 30555214 | PRJNA665531_P_NODE_12873_length_289_cov_1.032407_g12637_i0 | PRJNA665531 | 12873 | 289 | 1.032407 | 2.98365623 | uncultured Capnocytophaga sp. | 159273 | Bacteria | Bacteria | 184 | 3.3399999999999996e-57 | NR | WP_297979283.1 | 159273 | g12637 | i0 | 98.9 | 0.944636678200692 | 91 | 1 | 94.5 | 0 | 15 | 287 | 84 | 174 | WP_297979283.1 hypothetical protein [uncultured Capnocytophaga sp.] | diamond | 273 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | uncultured Capnocytophaga sp. | |
| 31135916 | 31135916 | PRJNA665531_P_NODE_14315_length_274_cov_1.527363_g14079_i0 | PRJNA665531 | 14315 | 274 | 1.527363 | 4.18497462 | Pedobacter | 84567 | Bacteria | Bacteria | 106 | 4.58e-26 | NR | WP_133556051.1 | 425511 | g14079 | i0 | 98.1 | 7.0948905109489 | 54 | 1 | 59.1 | 0 | 111 | 272 | 1 | 54 | WP_133556051.1 LytR/AlgR family response regulator transcription factor [Pedobacter duraquae] | diamond | 1944 | 107 | 0.990654205607477 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter duraquae | |
| 31978010 | 31978010 | PRJNA665531_P_NODE_15678_length_261_cov_1.851064_g15442_i0 | PRJNA665531 | 15678 | 261 | 1.851064 | 4.83127704 | uncultured Capnocytophaga sp. | 159273 | Bacteria | Bacteria | 64.3 | 4.8e-10 | NR | WP_298827276.1 | 159273 | g15442 | i0 | 66.7 | 0.551724137931034 | 48 | 15 | 54 | 1 | 142 | 2 | 124 | 171 | WP_298827276.1 hypothetical protein [uncultured Capnocytophaga sp.] | diamond | 144 | 64.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | uncultured Capnocytophaga sp. | |
| 32199631 | 32199631 | PRJNA665531_P_NODE_17518_length_249_cov_0.875000_g17282_i0 | PRJNA665531 | 17518 | 249 | 0.875 | 2.17875 | Ferruginibacter sp. | 1940288 | Bacteria | Bacteria | 57 | 2.86e-7 | NR | MEO7307653.1 | 1940288 | g17282 | i0 | 45.7 | 0.843373493975904 | 70 | 34 | 84.3 | 2 | 211 | 2 | 2 | 67 | MEO7307653.1 dienelactone hydrolase family protein [Ferruginibacter sp.] | diamond | 210 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter sp. | |
| 32326502 | 32326502 | PRJNA665531_P_NODE_14959_length_268_cov_1.394872_g14723_i0 | PRJNA665531 | 14959 | 268 | 1.394872 | 3.73825696 | Spirosoma lacussanchae | 1884249 | Bacteria | Bacteria | 120 | 1.12e-29 | NR | WP_138499255.1 | 1884249 | g14723 | i0 | 83.6 | 1.63432835820896 | 73 | 12 | 81.7 | 0 | 267 | 49 | 444 | 516 | WP_138499255.1 phosphatase PAP2 family protein [Spirosoma lacussanchae] | diamond | 438 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Spirosoma | Spirosoma lacussanchae | |
| 32338495 | 32338495 | PRJNA665531_P_NODE_10019_length_329_cov_2.406250_g9783_i0 | PRJNA665531 | 10019 | 329 | 2.40625 | 7.9165625 | Bacteroides | 816 | Bacteria | Bacteria | 105 | 2.0299999999999998e-24 | NR | WP_080979950.1 | 815 | g9783 | i0 | 43.5 | 6.93920972644377 | 108 | 61 | 98.5 | 0 | 6 | 329 | 8 | 115 | WP_080979950.1 MULTISPECIES: DUF3575 domain-containing protein [Bacteroidaceae] | diamond | 2283 | 106 | 0.990566037735849 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae |
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);;