contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA699078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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);;