contig_metadata
15 rows where bioproject = "PRJNA390533" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 409851 | 409851 | PRJNA390533_P_NODE_4621_length_891_cov_5.515258_g4017_i0 | PRJNA390533 | 4621 | 891 | 5.515258 | 49.14094878 | Halovalidus salilacus | 3075124 | Archaea | Archaea | 54.7 | 0.025 | NTclustered | gi|2581323319|gb|CP134700.1| | 3075124 | g4017 | i0 | 100 | 0.0325476992143659 | 29 | 0 | 3 | 0 | 385 | 413 | 3648312 | 3648340 | Halovalidus salilacus strain CCL63 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovalidus | Halovalidus salilacus | |
| 10613469 | 10613469 | PRJNA390533_P_NODE_26109_length_306_cov_2.101124_g25082_i0 | PRJNA390533 | 26109 | 306 | 2.101124 | 6.42943944 | Halomicrobium sp. HM KBTZ05 | 3242663 | Archaea | Archaea | 84.2 | 1.01e-11 | NTclustered | gi|2794134197|gb|CP168057.1| | 3242663 | g25082 | i0 | 85.185 | 4.46078431372549 | 81 | 12 | 26 | 0 | 1 | 81 | 792059 | 791979 | Halomicrobium sp. HM KBTZ05 chromosome, complete genome | blastn | 1365 | 84.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halomicrobium | Halomicrobium sp. HM KBTZ05 | |
| 14438655 | 14438655 | PRJNA390533_P_NODE_39612_length_182_cov_1.972028_g38585_i0 | PRJNA390533 | 39612 | 182 | 1.972028 | 3.58909096 | halophilic archaeon DL31 | 756883 | Archaea | Archaea | 71.3 | 4.27e-8 | NTclustered | gi|344319636|gb|CP002988.1| | 756883 | g38585 | i0 | 97.561 | 0.725274725274725 | 41 | 1 | 23 | 0 | 54 | 94 | 596487 | 596527 | Halophilic archaeon DL31 chromosome, complete genome | blastn | 132 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon DL31 | |||
| 27075242 | 27075242 | PRJNA390533_P_NODE_34902_length_209_cov_1.588235_g33875_i0 | PRJNA390533 | 34902 | 209 | 1.588235 | 3.31941115 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 52.4 | 9.54e-6 | NR | MFQ6060303.1 | 1906666 | g33875 | i0 | 46 | 0.717703349282297 | 50 | 27 | 71.8 | 0 | 7 | 156 | 276 | 325 | MFQ6060303.1 ATPase domain-containing protein [Thermoplasmata archaeon] | diamond | 150 | 52.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27454677 | 27454677 | PRJNA390533_P_NODE_13923_length_507_cov_1.297009_g12944_i0 | PRJNA390533 | 13923 | 507 | 1.297009 | 6.57583563 | Halobacteriales archaeon QS_8_69_26 | 1919187 | Archaea | Archaea | 70.9 | 3.46e-11 | NR | PSQ19632.1 | 1919187 | g12944 | i0 | 57.7 | 1.06508875739645 | 52 | 22 | 30.8 | 0 | 391 | 236 | 185 | 236 | PSQ19632.1 MAG: cyclase [Halobacteriales archaeon QS_8_69_26] | diamond | 540 | 70.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QS_8_69_26 | |||
| 29285649 | 29285649 | PRJNA390533_P_NODE_38489_length_188_cov_0.946309_g37462_i0 | PRJNA390533 | 38489 | 188 | 0.946309 | 1.77906092 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 54.7 | 1.09e-6 | NR | TLZ60410.1 | 2026739 | g37462 | i0 | 50 | 0.957446808510638 | 60 | 27 | 95.7 | 1 | 181 | 2 | 292 | 348 | TLZ60410.1 MAG: hypothetical protein E6K13_08345 [Methanobacteriota archaeon] | diamond | 180 | 54.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29727528 | 29727528 | PRJNA390533_P_NODE_25530_length_315_cov_1.630435_g24503_i0 | PRJNA390533 | 25530 | 315 | 1.630435 | 5.13587025 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 45.8 | 0.00117 | NR | MEA3323612.1 | 2026739 | g24503 | i0 | 30.6 | 0.80952380952381 | 85 | 58 | 80 | 1 | 1 | 252 | 8 | 92 | MEA3323612.1 tetratricopeptide repeat protein [Methanobacteriota archaeon] | diamond | 255 | 45.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30075136 | 30075136 | PRJNA390533_P_NODE_36432_length_199_cov_1.243750_g35405_i0 | PRJNA390533 | 36432 | 199 | 1.24375 | 2.4750625 | Methanococcoides sp. NM1 | 1201013 | Archaea | Archaea | 53.1 | 4.33e-6 | NR | WP_135605603.1 | 1201013 | g35405 | i0 | 41 | 0.919597989949749 | 61 | 36 | 92 | 0 | 188 | 6 | 302 | 362 | WP_135605603.1 BREX-1 system phosphatase PglZ type A [Methanococcoides sp. NM1] | diamond | 183 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanococcoides | Methanococcoides sp. NM1 | |
| 30454716 | 30454716 | PRJNA390533_P_NODE_33413_length_220_cov_1.149171_g32386_i0 | PRJNA390533 | 33413 | 220 | 1.149171 | 2.5281762 | Candidatus Methanophagaceae archaeon | 3386247 | Archaea | Archaea | 107 | 3.67e-25 | NR | KAF5433530.1 | 3386247 | g32386 | i0 | 68.1 | 7.85454545454545 | 72 | 23 | 98.2 | 0 | 218 | 3 | 81 | 152 | KAF5433530.1 SEFIR domain-containing protein [Candidatus Methanophagaceae archaeon] | diamond | 1728 | 107 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophagaceae archaeon | ||
| 30896928 | 30896928 | PRJNA390533_P_NODE_25374_length_316_cov_1.003610_g24347_i0 | PRJNA390533 | 25374 | 316 | 1.00361 | 3.1714076 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 46.6 | 0.00355 | NR | MEK9698609.1 | 2163009 | g24347 | i0 | 76.9 | 0.740506329113924 | 26 | 6 | 24.7 | 0 | 314 | 237 | 90 | 115 | MEK9698609.1 terminase family protein [Candidatus Poseidoniales archaeon] | diamond | 234 | 46.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 31086350 | 31086350 | PRJNA390533_P_NODE_42455_length_171_cov_1.234848_g41428_i0 | PRJNA390533 | 42455 | 171 | 1.234848 | 2.11159008 | Natronococcus wangiae | 3068275 | Archaea | Archaea | 83.2 | 6.04e-17 | NR | WP_306052390.1 | 3068275 | g41428 | i0 | 64.3 | 1.96491228070175 | 56 | 20 | 98.2 | 0 | 169 | 2 | 158 | 213 | WP_306052390.1 cation:proton antiporter [Natronococcus wangiae] | diamond | 336 | 83.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus wangiae | |
| 31086354 | 31086354 | PRJNA390533_P_NODE_46575_length_159_cov_1.108333_g45548_i0 | PRJNA390533 | 46575 | 159 | 1.108333 | 1.76224947 | Natronococcus wangiae | 3068275 | Archaea | Archaea | 60.5 | 6.39e-9 | NR | WP_306052390.1 | 3068275 | g45548 | i0 | 62 | 14.4716981132075 | 50 | 19 | 94.3 | 0 | 9 | 158 | 288 | 337 | WP_306052390.1 cation:proton antiporter [Natronococcus wangiae] | diamond | 2301 | 60.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus wangiae | |
| 31197534 | 31197534 | PRJNA390533_P_NODE_30815_length_244_cov_0.824390_g29788_i0 | PRJNA390533 | 30815 | 244 | 0.82439 | 2.0115116 | root | 1 | Root_unresolved | Root_unresolved | 52 | 1.19e-6 | NR | WP_240950869.1 | 59277 | g29788 | i0 | 57.5 | 1.04508196721311 | 40 | 17 | 49.2 | 0 | 8 | 127 | 13 | 52 | WP_240950869.1 tetratricopeptide repeat protein [Methanobacterium subterraneum] | diamond | 255 | 52 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 31419271 | 31419271 | PRJNA390533_P_NODE_37696_length_192_cov_1.130719_g36669_i0 | PRJNA390533 | 37696 | 192 | 1.130719 | 2.17098048 | Methanobacterium | 2160 | Archaea | Archaea | 45.1 | 0.00221 | NR | AXV38124.1 | 2025350 | g36669 | i0 | 51.4 | 4.734375 | 35 | 17 | 54.7 | 0 | 191 | 87 | 38 | 72 | AXV38124.1 MAG: pilus assembly protein PilF [Methanobacterium sp. BRmetb2] | diamond | 909 | 45.4 | 0.993392070484582 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BRmetb2 | |
| 31971819 | 31971819 | PRJNA390533_P_NODE_50958_length_150_cov_0.945946_g49931_i0 | PRJNA390533 | 50958 | 150 | 0.945946 | 1.418919 | Candidatus Methanogaster sp. ANME-2c ERB4 | 2759911 | Archaea | Archaea | 44.3 | 0.00309 | NR | QNO50037.1 | 2759911 | g49931 | i0 | 52.3 | 0.88 | 44 | 20 | 86 | 1 | 10 | 138 | 506 | 549 | QNO50037.1 hypothetical protein MMAJBCMK_00020 [Candidatus Methanogaster sp. ANME-2c ERB4] | diamond | 132 | 44.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanogasteraceae | Candidatus Methanogaster | Candidatus Methanogaster sp. ANME-2c ERB4 |
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);;