contig_metadata
12 rows where bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23896757 | 23896757 | PRJNA971593_P_NODE_23699_length_249_cov_0.875000_g23550_i0 | PRJNA971593 | 23699 | 249 | 0.875 | 2.17875 | Candidatus Nitrososphaera gargensis | 497727 | Archaea | Archaea | 209 | 1.26e-49 | NTclustered | gi|408363220|gb|CP002408.1| | 1237085 | g23550 | i0 | 82.258 | 4.07630522088353 | 248 | 38 | 97 | 1 | 1 | 242 | 126381 | 126134 | Candidatus Nitrososphaera gargensis Ga9.2, complete genome | blastn | 1015 | 209 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera gargensis | ||
| 27057585 | 27057585 | PRJNA971593_P_NODE_27942_length_243_cov_0.905882_g27793_i0 | PRJNA971593 | 27942 | 243 | 0.905882 | 2.20129326 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 146 | 1.33e-40 | NR | MDP8886784.1 | 2056631 | g27793 | i0 | 91.3 | 0.987654320987654 | 80 | 7 | 98.8 | 0 | 242 | 3 | 134 | 213 | MDP8886784.1 hypothetical protein [Thermoproteota archaeon] | diamond | 240 | 146 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27942077 | 27942077 | PRJNA971593_P_NODE_23985_length_249_cov_0.875000_g23836_i0 | PRJNA971593 | 23985 | 249 | 0.875 | 2.17875 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 151 | 1.54e-44 | NR | MDQ3727566.1 | 2056631 | g23836 | i0 | 94.7 | 0.91566265060241 | 76 | 4 | 91.6 | 0 | 2 | 229 | 22 | 97 | MDQ3727566.1 methyltransferase [Thermoproteota archaeon] | diamond | 228 | 151 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28794307 | 28794307 | PRJNA971593_P_NODE_8067_length_428_cov_1.521127_g7918_i0 | PRJNA971593 | 8067 | 428 | 1.521127 | 6.5104235600000004 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 93.6 | 4.13e-20 | NR | MCH7968822.1 | 2026795 | g7918 | i0 | 43.7 | 2.50233644859813 | 119 | 66 | 82.7 | 1 | 75 | 428 | 39 | 157 | MCH7968822.1 SIMPL domain-containing protein [Nitrososphaerota archaeon] | diamond | 1071 | 93.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29583497 | 29583497 | PRJNA971593_P_NODE_2710_length_725_cov_1.676380_g2572_i0 | PRJNA971593 | 2710 | 725 | 1.67638 | 12.153755 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 122 | 7.8e-30 | NR | MCZ6583165.1 | 2026795 | g2572 | i0 | 39.6 | 0.678620689655172 | 164 | 97 | 67 | 1 | 113 | 598 | 40 | 203 | MCZ6583165.1 SIMPL domain-containing protein [Nitrososphaerota archaeon] | diamond | 492 | 122 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29779533 | 29779533 | PRJNA971593_P_NODE_11591_length_355_cov_1.092199_g11442_i0 | PRJNA971593 | 11591 | 355 | 1.092199 | 3.87730645 | Archaea | 2157 | Archaea | Archaea | 45.8 | 0.00192 | NR | MBM5805508.1 | 2250257 | g11442 | i0 | 55.6 | 3.11830985915493 | 45 | 20 | 38 | 0 | 307 | 173 | 1 | 45 | MBM5805508.1 50S ribosomal protein P1 [Candidatus Methanomethylicota archaeon] | diamond | 1107 | 45.8 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 30215359 | 30215359 | PRJNA971593_P_NODE_18132_length_280_cov_1.115942_g17983_i0 | PRJNA971593 | 18132 | 280 | 1.115942 | 3.1246376 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 50.8 | 8.43e-5 | NR | MFB5630976.1 | 2202732 | g17983 | i0 | 36.7 | 1.63928571428571 | 60 | 34 | 60 | 2 | 171 | 4 | 289 | 348 | MFB5630976.1 M1 family metallopeptidase [Nitrosopumilaceae archaeon] | diamond | 459 | 50.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 30878971 | 30878971 | PRJNA971593_P_NODE_25554_length_246_cov_0.890173_g25405_i0 | PRJNA971593 | 25554 | 246 | 0.890173 | 2.18982558 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 40.4 | 0.0478 | NR | HII05077.1 | 2024843 | g25405 | i0 | 50 | 0.414634146341463 | 34 | 17 | 41.5 | 0 | 2 | 103 | 34 | 67 | HII05077.1 tetratricopeptide repeat protein [Nitrosopumilus sp.] | diamond | 102 | 40.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 30910796 | 30910796 | PRJNA971593_P_NODE_4334_length_580_cov_1.781065_g4189_i0 | PRJNA971593 | 4334 | 580 | 1.781065 | 10.330177 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 55.1 | 1.19e-5 | NR | MEM1995155.1 | 2268197 | g4189 | i0 | 32.9 | 0.832758620689655 | 161 | 85 | 76.6 | 7 | 97 | 540 | 8 | 158 | MEM1995155.1 peroxiredoxin [Nitrososphaerales archaeon] | diamond | 483 | 55.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 30980291 | 30980291 | PRJNA971593_P_NODE_22634_length_250_cov_1.406780_g22485_i0 | PRJNA971593 | 22634 | 250 | 1.40678 | 3.51695 | root | 1 | Root_unresolved | Root_unresolved | 116 | 3.5200000000000003e-29 | NR | WP_231911882.1 | 1903276 | g22485 | i0 | 67.5 | 56.832 | 83 | 25 | 98.4 | 2 | 247 | 2 | 123 | 204 | WP_231911882.1 M4 family metallopeptidase [Candidatus Nitrosotalea okcheonensis] | diamond | 14208 | 117 | 0.991452991452991 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Candidatus Nitrosotalea okcheonensis | ||
| 31637689 | 31637689 | PRJNA971593_P_NODE_25056_length_247_cov_0.885057_g24907_i0 | PRJNA971593 | 25056 | 247 | 0.885057 | 2.18609079 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 163 | 3.769999999999999e-48 | NR | HET6800061.1 | 2169593 | g24907 | i0 | 97.6 | 2.98785425101215 | 82 | 2 | 99.6 | 0 | 1 | 246 | 115 | 196 | HET6800061.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 738 | 163 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31833681 | 31833681 | PRJNA971593_P_NODE_3217_length_671_cov_1.693980_g3074_i0 | PRJNA971593 | 3217 | 671 | 1.69398 | 11.3666058 | Archaea | 2157 | Archaea | Archaea | 102 | 1.53e-22 | NR | OLD40889.1 | 1805387 | g3074 | i0 | 37.5 | 4.50670640834575 | 168 | 104 | 74.7 | 1 | 141 | 641 | 49 | 216 | OLD40889.1 MAG: hypothetical protein AUI60_03345 [Thaumarchaeota archaeon 13_1_40CM_2_39_4] | diamond | 3024 | 103 | 0.990291262135922 | Archaea | Thermoproteati | Nitrososphaerota | Thaumarchaeota archaeon 13_1_40CM_2_39_4 |
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);;