contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16537086 | 16537086 | PRJNA853194_S_NODE_30933_length_376_cov_20.775578_g29842_i0 | PRJNA853194 | 30933 | 376 | 20.775578 | 78.11617328 | Flavobacteriaceae bacterium | 1871037 | Bacteria | Bacteria | 67 | 7.97e-12 | NR | HKJ06409.1 | 1871037 | g29842 | i0 | 44.6 | 2.64095744680851 | 83 | 43 | 66.2 | 2 | 329 | 81 | 1 | 80 | HKJ06409.1 molybdopterin converting factor subunit 1 [Flavobacteriaceae bacterium] | diamond | 993 | 67 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 26620033 | 26620033 | PRJNA853194_S_NODE_71301_length_260_cov_1.358289_g70210_i0 | PRJNA853194 | 71301 | 260 | 1.358289 | 3.5315514 | Bacteroidota | 976 | Bacteria | Bacteria | 44.3 | 0.0131 | NR | MEP7374087.1 | 1869212 | g70210 | i0 | 29.6 | 3.24230769230769 | 71 | 50 | 81.9 | 0 | 29 | 241 | 43 | 113 | MEP7374087.1 S9 family peptidase [Chitinophagaceae bacterium] | diamond | 843 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 26928455 | 26928455 | PRJNA853194_S_NODE_24042_length_416_cov_30.825073_g22951_i0 | PRJNA853194 | 24042 | 416 | 30.825073 | 128.23230368 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 93.2 | 1e-20 | NR | MFN3872034.1 | 2651167 | g22951 | i0 | 47.8 | 4.84615384615385 | 90 | 46 | 64.2 | 1 | 91 | 357 | 93 | 182 | MFN3872034.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Ignavibacterium sp.] | diamond | 2016 | 93.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 26991504 | 26991504 | PRJNA853194_S_NODE_38702_length_343_cov_3.707407_g37611_i0 | PRJNA853194 | 38702 | 343 | 3.707407 | 12.71640601 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 44.7 | 0.0237 | NR | HBZ00572.1 | 2053527 | g37611 | i0 | 31.2 | 1.3469387755102 | 77 | 49 | 63.8 | 1 | 75 | 293 | 88 | 164 | HBZ00572.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] | diamond | 462 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 27086697 | 27086697 | PRJNA853194_S_NODE_45542_length_320_cov_2.469636_g44451_i0 | PRJNA853194 | 45542 | 320 | 2.469636 | 7.9028352 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 45.1 | 0.0118 | NR | MCA0389646.1 | 1898104 | g44451 | i0 | 29.5 | 0.825 | 88 | 59 | 80.6 | 2 | 274 | 17 | 113 | 199 | MCA0389646.1 DUF4292 domain-containing protein [Bacteroidota bacterium] | diamond | 264 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27371374 | 27371374 | PRJNA853194_S_NODE_35703_length_355_cov_1.567376_g34612_i0 | PRJNA853194 | 35703 | 355 | 1.567376 | 5.5641848 | Tenacibaculum agarivorans | 1908389 | Bacteria | Bacteria | 44.7 | 0.0207 | NR | WP_143569757.1 | 1908389 | g34612 | i0 | 33.1 | 1.09859154929577 | 130 | 55 | 90.4 | 7 | 12 | 332 | 116 | 236 | WP_143569757.1 hypothetical protein [Tenacibaculum agarivorans] | diamond | 390 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Tenacibaculum | Tenacibaculum agarivorans | |
| 27528927 | 27528927 | PRJNA853194_S_NODE_10863_length_575_cov_4.836653_g9814_i0 | PRJNA853194 | 10863 | 575 | 4.836653 | 27.81075475 | Bacteroides | 816 | Bacteria | Bacteria | 47 | 0.0196 | NR | WP_224319383.1 | 816 | g9814 | i0 | 32.8 | 0.667826086956522 | 128 | 70 | 59.5 | 5 | 227 | 568 | 136 | 261 | WP_224319383.1 MULTISPECIES: UDP-N-acetylmuramate dehydrogenase [Bacteroides] | diamond | 384 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | ||
| 27592281 | 27592281 | PRJNA853194_S_NODE_364_length_1934_cov_233.796346_g225_i1 | PRJNA853194 | 364 | 1934 | 233.796346 | 4521.62133164 | Chryseobacterium cucumeris | 1813611 | Bacteria | Bacteria | 49.3 | 0.0478 | NR | WP_062676161.1 | 1813611 | g225 | i1 | 27 | 0.350568769389866 | 226 | 113 | 34 | 10 | 929 | 1585 | 170 | 350 | WP_062676161.1 hypothetical protein [Chryseobacterium cucumeris] | diamond | 678 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium cucumeris | |
| 27781677 | 27781677 | PRJNA853194_S_NODE_5124_length_795_cov_4.168975_g4288_i0 | PRJNA853194 | 5124 | 795 | 4.168975 | 33.14335125 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 49.3 | 0.0103 | NR | RYF19581.1 | 2021391 | g4288 | i0 | 27 | 0.9660377358490572 | 256 | 144 | 86.4 | 9 | 77 | 763 | 140 | 379 | RYF19581.1 MAG: hypothetical protein EOO42_14125 [Flavobacteriales bacterium] | diamond | 768 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 27813384 | 27813384 | PRJNA853194_S_NODE_7784_length_665_cov_16.184122_g6801_i0 | PRJNA853194 | 7784 | 665 | 16.184122 | 107.6244113 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 132 | 6.37e-33 | NR | RMH53848.1 | 1898104 | g6801 | i0 | 40.4 | 3.48721804511278 | 146 | 84 | 65.4 | 2 | 25 | 459 | 225 | 368 | RMH53848.1 MAG: GTP 3',8-cyclase MoaA [Bacteroidota bacterium] | diamond | 2319 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 28318298 | 28318298 | PRJNA853194_S_NODE_79866_length_247_cov_1.327586_g78775_i0 | PRJNA853194 | 79866 | 247 | 1.327586 | 3.27913742 | Bacteroides eggerthii | 28111 | Bacteria | Bacteria | 43.9 | 0.0153 | NR | WP_004294264.1 | 28111 | g78775 | i0 | 35.7 | 1.7004048582996 | 70 | 43 | 83.8 | 2 | 243 | 37 | 52 | 120 | WP_004294264.1 sulfatase [Bacteroides eggerthii] | diamond | 420 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides eggerthii | |
| 28570809 | 28570809 | PRJNA853194_S_NODE_24347_length_414_cov_13.466276_g23256_i0 | PRJNA853194 | 24347 | 414 | 13.466276 | 55.75038264 | Sphingobacterium bovistauri | 2781959 | Bacteria | Bacteria | 46.2 | 0.0138 | NR | WP_225552148.1 | 2781959 | g23256 | i0 | 30.7 | 0.543478260869565 | 75 | 51 | 54.3 | 1 | 326 | 102 | 13 | 86 | WP_225552148.1 TonB-dependent receptor [Sphingobacterium bovistauri] | diamond | 225 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium bovistauri | |
| 28665755 | 28665755 | PRJNA853194_S_NODE_67047_length_268_cov_1.579487_g65956_i0 | PRJNA853194 | 67047 | 268 | 1.579487 | 4.23302516 | Prevotella sp. | 59823 | Bacteria | Bacteria | 42.7 | 0.0462 | NR | MBR3089822.1 | 59823 | g65956 | i0 | 41.5 | 0.593283582089552 | 53 | 31 | 59.3 | 0 | 197 | 39 | 13 | 65 | MBR3089822.1 transposase [Prevotella sp.] | diamond | 159 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. | |
| 28728809 | 28728809 | PRJNA853194_S_NODE_29687_length_383_cov_1.667742_g28596_i0 | PRJNA853194 | 29687 | 383 | 1.667742 | 6.38745186 | Parabacteroides gordonii | 574930 | Bacteria | Bacteria | 44.3 | 0.05 | NR | WP_028728217.1 | 574930 | g28596 | i0 | 40.4 | 0.446475195822454 | 57 | 34 | 44.6 | 0 | 81 | 251 | 667 | 723 | WP_028728217.1 hypothetical protein [Parabacteroides gordonii] | diamond | 171 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Tannerellaceae | Parabacteroides | Parabacteroides gordonii | |
| 28823225 | 28823225 | PRJNA853194_S_NODE_4148_length_865_cov_16.655303_g3381_i0 | PRJNA853194 | 4148 | 865 | 16.655303 | 144.06837095 | Chryseobacterium lacus | 2058346 | Bacteria | Bacteria | 60.8 | 1.85e-6 | NR | WP_114302830.1 | 2058346 | g3381 | i0 | 50 | 0.228901734104046 | 66 | 32 | 22.5 | 1 | 578 | 384 | 36 | 101 | WP_114302830.1 proline dehydrogenase family protein [Chryseobacterium lacus] | diamond | 198 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium lacus | |
| 29044690 | 29044690 | PRJNA853194_S_NODE_42568_length_330_cov_1.276265_g41477_i0 | PRJNA853194 | 42568 | 330 | 1.276265 | 4.2116745 | Bacteroidetes bacterium ADurb.Bin234 | 1852810 | Bacteria | Bacteria | 45.1 | 0.015 | NR | OQA92910.1 | 1852810 | g41477 | i0 | 30.5 | 0.745454545454545 | 82 | 54 | 72.7 | 2 | 44 | 283 | 409 | 489 | OQA92910.1 MAG: hypothetical protein BWY27_00095 [Bacteroidetes bacterium ADurb.Bin234] | diamond | 246 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidetes bacterium ADurb.Bin234 | |||||
| 29580968 | 29580968 | PRJNA853194_S_NODE_8750_length_631_cov_9.978495_g7737_i0 | PRJNA853194 | 8750 | 631 | 9.978495 | 62.96430345 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 50.8 | 0.00169 | NR | MEN9448333.1 | 1898104 | g7737 | i0 | 32 | 0.580031695721078 | 122 | 78 | 57.1 | 4 | 533 | 174 | 203 | 321 | MEN9448333.1 ribonuclease [Bacteroidota bacterium] | diamond | 366 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29991866 | 29991866 | PRJNA853194_S_NODE_22351_length_428_cov_3.492958_g21260_i0 | PRJNA853194 | 22351 | 428 | 3.492958 | 14.94986024 | Flavobacteriaceae bacterium | 1871037 | Bacteria | Bacteria | 47 | 0.00866 | NR | MDA8588908.1 | 1871037 | g21260 | i0 | 32.5 | 0.841121495327103 | 120 | 59 | 70.8 | 6 | 371 | 69 | 633 | 749 | MDA8588908.1 PD-(D/E)XK nuclease family protein [Flavobacteriaceae bacterium] | diamond | 360 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 30023613 | 30023613 | PRJNA853194_S_NODE_27551_length_394_cov_2.850467_g26460_i0 | PRJNA853194 | 27551 | 394 | 2.850467 | 11.23083998 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 45.4 | 0.0216 | NR | MDB5227346.1 | 1898104 | g26460 | i0 | 31.1 | 0.784263959390863 | 103 | 62 | 72.3 | 2 | 81 | 365 | 93 | 194 | MDB5227346.1 putative ATP-binding protein involved in virulence [Bacteroidota bacterium] | diamond | 309 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30276505 | 30276505 | PRJNA853194_S_NODE_56732_length_290_cov_1.520737_g55641_i0 | PRJNA853194 | 56732 | 290 | 1.520737 | 4.4101373 | Spirosoma pollinicola | 2057025 | Bacteria | Bacteria | 43.9 | 0.0262 | NR | WP_100989782.1 | 2057025 | g55641 | i0 | 27.1 | 0.993103448275862 | 96 | 53 | 89 | 3 | 282 | 25 | 184 | 272 | WP_100989782.1 DEAD/DEAH box helicase [Spirosoma pollinicola] | diamond | 288 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Spirosoma | Spirosoma pollinicola | |
| 30528865 | 30528865 | PRJNA853194_S_NODE_5113_length_796_cov_3.372061_g4278_i0 | PRJNA853194 | 5113 | 796 | 3.372061 | 26.84160556 | Candidatus Karelsulcia muelleri | 336810 | Bacteria | Bacteria | 48.1 | 0.00769 | NR | WP_348660600.1 | 336810 | g4278 | i0 | 32.9 | 0.561557788944724 | 149 | 78 | 54.3 | 7 | 60 | 491 | 4 | 135 | WP_348660600.1 F0F1 ATP synthase subunit delta [Candidatus Karelsulcia muelleri] | diamond | 447 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Candidatus Karelsulcia | Candidatus Karelsulcia muelleri | ||
| 31793170 | 31793170 | PRJNA853194_S_NODE_6417_length_724_cov_1258.970814_g5501_i0 | PRJNA853194 | 6417 | 724 | 1258.970814 | 9114.94869336 | Candidatus Aegiribacteria sp. | 2528271 | Bacteria | Bacteria | 94.7 | 3.44e-21 | NR | MFO8183585.1 | 2528271 | g5501 | i0 | 57.7 | 1.01519337016575 | 78 | 33 | 32.3 | 0 | 674 | 441 | 2 | 79 | MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.] | diamond | 735 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Aegiribacteria | Candidatus Aegiribacteria sp. | |||||
| 31951524 | 31951524 | PRJNA853194_S_NODE_8737_length_631_cov_150.365591_g7725_i0 | PRJNA853194 | 8737 | 631 | 150.365591 | 948.80687921 | Lacibacter sp. | 1915409 | Bacteria | Bacteria | 47 | 0.0172 | NR | WP_324232586.1 | 1915409 | g7725 | i0 | 31.9 | 0.446909667194929 | 94 | 63 | 44.2 | 1 | 93 | 371 | 3 | 96 | WP_324232586.1 hypothetical protein [Lacibacter sp.] | diamond | 282 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Lacibacter | Lacibacter sp. | |
| 32394624 | 32394624 | PRJNA853194_S_NODE_41299_length_334_cov_2.371648_g40208_i0 | PRJNA853194 | 41299 | 334 | 2.371648 | 7.92130432 | Rosettibacter primus | 3111523 | Bacteria | Bacteria | 43.9 | 0.0387 | NR | WP_353675908.1 | 3111523 | g40208 | i0 | 36.6 | 0.637724550898204 | 71 | 42 | 61.1 | 2 | 265 | 62 | 243 | 313 | WP_353675908.1 GWxTD domain-containing protein [Rosettibacter primus] | diamond | 213 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Rosettibacter | Rosettibacter primus | |
| 32426246 | 32426246 | PRJNA853194_S_NODE_55699_length_292_cov_3.593607_g54608_i0 | PRJNA853194 | 55699 | 292 | 3.593607 | 10.49333244 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 45.8 | 0.00527 | NR | MCB0693351.1 | 2202734 | g54608 | i0 | 39.6 | 0.986301369863014 | 48 | 26 | 46.2 | 1 | 29 | 163 | 234 | 281 | MCB0693351.1 hypothetical protein [Saprospiraceae bacterium] | diamond | 288 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae 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);;