contig_metadata
23 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924488 | 924488 | PRJNA944406_P_NODE_39321_length_273_cov_1.530000_g38362_i0 | PRJNA944406 | 39321 | 273 | 1.53 | 4.1769 | Haloarcula litorea | 3032579 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|2463595526|gb|CP119779.1| | 3032579 | g38362 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 188 | 215 | 847737 | 847710 | Haloarcula litorea strain GDY20 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula litorea | |
| 1259421 | 1259421 | PRJNA944406_P_NODE_34121_length_278_cov_1.434146_g33162_i0 | PRJNA944406 | 34121 | 278 | 1.434146 | 3.98692588 | Halobacterium | 2239 | Archaea | Archaea | 95.3 | 4.19e-15 | NTclustered | gi|966204314|emb|LN831302.1| | 1407499 | g33162 | i0 | 93.651 | 6.51798561151079 | 63 | 4 | 23 | 0 | 190 | 252 | 896973 | 897035 | Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I | blastn | 1812 | 95.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium hubeiense | |
| 1259546 | 1259546 | PRJNA944406_P_NODE_76141_length_248_cov_1.577143_g75182_i0 | PRJNA944406 | 76141 | 248 | 1.577143 | 3.91131464 | Methanobrevibacter | 2172 | Archaea | Archaea | 416 | 6.9e-112 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g75182 | i0 | 97.177 | 138.237903225806 | 248 | 4 | 100 | 1 | 1 | 248 | 265311 | 265067 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 34283 | 416 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 6027612 | 6027612 | PRJNA944406_P_NODE_32545_length_279_cov_2.165049_g31586_i0 | PRJNA944406 | 32545 | 279 | 2.165049 | 6.04048671 | Halobacterium hubeiense | 1407499 | Archaea | Archaea | 52.8 | 0.026 | NTclustered | gi|966204314|emb|LN831302.1| | 1407499 | g31586 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 11 | 38 | 144533 | 144560 | Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium hubeiense | |
| 6027662 | 6027662 | PRJNA944406_P_NODE_37465_length_275_cov_1.306931_g36506_i0 | PRJNA944406 | 37465 | 275 | 1.306931 | 3.59406025 | Halalkalicoccus tibetensis | 175632 | Archaea | Archaea | 60.1 | 2.36e-8 | NR | WP_340603854.1 | 175632 | g36506 | i0 | 93.9 | 0.36 | 33 | 2 | 36 | 0 | 2 | 100 | 60 | 92 | WP_340603854.1 hypothetical protein [Halalkalicoccus tibetensis] | diamond | 99 | 60.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus tibetensis | |
| 12403862 | 12403862 | PRJNA944406_P_NODE_56810_length_257_cov_1.298913_g55851_i0 | PRJNA944406 | 56810 | 257 | 1.298913 | 3.33820641 | Halalkalicoccus sp. | 1973143 | Archaea | Archaea | 151 | 5.1e-42 | NR | MEM4782406.1 | 1973143 | g55851 | i0 | 90.6 | 0.992217898832685 | 85 | 8 | 99.2 | 0 | 257 | 3 | 26 | 110 | MEM4782406.1 GTP-binding protein [Halalkalicoccus sp.] | diamond | 255 | 151 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus sp. | |
| 18776921 | 18776921 | PRJNA944406_P_NODE_97875_length_243_cov_1.676471_g96916_i0 | PRJNA944406 | 97875 | 243 | 1.676471 | 4.0738245300000004 | Methanobacterium lacus | 877455 | Archaea | Archaea | 337 | 5.399999999999998e-88 | NTclustered | gi|325329191|gb|CP002551.1| | 877455 | g96916 | i0 | 94.118 | 5.46090534979424 | 221 | 13 | 91 | 0 | 1 | 221 | 580339 | 580559 | Methanobacterium lacus strain AL-21, complete genome | blastn | 1327 | 337 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium lacus | |
| 22601351 | 22601351 | PRJNA944406_P_NODE_19618_length_297_cov_2.607143_g18659_i0 | PRJNA944406 | 19618 | 297 | 2.607143 | 7.74321471 | Methanogenium organophilum | 2199 | Archaea | Archaea | 303 | 6.9000000000000015e-78 | NTclustered | gi|2388587735|gb|CP113361.1| | 2199 | g18659 | i0 | 92.093 | 0.723905723905724 | 215 | 17 | 72 | 0 | 3 | 217 | 2242403 | 2242189 | Methanogenium organophilum strain DSM 3596 chromosome, complete genome | blastn | 215 | 303 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium organophilum | |
| 22601640 | 22601640 | PRJNA944406_P_NODE_45478_length_267_cov_1.587629_g44519_i0 | PRJNA944406 | 45478 | 267 | 1.587629 | 4.23896943 | Haloferax mediterranei | 2252 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|640913992|gb|CP001868.2| | 523841 | g44519 | i0 | 96.774 | 0.337078651685393 | 31 | 1 | 12 | 0 | 94 | 124 | 2373736 | 2373766 | Haloferax mediterranei ATCC 33500, complete genome | blastn | 90 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax mediterranei | |
| 26740042 | 26740042 | PRJNA944406_P_NODE_99001_length_243_cov_0.905882_g98042_i0 | PRJNA944406 | 99001 | 243 | 0.905882 | 2.20129326 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 137 | 1.7399999999999999e-38 | NR | RPJ50273.1 | 2026739 | g98042 | i0 | 87.5 | 2.95061728395062 | 80 | 10 | 98.8 | 0 | 3 | 242 | 115 | 194 | RPJ50273.1 MAG: DUF2306 domain-containing protein [Methanobacteriota archaeon] | diamond | 717 | 137 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27316761 | 27316761 | PRJNA944406_P_NODE_89403_length_245_cov_1.389535_g88444_i0 | PRJNA944406 | 89403 | 245 | 1.389535 | 3.40436075 | Archaea | 2157 | Archaea | Archaea | 102 | 9.11e-24 | NR | MDI9642944.1 | 2250258 | g88444 | i0 | 61.3 | 6.85714285714286 | 80 | 31 | 98 | 0 | 2 | 241 | 140 | 219 | MDI9642944.1 bis-aminopropyl spermidine synthase family protein [Archaeoglobales archaeon] | diamond | 1680 | 102 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobales archaeon | ||||
| 27625762 | 27625762 | PRJNA944406_P_NODE_53024_length_260_cov_1.647059_g52065_i0 | PRJNA944406 | 53024 | 260 | 1.647059 | 4.2823534 | Candidatus Methanogaster sp. | 3386292 | Archaea | Archaea | 55.8 | 1.15e-6 | NR | KAF5417137.1 | 3386292 | g52065 | i0 | 57.7 | 1.65 | 52 | 21 | 60 | 1 | 157 | 2 | 7 | 57 | KAF5417137.1 MAG: hypothetical protein C5S48_01000 [Candidatus Methanogaster sp.] | diamond | 429 | 55.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanogasteraceae | Candidatus Methanogaster | Candidatus Methanogaster sp. | |
| 27853338 | 27853338 | PRJNA944406_P_NODE_53244_length_260_cov_1.631016_g52285_i0 | PRJNA944406 | 53244 | 260 | 1.631016 | 4.2406416 | Methanobacteriati | 3366610 | Archaea | Archaea | 99.4 | 2.28e-22 | NR | MAP58251.1 | 2026739 | g52285 | i0 | 57 | 2.97692307692308 | 86 | 37 | 99.2 | 0 | 2 | 259 | 145 | 230 | MAP58251.1 cobalamin biosynthesis protein CobW [Methanobacteriota archaeon] | diamond | 774 | 99.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28636251 | 28636251 | PRJNA944406_P_NODE_99987_length_243_cov_0.905882_g99028_i0 | PRJNA944406 | 99987 | 243 | 0.905882 | 2.20129326 | Methanogenium sp. | 2196 | Archaea | Archaea | 42.4 | 0.0184 | NR | MFA5395176.1 | 2196 | g99028 | i0 | 30.9 | 0.839506172839506 | 68 | 44 | 84 | 1 | 19 | 222 | 57 | 121 | MFA5395176.1 hypothetical protein [Methanogenium sp.] | diamond | 204 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 28762136 | 28762136 | PRJNA944406_P_NODE_101367_length_243_cov_0.905882_g100408_i0 | PRJNA944406 | 101367 | 243 | 0.905882 | 2.20129326 | Methanogenium organophilum | 2199 | Archaea | Archaea | 46.6 | 0.00168 | NR | WP_268186323.1 | 2199 | g100408 | i0 | 29.1 | 0.975308641975309 | 79 | 54 | 97.5 | 1 | 1 | 237 | 345 | 421 | WP_268186323.1 hypothetical protein [Methanogenium organophilum] | diamond | 237 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium organophilum | |
| 28983542 | 28983542 | PRJNA944406_P_NODE_74348_length_249_cov_0.875000_g73389_i0 | PRJNA944406 | 74348 | 249 | 0.875 | 2.17875 | Palaeococcus pacificus | 971279 | Archaea | Archaea | 62.8 | 3.34e-9 | NR | WP_048164987.1 | 971279 | g73389 | i0 | 35.8 | 5.81927710843374 | 81 | 52 | 97.6 | 0 | 247 | 5 | 323 | 403 | WP_048164987.1 NCS2 family permease [Palaeococcus pacificus] | diamond | 1449 | 62.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Palaeococcus | Palaeococcus pacificus | ||
| 29046511 | 29046511 | PRJNA944406_P_NODE_101688_length_242_cov_2.378698_g100729_i0 | PRJNA944406 | 101688 | 242 | 2.378698 | 5.75644916 | Methanobacterium sp. | 2164 | Archaea | Archaea | 124 | 4.589999999999999e-31 | NR | MBI5679795.1 | 2164 | g100729 | i0 | 77.5 | 1.98347107438017 | 80 | 18 | 99.2 | 0 | 1 | 240 | 249 | 328 | MBI5679795.1 GTP-binding protein [Methanobacterium sp.] | diamond | 480 | 124 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29109697 | 29109697 | PRJNA944406_P_NODE_26248_length_285_cov_2.250000_g25289_i0 | PRJNA944406 | 26248 | 285 | 2.25 | 6.4125 | Halococcus sediminicola | 1264579 | Archaea | Archaea | 125 | 1.7800000000000002e-33 | NR | WP_049999292.1 | 1264579 | g25289 | i0 | 68.1 | 0.957894736842105 | 91 | 28 | 94.7 | 1 | 3 | 272 | 126 | 216 | WP_049999292.1 helix-turn-helix domain-containing protein [Halococcus sediminicola] | diamond | 273 | 125 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sediminicola | |
| 29804136 | 29804136 | PRJNA944406_P_NODE_58231_length_255_cov_1.989011_g57272_i0 | PRJNA944406 | 58231 | 255 | 1.989011 | 5.07197805 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 42.7 | 0.0404 | NR | MBT3651793.1 | 2026739 | g57272 | i0 | 46 | 0.588235294117647 | 50 | 23 | 58.8 | 2 | 80 | 229 | 208 | 253 | MBT3651793.1 ABC transporter ATP-binding protein [Methanobacteriota archaeon] | diamond | 150 | 42.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30278433 | 30278433 | PRJNA944406_P_NODE_113252_length_226_cov_2.013072_g112293_i0 | PRJNA944406 | 113252 | 226 | 2.013072 | 4.54954272 | Methanogenium sp. S4BF | 1789226 | Archaea | Archaea | 42.4 | 0.0412 | NR | WP_278154310.1 | 1789226 | g112293 | i0 | 39.3 | 0.809734513274336 | 61 | 34 | 79.6 | 2 | 38 | 217 | 448 | 506 | WP_278154310.1 serine/threonine-protein kinase [Methanogenium sp. S4BF] | diamond | 183 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. S4BF | |
| 31289140 | 31289140 | PRJNA944406_P_NODE_82435_length_247_cov_0.885057_g81476_i0 | PRJNA944406 | 82435 | 247 | 0.885057 | 2.18609079 | Haladaptatus halobius | 2884875 | Archaea | Archaea | 64.7 | 3.6e-11 | NR | WP_227375586.1 | 2884875 | g81476 | i0 | 50 | 0.728744939271255 | 60 | 30 | 72.9 | 0 | 67 | 246 | 47 | 106 | WP_227375586.1 KTSC domain-containing protein [Haladaptatus halobius] | diamond | 180 | 64.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus halobius | |
| 31479251 | 31479251 | PRJNA944406_P_NODE_86156_length_246_cov_0.890173_g85197_i0 | PRJNA944406 | 86156 | 246 | 0.890173 | 2.18982558 | Halosimplex rubrum | 869889 | Archaea | Archaea | 42.7 | 0.0355 | NR | WP_179908788.1 | 869889 | g85197 | i0 | 36.4 | 0.804878048780488 | 66 | 38 | 75.6 | 1 | 211 | 26 | 93 | 158 | WP_179908788.1 polysaccharide deacetylase family protein [Halosimplex rubrum] | diamond | 198 | 42.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex rubrum | |
| 32396621 | 32396621 | PRJNA944406_P_NODE_85839_length_246_cov_0.890173_g84880_i0 | PRJNA944406 | 85839 | 246 | 0.890173 | 2.18982558 | Halococcus sp. | 29286 | Archaea | Archaea | 70.5 | 3.23e-14 | NR | HET7325487.1 | 29286 | g84880 | i0 | 81.8 | 0.536585365853659 | 44 | 8 | 53.7 | 0 | 175 | 44 | 1 | 44 | HET7325487.1 hypothetical protein [Halococcus sp.] | diamond | 132 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. |
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);;