contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax_clade = "Stenosarchaea 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2096501 | 2096501 | PRJNA827593_P_NODE_25422_length_416_cov_1.244898_g25123_i0 | PRJNA827593 | 25422 | 416 | 1.244898 | 5.17877568 | root | 1 | Root_unresolved | Root_unresolved | 192 | 9.59e-54 | NR | WP_324474872.1 | 45200 | g25123 | i0 | 65.2 | 12.9447115384615 | 138 | 47 | 99.5 | 1 | 3 | 416 | 558 | 694 | WP_324474872.1 type I restriction endonuclease subunit R [Methanospirillum sp.] | diamond | 5385 | 192 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 26619931 | 26619931 | PRJNA827593_P_NODE_17401_length_514_cov_3.716553_g17103_i0 | PRJNA827593 | 17401 | 514 | 3.716553 | 19.10308242 | root | 1 | Root_unresolved | Root_unresolved | 108 | 5.2699999999999994e-24 | NR | MDD4580503.1 | 90426 | g17103 | i0 | 54.2 | 1.86186770428016 | 107 | 48 | 61.9 | 1 | 414 | 97 | 1 | 107 | MDD4580503.1 glycosyltransferase [Methanothrix sp.] | diamond | 957 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 27497004 | 27497004 | PRJNA827593_P_NODE_52583_length_274_cov_2.452736_g52284_i0 | PRJNA827593 | 52583 | 274 | 2.452736 | 6.72049664 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 77 | 1.52e-15 | NR | MCZ7382623.1 | 2032688 | g52284 | i0 | 46.3 | 1.65328467153285 | 80 | 42 | 87.6 | 1 | 16 | 255 | 3 | 81 | MCZ7382623.1 50S ribosomal protein L11 [Candidatus Methanoperedens sp.] | diamond | 453 | 77 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 28349372 | 28349372 | PRJNA827593_P_NODE_42386_length_311_cov_1.294118_g42087_i0 | PRJNA827593 | 42386 | 311 | 1.294118 | 4.02470698 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 99 | 4.76e-22 | NR | RYE85335.1 | 2250255 | g42087 | i0 | 56 | 0.877813504823151 | 91 | 33 | 87.8 | 1 | 23 | 295 | 73 | 156 | RYE85335.1 MAG: hypothetical protein EOO65_00610 [Methanosarcinales archaeon] | diamond | 273 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28665260 | 28665260 | PRJNA827593_P_NODE_46667_length_294_cov_2.565611_g46368_i0 | PRJNA827593 | 46667 | 294 | 2.565611 | 7.54289634 | Candidatus Argoarchaeum ethanivorans | 2608793 | Archaea | Archaea | 86.7 | 2.14e-17 | NR | RZB31008.1 | 2608793 | g46368 | i0 | 45.2 | 1.71428571428571 | 84 | 45 | 85.7 | 1 | 292 | 41 | 296 | 378 | RZB31008.1 MAG: hypothetical protein AEth_00962 [Candidatus Argoarchaeum ethanivorans] | diamond | 504 | 86.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Argoarchaeum | Candidatus Argoarchaeum ethanivorans | ||
| 32781150 | 32781150 | PRJNA827593_P_NODE_31140_length_370_cov_1.814815_g30841_i0 | PRJNA827593 | 31140 | 370 | 1.814815 | 6.7148155 | Halococcus | 2249 | Archaea | Archaea | 54.7 | 9.61e-6 | NR | RBI58627.1 | 29295 | g30841 | i0 | 41.8 | 1.36216216216216 | 79 | 42 | 60.8 | 2 | 225 | 1 | 175 | 253 | RBI58627.1 hypothetical protein DMJ13_26235 [halophilic archaeon] | diamond | 504 | 55.1 | 0.992740471869329 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon |
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);;