contig_metadata
9 rows where 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. | |
| 8474047 | 8474047 | PRJNA827593_P_NODE_36987_length_335_cov_3.675573_g36688_i0 | PRJNA827593 | 36987 | 335 | 3.675573 | 12.31316955 | Methanosarcina acetivorans | 2214 | Archaea | Archaea | 52.8 | 0.032 | NTclustered | gi|19918815|gb|AE010299.1| | 188937 | g36688 | i0 | 100 | 0.0835820895522388 | 28 | 0 | 8 | 0 | 230 | 257 | 2077152 | 2077179 | Methanosarcina acetivorans str. C2A, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina acetivorans | |
| 12300181 | 12300181 | PRJNA827593_P_NODE_24950_length_420_cov_1.902017_g24651_i0 | PRJNA827593 | 24950 | 420 | 1.902017 | 7.9884714 | Natrarchaeobaculum aegyptiacum | 745377 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|1196598842|gb|CP019893.1| | 745377 | g24651 | i0 | 100 | 0.0714285714285714 | 30 | 0 | 7 | 0 | 44 | 73 | 2973647 | 2973618 | Natrarchaeobaculum aegyptiacum strain JW/NM-HA 15 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrarchaeobaculum | Natrarchaeobaculum aegyptiacum | |
| 25047873 | 25047873 | PRJNA827593_P_NODE_58460_length_258_cov_1.659459_g58161_i0 | PRJNA827593 | 58460 | 258 | 1.659459 | 4.28140422 | Haloferax mediterranei | 2252 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|640913992|gb|CP001868.2| | 523841 | g58161 | i0 | 100 | 0.325581395348837 | 28 | 0 | 11 | 0 | 18 | 45 | 2426173 | 2426146 | Haloferax mediterranei ATCC 33500, complete genome | blastn | 84 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax mediterranei | |
| 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);;