contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21838357 | 21838357 | PRJNA1022139_P_NODE_12098_length_387_cov_0.980892_g11993_i0 | PRJNA1022139 | 12098 | 387 | 0.980892 | 3.79605204 | Metallosphaera | 41980 | Archaea | Archaea | 181 | 1.7e-55 | NR | WP_048057560.1 | 41980 | g11993 | i0 | 64.8 | 9.91472868217054 | 125 | 44 | 96.9 | 0 | 1 | 375 | 8 | 132 | WP_048057560.1 MULTISPECIES: peptide-methionine (S)-S-oxide reductase MsrA [Metallosphaera] | diamond | 3837 | 181 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Metallosphaera | |||
| 26623299 | 26623299 | PRJNA1022139_P_NODE_17221_length_333_cov_1.776923_g17116_i0 | PRJNA1022139 | 17221 | 333 | 1.776923 | 5.91715359 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 42 | 0.0318 | NR | MEM0462448.1 | 2972665 | g17116 | i0 | 31.3 | 0.576576576576577 | 64 | 36 | 57.7 | 1 | 268 | 77 | 2 | 57 | MEM0462448.1 hypothetical protein [Candidatus Caldarchaeum sp.] | diamond | 192 | 42 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 27098109 | 27098109 | PRJNA1022139_P_NODE_27882_length_274_cov_2.179104_g27777_i0 | PRJNA1022139 | 27882 | 274 | 2.179104 | 5.97074496 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 62.4 | 1.17e-9 | NR | MBT3686226.1 | 2024843 | g27777 | i0 | 36.6 | 2.38686131386861 | 82 | 52 | 89.8 | 0 | 246 | 1 | 1 | 82 | MBT3686226.1 ferritin [Nitrosopumilus sp.] | diamond | 654 | 62.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 27438225 | 27438225 | PRJNA1022139_P_NODE_21583_length_302_cov_1.008734_g21478_i0 | PRJNA1022139 | 21583 | 302 | 1.008734 | 3.04637668 | root | 1 | Root_unresolved | Root_unresolved | 120 | 9.16e-31 | NR | WP_268541211.1 | 1603555 | g21478 | i0 | 57 | 15.8940397350993 | 100 | 43 | 99.3 | 0 | 1 | 300 | 48 | 147 | WP_268541211.1 spherulation-specific family 4 protein, partial [Candidatus Nitrosotenuis cloacae] | diamond | 4800 | 121 | 0.991735537190083 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 27477346 | 27477346 | PRJNA1022139_P_NODE_32183_length_258_cov_1.664865_g32078_i0 | PRJNA1022139 | 32183 | 258 | 1.664865 | 4.2953517 | Candidatus Bathyarchaeum tardum | 3042151 | Archaea | Archaea | 67 | 1.11e-10 | NR | MDG6222931.1 | 3042151 | g32078 | i0 | 38.6 | 0.965116279069767 | 83 | 40 | 83.7 | 1 | 221 | 6 | 77 | 159 | MDG6222931.1 kelch repeat-containing protein [Candidatus Bathyarchaeum tardum] | diamond | 249 | 67 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeales | Candidatus Bathyarchaeaceae | Candidatus Bathyarchaeum | Candidatus Bathyarchaeum tardum | ||
| 29119467 | 29119467 | PRJNA1022139_P_NODE_42889_length_241_cov_0.916667_g42784_i0 | PRJNA1022139 | 42889 | 241 | 0.916667 | 2.20916747 | Sulfolobales archaeon HS-7 | 2823152 | Archaea | Archaea | 65.1 | 3.19e-11 | NR | BCU66956.1 | 2823152 | g42784 | i0 | 46.3 | 0.83402489626556 | 67 | 33 | 83.4 | 2 | 201 | 1 | 5 | 68 | BCU66956.1 endoribonuclease [Sulfolobales archaeon HS-7] | diamond | 201 | 65.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobales archaeon HS-7 | ||||
| 29623878 | 29623878 | PRJNA1022139_P_NODE_31210_length_262_cov_1.629630_g31105_i0 | PRJNA1022139 | 31210 | 262 | 1.62963 | 4.2696306 | Candidatus Nitrosotalea sp. FS | 2341021 | Archaea | Archaea | 48.5 | 2.98e-4 | NR | NHH98042.1 | 2341021 | g31105 | i0 | 30.4 | 1.80916030534351 | 79 | 51 | 90.5 | 1 | 10 | 246 | 89 | 163 | NHH98042.1 putative MFS-type transporter [Candidatus Nitrosotalea sp. FS] | diamond | 474 | 48.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Candidatus Nitrosotalea sp. FS | ||
| 30153238 | 30153238 | PRJNA1022139_P_NODE_11952_length_389_cov_0.968354_g11847_i0 | PRJNA1022139 | 11952 | 389 | 0.968354 | 3.76689706 | Archaea | 2157 | Archaea | Archaea | 62.4 | 2.53e-8 | NR | MBD3188925.1 | 2026714 | g11847 | i0 | 52.8 | 0.802056555269923 | 53 | 25 | 40.9 | 0 | 159 | 1 | 197 | 249 | MBD3188925.1 CDC48 family AAA ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 312 | 62.8 | 0.993630573248408 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30185006 | 30185006 | PRJNA1022139_P_NODE_25212_length_284_cov_1.184834_g25107_i0 | PRJNA1022139 | 25212 | 284 | 1.184834 | 3.36492856 | Archaea | 2157 | Archaea | Archaea | 53.1 | 1.32e-5 | NR | MBT5201713.1 | 2026795 | g25107 | i0 | 33.7 | 2.36619718309859 | 92 | 59 | 97.2 | 2 | 8 | 283 | 316 | 405 | MBT5201713.1 polysaccharide deacetylase family protein [Nitrososphaerota archaeon] | diamond | 672 | 53.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30532612 | 30532612 | PRJNA1022139_P_NODE_15033_length_353_cov_1.760714_g14928_i0 | PRJNA1022139 | 15033 | 353 | 1.760714 | 6.21532042 | Archaea | 2157 | Archaea | Archaea | 73.6 | 1.87e-12 | NR | PSN87746.1 | 1978157 | g14928 | i0 | 37 | 6.03399433427762 | 119 | 65 | 97.7 | 2 | 8 | 352 | 185 | 297 | PSN87746.1 MAG: hypothetical protein B9Q03_10110 [Candidatus Marsarchaeota G2 archaeon OSP_D] | diamond | 2130 | 73.6 | 1 | Archaea | Candidatus Marsarchaeota group 2 | Thermoproteati | Candidatus Marsarchaeota | Candidatus Marsarchaeota G2 archaeon OSP_D | |||||
| 30975112 | 30975112 | PRJNA1022139_P_NODE_3574_length_667_cov_1.685185_g3472_i0 | PRJNA1022139 | 3574 | 667 | 1.685185 | 11.24018395 | root | 1 | Root_unresolved | Root_unresolved | 244 | 8.05e-76 | NR | WP_157927732.1 | 1903276 | g3472 | i0 | 54.4 | 10.880059970015 | 217 | 94 | 96.3 | 3 | 642 | 1 | 57 | 271 | WP_157927732.1 multicopper oxidase domain-containing protein [Candidatus Nitrosotalea okcheonensis] | diamond | 7257 | 246 | 0.991869918699187 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Candidatus Nitrosotalea okcheonensis | ||
| 31322584 | 31322584 | PRJNA1022139_P_NODE_40615_length_244_cov_0.900585_g40510_i0 | PRJNA1022139 | 40615 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0267 | NR | HID18365.1 | 2026714 | g40510 | i0 | 37.1 | 2.88934426229508 | 62 | 37 | 76.2 | 1 | 55 | 240 | 153 | 212 | HID18365.1 AAA family ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 705 | 43.5 | 0.990804597701149 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32374592 | 32374592 | PRJNA1022139_P_NODE_19679_length_315_cov_1.272727_g19574_i0 | PRJNA1022139 | 19679 | 315 | 1.272727 | 4.00909005 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 71.2 | 7.84e-14 | NR | MFI5422912.1 | 2268197 | g19574 | i0 | 48.5 | 0.647619047619048 | 68 | 34 | 63.8 | 1 | 66 | 266 | 8 | 75 | MFI5422912.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 204 | 71.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 32406183 | 32406183 | PRJNA1022139_P_NODE_26239_length_280_cov_1.830918_g26134_i0 | PRJNA1022139 | 26239 | 280 | 1.830918 | 5.1265704 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 48.9 | 3.85e-4 | NR | MDH5691071.1 | 2026714 | g26134 | i0 | 35.8 | 0.867857142857143 | 81 | 51 | 85.7 | 1 | 33 | 272 | 542 | 622 | MDH5691071.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Bathyarchaeota archaeon] | diamond | 243 | 48.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota 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);;