contig_metadata
16 rows where bioproject = "PRJNA533114", tax_clade = "Stenosarchaea group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1780830 | 1780830 | PRJNA533114_P_NODE_74202_length_280_cov_1.507246_g73950_i0 | PRJNA533114 | 74202 | 280 | 1.507246 | 4.2202888 | Salinirarus marinus | 3068310 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g73950 | i0 | 96.97 | 0.117857142857143 | 33 | 1 | 12 | 0 | 156 | 188 | 930919 | 930887 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 8770616 | 8770616 | PRJNA533114_P_NODE_54367_length_321_cov_1.637097_g54115_i0 | PRJNA533114 | 54367 | 321 | 1.637097 | 5.25508137 | Methanomicrobiales | 2191 | Archaea | Archaea | 63.9 | 1.39e-5 | NTclustered | gi|2006650972|gb|CP036172.1| | 126734 | g54115 | i0 | 93.023 | 0.342679127725857 | 43 | 3 | 13 | 0 | 257 | 299 | 276271 | 276313 | Methanofollis aquaemaris strain N2F9704 chromosome, complete genome | blastn | 110 | 63.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | Methanofollis aquaemaris | |
| 17081845 | 17081845 | PRJNA533114_P_NODE_110454_length_245_cov_0.895349_g110202_i0 | PRJNA533114 | 110454 | 245 | 0.895349 | 2.19360505 | Natrinema marinum | 2961598 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2273363723|gb|CP100763.1| | 2961598 | g110202 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 144 | 171 | 736315 | 736342 | Natrinema marinum strain DT87 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema marinum | |
| 27299044 | 27299044 | PRJNA533114_P_NODE_80363_length_271_cov_1.166667_g80111_i0 | PRJNA533114 | 80363 | 271 | 1.166667 | 3.16166757 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 92.4 | 5.3e-20 | NR | HJJ36320.1 | 2058474 | g80111 | i0 | 53.3 | 1.99261992619926 | 90 | 39 | 98.5 | 2 | 269 | 3 | 22 | 109 | HJJ36320.1 aspartate-semialdehyde dehydrogenase [Methanocorpusculum sp.] | diamond | 540 | 92.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 27709952 | 27709952 | PRJNA533114_P_NODE_47364_length_341_cov_1.559701_g47112_i0 | PRJNA533114 | 47364 | 341 | 1.559701 | 5.31858041 | Candidatus Methanophaga sp. ANME-1 ERB7 | 2759913 | Archaea | Archaea | 50.8 | 1.67e-4 | NR | QNO55615.1 | 2759913 | g47112 | i0 | 35.6 | 1.57478005865103 | 87 | 54 | 76.5 | 2 | 328 | 68 | 328 | 412 | QNO55615.1 hypothetical protein JLLEDACL_00014 [Candidatus Methanophaga sp. ANME-1 ERB7] | diamond | 537 | 50.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophaga | Candidatus Methanophaga sp. ANME-1 ERB7 | |
| 27898787 | 27898787 | PRJNA533114_P_NODE_70005_length_287_cov_1.182243_g69753_i0 | PRJNA533114 | 70005 | 287 | 1.182243 | 3.39303741 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 85.9 | 4.39e-17 | NR | MCK5217385.1 | 2250255 | g69753 | i0 | 54.4 | 1.80836236933798 | 79 | 35 | 81.5 | 1 | 51 | 284 | 441 | 519 | MCK5217385.1 PKD domain-containing protein [Methanosarcinales archaeon] | diamond | 519 | 85.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28404118 | 28404118 | PRJNA533114_P_NODE_42786_length_356_cov_1.628975_g42534_i0 | PRJNA533114 | 42786 | 356 | 1.628975 | 5.799151 | ANME-2 cluster archaeon | 2056317 | Archaea | Archaea | 88.2 | 4.01e-19 | NR | MCL7413678.1 | 2056317 | g42534 | i0 | 42.6 | 0.851123595505618 | 101 | 56 | 84.3 | 2 | 31 | 330 | 36 | 135 | MCL7413678.1 hypothetical protein [ANME-2 cluster archaeon] | diamond | 303 | 88.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | ANME-2 cluster archaeon | |||
| 28498944 | 28498944 | PRJNA533114_P_NODE_12047_length_650_cov_3.537262_g11807_i0 | PRJNA533114 | 12047 | 650 | 3.537262 | 22.992203 | Methanoregula sp. UBA64 | 1915554 | Archaea | Archaea | 74.3 | 2.29e-11 | NR | WP_292368417.1 | 1915554 | g11807 | i0 | 39.4 | 0.48 | 104 | 58 | 48 | 1 | 313 | 2 | 292 | 390 | WP_292368417.1 hypothetical protein [Methanoregula sp. UBA64] | diamond | 312 | 74.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. UBA64 | |
| 28576946 | 28576946 | PRJNA533114_P_NODE_1207_length_1616_cov_5.113415_g1149_i0 | PRJNA533114 | 1207 | 1616 | 5.113415 | 82.6327864 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 2.89e-5 | NR | MEI7648635.1 | 2184052 | g1149 | i0 | 35.6 | 0.796410891089109 | 101 | 62 | 18.6 | 2 | 49 | 348 | 103 | 201 | MEI7648635.1 kelch repeat-containing protein [Methanomicrobiales archaeon] | diamond | 1287 | 58.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 28845991 | 28845991 | PRJNA533114_P_NODE_63428_length_299_cov_2.800885_g63176_i0 | PRJNA533114 | 63428 | 299 | 2.800885 | 8.37464615 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 68.9 | 4.48e-11 | NR | HNJ81026.1 | 2485498 | g63176 | i0 | 53.3 | 0.602006688963211 | 60 | 26 | 60.2 | 1 | 285 | 106 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 180 | 68.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 28861056 | 28861056 | PRJNA533114_P_NODE_102988_length_248_cov_0.880000_g102736_i0 | PRJNA533114 | 102988 | 248 | 0.88 | 2.1824 | Stenosarchaea group | 2290931 | Archaea | Archaea | 73.9 | 8.23e-14 | NR | HEY3273022.1 | 2052833 | g102736 | i0 | 48.8 | 3.88306451612903 | 80 | 40 | 96.8 | 1 | 242 | 3 | 53 | 131 | HEY3273022.1 UMP kinase [Methanocella sp.] | diamond | 963 | 73.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella sp. | |
| 29698164 | 29698164 | PRJNA533114_P_NODE_105750_length_246_cov_2.225434_g105498_i0 | PRJNA533114 | 105750 | 246 | 2.225434 | 5.47456764 | Saliphagus infecundisoli | 1849069 | Archaea | Archaea | 44.3 | 0.0105 | NR | WP_224829259.1 | 1849069 | g105498 | i0 | 53.3 | 0.365853658536585 | 30 | 14 | 36.6 | 0 | 152 | 241 | 219 | 248 | WP_224829259.1 DUF2264 domain-containing protein [Saliphagus infecundisoli] | diamond | 90 | 44.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Saliphagus | Saliphagus infecundisoli | |
| 29729924 | 29729924 | PRJNA533114_P_NODE_13070_length_626_cov_1.915009_g12826_i0 | PRJNA533114 | 13070 | 626 | 1.915009 | 11.98795634 | Methanoculleus formosensis | 2590886 | Archaea | Archaea | 55.1 | 6.29e-5 | NR | WP_261596875.1 | 2590886 | g12826 | i0 | 44.4 | 1.2555910543131 | 63 | 34 | 30.2 | 1 | 3 | 191 | 153 | 214 | WP_261596875.1 PKD domain-containing protein [Methanoculleus formosensis] | diamond | 786 | 55.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus formosensis | |
| 31626291 | 31626291 | PRJNA533114_P_NODE_88496_length_258_cov_1.616216_g88244_i0 | PRJNA533114 | 88496 | 258 | 1.616216 | 4.16983728 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 50.1 | 9.17e-5 | NR | MCK9313999.1 | 2058474 | g88244 | i0 | 32.1 | 1.97674418604651 | 84 | 52 | 96.5 | 2 | 254 | 6 | 108 | 187 | MCK9313999.1 aquaporin family protein [Methanocorpusculum sp.] | diamond | 510 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 31752662 | 31752662 | PRJNA533114_P_NODE_122277_length_232_cov_2.905660_g122025_i0 | PRJNA533114 | 122277 | 232 | 2.90566 | 6.7411312 | uncultured Methanolobus sp. | 218300 | Archaea | Archaea | 44.7 | 0.00664 | NR | WP_321498690.1 | 218300 | g122025 | i0 | 50 | 0.620689655172414 | 48 | 21 | 58.2 | 2 | 64 | 198 | 332 | 379 | WP_321498690.1 ABC transporter substrate-binding protein [uncultured Methanolobus sp.] | diamond | 144 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | uncultured Methanolobus sp. | |
| 32227563 | 32227563 | PRJNA533114_P_NODE_45338_length_348_cov_0.756364_g45086_i0 | PRJNA533114 | 45338 | 348 | 0.756364 | 2.63214672 | Haloarchaeobius amylolyticus | 1198296 | Archaea | Archaea | 43.9 | 0.0461 | NR | WP_267641267.1 | 1198296 | g45086 | i0 | 31.2 | 0.801724137931034 | 93 | 57 | 77.6 | 2 | 54 | 323 | 124 | 212 | WP_267641267.1 vWA domain-containing protein [Haloarchaeobius amylolyticus] | diamond | 279 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius amylolyticus |
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);;