contig_metadata
12 rows where bioproject = "PRJNA1262902" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 363475 | 363475 | PRJNA1262902_P_NODE_10921_length_244_cov_0.900585_g10879_i0 | PRJNA1262902 | 10921 | 244 | 0.900585 | 2.1974274 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 451 | 1.86e-122 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g10879 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 3681733 | 3681976 | Natronobacterium gregoryi SP2, complete genome | blastn | 244 | 451 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 1638350 | 1638350 | PRJNA1262902_P_NODE_5002_length_279_cov_1.169903_g4960_i0 | PRJNA1262902 | 5002 | 279 | 1.169903 | 3.26402937 | Methanothermococcus okinawensis | 155863 | Archaea | Archaea | 52.8 | 0.026 | NTclustered | gi|334855522|gb|CP002792.1| | 647113 | g4960 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 247 | 274 | 719913 | 719886 | Methanothermococcus okinawensis IH1, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanothermococcus | Methanothermococcus okinawensis | |
| 2914222 | 2914222 | PRJNA1262902_P_NODE_11963_length_242_cov_0.911243_g11921_i0 | PRJNA1262902 | 11963 | 242 | 0.911243 | 2.20520806 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g11921 | i0 | 100 | 17.6239669421488 | 242 | 0 | 100 | 0 | 1 | 242 | 1353613 | 1353854 | Natronobacterium gregoryi SP2, complete genome | blastn | 4265 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 8016885 | 8016885 | PRJNA1262902_P_NODE_11427_length_243_cov_0.905882_g11385_i0 | PRJNA1262902 | 11427 | 243 | 0.905882 | 2.20129326 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 449 | 6.65e-122 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g11385 | i0 | 100 | 2.98353909465021 | 243 | 0 | 100 | 0 | 1 | 243 | 1891124 | 1891366 | Natronobacterium gregoryi SP2, complete genome | blastn | 725 | 449 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 9291721 | 9291721 | PRJNA1262902_P_NODE_8808_length_248_cov_0.880000_g8766_i0 | PRJNA1262902 | 8808 | 248 | 0.88 | 2.1824 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 459 | 1.13e-124 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g8766 | i0 | 100 | 10.8709677419355 | 248 | 0 | 100 | 0 | 1 | 248 | 1491891 | 1491644 | Natronobacterium gregoryi SP2, complete genome | blastn | 2696 | 459 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 14392750 | 14392750 | PRJNA1262902_P_NODE_8992_length_248_cov_0.880000_g8950_i0 | PRJNA1262902 | 8992 | 248 | 0.88 | 2.1824 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 453 | 5.2600000000000005e-123 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g8950 | i0 | 99.597 | 10.3870967741935 | 248 | 1 | 100 | 0 | 1 | 248 | 1692903 | 1692656 | Natronobacterium gregoryi SP2, complete genome | blastn | 2576 | 453 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 18215250 | 18215250 | PRJNA1262902_P_NODE_11915_length_242_cov_0.911243_g11873_i0 | PRJNA1262902 | 11915 | 242 | 0.911243 | 2.20520806 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g11873 | i0 | 100 | 2.10330578512397 | 242 | 0 | 100 | 0 | 1 | 242 | 1830039 | 1830280 | Natronobacterium gregoryi SP2, complete genome | blastn | 509 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 22040209 | 22040209 | PRJNA1262902_P_NODE_4278_length_289_cov_1.425926_g4236_i0 | PRJNA1262902 | 4278 | 289 | 1.425926 | 4.12092614 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 534 | 2.18e-147 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g4236 | i0 | 100 | 2.43944636678201 | 289 | 0 | 100 | 0 | 1 | 289 | 3400925 | 3401213 | Natronobacterium gregoryi SP2, complete genome | blastn | 705 | 534 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 27831947 | 27831947 | PRJNA1262902_P_NODE_12164_length_241_cov_0.916667_g12122_i0 | PRJNA1262902 | 12164 | 241 | 0.916667 | 2.20916747 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 70.9 | 4.5e-12 | NR | HEY1248456.1 | 1971748 | g12122 | i0 | 43.8 | 0.995850622406639 | 80 | 43 | 97.1 | 1 | 241 | 8 | 383 | 462 | HEY1248456.1 hypothetical protein [Nitrososphaera sp.] | diamond | 240 | 70.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30327163 | 30327163 | PRJNA1262902_P_NODE_11272_length_243_cov_0.905882_g11230_i0 | PRJNA1262902 | 11272 | 243 | 0.905882 | 2.20129326 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 76.3 | 2.07e-15 | NR | MEJ7642329.1 | 2109671 | g11230 | i0 | 75 | 0.592592592592593 | 48 | 11 | 58 | 1 | 240 | 100 | 94 | 141 | MEJ7642329.1 hypothetical protein [Candidatus Nitrosocosmicus sp.] | diamond | 144 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 30800462 | 30800462 | PRJNA1262902_P_NODE_10014_length_245_cov_1.738372_g9972_i0 | PRJNA1262902 | 10014 | 245 | 1.738372 | 4.2590114 | Candidatus Heimdallarchaeota archaeon LC_3 | 1841598 | Archaea | Archaea | 67 | 7.5e-11 | NR | OLS21962.1 | 1841598 | g9972 | i0 | 65.9 | 2.35102040816327 | 44 | 15 | 53.9 | 0 | 208 | 77 | 265 | 308 | OLS21962.1 MAG: Ornithine carbamoyltransferase [Candidatus Heimdallarchaeota archaeon LC_3] | diamond | 576 | 67 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon LC_3 | ||||||
| 32540240 | 32540240 | PRJNA1262902_P_NODE_2339_length_339_cov_1.157895_g2297_i0 | PRJNA1262902 | 2339 | 339 | 1.157895 | 3.92526405 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 44.3 | 0.0171 | NR | RLI93475.1 | 2250256 | g2297 | i0 | 34.8 | 0.814159292035398 | 92 | 47 | 69.9 | 4 | 57 | 293 | 82 | 173 | RLI93475.1 MAG: hypothetical protein DRO94_05110, partial [Candidatus Altiarchaeales archaeon] | diamond | 276 | 44.3 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales 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);;