contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA699078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20310464 | 20310464 | PRJNA699078_S_NODE_87296_length_179_cov_1.600000_g86347_i0 | PRJNA699078 | 87296 | 179 | 1.6 | 2.864 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 60.1 | 1.21e-8 | NR | MCI1779820.1 | 2030927 | g86347 | i0 | 53.4 | 2.91620111731844 | 58 | 25 | 97.2 | 1 | 6 | 179 | 648 | 703 | MCI1779820.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Bacteroidales bacterium] | diamond | 522 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 27177338 | 27177338 | PRJNA699078_S_NODE_44082_length_259_cov_2.671429_g43133_i0 | PRJNA699078 | 44082 | 259 | 2.671429 | 6.91900111 | uncultured Bacteroides sp. | 162156 | Bacteria | Bacteria | 77.8 | 2.61e-16 | NR | WP_300852200.1 | 162156 | g43133 | i0 | 44 | 5.91891891891892 | 84 | 47 | 97.3 | 0 | 258 | 7 | 24 | 107 | WP_300852200.1 flavodoxin family protein, partial [uncultured Bacteroides sp.] | diamond | 1533 | 77.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | uncultured Bacteroides sp. | |
| 27536355 | 27536355 | PRJNA699078_S_NODE_33283_length_299_cov_4.016000_g32334_i0 | PRJNA699078 | 33283 | 299 | 4.016 | 12.00784 | Porphyromonas | 836 | Bacteria | Bacteria | 95.1 | 2.7e-20 | NR | WP_004333198.1 | 28124 | g32334 | i0 | 45.5 | 2.64882943143813 | 88 | 47 | 88.3 | 1 | 293 | 30 | 442 | 528 | WP_004333198.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Porphyromonas endodontalis] | diamond | 792 | 95.5 | 0.995811518324607 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas endodontalis | |
| 27903743 | 27903743 | PRJNA699078_S_NODE_100685_length_167_cov_0.881356_g99736_i0 | PRJNA699078 | 100685 | 167 | 0.881356 | 1.47186452 | uncultured Bacteroides sp. | 162156 | Bacteria | Bacteria | 43.9 | 0.00525 | NR | WP_302829521.1 | 162156 | g99736 | i0 | 50 | 0.682634730538922 | 38 | 19 | 68.3 | 0 | 36 | 149 | 348 | 385 | WP_302829521.1 alpha-1,3-galactosidase B [uncultured Bacteroides sp.] | diamond | 114 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | uncultured Bacteroides sp. | |
| 28724920 | 28724920 | PRJNA699078_S_NODE_53747_length_233_cov_0.847826_g52798_i0 | PRJNA699078 | 53747 | 233 | 0.847826 | 1.97543458 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 55.5 | 1.08e-6 | NR | MCQ2146269.1 | 2030927 | g52798 | i0 | 36.8 | 4.87982832618026 | 76 | 39 | 97.9 | 2 | 233 | 6 | 709 | 775 | MCQ2146269.1 4-alpha-glucanotransferase [Bacteroidales bacterium] | diamond | 1137 | 55.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 29261445 | 29261445 | PRJNA699078_S_NODE_13909_length_427_cov_1.394180_g12974_i0 | PRJNA699078 | 13909 | 427 | 1.39418 | 5.9531486 | Bacteroidia bacterium | 2044936 | Bacteria | Bacteria | 45.1 | 0.0346 | NR | MBL7927784.1 | 2044936 | g12974 | i0 | 28.6 | 0.836065573770492 | 119 | 77 | 81.5 | 4 | 365 | 18 | 183 | 296 | MBL7927784.1 T9SS type A sorting domain-containing protein [Bacteroidia bacterium] | diamond | 357 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 29261446 | 29261446 | PRJNA699078_S_NODE_14529_length_420_cov_6.018868_g13591_i0 | PRJNA699078 | 14529 | 420 | 6.018868 | 25.2792456 | Marinilabilia salmonicolor | 989 | Bacteria | Bacteria | 51.2 | 2.62e-4 | NR | WP_234408653.1 | 989 | g13591 | i0 | 36.8 | 1.8 | 76 | 45 | 54.3 | 1 | 116 | 343 | 475 | 547 | WP_234408653.1 DUF3417 domain-containing protein [Marinilabilia salmonicolor] | diamond | 756 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Marinilabiliaceae | Marinilabilia | Marinilabilia salmonicolor | |
| 29272644 | 29272644 | PRJNA699078_S_NODE_28529_length_322_cov_1.967033_g27580_i0 | PRJNA699078 | 28529 | 322 | 1.967033 | 6.33384626 | Bacteroidia | 200643 | Bacteria | Bacteria | 117 | 2.8699999999999997e-30 | NR | MDR0968959.1 | 2026756 | g27580 | i0 | 50 | 6.70807453416149 | 98 | 49 | 91.3 | 0 | 20 | 313 | 109 | 206 | MDR0968959.1 nitroreductase family protein [Lentimicrobiaceae bacterium] | diamond | 2160 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Lentimicrobiaceae | Lentimicrobiaceae bacterium | ||
| 29967616 | 29967616 | PRJNA699078_S_NODE_42291_length_265_cov_2.763889_g41342_i0 | PRJNA699078 | 42291 | 265 | 2.763889 | 7.32430585 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 5.44e-6 | NR | MBC7748233.1 | 239 | g41342 | i0 | 65.8 | 4.69811320754717 | 38 | 12 | 43 | 1 | 5 | 118 | 114 | 150 | MBC7748233.1 D-tyrosyl-tRNA(Tyr) deacylase [Flavobacterium sp.] | diamond | 1245 | 52.8 | 0.992424242424242 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 29987988 | 29987988 | PRJNA699078_S_NODE_103871_length_165_cov_0.879310_g102922_i0 | PRJNA699078 | 103871 | 165 | 0.87931 | 1.4508615 | Tenacibaculum sp. | 1906242 | Bacteria | Bacteria | 48.9 | 8.52e-5 | NR | HBI40987.1 | 1906242 | g102922 | i0 | 43.8 | 1.74545454545455 | 48 | 27 | 87.3 | 0 | 164 | 21 | 100 | 147 | HBI40987.1 hypothetical protein [Tenacibaculum sp.] | diamond | 288 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Tenacibaculum | Tenacibaculum sp. | |
| 30304373 | 30304373 | PRJNA699078_S_NODE_33572_length_298_cov_2.751004_g32623_i0 | PRJNA699078 | 33572 | 298 | 2.751004 | 8.19799192 | Porphyromonas gingivalis F | 837 | Bacteria | Bacteria | 65.5 | 7.47e-12 | NR | ERJ68952.1 | 1227271 | g32623 | i0 | 100 | 0.664429530201342 | 27 | 0 | 27.2 | 0 | 36 | 116 | 5 | 31 | ERJ68952.1 hypothetical protein HMPREF1555_00132 [Porphyromonas gingivalis F0570] | diamond | 198 | 65.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas gingivalis | |
| 30315596 | 30315596 | PRJNA699078_S_NODE_45932_length_253_cov_2.436275_g44983_i0 | PRJNA699078 | 45932 | 253 | 2.436275 | 6.16377575 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 8.91e-4 | NR | MEI8185813.1 | 2067991 | g44983 | i0 | 36.5 | 4.11462450592885 | 63 | 40 | 74.7 | 0 | 26 | 214 | 27 | 89 | MEI8185813.1 hypothetical protein [Chlorobiaceae bacterium] | diamond | 1041 | 45.8 | 0.991266375545852 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobiaceae bacterium | ||
| 30410243 | 30410243 | PRJNA699078_S_NODE_25833_length_336_cov_5.456446_g24884_i0 | PRJNA699078 | 25833 | 336 | 5.456446 | 18.33365856 | FCB group | 1783270 | Bacteria | Bacteria | 116 | 8.429999999999999e-31 | NR | HET6379967.1 | 2053527 | g24884 | i0 | 53.2 | 3.90178571428571 | 111 | 49 | 97.3 | 2 | 9 | 335 | 12 | 121 | HET6379967.1 RidA family protein [Candidatus Zixiibacteriota bacterium] | diamond | 1311 | 117 | 0.991452991452991 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30588109 | 30588109 | PRJNA699078_S_NODE_106573_length_163_cov_0.912281_g105624_i0 | PRJNA699078 | 106573 | 163 | 0.912281 | 1.48701803 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 50.4 | 2.29e-5 | NR | MBX2900036.1 | 2099675 | g105624 | i0 | 50.9 | 0.975460122699387 | 53 | 26 | 97.5 | 0 | 3 | 161 | 316 | 368 | MBX2900036.1 hypothetical protein [Cyclobacteriaceae bacterium] | diamond | 159 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 30714580 | 30714580 | PRJNA699078_S_NODE_107474_length_162_cov_1.380531_g106525_i0 | PRJNA699078 | 107474 | 162 | 1.380531 | 2.23646022 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 58.2 | 4.22e-8 | NR | HXE60926.1 | 2026741 | g106525 | i0 | 53.3 | 3.37037037037037 | 45 | 21 | 83.3 | 0 | 3 | 137 | 102 | 146 | HXE60926.1 selenide, water dikinase SelD [Gemmatimonadaceae bacterium] | diamond | 546 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30725783 | 30725783 | PRJNA699078_S_NODE_6034_length_574_cov_2.152381_g5201_i0 | PRJNA699078 | 6034 | 574 | 2.152381 | 12.35466694 | Bacteria | 2 | Bacteria | Bacteria | 50.4 | 6.58e-4 | NR | MBK9579349.1 | 2052160 | g5201 | i0 | 65.6 | 1.5052264808362401 | 32 | 11 | 16.7 | 0 | 479 | 574 | 2 | 33 | MBK9579349.1 RNA-binding protein [Fibrobacterota bacterium] | diamond | 864 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 30904315 | 30904315 | PRJNA699078_S_NODE_102094_length_166_cov_0.888889_g101145_i0 | PRJNA699078 | 102094 | 166 | 0.888889 | 1.47555574 | Odoribacter sp. | 1965233 | Bacteria | Bacteria | 77.8 | 4.87e-15 | NR | MEG0795602.1 | 1965233 | g101145 | i0 | 67.3 | 5.87349397590361 | 55 | 18 | 99.4 | 0 | 166 | 2 | 341 | 395 | MEG0795602.1 bifunctional phosphopantothenoylcysteine decarboxylase/phosphopantothenate--cysteine ligase CoaBC [Odoribacter sp.] | diamond | 975 | 77.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Odoribacteraceae | Odoribacter | Odoribacter sp. | |
| 30999055 | 30999055 | PRJNA699078_S_NODE_30374_length_313_cov_0.833333_g29425_i0 | PRJNA699078 | 30374 | 313 | 0.833333 | 2.60833229 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 96.7 | 1.03e-20 | NR | MCH2046448.1 | 2202734 | g29425 | i0 | 45.1 | 0.977635782747604 | 102 | 56 | 97.8 | 0 | 2 | 307 | 65 | 166 | MCH2046448.1 hypothetical protein [Saprospiraceae bacterium] | diamond | 306 | 96.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 31536673 | 31536673 | PRJNA699078_S_NODE_50016_length_242_cov_1.409326_g49067_i0 | PRJNA699078 | 50016 | 242 | 1.409326 | 3.41056892 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 46.2 | 0.00156 | NR | HOP05997.1 | 2053527 | g49067 | i0 | 33.3 | 3.75619834710744 | 81 | 51 | 96.7 | 2 | 9 | 242 | 122 | 202 | HOP05997.1 CYTH domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 909 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31916021 | 31916021 | PRJNA699078_S_NODE_76577_length_192_cov_1.454545_g75628_i0 | PRJNA699078 | 76577 | 192 | 1.454545 | 2.7927264 | Bacteroidaceae bacterium | 2212467 | Bacteria | Bacteria | 80.1 | 1.21e-15 | NR | MBR3455466.1 | 2212467 | g75628 | i0 | 56.5 | 0.96875 | 62 | 26 | 96.9 | 1 | 6 | 191 | 378 | 438 | MBR3455466.1 aminoacyl-histidine dipeptidase [Bacteroidaceae bacterium] | diamond | 186 | 80.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroidaceae bacterium | ||
| 31927241 | 31927241 | PRJNA699078_S_NODE_16097_length_405_cov_2.497191_g15155_i0 | PRJNA699078 | 16097 | 405 | 2.497191 | 10.11362355 | root | 1 | Root_unresolved | Root_unresolved | 79 | 2.26e-14 | NR | MEO6447435.1 | 2026741 | g15155 | i0 | 38 | 7.60740740740741 | 129 | 59 | 95.6 | 3 | 12 | 398 | 201 | 308 | MEO6447435.1 GDP-mannose 4,6-dehydratase [Gemmatimonadaceae bacterium] | diamond | 3081 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32074267 | 32074267 | PRJNA699078_S_NODE_87598_length_179_cov_1.153846_g86649_i0 | PRJNA699078 | 87598 | 179 | 1.153846 | 2.06538434 | Chitinophagia bacterium | 2448778 | Bacteria | Bacteria | 65.1 | 3.12e-11 | NR | NBO50522.1 | 2448778 | g86649 | i0 | 48.3 | 3.88826815642458 | 58 | 30 | 97.2 | 0 | 178 | 5 | 71 | 128 | NBO50522.1 UV DNA damage repair endonuclease UvsE [Chitinophagia bacterium] | diamond | 696 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagia bacterium | ||||
| 32327775 | 32327775 | PRJNA699078_S_NODE_54519_length_231_cov_1.186813_g53570_i0 | PRJNA699078 | 54519 | 231 | 1.186813 | 2.74153803 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 50.1 | 8.1e-5 | NR | MEM9329129.1 | 1898104 | g53570 | i0 | 46 | 0.649350649350649 | 50 | 27 | 64.9 | 0 | 229 | 80 | 413 | 462 | MEM9329129.1 ankyrin repeat domain-containing protein [Bacteroidota bacterium] | diamond | 150 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 32800685 | 32800685 | PRJNA699078_S_NODE_82820_length_184_cov_1.925926_g81871_i0 | PRJNA699078 | 82820 | 184 | 1.925926 | 3.54370384 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 42 | 0.0152 | NR | MBW7933743.1 | 2026741 | g81871 | i0 | 45.5 | 0.717391304347826 | 44 | 23 | 70.1 | 1 | 12 | 140 | 21 | 64 | MBW7933743.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 132 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;