contig_metadata
11 rows where bioproject = "PRJEB80557" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11617721 | 11617721 | PRJEB80557_S_NODE_3310_length_449_cov_2.370000_g2914_i0 | PRJEB80557 | 3310 | 449 | 2.37 | 10.6413 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 178 | 7.17e-49 | NR | MEM3368522.1 | 2056631 | g2914 | i0 | 88.7 | 0.708240534521158 | 106 | 11 | 70.2 | 1 | 440 | 126 | 201 | 306 | MEM3368522.1 hypothetical protein [Thermoproteota archaeon] | diamond | 318 | 178 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 20540046 | 20540046 | PRJEB80557_S_NODE_27017_length_185_cov_5.551471_g26621_i0 | PRJEB80557 | 27017 | 185 | 5.551471 | 10.27022135 | Vulcanisaeta moutnovskia | 985052 | Archaea | Archaea | 52.8 | 0.016 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g26621 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 48 | 75 | 336127 | 336100 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 26876322 | 26876322 | PRJEB80557_S_NODE_20801_length_208_cov_3.182390_g20405_i0 | PRJEB80557 | 20801 | 208 | 3.18239 | 6.6193712 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 57.8 | 8.09e-9 | NR | TLX69261.1 | 2026795 | g20405 | i0 | 56.3 | 2.75480769230769 | 48 | 21 | 69.2 | 0 | 1 | 144 | 41 | 88 | TLX69261.1 MAG: hypothetical protein E6L03_00525 [Nitrososphaerota archaeon] | diamond | 573 | 57.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27065760 | 27065760 | PRJEB80557_S_NODE_24402_length_194_cov_1.786207_g24006_i0 | PRJEB80557 | 24402 | 194 | 1.786207 | 3.46524158 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 76.3 | 1.12e-14 | NR | WP_345803918.1 | 121277 | g24006 | i0 | 100 | 0.494845360824742 | 32 | 0 | 49.5 | 0 | 90 | 185 | 247 | 278 | WP_345803918.1 twitching motility protein [Pyrobaculum arsenaticum] | diamond | 96 | 76.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 27792530 | 27792530 | PRJEB80557_S_NODE_31024_length_174_cov_1.328000_g30628_i0 | PRJEB80557 | 31024 | 174 | 1.328 | 2.31072 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 51.2 | 1.53e-5 | NR | MEM4382161.1 | 2972665 | g30628 | i0 | 46.2 | 0.896551724137931 | 52 | 23 | 81 | 1 | 31 | 171 | 504 | 555 | MEM4382161.1 DUF262 domain-containing protein [Candidatus Caldarchaeum sp.] | diamond | 156 | 51.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 28929088 | 28929088 | PRJEB80557_S_NODE_3728_length_429_cov_3.723684_g3332_i0 | PRJEB80557 | 3728 | 429 | 3.723684 | 15.97460436 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 151 | 3.12e-39 | NR | MEM3368578.1 | 2056631 | g3332 | i0 | 94.3 | 0.615384615384615 | 88 | 5 | 61.5 | 0 | 264 | 1 | 1 | 88 | MEM3368578.1 hypothetical protein [Thermoproteota archaeon] | diamond | 264 | 151 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29213462 | 29213462 | PRJEB80557_S_NODE_13569_length_252_cov_4.955665_g13173_i0 | PRJEB80557 | 13569 | 252 | 4.955665 | 12.4882758 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 116 | 1.9999999999999997e-28 | NR | WP_345803937.1 | 121277 | g13173 | i0 | 93.7 | 0.75 | 63 | 4 | 75 | 0 | 22 | 210 | 137 | 199 | WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] | diamond | 189 | 116 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 30192146 | 30192146 | PRJEB80557_S_NODE_4792_length_390_cov_3.387097_g4396_i0 | PRJEB80557 | 4792 | 390 | 3.387097 | 13.2096783 | Desulfurococcaceae archaeon | 2184738 | Archaea | Archaea | 62.4 | 2.32e-8 | NR | MEM0326648.1 | 2184738 | g4396 | i0 | 71.8 | 0.3 | 39 | 10 | 29.2 | 1 | 159 | 272 | 390 | 428 | MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] | diamond | 117 | 62.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 30539744 | 30539744 | PRJEB80557_S_NODE_27113_length_185_cov_1.977941_g26717_i0 | PRJEB80557 | 27113 | 185 | 1.977941 | 3.65919085 | Ignisphaera sp. | 2268142 | Archaea | Archaea | 47.4 | 4.06e-4 | NR | MEM4584643.1 | 2268142 | g26717 | i0 | 57.6 | 0.535135135135135 | 33 | 13 | 53.5 | 1 | 169 | 71 | 333 | 364 | MEM4584643.1 DUF2341 domain-containing protein [Ignisphaera sp.] | diamond | 99 | 47.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Ignisphaera | Ignisphaera sp. | ||
| 30729341 | 30729341 | PRJEB80557_S_NODE_15014_length_242_cov_1.067358_g14618_i0 | PRJEB80557 | 15014 | 242 | 1.067358 | 2.58300636 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 98.2 | 7.94e-25 | NR | MDW0190195.1 | 2169593 | g14618 | i0 | 100 | 1.21487603305785 | 49 | 0 | 60.7 | 0 | 3 | 149 | 31 | 79 | MDW0190195.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 294 | 98.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32808200 | 32808200 | PRJEB80557_S_NODE_5680_length_365_cov_2.879747_g5284_i0 | PRJEB80557 | 5680 | 365 | 2.879747 | 10.51107655 | root | 1 | Root_unresolved | Root_unresolved | 141 | 4.439999999999999e-37 | NR | WP_345803937.1 | 121277 | g5284 | i0 | 94.7 | 1.23287671232877 | 75 | 4 | 61.6 | 0 | 129 | 353 | 245 | 319 | WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] | diamond | 450 | 141 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum |
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);;