contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27225889 | 27225889 | PRJNA1115053_S_NODE_341103_length_152_cov_1.403670_g339286_i0 | PRJNA1115053 | 341103 | 152 | 1.40367 | 2.1335784 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 101 | 2.6e-23 | NR | NYB25877.1 | 2099680 | g339286 | i0 | 100 | 1.97368421052632 | 50 | 0 | 98.7 | 0 | 2 | 151 | 112 | 161 | NYB25877.1 SMC family ATPase [Methanobacteriaceae archaeon] | diamond | 300 | 101 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 27731694 | 27731694 | PRJNA1115053_S_NODE_175664_length_205_cov_1.623457_g173847_i0 | PRJNA1115053 | 175664 | 205 | 1.623457 | 3.32808685 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 131 | 4.01e-36 | NR | WP_288267474.1 | 253161 | g173847 | i0 | 92.5 | 0.980487804878049 | 67 | 5 | 98 | 0 | 203 | 3 | 170 | 236 | WP_288267474.1 DUF169 domain-containing protein, partial [uncultured Methanobrevibacter sp.] | diamond | 201 | 131 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 28868076 | 28868076 | PRJNA1115053_S_NODE_77568_length_286_cov_2.172840_g75751_i0 | PRJNA1115053 | 77568 | 286 | 2.17284 | 6.2143224 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 60.5 | 3.56e-8 | NR | WP_330008794.1 | 66852 | g75751 | i0 | 100 | 0.713286713286713 | 34 | 0 | 35.7 | 0 | 3 | 104 | 725 | 758 | WP_330008794.1 ABC transporter permease [Methanobrevibacter sp.] | diamond | 204 | 60.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29089148 | 29089148 | PRJNA1115053_S_NODE_118868_length_242_cov_0.964824_g117051_i0 | PRJNA1115053 | 118868 | 242 | 0.964824 | 2.33487408 | Methanothrix sp. | 90426 | Archaea | Archaea | 47.4 | 7.19e-4 | NR | MCK9566210.1 | 90426 | g117051 | i0 | 45.9 | 0.45867768595041303 | 37 | 20 | 45.9 | 0 | 50 | 160 | 20 | 56 | MCK9566210.1 hypothetical protein [Methanothrix sp.] | diamond | 111 | 47.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 29751891 | 29751891 | PRJNA1115053_S_NODE_350231_length_151_cov_1.333333_g348414_i0 | PRJNA1115053 | 350231 | 151 | 1.333333 | 2.01333283 | Halorubrum vacuolatum | 63740 | Archaea | Archaea | 41.6 | 0.028 | NR | WP_143420458.1 | 63740 | g348414 | i0 | 58.6 | 0.576158940397351 | 29 | 12 | 57.6 | 0 | 121 | 35 | 1372 | 1400 | WP_143420458.1 hypothetical protein [Halorubrum vacuolatum] | diamond | 87 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum vacuolatum | |
| 29910196 | 29910196 | PRJNA1115053_S_NODE_159511_length_214_cov_1.122807_g157694_i0 | PRJNA1115053 | 159511 | 214 | 1.1228070000000001 | 2.40280698 | Methanolinea mesophila | 547055 | Archaea | Archaea | 42 | 0.0477 | NR | WP_209673321.1 | 547055 | g157694 | i0 | 42.6 | 1.23364485981308 | 54 | 28 | 75.7 | 1 | 37 | 198 | 277 | 327 | WP_209673321.1 aldo/keto reductase [Methanolinea mesophila] | diamond | 264 | 42 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanolinea | Methanolinea mesophila | |
| 31458647 | 31458647 | PRJNA1115053_S_NODE_90056_length_270_cov_2.145374_g88239_i0 | PRJNA1115053 | 90056 | 270 | 2.145374 | 5.7925098 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 43.5 | 0.0251 | NR | WP_060537930.1 | 2162 | g88239 | i0 | 35.3 | 0.566666666666667 | 51 | 33 | 56.7 | 0 | 116 | 268 | 74 | 124 | WP_060537930.1 glycosyltransferase family 2 protein [Methanobacterium formicicum] | diamond | 153 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 32745865 | 32745865 | PRJNA1115053_S_NODE_343820_length_152_cov_0.880734_g342003_i0 | PRJNA1115053 | 343820 | 152 | 0.880734 | 1.33871568 | Methanobacteriati | 3366610 | Archaea | Archaea | 42.4 | 0.0146 | NR | MDB3871565.1 | 2026739 | g342003 | i0 | 45.8 | 4.69736842105263 | 48 | 21 | 94.7 | 1 | 151 | 8 | 102 | 144 | MDB3871565.1 phosphonate ABC transporter, permease protein PhnE [Methanobacteriota archaeon] | diamond | 714 | 42.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32754704 | 32754704 | PRJNA1115053_S_NODE_79920_length_283_cov_1.600000_g78103_i0 | PRJNA1115053 | 79920 | 283 | 1.6 | 4.528 | Halorarum halophilum | 2743090 | Archaea | Archaea | 45.4 | 0.00655 | NR | WP_179170698.1 | 2743090 | g78103 | i0 | 38.6 | 0.879858657243816 | 83 | 46 | 85.9 | 3 | 243 | 1 | 229 | 308 | WP_179170698.1 sensor histidine kinase [Halorarum halophilum] | diamond | 249 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorarum | Halorarum halophilum |
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);;