contig_metadata
23 rows where bioproject = "PRJNA1204310" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8697899 | 8697899 | PRJNA1204310_P_NODE_21907_length_389_cov_0.987342_g21610_i0 | PRJNA1204310 | 21907 | 389 | 0.987342 | 3.84076038 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 98.2 | 1.37e-22 | NR | UCF08245.1 | 1906666 | g21610 | i0 | 43.2 | 0.96401028277635 | 125 | 70 | 95.6 | 1 | 6 | 377 | 45 | 169 | UCF08245.1 MAG: ribonuclease Z, partial [Thermoplasmata archaeon] | diamond | 375 | 98.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26819610 | 26819610 | PRJNA1204310_P_NODE_28401_length_348_cov_1.134545_g28104_i0 | PRJNA1204310 | 28401 | 348 | 1.134545 | 3.9482166 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 159 | 4.2e-45 | NR | MBJ62011.1 | 2026739 | g28104 | i0 | 62.6 | 0.991379310344828 | 115 | 42 | 98.3 | 1 | 5 | 346 | 215 | 329 | MBJ62011.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 345 | 159 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 26945963 | 26945963 | PRJNA1204310_P_NODE_58542_length_246_cov_0.901734_g58245_i0 | PRJNA1204310 | 58542 | 246 | 0.901734 | 2.21826564 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 49.3 | 1.66e-4 | NR | MDE0953844.1 | 2163009 | g58245 | i0 | 48 | 0.609756097560976 | 50 | 26 | 61 | 0 | 235 | 86 | 60 | 109 | MDE0953844.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 150 | 49.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 27325481 | 27325481 | PRJNA1204310_P_NODE_18163_length_421_cov_1.344828_g17866_i0 | PRJNA1204310 | 18163 | 421 | 1.344828 | 5.66172588 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 73.6 | 4.49e-12 | NR | MEC7483603.1 | 2806419 | g17866 | i0 | 40.4 | 1.62470308788599 | 114 | 55 | 80.5 | 4 | 419 | 81 | 66 | 167 | MEC7483603.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 684 | 73.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 27514980 | 27514980 | PRJNA1204310_P_NODE_46323_length_270_cov_1.583756_g46026_i0 | PRJNA1204310 | 46323 | 270 | 1.583756 | 4.2761412 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 46.6 | 0.00223 | NR | WP_054835095.1 | 39441 | g46026 | i0 | 47.8 | 2.23333333333333 | 67 | 33 | 72.2 | 1 | 265 | 71 | 42 | 108 | WP_054835095.1 Ig-like domain-containing protein [Methanobrevibacter arboriphilus] | diamond | 603 | 46.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 27786591 | 27786591 | PRJNA1204310_P_NODE_20324_length_401_cov_1.536585_g20027_i0 | PRJNA1204310 | 20324 | 401 | 1.536585 | 6.16170585 | root | 1 | Root_unresolved | Root_unresolved | 73.2 | 3.83e-12 | NR | WP_214021670.1 | 90427 | g20027 | i0 | 54.5 | 3.99501246882793 | 66 | 27 | 49.4 | 1 | 328 | 131 | 4 | 66 | WP_214021670.1 molecular chaperone DnaJ [Methanoculleus sp.] | diamond | 1602 | 73.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 27799351 | 27799351 | PRJNA1204310_P_NODE_57264_length_247_cov_0.896552_g56967_i0 | PRJNA1204310 | 57264 | 247 | 0.896552 | 2.21448344 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 93.6 | 4.7e-20 | NR | RYE85578.1 | 2250255 | g56967 | i0 | 49.4 | 1.05668016194332 | 87 | 39 | 99.6 | 1 | 2 | 247 | 432 | 518 | RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] | diamond | 261 | 93.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28177785 | 28177785 | PRJNA1204310_P_NODE_46866_length_268_cov_1.600000_g46569_i0 | PRJNA1204310 | 46866 | 268 | 1.6 | 4.288 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 66.6 | 2.02e-10 | NR | MEC7483603.1 | 2806419 | g46569 | i0 | 42 | 9.88432835820896 | 88 | 42 | 97.4 | 3 | 5 | 265 | 68 | 147 | MEC7483603.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 2649 | 66.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28209419 | 28209419 | PRJNA1204310_P_NODE_18706_length_416_cov_1.160350_g18409_i0 | PRJNA1204310 | 18706 | 416 | 1.16035 | 4.827056 | Methanothrix sp. | 90426 | Archaea | Archaea | 62 | 4.51e-8 | NR | TFH52534.1 | 90426 | g18409 | i0 | 58.8 | 0.663461538461538 | 51 | 18 | 34.6 | 1 | 94 | 237 | 590 | 640 | TFH52534.1 MAG: hypothetical protein E4G89_01470 [Methanothrix sp.] | diamond | 276 | 62 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28620251 | 28620251 | PRJNA1204310_P_NODE_62167_length_242_cov_0.923077_g61870_i0 | PRJNA1204310 | 62167 | 242 | 0.923077 | 2.23384634 | Halorhabdus sp. | 1961697 | Archaea | Archaea | 45.1 | 0.00559 | NR | MFB6202023.1 | 1961697 | g61870 | i0 | 33.8 | 0.991735537190083 | 80 | 37 | 79.3 | 3 | 195 | 4 | 177 | 256 | MFB6202023.1 hypothetical protein [Halorhabdus sp.] | diamond | 240 | 45.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorhabdus | Halorhabdus sp. | |
| 28746380 | 28746380 | PRJNA1204310_P_NODE_62567_length_242_cov_0.923077_g62270_i0 | PRJNA1204310 | 62567 | 242 | 0.923077 | 2.23384634 | Halosimplex pelagicum | 869886 | Archaea | Archaea | 42.4 | 0.0338 | NR | WP_179918470.1 | 869886 | g62270 | i0 | 41.5 | 0.65702479338843 | 53 | 28 | 62 | 2 | 51 | 200 | 110 | 162 | WP_179918470.1 hypothetical protein [Halosimplex pelagicum] | diamond | 159 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex pelagicum | |
| 28840974 | 28840974 | PRJNA1204310_P_NODE_43088_length_282_cov_1.866029_g42791_i0 | PRJNA1204310 | 43088 | 282 | 1.866029 | 5.26220178 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 56.6 | 7.46e-7 | NR | MBJ35148.1 | 2026739 | g42791 | i0 | 49.2 | 0.648936170212766 | 61 | 30 | 63.8 | 1 | 102 | 281 | 323 | 383 | MBJ35148.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 183 | 56.6 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29125543 | 29125543 | PRJNA1204310_P_NODE_55569_length_249_cov_0.886364_g55272_i0 | PRJNA1204310 | 55569 | 249 | 0.886364 | 2.20704636 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 96.3 | 5.96e-21 | NR | MAO69667.1 | 2026739 | g55272 | i0 | 56.1 | 0.987951807228916 | 82 | 32 | 94 | 1 | 14 | 247 | 1131 | 1212 | MAO69667.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 246 | 96.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30546534 | 30546534 | PRJNA1204310_P_NODE_16693_length_438_cov_0.975342_g16396_i0 | PRJNA1204310 | 16693 | 438 | 0.975342 | 4.27199796 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 213 | 2.45e-68 | NR | HJM77902.1 | 2670411 | g16396 | i0 | 80.5 | 3.53424657534247 | 128 | 25 | 87.7 | 0 | 391 | 8 | 5 | 132 | HJM77902.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Candidatus Thalassarchaeaceae archaeon] | diamond | 1548 | 213 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 30925925 | 30925925 | PRJNA1204310_P_NODE_50214_length_254_cov_5.464088_g49917_i0 | PRJNA1204310 | 50214 | 254 | 5.464088 | 13.87878352 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 51.2 | 5.71e-6 | NR | MCD4843809.1 | 2250255 | g49917 | i0 | 48.4 | 0.755905511811024 | 64 | 33 | 75.6 | 0 | 60 | 251 | 6 | 69 | MCD4843809.1 50S ribosomal protein P1 [Methanosarcinales archaeon] | diamond | 192 | 51.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 31052317 | 31052317 | PRJNA1204310_P_NODE_26695_length_357_cov_1.834507_g26398_i0 | PRJNA1204310 | 26695 | 357 | 1.834507 | 6.54918999 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 124 | 2.59e-30 | NR | GIQ99072.1 | 2026739 | g26398 | i0 | 52.6 | 0.974789915966387 | 116 | 54 | 96.6 | 1 | 2 | 346 | 35 | 150 | GIQ99072.1 MAG: hypothetical protein CM15mP6_0890 [Methanobacteriota archaeon] | diamond | 348 | 124 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31178183 | 31178183 | PRJNA1204310_P_NODE_48555_length_261_cov_1.659574_g48258_i0 | PRJNA1204310 | 48555 | 261 | 1.659574 | 4.33148814 | methanogenic archaeon mixed culture ISO4-G1 | 1452364 | Archaea | Archaea | 57 | 2.11e-7 | NR | AMK14294.1 | 1452364 | g48258 | i0 | 37 | 0.839080459770115 | 73 | 46 | 83.9 | 0 | 232 | 14 | 127 | 199 | AMK14294.1 metallophosphoesterase [methanogenic archaeon mixed culture ISO4-G1] | diamond | 219 | 57 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | methanogenic archaeon mixed culture ISO4-G1 | |||
| 31209563 | 31209563 | PRJNA1204310_P_NODE_46495_length_270_cov_1.187817_g46198_i0 | PRJNA1204310 | 46495 | 270 | 1.187817 | 3.2071059 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 49.3 | 2.63e-4 | NR | MBU38166.1 | 2026739 | g46198 | i0 | 34.5 | 0.933333333333333 | 84 | 52 | 92.2 | 3 | 21 | 269 | 1965 | 2046 | MBU38166.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 252 | 49.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31842461 | 31842461 | PRJNA1204310_P_NODE_41657_length_287_cov_1.457944_g41360_i0 | PRJNA1204310 | 41657 | 287 | 1.457944 | 4.18429928 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 44.7 | 0.00817 | NR | HJN55235.1 | 2163009 | g41360 | i0 | 32.9 | 0.794425087108014 | 76 | 50 | 79.4 | 1 | 228 | 1 | 33 | 107 | HJN55235.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 228 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 32254310 | 32254310 | PRJNA1204310_P_NODE_54578_length_250_cov_0.881356_g54281_i0 | PRJNA1204310 | 54578 | 250 | 0.881356 | 2.20339 | uncultured marine group II/III euryarchaeote SAT1 | 1456558 | Archaea | Archaea | 57 | 4.03e-7 | NR | AIF23262.1 | 1456558 | g54281 | i0 | 39.1 | 2.832 | 87 | 47 | 97.2 | 3 | 243 | 1 | 1936 | 2022 | AIF23262.1 RCC1 domain-containing protein [uncultured marine group II/III euryarchaeote SAT1000_14_B08] | diamond | 708 | 57 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote SAT1000_14_B08 | ||||||
| 32412295 | 32412295 | PRJNA1204310_P_NODE_53019_length_251_cov_0.876404_g52722_i0 | PRJNA1204310 | 53019 | 251 | 0.876404 | 2.19977404 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 42.7 | 0.0408 | NR | RCH71065.1 | 2163009 | g52722 | i0 | 35.5 | 0.908366533864542 | 76 | 49 | 90.8 | 0 | 8 | 235 | 156 | 231 | RCH71065.1 MAG: hypothetical protein DBX06_07595 [Candidatus Poseidoniales archaeon] | diamond | 228 | 42.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 32601886 | 32601886 | PRJNA1204310_P_NODE_60300_length_244_cov_0.912281_g60003_i0 | PRJNA1204310 | 60300 | 244 | 0.912281 | 2.22596564 | Methanocella paludicola | 570267 | Archaea | Archaea | 78.2 | 9.09e-15 | NR | WP_012901309.1 | 570267 | g60003 | i0 | 49.4 | 0.971311475409836 | 79 | 35 | 97.1 | 2 | 244 | 8 | 181 | 254 | WP_012901309.1 PQQ-dependent sugar dehydrogenase [Methanocella paludicola] | diamond | 237 | 78.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 32683454 | 32683454 | PRJNA1204310_P_NODE_28980_length_345_cov_1.147059_g28683_i0 | PRJNA1204310 | 28980 | 345 | 1.147059 | 3.95735355 | root | 1 | Root_unresolved | Root_unresolved | 152 | 1.45e-40 | NR | WP_245249312.1 | 547055 | g28683 | i0 | 62.8 | 12.7826086956522 | 113 | 42 | 98.3 | 0 | 2 | 340 | 466 | 578 | WP_245249312.1 propionyl-CoA synthetase [Methanolinea mesophila] | diamond | 4410 | 153 | 0.993464052287582 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanolinea | Methanolinea mesophila |
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);;