contig_metadata
26 rows where bioproject = "PRJNA557436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 535665 | 535665 | PRJNA557436_S_NODE_781_length_402_cov_2.713896_g733_i0 | PRJNA557436 | 781 | 402 | 2.713896 | 10.90986192 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 144 | 8.68e-37 | NR | MBK64534.1 | 2026739 | g733 | i0 | 50 | 2 | 134 | 67 | 100 | 0 | 1 | 402 | 484 | 617 | MBK64534.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 804 | 144 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 4362996 | 4362996 | PRJNA557436_S_NODE_8404_length_155_cov_1.800000_g8356_i0 | PRJNA557436 | 8404 | 155 | 1.8 | 2.79 | Halovivax cerinus | 1487865 | Archaea | Archaea | 52.8 | 0.013 | NTclustered | gi|2279709464|gb|CP101824.1| | 1487865 | g8356 | i0 | 100 | 0.180645161290323 | 28 | 0 | 18 | 0 | 32 | 59 | 1223968 | 1223995 | Halovivax cerinus strain IBRC-M 10256 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax cerinus | |
| 22212746 | 22212746 | PRJNA557436_S_NODE_2578_length_237_cov_1.589109_g2530_i0 | PRJNA557436 | 2578 | 237 | 1.589109 | 3.76618833 | Methanomassiliicoccaceae archaeon | 2052168 | Archaea | Archaea | 149 | 3.17e-41 | NR | HPP44499.1 | 2052168 | g2530 | i0 | 82.3 | 5 | 79 | 14 | 100 | 0 | 1 | 237 | 239 | 317 | HPP44499.1 DUF3440 domain-containing protein [Methanomassiliicoccaceae archaeon] | diamond | 1185 | 149 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon | |||
| 23488093 | 23488093 | PRJNA557436_S_NODE_1059_length_351_cov_11.215190_g1011_i0 | PRJNA557436 | 1059 | 351 | 11.21519 | 39.3653169 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 63.9 | 1.53e-5 | NTclustered | gi|2573961727|gb|CP133596.1| | 2268204 | g1011 | i0 | 95.122 | 0.202279202279202 | 41 | 0 | 11 | 2 | 38 | 76 | 518115 | 518155 | MAG: Thermoplasmatales archaeon isolate BR_05 chromosome, complete genome | blastn | 71 | 63.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 26794067 | 26794067 | PRJNA557436_S_NODE_3261_length_215_cov_2.922222_g3213_i0 | PRJNA557436 | 3261 | 215 | 2.922222 | 6.2827773 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 54.7 | 1.26e-6 | NR | MBG17509.1 | 2026739 | g3213 | i0 | 49.2 | 0.823255813953488 | 59 | 30 | 82.3 | 0 | 214 | 38 | 202 | 260 | MBG17509.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 177 | 54.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 26794070 | 26794070 | PRJNA557436_S_NODE_4221_length_196_cov_1.596273_g4173_i0 | PRJNA557436 | 4221 | 196 | 1.596273 | 3.12869508 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 49.7 | 6.01e-5 | NR | MEA1997743.1 | 2026739 | g4173 | i0 | 53.8 | 0.596938775510204 | 39 | 17 | 59.7 | 1 | 121 | 5 | 21 | 58 | MEA1997743.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 117 | 49.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27489711 | 27489711 | PRJNA557436_S_NODE_7883_length_158_cov_1.902439_g7835_i0 | PRJNA557436 | 7883 | 158 | 1.902439 | 3.00585362 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 93.6 | 3.75e-23 | NR | HQF90435.1 | 2666341 | g7835 | i0 | 100 | 0.949367088607595 | 50 | 0 | 94.9 | 0 | 156 | 7 | 59 | 108 | HQF90435.1 hypothetical protein [Methanofastidiosum sp.] | diamond | 150 | 93.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 28135311 | 28135311 | PRJNA557436_S_NODE_7365_length_162_cov_1.212598_g7317_i0 | PRJNA557436 | 7365 | 162 | 1.212598 | 1.96440876 | root | 1 | Root_unresolved | Root_unresolved | 67.4 | 1.71e-11 | NR | HET8686251.1 | 2213 | g7317 | i0 | 54.7 | 3.92592592592593 | 53 | 24 | 98.1 | 0 | 160 | 2 | 146 | 198 | HET8686251.1 hypothetical protein [Methanosarcina sp.] | diamond | 636 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28419512 | 28419512 | PRJNA557436_S_NODE_2406_length_245_cov_1.428571_g2358_i0 | PRJNA557436 | 2406 | 245 | 1.428571 | 3.49999895 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 1.27e-9 | NR | OQC51359.1 | 1852875 | g2358 | i0 | 67.4 | 1.0530612244898 | 43 | 14 | 52.7 | 0 | 244 | 116 | 249 | 291 | OQC51359.1 MAG: hypothetical protein BWX56_01014 [Euryarchaeota archaeon ADurb.Bin023] | diamond | 258 | 63.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon ADurb.Bin023 | ||||||
| 28468624 | 28468624 | PRJNA557436_S_NODE_546_length_477_cov_4.239819_g498_i0 | PRJNA557436 | 546 | 477 | 4.239819 | 20.22393663 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 78.6 | 7.39e-16 | NR | MBG17600.1 | 2026739 | g498 | i0 | 53.8 | 0.830188679245283 | 65 | 29 | 40.3 | 1 | 476 | 285 | 10 | 74 | MBG17600.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 396 | 78.6 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28721102 | 28721102 | PRJNA557436_S_NODE_7667_length_160_cov_1.184000_g7619_i0 | PRJNA557436 | 7667 | 160 | 1.184 | 1.8944 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 77.8 | 5.32e-15 | NR | NDB93712.1 | 2026739 | g7619 | i0 | 64.2 | 2.98125 | 53 | 19 | 99.4 | 0 | 159 | 1 | 78 | 130 | NDB93712.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 477 | 77.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28910142 | 28910142 | PRJNA557436_S_NODE_4928_length_185_cov_1.633333_g4880_i0 | PRJNA557436 | 4928 | 185 | 1.633333 | 3.02166605 | Methanosarcina sp. | 2213 | Archaea | Archaea | 73.6 | 1.18e-14 | NR | HET8687731.1 | 2213 | g4880 | i0 | 68.9 | 0.989189189189189 | 61 | 16 | 98.9 | 2 | 1 | 183 | 9 | 66 | HET8687731.1 hypothetical protein [Methanosarcina sp.] | diamond | 183 | 73.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29289258 | 29289258 | PRJNA557436_S_NODE_7169_length_163_cov_1.515625_g7121_i0 | PRJNA557436 | 7169 | 163 | 1.515625 | 2.47046875 | Methanosarcina sp. | 2213 | Archaea | Archaea | 92.8 | 1.17e-21 | NR | HET8685201.1 | 2213 | g7121 | i0 | 75.9 | 0.993865030674847 | 54 | 13 | 99.4 | 0 | 2 | 163 | 115 | 168 | HET8685201.1 hypothetical protein [Methanosarcina sp.] | diamond | 162 | 92.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29352594 | 29352594 | PRJNA557436_S_NODE_1529_length_298_cov_2.349810_g1481_i0 | PRJNA557436 | 1529 | 298 | 2.34981 | 7.0024338 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 69.7 | 2.45e-11 | NR | HUV85242.1 | 2250255 | g1481 | i0 | 38.6 | 1.14765100671141 | 114 | 54 | 98.7 | 4 | 1 | 294 | 260 | 373 | HUV85242.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 342 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 29478515 | 29478515 | PRJNA557436_S_NODE_2790_length_229_cov_1.474227_g2742_i0 | PRJNA557436 | 2790 | 229 | 1.474227 | 3.37597983 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 97.8 | 6.16e-23 | NR | MBE3139027.1 | 1906666 | g2742 | i0 | 75.8 | 2.46288209606987 | 62 | 15 | 81.2 | 0 | 40 | 225 | 112 | 173 | MBE3139027.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 564 | 97.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29541829 | 29541829 | PRJNA557436_S_NODE_430_length_531_cov_3.141129_g386_i0 | PRJNA557436 | 430 | 531 | 3.141129 | 16.67939499 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 52.8 | 1.97e-5 | NR | MEE9594261.1 | 3107144 | g386 | i0 | 53.3 | 0.254237288135593 | 45 | 21 | 25.4 | 0 | 136 | 2 | 15 | 59 | MEE9594261.1 hypothetical protein [Candidatus Hydrothermarchaeales archaeon] | diamond | 135 | 52.8 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 29857637 | 29857637 | PRJNA557436_S_NODE_3011_length_223_cov_1.414894_g2963_i0 | PRJNA557436 | 3011 | 223 | 1.414894 | 3.15521362 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 133 | 2.66e-35 | NR | MEK9696318.1 | 2163009 | g2963 | i0 | 95.6 | 0.914798206278027 | 68 | 3 | 91.5 | 0 | 205 | 2 | 1 | 68 | MEK9696318.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 204 | 133 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 30047054 | 30047054 | PRJNA557436_S_NODE_4571_length_190_cov_1.561290_g4523_i0 | PRJNA557436 | 4571 | 190 | 1.56129 | 2.966451 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.4 | 0.00209 | NR | DAC71929.1 | 1906666 | g4523 | i0 | 46.8 | 0.978947368421053 | 62 | 33 | 97.9 | 0 | 1 | 186 | 91 | 152 | DAC71929.1 MAG TPA: hypothetical protein DSN98_07775, partial [Thermoplasmata archaeon] | diamond | 186 | 45.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30332101 | 30332101 | PRJNA557436_S_NODE_5932_length_173_cov_2.659420_g5884_i0 | PRJNA557436 | 5932 | 173 | 2.65942 | 4.6007966 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 77.4 | 8.58e-15 | NR | MBG17549.1 | 2026739 | g5884 | i0 | 66.7 | 2.94797687861272 | 57 | 19 | 98.8 | 0 | 2 | 172 | 112 | 168 | MBG17549.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 510 | 77.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30395196 | 30395196 | PRJNA557436_S_NODE_4333_length_194_cov_1.786164_g4285_i0 | PRJNA557436 | 4333 | 194 | 1.786164 | 3.46515816 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 52 | 1.05e-6 | NR | NDB93713.1 | 2026739 | g4285 | i0 | 41.5 | 1.00515463917526 | 65 | 37 | 99 | 1 | 194 | 3 | 24 | 88 | NDB93713.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 195 | 52 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30710688 | 30710688 | PRJNA557436_S_NODE_5294_length_181_cov_1.075342_g5246_i0 | PRJNA557436 | 5294 | 181 | 1.075342 | 1.94636902 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 82 | 1.03e-17 | NR | MFH1835354.1 | 2026739 | g5246 | i0 | 63.3 | 0.994475138121547 | 60 | 22 | 99.4 | 0 | 181 | 2 | 109 | 168 | MFH1835354.1 HNH endonuclease [Methanobacteriota archaeon] | diamond | 180 | 82 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30900456 | 30900456 | PRJNA557436_S_NODE_6034_length_172_cov_2.766423_g5986_i0 | PRJNA557436 | 6034 | 172 | 2.766423 | 4.75824756 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 82.4 | 2.09e-18 | NR | MEK9698599.1 | 2163009 | g5986 | i0 | 76.8 | 0.976744186046512 | 56 | 13 | 97.7 | 0 | 3 | 170 | 12 | 67 | MEK9698599.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 168 | 82.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 31230212 | 31230212 | PRJNA557436_S_NODE_9015_length_152_cov_2.230769_g8967_i0 | PRJNA557436 | 9015 | 152 | 2.230769 | 3.39076888 | root | 1 | Root_unresolved | Root_unresolved | 61.2 | 3.16e-9 | NR | MEM3341451.1 | 1906666 | g8967 | i0 | 56.5 | 1.81578947368421 | 46 | 20 | 90.8 | 0 | 3 | 140 | 337 | 382 | MEM3341451.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 276 | 61.6 | 0.993506493506494 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31469480 | 31469480 | PRJNA557436_S_NODE_2016_length_263_cov_2.622807_g1968_i0 | PRJNA557436 | 2016 | 263 | 2.622807 | 6.89798241 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 42.4 | 0.021 | NR | MBP04517.1 | 2026739 | g1968 | i0 | 40 | 0.627376425855513 | 55 | 33 | 62.7 | 0 | 77 | 241 | 13 | 67 | MBP04517.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 165 | 42.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31564452 | 31564452 | PRJNA557436_S_NODE_2996_length_223_cov_1.925532_g2948_i0 | PRJNA557436 | 2996 | 223 | 1.925532 | 4.29393636 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 85.9 | 9.07e-18 | NR | MBG17502.1 | 2026739 | g2948 | i0 | 54.8 | 0.834080717488789 | 62 | 28 | 83.4 | 0 | 5 | 190 | 96 | 157 | MBG17502.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 186 | 85.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32702389 | 32702389 | PRJNA557436_S_NODE_2840_length_227_cov_2.395833_g2792_i0 | PRJNA557436 | 2840 | 227 | 2.395833 | 5.43854091 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 53.5 | 2.28e-6 | NR | NIT79678.1 | 1906666 | g2792 | i0 | 41.1 | 0.964757709251101 | 73 | 39 | 92.5 | 2 | 2 | 211 | 51 | 122 | NIT79678.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 219 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;