contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA825466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2096017 | 2096017 | PRJNA825466_P_NODE_9482_length_292_cov_1.611872_g9381_i0 | PRJNA825466 | 9482 | 292 | 1.611872 | 4.70666624 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 183 | 2.62e-53 | NR | MCB9163034.1 | 2021391 | g9381 | i0 | 89.6 | 0.986301369863014 | 96 | 10 | 98.6 | 0 | 289 | 2 | 98 | 193 | MCB9163034.1 aldehyde dehydrogenase [Flavobacteriales bacterium] | diamond | 288 | 183 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 5923706 | 5923706 | PRJNA825466_P_NODE_925_length_705_cov_1.648734_g834_i0 | PRJNA825466 | 925 | 705 | 1.648734 | 11.6235747 | root | 1 | Root_unresolved | Root_unresolved | 199 | 3.089999999999999e-55 | NR | MCA6491779.1 | 1869212 | g834 | i0 | 67.6 | 1.19148936170213 | 136 | 44 | 57.9 | 0 | 701 | 294 | 631 | 766 | MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium] | diamond | 840 | 201 | 0.990049751243781 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 9748472 | 9748472 | PRJNA825466_P_NODE_28548_length_241_cov_0.916667_g28447_i0 | PRJNA825466 | 28548 | 241 | 0.916667 | 2.20916747 | unclassified Flavobacterium | 196869 | Bacteria | Bacteria | 159 | 3.34e-47 | NR | WP_153207106.1 | 196869 | g28447 | i0 | 94.9 | 0.983402489626556 | 79 | 4 | 98.3 | 0 | 239 | 3 | 87 | 165 | WP_153207106.1 MULTISPECIES: GldM family protein [unclassified Flavobacterium] | diamond | 237 | 159 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 21222531 | 21222531 | PRJNA825466_S_NODE_1457_length_250_cov_0.870056_g1451_i0 | PRJNA825466 | 1457 | 250 | 0.870056 | 2.17514 | Chitinophagaceae | 563835 | Bacteria | Bacteria | 110 | 2.5e-26 | NR | WP_090661288.1 | 1465490 | g1451 | i0 | 88.7 | 15.528 | 53 | 6 | 63.6 | 0 | 248 | 90 | 448 | 500 | WP_090661288.1 S26 family signal peptidase [Parafilimonas terrae] | diamond | 3882 | 111 | 0.990990990990991 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Parafilimonas | Parafilimonas terrae | |
| 26927904 | 26927904 | PRJNA825466_P_NODE_28242_length_241_cov_0.916667_g28141_i0 | PRJNA825466 | 28242 | 241 | 0.916667 | 2.20916747 | Draconibacterium sp. | 1965318 | Bacteria | Bacteria | 88.6 | 1.73e-19 | NR | HPF51747.1 | 1965318 | g28141 | i0 | 50 | 0.995850622406639 | 80 | 40 | 99.6 | 0 | 240 | 1 | 130 | 209 | HPF51747.1 CAP domain-containing protein [Draconibacterium sp.] | diamond | 240 | 88.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Prolixibacteraceae | Draconibacterium | Draconibacterium sp. | |
| 27244102 | 27244102 | PRJNA825466_P_NODE_19623_length_248_cov_1.760000_g19522_i0 | PRJNA825466 | 19623 | 248 | 1.76 | 4.3648 | Bacteroidia bacterium | 2044936 | Bacteria | Bacteria | 143 | 1.97e-37 | NR | HXB41044.1 | 2044936 | g19522 | i0 | 78 | 0.991935483870968 | 82 | 18 | 99.2 | 0 | 2 | 247 | 74 | 155 | HXB41044.1 PKD domain-containing protein [Bacteroidia bacterium] | diamond | 246 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 28065175 | 28065175 | PRJNA825466_S_NODE_1685_length_246_cov_0.890173_g1679_i0 | PRJNA825466 | 1685 | 246 | 0.890173 | 2.18982558 | Flavitalea sp. | 1909289 | Bacteria | Bacteria | 149 | 9.19e-40 | NR | HSB93653.1 | 1909289 | g1679 | i0 | 79 | 0.98780487804878 | 81 | 17 | 98.8 | 0 | 245 | 3 | 542 | 622 | HSB93653.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Flavitalea sp.] | diamond | 243 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Flavitalea | Flavitalea sp. | |
| 28285980 | 28285980 | PRJNA825466_S_NODE_1426_length_250_cov_1.209040_g1420_i0 | PRJNA825466 | 1426 | 250 | 1.20904 | 3.0226 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 60.5 | 1.75e-8 | NR | HEY6504147.1 | 1869212 | g1420 | i0 | 67.6 | 1.884 | 34 | 11 | 40.8 | 0 | 1 | 102 | 247 | 280 | HEY6504147.1 alpha/beta hydrolase-fold protein [Chitinophagaceae bacterium] | diamond | 471 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 28444210 | 28444210 | PRJNA825466_S_NODE_1566_length_248_cov_1.217143_g1560_i0 | PRJNA825466 | 1566 | 248 | 1.217143 | 3.01851464 | Hymenobacter sp. IS2118 | 1505605 | Bacteria | Bacteria | 112 | 1.34e-26 | NR | WP_035564435.1 | 1505605 | g1560 | i0 | 66.7 | 3.93145161290323 | 81 | 27 | 98 | 0 | 1 | 243 | 76 | 156 | WP_035564435.1 sensor histidine kinase [Hymenobacter sp. IS2118] | diamond | 975 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter sp. IS2118 | |
| 28475670 | 28475670 | PRJNA825466_P_NODE_9766_length_290_cov_1.377880_g9665_i0 | PRJNA825466 | 9766 | 290 | 1.37788 | 3.995852 | Pedobacter cryoconitis | 188932 | Bacteria | Bacteria | 117 | 4.4e-31 | NR | WP_183878434.1 | 188932 | g9665 | i0 | 100 | 0.662068965517241 | 64 | 0 | 66.2 | 0 | 3 | 194 | 35 | 98 | WP_183878434.1 hypothetical protein [Pedobacter cryoconitis] | diamond | 192 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter cryoconitis | |
| 28958121 | 28958121 | PRJNA825466_P_NODE_27528_length_242_cov_0.911243_g27427_i0 | PRJNA825466 | 27528 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 163 | 2.46e-50 | NR | WP_141554293.1 | 361581 | g27427 | i0 | 100 | 1.98347107438017 | 80 | 0 | 99.2 | 0 | 241 | 2 | 23 | 102 | WP_141554293.1 redoxin domain-containing protein, partial [Tenacibaculum discolor] | diamond | 480 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Tenacibaculum | Tenacibaculum discolor | |
| 29170405 | 29170405 | PRJNA825466_P_NODE_18669_length_249_cov_0.875000_g18568_i0 | PRJNA825466 | 18669 | 249 | 0.875 | 2.17875 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 44.3 | 0.0121 | NR | MDZ4707736.1 | 2202734 | g18568 | i0 | 39.3 | 0.674698795180723 | 56 | 31 | 67.5 | 1 | 82 | 249 | 1492 | 1544 | MDZ4707736.1 CARDB domain-containing protein [Saprospiraceae bacterium] | diamond | 168 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 29580408 | 29580408 | PRJNA825466_P_NODE_10970_length_281_cov_1.625000_g10869_i0 | PRJNA825466 | 10970 | 281 | 1.625 | 4.56625 | Cytophagales bacterium | 2053541 | Bacteria | Bacteria | 87.8 | 1.54e-19 | NR | MCR9066919.1 | 2053541 | g10869 | i0 | 57.9 | 0.811387900355872 | 76 | 31 | 81.1 | 1 | 279 | 52 | 87 | 161 | MCR9066919.1 Hsp20/alpha crystallin family protein [Cytophagales bacterium] | diamond | 228 | 87.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagales bacterium | |||
| 29936819 | 29936819 | PRJNA825466_P_NODE_15911_length_253_cov_1.005556_g15810_i0 | PRJNA825466 | 15911 | 253 | 1.005556 | 2.54405668 | Paludibacter | 346096 | Bacteria | Bacteria | 50.4 | 8.46e-5 | NR | MDD4992995.1 | 1898105 | g15810 | i0 | 42 | 4.87351778656126 | 81 | 43 | 92.5 | 2 | 240 | 7 | 1264 | 1343 | MDD4992995.1 alpha-2-macroglobulin family protein [Paludibacter sp.] | diamond | 1233 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Paludibacteraceae | Paludibacter | Paludibacter sp. | |
| 30212273 | 30212273 | PRJNA825466_P_NODE_10732_length_283_cov_1.242857_g10631_i0 | PRJNA825466 | 10732 | 283 | 1.242857 | 3.51728531 | Sphingobacteriales bacterium | 2044944 | Bacteria | Bacteria | 129 | 1.03e-36 | NR | RYE50665.1 | 2044944 | g10631 | i0 | 83.1 | 0.816254416961131 | 77 | 13 | 81.6 | 0 | 47 | 277 | 1 | 77 | RYE50665.1 MAG: hypothetical protein EOP48_19390 [Sphingobacteriales bacterium] | diamond | 231 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriales bacterium | |||
| 30749567 | 30749567 | PRJNA825466_P_NODE_22754_length_246_cov_0.890173_g22653_i0 | PRJNA825466 | 22754 | 246 | 0.890173 | 2.18982558 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 149 | 5.569999999999999e-42 | NR | MEN9549681.1 | 1898104 | g22653 | i0 | 90.2 | 2 | 82 | 8 | 100 | 0 | 246 | 1 | 244 | 325 | MEN9549681.1 3-phosphoshikimate 1-carboxyvinyltransferase [Bacteroidota bacterium] | diamond | 492 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 31034223 | 31034223 | PRJNA825466_P_NODE_26695_length_243_cov_0.905882_g26594_i0 | PRJNA825466 | 26695 | 243 | 0.905882 | 2.20129326 | Chryseobacterium sp. | 1871047 | Bacteria | Bacteria | 75.5 | 3.49e-14 | NR | MBO6201510.1 | 1871047 | g26594 | i0 | 90.9 | 1.08641975308642 | 44 | 4 | 54.3 | 0 | 110 | 241 | 1 | 44 | MBO6201510.1 glycoside hydrolase family 28 protein [Chryseobacterium sp.] | diamond | 264 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. | |
| 31159908 | 31159908 | PRJNA825466_S_NODE_1395_length_251_cov_0.865169_g1389_i0 | PRJNA825466 | 1395 | 251 | 0.865169 | 2.17157419 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 171 | 5.73e-48 | NR | MBL7846519.1 | 2099675 | g1389 | i0 | 97.6 | 2.97609561752988 | 83 | 2 | 99.2 | 0 | 3 | 251 | 480 | 562 | MBL7846519.1 phosphoglycerate dehydrogenase [Cyclobacteriaceae bacterium] | diamond | 747 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 31517036 | 31517036 | PRJNA825466_S_NODE_556_length_339_cov_1.654135_g550_i0 | PRJNA825466 | 556 | 339 | 1.654135 | 5.60751765 | FCB group | 1783270 | Bacteria | Bacteria | 75.5 | 8.85e-15 | NR | WP_050229787.1 | 821 | g550 | i0 | 100 | 0.955752212389381 | 36 | 0 | 31.9 | 0 | 193 | 300 | 1 | 36 | WP_050229787.1 hypothetical protein [Phocaeicola vulgatus] | diamond | 324 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola vulgatus | |
| 32014290 | 32014290 | PRJNA825466_S_NODE_1398_length_251_cov_0.865169_g1392_i0 | PRJNA825466 | 1398 | 251 | 0.865169 | 2.17157419 | Ohtaekwangia kribbensis | 688913 | Bacteria | Bacteria | 128 | 8.269999999999998e-35 | NR | WP_377579525.1 | 688913 | g1392 | i0 | 62.7 | 1.9601593625498 | 83 | 31 | 99.2 | 0 | 2 | 250 | 128 | 210 | WP_377579525.1 DUF6048 family protein [Ohtaekwangia kribbensis] | diamond | 492 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Fulvivirgaceae | Ohtaekwangia | Ohtaekwangia kribbensis | |
| 32655020 | 32655020 | PRJNA825466_P_NODE_17980_length_250_cov_0.870056_g17879_i0 | PRJNA825466 | 17980 | 250 | 0.870056 | 2.17514 | Ferruginibacter | 1004303 | Bacteria | Bacteria | 147 | 4.34e-39 | NR | MBK8610442.1 | 1869212 | g17879 | i0 | 84.3 | 5.976 | 83 | 13 | 99.6 | 0 | 250 | 2 | 103 | 185 | MBK8610442.1 DUF4954 family protein [Chitinophagaceae bacterium] | diamond | 1494 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 32709614 | 32709614 | PRJNA825466_S_NODE_1440_length_250_cov_0.870056_g1434_i0 | PRJNA825466 | 1440 | 250 | 0.870056 | 2.17514 | Ferruginibacter sp. | 1940288 | Bacteria | Bacteria | 125 | 8.58e-33 | NR | MEO6229582.1 | 1940288 | g1434 | i0 | 72.7 | 0.924 | 77 | 21 | 92.4 | 0 | 15 | 245 | 181 | 257 | MEO6229582.1 hypothetical protein [Ferruginibacter sp.] | diamond | 231 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter 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);;