contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax_clade = "FCB group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1923865 | 1923865 | PRJNA675331_P_NODE_18662_length_250_cov_0.870056_g18490_i0 | PRJNA675331 | 18662 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 89.7 | 2.28e-21 | NR | MBL7722999.1 | 1869212 | g18490 | i0 | 97.7 | 2.64 | 44 | 1 | 52.8 | 0 | 236 | 105 | 1 | 44 | MBL7722999.1 dihydropteroate synthase [Chitinophagaceae bacterium] | diamond | 660 | 89.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 7026407 | 7026407 | PRJNA675331_P_NODE_20946_length_246_cov_0.890173_g20774_i0 | PRJNA675331 | 20946 | 246 | 0.890173 | 2.18982558 | Bacteroidota | 976 | Bacteria | Bacteria | 139 | 4.51e-37 | NR | MEI7736649.1 | 1940288 | g20774 | i0 | 78.8 | 6.85365853658537 | 80 | 17 | 97.6 | 0 | 240 | 1 | 192 | 271 | MEI7736649.1 citrate (Si)-synthase, eukaryotic [Ferruginibacter sp.] | diamond | 1686 | 140 | 0.992857142857143 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter sp. | |
| 27050395 | 27050395 | PRJNA675331_P_NODE_922_length_930_cov_1.768961_g790_i0 | PRJNA675331 | 922 | 930 | 1.768961 | 16.4513373 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 143 | 1.32e-36 | NR | MBL0135014.1 | 1869212 | g790 | i0 | 40.1 | 3.60322580645161 | 282 | 145 | 85.8 | 11 | 42 | 839 | 36 | 309 | MBL0135014.1 fasciclin domain-containing protein [Chitinophagaceae bacterium] | diamond | 3351 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27378454 | 27378454 | PRJNA675331_P_NODE_18303_length_251_cov_0.865169_g18131_i0 | PRJNA675331 | 18303 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 126 | 3.969999999999999e-34 | NR | MBL7730473.1 | 1869212 | g18131 | i0 | 94.2 | 4.12350597609562 | 69 | 4 | 82.5 | 0 | 207 | 1 | 1 | 69 | MBL7730473.1 response regulator transcription factor [Chitinophagaceae bacterium] | diamond | 1035 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27567554 | 27567554 | PRJNA675331_P_NODE_1684_length_702_cov_2.055644_g1523_i0 | PRJNA675331 | 1684 | 702 | 2.055644 | 14.43062088 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 4.11e-29 | NR | MDZ7717225.1 | 2053516 | g1523 | i0 | 41.8 | 2.67094017094017 | 184 | 92 | 75.6 | 5 | 172 | 702 | 73 | 248 | MDZ7717225.1 fasciclin domain-containing protein [Balneolaceae bacterium] | diamond | 1875 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 27682504 | 27682504 | PRJNA675331_P_NODE_23884_length_241_cov_0.916667_g23712_i0 | PRJNA675331 | 23884 | 241 | 0.916667 | 2.20916747 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 47.8 | 6.52e-4 | NR | MFN6380301.1 | 2021391 | g23712 | i0 | 41.3 | 0.933609958506224 | 75 | 42 | 90.9 | 2 | 1 | 219 | 1938 | 2012 | MFN6380301.1 T9SS type A sorting domain-containing protein [Flavobacteriales bacterium] | diamond | 225 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 28451900 | 28451900 | PRJNA675331_P_NODE_23346_length_242_cov_0.911243_g23174_i0 | PRJNA675331 | 23346 | 242 | 0.911243 | 2.20520806 | Bacteria | 2 | Bacteria | Bacteria | 55.8 | 8.99e-7 | NR | WP_031453842.1 | 554283 | g23174 | i0 | 44.2 | 2.83884297520661 | 77 | 39 | 90.5 | 1 | 220 | 2 | 129 | 205 | WP_031453842.1 Ig-like domain-containing protein [Flavobacterium chungangense] | diamond | 687 | 55.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium chungangense | |
| 28629578 | 28629578 | PRJNA675331_P_NODE_12307_length_289_cov_2.796296_g12135_i0 | PRJNA675331 | 12307 | 289 | 2.796296 | 8.08129544 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 61.6 | 9.04e-9 | NR | MDB4835335.1 | 2099675 | g12135 | i0 | 35.9 | 1.86851211072664 | 92 | 55 | 92.4 | 2 | 23 | 289 | 152 | 242 | MDB4835335.1 carbonic anhydrase family protein [Cyclobacteriaceae bacterium] | diamond | 540 | 61.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 28957156 | 28957156 | PRJNA675331_P_NODE_11948_length_293_cov_1.050000_g11776_i0 | PRJNA675331 | 11948 | 293 | 1.05 | 3.0765 | Bacteria | 2 | Bacteria | Bacteria | 45.1 | 0.0106 | NR | MCB0538595.1 | 1898104 | g11776 | i0 | 31.7 | 2.20136518771331 | 82 | 53 | 81.9 | 2 | 250 | 11 | 741 | 821 | MCB0538595.1 hypothetical protein [Bacteroidota bacterium] | diamond | 645 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29071599 | 29071599 | PRJNA675331_P_NODE_24048_length_241_cov_0.916667_g23876_i0 | PRJNA675331 | 24048 | 241 | 0.916667 | 2.20916747 | Polaribacter aquimarinus | 2100726 | Bacteria | Bacteria | 42.7 | 0.037 | NR | WP_235869097.1 | 2100726 | g23876 | i0 | 28.6 | 0.871369294605809 | 70 | 48 | 87.1 | 1 | 240 | 31 | 484 | 551 | WP_235869097.1 tetratricopeptide repeat protein [Polaribacter aquimarinus] | diamond | 210 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Polaribacter | Polaribacter aquimarinus | |
| 29619559 | 29619559 | PRJNA675331_P_NODE_24150_length_241_cov_0.916667_g23978_i0 | PRJNA675331 | 24150 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 4.77e-19 | NR | MCF8289086.1 | 1869212 | g23978 | i0 | 55.3 | 3.78423236514523 | 76 | 33 | 94.6 | 1 | 231 | 4 | 33 | 107 | MCF8289086.1 family 10 glycosylhydrolase [Chitinophagaceae bacterium] | diamond | 912 | 90.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 30429856 | 30429856 | PRJNA675331_P_NODE_22873_length_243_cov_0.905882_g22701_i0 | PRJNA675331 | 22873 | 243 | 0.905882 | 2.20129326 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 167 | 1.74e-49 | NR | MCA6437638.1 | 1898104 | g22701 | i0 | 91.3 | 1.97530864197531 | 80 | 7 | 98.8 | 0 | 241 | 2 | 16 | 95 | MCA6437638.1 acetyl-CoA carboxylase carboxyltransferase subunit beta [Bacteroidota bacterium] | diamond | 480 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30682010 | 30682010 | PRJNA675331_P_NODE_4653_length_441_cov_1.695652_g4481_i0 | PRJNA675331 | 4653 | 441 | 1.695652 | 7.47782532 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 73.9 | 4.23e-12 | NR | MCH2213589.1 | 2021391 | g4481 | i0 | 49 | 0.707482993197279 | 104 | 40 | 67.3 | 6 | 429 | 133 | 96 | 191 | MCH2213589.1 HYR domain-containing protein [Flavobacteriales bacterium] | diamond | 312 | 73.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 31061635 | 31061635 | PRJNA675331_P_NODE_1295_length_791_cov_2.079387_g1143_i0 | PRJNA675331 | 1295 | 791 | 2.079387 | 16.44795117 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 60.1 | 3.34e-6 | NR | MBM3956824.1 | 2026742 | g1143 | i0 | 28.9 | 1.61567635903919 | 211 | 120 | 78.5 | 9 | 142 | 762 | 49 | 233 | MBM3956824.1 tandem-95 repeat protein [Gemmatimonadota bacterium] | diamond | 1278 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31294386 | 31294386 | PRJNA675331_P_NODE_13135_length_282_cov_1.105263_g12963_i0 | PRJNA675331 | 13135 | 282 | 1.105263 | 3.11684166 | Bacteroidota | 976 | Bacteria | Bacteria | 101 | 1.1e-22 | NR | MBT3443244.1 | 1871037 | g12963 | i0 | 65.9 | 7.9468085106383 | 82 | 25 | 84 | 2 | 34 | 270 | 3 | 84 | MBT3443244.1 aspartate--tRNA ligase [Flavobacteriaceae bacterium] | diamond | 2241 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 32231906 | 32231906 | PRJNA675331_P_NODE_17138_length_257_cov_0.994565_g16966_i0 | PRJNA675331 | 17138 | 257 | 0.994565 | 2.5560320500000002 | Gelidibacter sp. F2691 | 2926852 | Bacteria | Bacteria | 53.5 | 7.22e-6 | NR | MCK0124720.1 | 2926852 | g16966 | i0 | 42.4 | 0.992217898832685 | 85 | 46 | 98.1 | 3 | 253 | 2 | 1427 | 1509 | MCK0124720.1 gliding motility-associated C-terminal domain-containing protein [Gelidibacter sp. F2691] | diamond | 255 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Gelidibacter | Gelidibacter sp. F2691 | |
| 32673909 | 32673909 | PRJNA675331_P_NODE_3240_length_519_cov_1.381166_g3070_i0 | PRJNA675331 | 3240 | 519 | 1.381166 | 7.16825154 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 47.4 | 0.012 | NR | MCH9031196.1 | 2053527 | g3070 | i0 | 29.9 | 0.774566473988439 | 134 | 73 | 74.6 | 7 | 49 | 435 | 226 | 343 | MCH9031196.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 402 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium |
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);;