contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26683375 | 26683375 | PRJNA884104_S_NODE_39001_length_331_cov_1.000000_g38258_i0 | PRJNA884104 | 39001 | 331 | 1 | 3.31 | root | 1 | Root_unresolved | Root_unresolved | 105 | 9.449999999999999e-25 | NR | HXW37693.1 | 2268197 | g38258 | i0 | 57 | 2.72809667673716 | 100 | 41 | 88.8 | 1 | 35 | 328 | 67 | 166 | HXW37693.1 ornithine cyclodeaminase family protein [Nitrososphaerales archaeon] | diamond | 903 | 105 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 26960339 | 26960339 | PRJNA884104_S_NODE_80902_length_244_cov_0.900585_g80159_i0 | PRJNA884104 | 80902 | 244 | 0.900585 | 2.1974274 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 67.4 | 5.43e-11 | NR | HSA98962.1 | 2507556 | g80159 | i0 | 46.6 | 0.897540983606557 | 73 | 39 | 89.8 | 0 | 12 | 230 | 74 | 146 | HSA98962.1 hypothetical protein [Candidatus Nitrosotenuis sp.] | diamond | 219 | 67.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 27087136 | 27087136 | PRJNA884104_S_NODE_70762_length_250_cov_0.870056_g70019_i0 | PRJNA884104 | 70762 | 250 | 0.870056 | 2.17514 | Candidatus Nitrosocaldaceae archaeon | 2838776 | Archaea | Archaea | 66.6 | 1.51e-10 | NR | GIU70885.1 | 2838776 | g70019 | i0 | 63.8 | 0.564 | 47 | 17 | 56.4 | 0 | 3 | 143 | 194 | 240 | GIU70885.1 MAG: hypothetical protein KatS3mg003_0364 [Candidatus Nitrosocaldaceae archaeon] | diamond | 141 | 66.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Candidatus Nitrosocaldales | Candidatus Nitrosocaldaceae | Candidatus Nitrosocaldaceae archaeon | |||
| 27624266 | 27624266 | PRJNA884104_S_NODE_29124_length_377_cov_1.986842_g28381_i0 | PRJNA884104 | 29124 | 377 | 1.986842 | 7.49039434 | Stygiolobus caldivivus | 2824673 | Archaea | Archaea | 60.5 | 9.51e-9 | NR | WP_221289405.1 | 2824673 | g28381 | i0 | 34.7 | 0.986737400530504 | 124 | 64 | 93.1 | 4 | 13 | 363 | 7 | 120 | WP_221289405.1 universal stress protein [Stygiolobus caldivivus] | diamond | 372 | 60.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Stygiolobus | Stygiolobus caldivivus | ||
| 28642524 | 28642524 | PRJNA884104_S_NODE_55867_length_280_cov_1.115942_g55124_i0 | PRJNA884104 | 55867 | 280 | 1.115942 | 3.1246376 | Archaea | 2157 | Archaea | Archaea | 82.4 | 7.27e-18 | NR | RLF24173.1 | 2250277 | g55124 | i0 | 52.9 | 3.68571428571429 | 85 | 39 | 91.1 | 1 | 26 | 280 | 10 | 93 | RLF24173.1 MAG: peptidyl-tRNA hydrolase [Thermoprotei archaeon] | diamond | 1032 | 83.2 | 0.990384615384615 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 29021618 | 29021618 | PRJNA884104_S_NODE_12628_length_567_cov_3.319838_g11897_i0 | PRJNA884104 | 12628 | 567 | 3.319838 | 18.82348146 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 3.75e-6 | NR | MCX6655225.1 | 2026714 | g11897 | i0 | 37.1 | 1.4021164021164 | 97 | 52 | 50.3 | 5 | 504 | 220 | 574 | 663 | MCX6655225.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 795 | 58.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29171336 | 29171336 | PRJNA884104_S_NODE_16109_length_501_cov_1.331776_g15371_i0 | PRJNA884104 | 16109 | 501 | 1.331776 | 6.67219776 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 72.8 | 1.95e-11 | NR | MDH3277049.1 | 2024843 | g15371 | i0 | 47.7 | 0.514970059880239 | 86 | 45 | 51.5 | 0 | 244 | 501 | 394 | 479 | MDH3277049.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 258 | 72.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29179295 | 29179295 | PRJNA884104_S_NODE_48109_length_301_cov_1.482456_g47366_i0 | PRJNA884104 | 48109 | 301 | 1.482456 | 4.46219256 | Archaea | 2157 | Archaea | Archaea | 103 | 1.94e-23 | NR | MBT3283979.1 | 2026714 | g47366 | i0 | 51 | 2.99003322259136 | 100 | 49 | 99.7 | 0 | 301 | 2 | 149 | 248 | MBT3283979.1 hydroxylamine reductase [Candidatus Bathyarchaeota archaeon] | diamond | 900 | 103 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29360750 | 29360750 | PRJNA884104_S_NODE_68489_length_251_cov_0.865169_g67746_i0 | PRJNA884104 | 68489 | 251 | 0.865169 | 2.17157419 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 52.8 | 8.26e-7 | NR | MDF2737902.1 | 2169593 | g67746 | i0 | 49 | 0.609561752988048 | 51 | 26 | 61 | 0 | 207 | 55 | 5 | 55 | MDF2737902.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 153 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29423617 | 29423617 | PRJNA884104_S_NODE_60809_length_268_cov_1.184615_g60066_i0 | PRJNA884104 | 60809 | 268 | 1.184615 | 3.1747682 | Candidatus Nitrosocaldaceae archaeon | 2838776 | Archaea | Archaea | 60.5 | 2.6e-8 | NR | MEM4322925.1 | 2838776 | g60066 | i0 | 60.5 | 0.962686567164179 | 43 | 17 | 48.1 | 0 | 266 | 138 | 324 | 366 | MEM4322925.1 hypothetical protein [Candidatus Nitrosocaldaceae archaeon] | diamond | 258 | 60.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Candidatus Nitrosocaldales | Candidatus Nitrosocaldaceae | Candidatus Nitrosocaldaceae archaeon | |||
| 29549926 | 29549926 | PRJNA884104_S_NODE_26430_length_395_cov_1.586957_g25687_i0 | PRJNA884104 | 26430 | 395 | 1.586957 | 6.26848015 | Candidatus Geocrenenecus arthurdayi | 2978060 | Archaea | Archaea | 67 | 2.56e-10 | NR | MCL7388697.1 | 2978060 | g25687 | i0 | 37.3 | 0.774683544303797 | 102 | 60 | 77.5 | 3 | 66 | 371 | 25 | 122 | MCL7388697.1 hypothetical protein [Candidatus Geocrenenecus arthurdayi] | diamond | 306 | 67 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Wolframiiraptoraceae | Candidatus Geocrenenecus | Candidatus Geocrenenecus arthurdayi | ||||
| 29929251 | 29929251 | PRJNA884104_S_NODE_64851_length_259_cov_0.758065_g64108_i0 | PRJNA884104 | 64851 | 259 | 0.758065 | 1.96338835 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 62.4 | 5.16e-9 | NR | MCW3996296.1 | 2026714 | g64108 | i0 | 40.7 | 2.75675675675676 | 81 | 45 | 90.3 | 1 | 25 | 258 | 164 | 244 | MCW3996296.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 714 | 62.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30055297 | 30055297 | PRJNA884104_S_NODE_83091_length_243_cov_0.905882_g82348_i0 | PRJNA884104 | 83091 | 243 | 0.905882 | 2.20129326 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 164 | 4.88e-50 | NR | MDP8914877.1 | 2056631 | g82348 | i0 | 96.2 | 0.975308641975309 | 79 | 3 | 97.5 | 0 | 241 | 5 | 29 | 107 | MDP8914877.1 hypothetical protein [Thermoproteota archaeon] | diamond | 237 | 164 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30718860 | 30718860 | PRJNA884104_S_NODE_82334_length_243_cov_0.905882_g81591_i0 | PRJNA884104 | 82334 | 243 | 0.905882 | 2.20129326 | Candidatus Marsarchaeota archaeon | 2823144 | Archaea | Archaea | 43.9 | 0.0147 | NR | MCL5007705.1 | 2823144 | g81591 | i0 | 58.8 | 0.419753086419753 | 34 | 14 | 42 | 0 | 243 | 142 | 22 | 55 | MCL5007705.1 AAA family ATPase [Candidatus Marsarchaeota archaeon] | diamond | 102 | 43.9 | 1 | Archaea | Thermoproteati | Candidatus Marsarchaeota | Candidatus Marsarchaeota archaeon | ||||||
| 31604113 | 31604113 | PRJNA884104_S_NODE_82536_length_243_cov_0.905882_g81793_i0 | PRJNA884104 | 82536 | 243 | 0.905882 | 2.20129326 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 65.5 | 3.3e-10 | NR | MFI5423023.1 | 2268197 | g81793 | i0 | 35.9 | 0.962962962962963 | 78 | 50 | 96.3 | 0 | 2 | 235 | 215 | 292 | MFI5423023.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 234 | 65.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 31667190 | 31667190 | PRJNA884104_S_NODE_38317_length_333_cov_1.715385_g37574_i0 | PRJNA884104 | 38317 | 333 | 1.715385 | 5.71223205 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 50.8 | 1.44e-4 | NR | MDE1852183.1 | 2026795 | g37574 | i0 | 46.9 | 0.441441441441441 | 49 | 26 | 44.1 | 0 | 68 | 214 | 93 | 141 | MDE1852183.1 aromatic amino acid lyase [Nitrososphaerota archaeon] | diamond | 147 | 50.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 31793614 | 31793614 | PRJNA884104_S_NODE_66137_length_256_cov_1.092896_g65394_i0 | PRJNA884104 | 66137 | 256 | 1.092896 | 2.79781376 | Candidatus Nitrosocaldaceae archaeon | 2838776 | Archaea | Archaea | 61.2 | 1.29e-8 | NR | GIU70885.1 | 2838776 | g65394 | i0 | 52.6 | 1.32421875 | 57 | 26 | 66.8 | 1 | 254 | 84 | 181 | 236 | GIU70885.1 MAG: hypothetical protein KatS3mg003_0364 [Candidatus Nitrosocaldaceae archaeon] | diamond | 339 | 61.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Candidatus Nitrosocaldales | Candidatus Nitrosocaldaceae | Candidatus Nitrosocaldaceae archaeon | |||
| 31856963 | 31856963 | PRJNA884104_S_NODE_23517_length_418_cov_0.936232_g22774_i0 | PRJNA884104 | 23517 | 418 | 0.936232 | 3.9134497600000002 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 129 | 1.19e-32 | NR | MBI1828022.1 | 2026795 | g22774 | i0 | 50.4 | 2.69138755980861 | 125 | 51 | 89.7 | 1 | 30 | 404 | 127 | 240 | MBI1828022.1 multicopper oxidase domain-containing protein [Nitrososphaerota archaeon] | diamond | 1125 | 129 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32899443 | 32899443 | PRJNA884104_S_NODE_62340_length_264_cov_1.612565_g61597_i0 | PRJNA884104 | 62340 | 264 | 1.612565 | 4.2571716 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 78.2 | 1.61e-14 | NR | RLG04369.1 | 2026795 | g61597 | i0 | 50.7 | 1.71590909090909 | 73 | 36 | 83 | 0 | 234 | 16 | 430 | 502 | RLG04369.1 MAG: hypothetical protein DRN68_09895, partial [Nitrososphaerota archaeon] | diamond | 453 | 78.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota 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);;