contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4661484 | 4661484 | PRJNA846110_P_NODE_23124_length_250_cov_1.401130_g22879_i0 | PRJNA846110 | 23124 | 250 | 1.40113 | 3.502825 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 141 | 5.28e-39 | NR | HEY0978547.1 | 2021391 | g22879 | i0 | 77.1 | 0.996 | 83 | 19 | 99.6 | 0 | 250 | 2 | 227 | 309 | HEY0978547.1 type IX secretion system membrane protein PorP/SprF [Flavobacteriales bacterium] | diamond | 249 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 9761032 | 9761032 | PRJNA846110_P_NODE_17148_length_277_cov_1.431373_g16903_i0 | PRJNA846110 | 17148 | 277 | 1.431373 | 3.96490321 | Chryseobacterium sp. | 1871047 | Bacteria | Bacteria | 184 | 3.13e-54 | NR | MBN9313049.1 | 1871047 | g16903 | i0 | 100 | 0.996389891696751 | 92 | 0 | 99.6 | 0 | 277 | 2 | 187 | 278 | MBN9313049.1 tRNA (N(6)-L-threonylcarbamoyladenosine(37)-C(2))-methylthiotransferase MtaB [Chryseobacterium sp.] | diamond | 276 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. | |
| 21235081 | 21235081 | PRJNA846110_P_NODE_18777_length_269_cov_1.443878_g18532_i0 | PRJNA846110 | 18777 | 269 | 1.443878 | 3.88403182 | Flavobacterium ginsenosidimutans | 687844 | Bacteria | Bacteria | 140 | 2.56e-37 | NR | WP_111289297.1 | 687844 | g18532 | i0 | 80.9 | 0.992565055762082 | 89 | 17 | 99.3 | 0 | 269 | 3 | 283 | 371 | WP_111289297.1 sensor histidine kinase [Flavobacterium ginsenosidimutans] | diamond | 267 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium ginsenosidimutans | |
| 25059336 | 25059336 | PRJNA846110_P_NODE_30740_length_232_cov_2.861635_g30495_i0 | PRJNA846110 | 30740 | 232 | 2.861635 | 6.6389932 | Flavobacterium | 237 | Bacteria | Bacteria | 146 | 8.44e-40 | NR | WP_182494091.1 | 237 | g30495 | i0 | 93.4 | 0.982758620689655 | 76 | 5 | 98.3 | 0 | 230 | 3 | 323 | 398 | WP_182494091.1 MULTISPECIES: sugar transferase [Flavobacterium] | diamond | 228 | 146 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 26706286 | 26706286 | PRJNA846110_P_NODE_15921_length_283_cov_1.190476_g15676_i0 | PRJNA846110 | 15921 | 283 | 1.190476 | 3.36904708 | Algoriphagus oliviformis | 2811231 | Bacteria | Bacteria | 173 | 4.51e-53 | NR | WP_236025653.1 | 2811231 | g15676 | i0 | 96.8 | 0.996466431095406 | 94 | 3 | 99.6 | 0 | 283 | 2 | 89 | 182 | WP_236025653.1 RNA polymerase sigma factor [Algoriphagus oliviformis] | diamond | 282 | 173 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Algoriphagus | Algoriphagus oliviformis | |
| 26833329 | 26833329 | PRJNA846110_P_NODE_23501_length_250_cov_0.870056_g23256_i0 | PRJNA846110 | 23501 | 250 | 0.870056 | 2.17514 | Chryseobacterium pennipullorum | 2258963 | Bacteria | Bacteria | 164 | 1.24e-48 | NR | WP_115927492.1 | 2258963 | g23256 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 250 | 2 | 67 | 149 | WP_115927492.1 hypothetical protein [Chryseobacterium pennipullorum] | diamond | 249 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium pennipullorum | |
| 26928195 | 26928195 | PRJNA846110_P_NODE_26682_length_246_cov_0.890173_g26437_i0 | PRJNA846110 | 26682 | 246 | 0.890173 | 2.18982558 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 166 | 2.12e-46 | NR | MES2593372.1 | 1898104 | g26437 | i0 | 92.6 | 0.98780487804878 | 81 | 6 | 98.8 | 0 | 244 | 2 | 467 | 547 | MES2593372.1 S9 family peptidase [Bacteroidota bacterium] | diamond | 243 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 26928196 | 26928196 | PRJNA846110_P_NODE_27882_length_244_cov_0.900585_g27637_i0 | PRJNA846110 | 27882 | 244 | 0.900585 | 2.1974274 | Paludibacter sp. | 1898105 | Bacteria | Bacteria | 126 | 4.66e-32 | NR | MBP6635942.1 | 1898105 | g27637 | i0 | 98.5 | 0.799180327868853 | 65 | 1 | 79.9 | 0 | 235 | 41 | 424 | 488 | MBP6635942.1 hypothetical protein [Paludibacter sp.] | diamond | 195 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Paludibacteraceae | Paludibacter | Paludibacter sp. | |
| 27117740 | 27117740 | PRJNA846110_P_NODE_27582_length_244_cov_1.567251_g27337_i0 | PRJNA846110 | 27582 | 244 | 1.567251 | 3.82409244 | Nubsella zeaxanthinifaciens | 392412 | Bacteria | Bacteria | 156 | 1.76e-44 | NR | WP_237088307.1 | 392412 | g27337 | i0 | 93.8 | 0.995901639344262 | 81 | 5 | 99.6 | 0 | 1 | 243 | 128 | 208 | WP_237088307.1 cell division protein FtsQ/DivIB [Nubsella zeaxanthinifaciens] | diamond | 243 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Nubsella | Nubsella zeaxanthinifaciens | |
| 27307806 | 27307806 | PRJNA846110_P_NODE_14203_length_291_cov_1.853211_g13958_i0 | PRJNA846110 | 14203 | 291 | 1.853211 | 5.39284401 | Flavobacterium sp. NG2 | 3097547 | Bacteria | Bacteria | 43.5 | 0.036 | NR | WP_320889623.1 | 3097547 | g13958 | i0 | 33.8 | 0.824742268041237 | 80 | 41 | 82.5 | 3 | 266 | 27 | 1082 | 1149 | WP_320889623.1 hybrid sensor histidine kinase/response regulator transcription factor [Flavobacterium sp. NG2] | diamond | 240 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. NG2 | |
| 28886265 | 28886265 | PRJNA846110_P_NODE_30828_length_230_cov_2.751592_g30583_i0 | PRJNA846110 | 30828 | 230 | 2.751592 | 6.3286616 | Pedobacter ureilyticus | 1393051 | Bacteria | Bacteria | 116 | 1.7e-30 | NR | WP_138721603.1 | 1393051 | g30583 | i0 | 98.2 | 0.730434782608696 | 56 | 1 | 73 | 0 | 63 | 230 | 1 | 56 | WP_138721603.1 CatA-like O-acetyltransferase [Pedobacter ureilyticus] | diamond | 168 | 116 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter ureilyticus | |
| 29044442 | 29044442 | PRJNA846110_P_NODE_28088_length_244_cov_0.900585_g27843_i0 | PRJNA846110 | 28088 | 244 | 0.900585 | 2.1974274 | uncultured Flavobacterium sp. | 165435 | Bacteria | Bacteria | 160 | 1.12e-45 | NR | WP_308131143.1 | 165435 | g27843 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 243 | 1 | 83 | 163 | WP_308131143.1 formimidoylglutamase [uncultured Flavobacterium sp.] | diamond | 243 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | uncultured Flavobacterium sp. | |
| 29233805 | 29233805 | PRJNA846110_P_NODE_30809_length_231_cov_2.392405_g30564_i0 | PRJNA846110 | 30809 | 231 | 2.392405 | 5.52645555 | Fulvivirga sp. | 1931237 | Bacteria | Bacteria | 44.3 | 0.00901 | NR | WP_350105577.1 | 1931237 | g30564 | i0 | 44.7 | 0.61038961038961 | 47 | 23 | 61 | 1 | 161 | 21 | 56 | 99 | WP_350105577.1 PAS domain-containing sensor histidine kinase [Fulvivirga sp.] | diamond | 141 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Fulvivirgaceae | Fulvivirga | Fulvivirga sp. | |
| 29557698 | 29557698 | PRJNA846110_P_NODE_16450_length_280_cov_2.004831_g16205_i0 | PRJNA846110 | 16450 | 280 | 2.004831 | 5.6135268 | Bacteria | 2 | Bacteria | Bacteria | 51.2 | 5.95e-5 | NR | WP_310003438.1 | 280093 | g16205 | i0 | 44.4 | 5.18571428571429 | 54 | 25 | 52.5 | 1 | 116 | 262 | 243 | 296 | WP_310003438.1 ankyrin repeat domain-containing protein [Flavobacterium granuli] | diamond | 1452 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium granuli | |
| 29580704 | 29580704 | PRJNA846110_P_NODE_24590_length_248_cov_1.571429_g24345_i0 | PRJNA846110 | 24590 | 248 | 1.571429 | 3.89714392 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 43.1 | 0.0285 | NR | MBN8706367.1 | 1898104 | g24345 | i0 | 36.1 | 0.870967741935484 | 72 | 42 | 82.3 | 1 | 32 | 235 | 49 | 120 | MBN8706367.1 hypothetical protein [Bacteroidota bacterium] | diamond | 216 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29643791 | 29643791 | PRJNA846110_P_NODE_23490_length_250_cov_0.870056_g23245_i0 | PRJNA846110 | 23490 | 250 | 0.870056 | 2.17514 | Telluribacter humicola | 1720261 | Bacteria | Bacteria | 43.1 | 0.0132 | NR | WP_207507104.1 | 1720261 | g23245 | i0 | 33.8 | 0.852 | 71 | 40 | 78 | 2 | 12 | 206 | 70 | 139 | WP_207507104.1 response regulator [Telluribacter humicola] | diamond | 213 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Telluribacter | Telluribacter humicola | |
| 29896922 | 29896922 | PRJNA846110_P_NODE_30531_length_237_cov_3.030488_g30286_i0 | PRJNA846110 | 30531 | 237 | 3.030488 | 7.18225656 | Flavobacterium sp. J372 | 2898436 | Bacteria | Bacteria | 74.7 | 1.86e-13 | NR | WP_257867489.1 | 2898436 | g30286 | i0 | 70.2 | 0.594936708860759 | 47 | 14 | 59.5 | 0 | 143 | 3 | 1 | 47 | WP_257867489.1 GumC family protein [Flavobacterium sp. J372] | diamond | 141 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. J372 | |
| 30339611 | 30339611 | PRJNA846110_P_NODE_18412_length_271_cov_1.267677_g18167_i0 | PRJNA846110 | 18412 | 271 | 1.267677 | 3.43540467 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 129 | 1.96e-32 | NR | MEO6037373.1 | 2202734 | g18167 | i0 | 71.1 | 0.996309963099631 | 90 | 26 | 99.6 | 0 | 2 | 271 | 782 | 871 | MEO6037373.1 tetratricopeptide repeat protein [Saprospiraceae bacterium] | diamond | 270 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 31318627 | 31318627 | PRJNA846110_P_NODE_30095_length_241_cov_0.916667_g29850_i0 | PRJNA846110 | 30095 | 241 | 0.916667 | 2.20916747 | Chryseobacterium sp. SNU WT5 | 2594269 | Bacteria | Bacteria | 85.5 | 2.92e-17 | NR | WP_143853190.1 | 2594269 | g29850 | i0 | 56.8 | 0.921161825726141 | 74 | 32 | 92.1 | 0 | 232 | 11 | 286 | 359 | WP_143853190.1 hypothetical protein [Chryseobacterium sp. SNU WT5] | diamond | 222 | 85.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. SNU WT5 | |
| 31540217 | 31540217 | PRJNA846110_P_NODE_16736_length_279_cov_1.305825_g16491_i0 | PRJNA846110 | 16736 | 279 | 1.305825 | 3.64325175 | Empedobacter falsenii | 343874 | Bacteria | Bacteria | 188 | 3.7e-53 | NR | MFV0187807.1 | 343874 | g16491 | i0 | 94.6 | 0.989247311827957 | 92 | 5 | 98.9 | 0 | 3 | 278 | 727 | 818 | MFV0187807.1 DUF4433 domain-containing protein [Empedobacter falsenii] | diamond | 276 | 188 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Empedobacter | Empedobacter falsenii | |
| 31856331 | 31856331 | PRJNA846110_P_NODE_30737_length_232_cov_3.094340_g30492_i0 | PRJNA846110 | 30737 | 232 | 3.09434 | 7.1788688 | Pedobacter sp. | 1411316 | Bacteria | Bacteria | 101 | 4.05e-24 | NR | RZK69367.1 | 1411316 | g30492 | i0 | 68.7 | 0.866379310344828 | 67 | 21 | 86.6 | 0 | 30 | 230 | 1 | 67 | RZK69367.1 MAG: hypothetical protein EOO92_22065 [Pedobacter sp.] | diamond | 201 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. | |
| 31982859 | 31982859 | PRJNA846110_P_NODE_17958_length_273_cov_1.515000_g17713_i0 | PRJNA846110 | 17958 | 273 | 1.515 | 4.13595 | Sphingobacteriaceae bacterium | 2021370 | Bacteria | Bacteria | 106 | 2.5699999999999997e-24 | NR | MBK7667879.1 | 2021370 | g17713 | i0 | 56.7 | 4.9010989010989 | 90 | 39 | 98.9 | 0 | 4 | 273 | 506 | 595 | MBK7667879.1 gliding motility-associated C-terminal domain-containing protein [Sphingobacteriaceae bacterium] | diamond | 1338 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacteriaceae bacterium | ||
| 32299729 | 32299729 | PRJNA846110_P_NODE_17539_length_275_cov_1.524752_g17294_i0 | PRJNA846110 | 17539 | 275 | 1.524752 | 4.193068 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 133 | 1.87e-35 | NR | MFO8234111.1 | 2030927 | g17294 | i0 | 70.3 | 0.992727272727273 | 91 | 27 | 99.3 | 0 | 2 | 274 | 122 | 212 | MFO8234111.1 DmsC/YnfH family molybdoenzyme membrane anchor subunit [Bacteroidales bacterium] | diamond | 273 | 133 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 32299730 | 32299730 | PRJNA846110_P_NODE_19419_length_266_cov_1.341969_g19174_i0 | PRJNA846110 | 19419 | 266 | 1.341969 | 3.56963754 | Segatella oris | 28135 | Bacteria | Bacteria | 108 | 1.86e-27 | NR | WP_380978528.1 | 28135 | g19174 | i0 | 66.7 | 3.22556390977444 | 69 | 23 | 77.8 | 0 | 48 | 254 | 69 | 137 | WP_380978528.1 7-carboxy-7-deazaguanine synthase QueE [Segatella oris] | diamond | 858 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Segatella | Segatella oris | |
| 32781186 | 32781186 | PRJNA846110_P_NODE_15340_length_286_cov_1.112676_g15095_i0 | PRJNA846110 | 15340 | 286 | 1.112676 | 3.18225336 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 113 | 5.51e-28 | NR | WP_147168837.1 | 1564516 | g15095 | i0 | 58.7 | 4.82517482517482 | 92 | 35 | 96.5 | 1 | 276 | 1 | 1 | 89 | WP_147168837.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [Phaeodactylibacter luteus] | diamond | 1380 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Haliscomenobacteraceae | Phaeodactylibacter | Phaeodactylibacter luteus |
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);;