contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4461140 | 4461140 | PRJNA666695_S_NODE_77664_length_246_cov_2.024390_g76570_i0 | PRJNA666695 | 77664 | 246 | 2.02439 | 4.9799994 | Pseudomonadota | 1224 | Bacteria | Bacteria | 120 | 1.71e-29 | NR | MBF0352335.1 | 2024889 | g76570 | i0 | 67.5 | 4.8780487804878 | 80 | 26 | 97.6 | 0 | 246 | 7 | 628 | 707 | MBF0352335.1 methylmalonyl-CoA mutase [SAR324 cluster bacterium] | diamond | 1200 | 120 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 28249898 | 28249898 | PRJNA666695_S_NODE_104726_length_215_cov_1.586207_g103632_i0 | PRJNA666695 | 104726 | 215 | 1.586207 | 3.41034505 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 46.2 | 0.00158 | NR | WP_146959293.1 | 2600177 | g103632 | i0 | 41.9 | 0.865116279069767 | 62 | 35 | 86.5 | 1 | 29 | 214 | 1383 | 1443 | WP_146959293.1 hypothetical protein [Microvenator marinus] | diamond | 186 | 46.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 28893515 | 28893515 | PRJNA666695_S_NODE_37448_length_328_cov_3.020906_g36354_i0 | PRJNA666695 | 37448 | 328 | 3.020906 | 9.90857168 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 144 | 3.9399999999999997e-38 | NR | OGP58345.1 | 1797827 | g36354 | i0 | 65.7 | 14.8170731707317 | 108 | 33 | 98.8 | 1 | 324 | 1 | 431 | 534 | OGP58345.1 MAG: AMP-dependent synthetase [Deltaproteobacteria bacterium RBG_13_49_15] | diamond | 4860 | 144 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_49_15 | ||||||
| 29923637 | 29923637 | PRJNA666695_S_NODE_111171_length_209_cov_0.970238_g110077_i0 | PRJNA666695 | 111171 | 209 | 0.970238 | 2.02779742 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 41.6 | 0.0225 | NR | MEC8594321.1 | 2024889 | g110077 | i0 | 56 | 0.358851674641148 | 25 | 11 | 35.9 | 0 | 45 | 119 | 38 | 62 | MEC8594321.1 hypothetical protein [SAR324 cluster bacterium] | diamond | 75 | 41.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 30144372 | 30144372 | PRJNA666695_S_NODE_28792_length_362_cov_2.760125_g27699_i0 | PRJNA666695 | 28792 | 362 | 2.760125 | 9.9916525 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2 | 2013747 | Bacteria | Bacteria | 75.9 | 3.06e-14 | NR | PKN46214.1 | 2013748 | g27699 | i0 | 56.1 | 0.546961325966851 | 66 | 27 | 54.7 | 1 | 40 | 237 | 122 | 185 | PKN46214.1 MAG: macrodomain protein [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20] | diamond | 198 | 75.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20 | ||||||
| 30303189 | 30303189 | PRJNA666695_S_NODE_58312_length_276_cov_3.489362_g57218_i0 | PRJNA666695 | 58312 | 276 | 3.489362 | 9.63063912 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 63.5 | 2.68e-9 | NR | WP_141197549.1 | 2292766 | g57218 | i0 | 40.4 | 1.95652173913043 | 89 | 44 | 96.7 | 1 | 275 | 9 | 872 | 951 | WP_141197549.1 IPT/TIG domain-containing protein [Persicimonas caeni] | diamond | 540 | 63.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 32780053 | 32780053 | PRJNA666695_S_NODE_160200_length_171_cov_1.061538_g159106_i0 | PRJNA666695 | 160200 | 171 | 1.061538 | 1.81522998 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 65.5 | 1.38e-10 | NR | WP_111331151.1 | 1548548 | g159106 | i0 | 54.5 | 13.7368421052632 | 44 | 20 | 77.2 | 0 | 1 | 132 | 641 | 684 | WP_111331151.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Bradymonas sediminis] | diamond | 2349 | 65.9 | 0.993930197268589 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis |
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);;