contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA572587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18410920 | 18410920 | PRJNA572587_P_NODE_34155_length_189_cov_6.078571_g33827_i0 | PRJNA572587 | 34155 | 189 | 6.078571 | 11.48849919 | Candidatus Brockarchaeota archaeon | 2815303 | Archaea | Archaea | 105 | 8.040000000000001e-27 | NR | MBO3757527.1 | 2815303 | g33827 | i0 | 100 | 0.793650793650794 | 50 | 0 | 79.4 | 0 | 38 | 187 | 115 | 164 | MBO3757527.1 hypothetical protein [Candidatus Brockarchaeota archaeon] | diamond | 150 | 105 | 1 | Archaea | Thermoproteati | Candidatus Brockarchaeota | Candidatus Brockarchaeota archaeon | ||||||
| 26667735 | 26667735 | PRJNA572587_P_NODE_27541_length_212_cov_57.423313_g27213_i0 | PRJNA572587 | 27541 | 212 | 57.423313 | 121.73742356 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 99.8 | 2.16e-22 | NR | MEM3368556.1 | 2056631 | g27213 | i0 | 88.9 | 0.891509433962264 | 63 | 7 | 89.2 | 0 | 190 | 2 | 1339 | 1401 | MEM3368556.1 hypothetical protein [Thermoproteota archaeon] | diamond | 189 | 99.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 26794700 | 26794700 | PRJNA572587_P_NODE_10441_length_366_cov_18.596215_g10114_i0 | PRJNA572587 | 10441 | 366 | 18.596215 | 68.0621469 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 211 | 9.459999999999999e-68 | NR | MEM3368590.1 | 2056631 | g10114 | i0 | 94.6 | 0.918032786885246 | 112 | 6 | 91.8 | 0 | 25 | 360 | 63 | 174 | MEM3368590.1 N-acetylmuramoyl-L-alanine amidase [Thermoproteota archaeon] | diamond | 336 | 211 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 26952801 | 26952801 | PRJNA572587_P_NODE_7882_length_432_cov_107.540470_g7557_i0 | PRJNA572587 | 7882 | 432 | 107.54047 | 464.5748304 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 161 | 5.7e-48 | NR | WP_345803931.1 | 121277 | g7557 | i0 | 94.3 | 0.611111111111111 | 88 | 5 | 61.1 | 0 | 430 | 167 | 61 | 148 | WP_345803931.1 Na+/H+ antiporter subunit E [Pyrobaculum arsenaticum] | diamond | 264 | 161 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 27079502 | 27079502 | PRJNA572587_P_NODE_36402_length_182_cov_14.278195_g36074_i0 | PRJNA572587 | 36402 | 182 | 14.278195 | 25.9863149 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 97.1 | 1.32e-23 | NR | WP_345803901.1 | 121277 | g36074 | i0 | 90.2 | 0.840659340659341 | 51 | 1 | 77.5 | 1 | 28 | 168 | 1 | 51 | WP_345803901.1 PAS domain-containing protein [Pyrobaculum arsenaticum] | diamond | 153 | 97.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 27155954 | 27155954 | PRJNA572587_P_NODE_36462_length_182_cov_9.263158_g36134_i0 | PRJNA572587 | 36462 | 182 | 9.263158 | 16.85894756 | root | 1 | Root_unresolved | Root_unresolved | 82 | 1.77e-16 | NR | WP_345803936.1 | 121277 | g36134 | i0 | 97.5 | 1.31868131868132 | 40 | 1 | 65.9 | 0 | 42 | 161 | 351 | 390 | WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] | diamond | 240 | 82 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 27332567 | 27332567 | PRJNA572587_P_NODE_36563_length_182_cov_3.902256_g36235_i0 | PRJNA572587 | 36563 | 182 | 3.902256 | 7.10210592 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 84 | 4.91e-17 | NR | MEM3368524.1 | 2056631 | g36235 | i0 | 84.6 | 0.857142857142857 | 52 | 8 | 85.7 | 0 | 158 | 3 | 580 | 631 | MEM3368524.1 hypothetical protein [Thermoproteota archaeon] | diamond | 156 | 84 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28216251 | 28216251 | PRJNA572587_P_NODE_29766_length_204_cov_1.458065_g29438_i0 | PRJNA572587 | 29766 | 204 | 1.458065 | 2.9744526 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 74.7 | 5.9e-14 | NR | MEM3368521.1 | 2056631 | g29438 | i0 | 80 | 0.661764705882353 | 45 | 9 | 66.2 | 0 | 156 | 22 | 38 | 82 | MEM3368521.1 hypothetical protein [Thermoproteota archaeon] | diamond | 135 | 74.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28342789 | 28342789 | PRJNA572587_P_NODE_10886_length_357_cov_30.165584_g10559_i0 | PRJNA572587 | 10886 | 357 | 30.165584 | 107.69113488 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 191 | 8.4e-54 | NR | MEM3368578.1 | 2056631 | g10559 | i0 | 98.2 | 0.932773109243697 | 111 | 2 | 93.3 | 0 | 334 | 2 | 475 | 585 | MEM3368578.1 hypothetical protein [Thermoproteota archaeon] | diamond | 333 | 191 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28406005 | 28406005 | PRJNA572587_P_NODE_6046_length_504_cov_34.872527_g5725_i0 | PRJNA572587 | 6046 | 504 | 34.872527 | 175.75753608 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 215 | 7.87e-68 | NR | MEM3368514.1 | 2056631 | g5725 | i0 | 90.7 | 0.702380952380952 | 118 | 11 | 70.2 | 0 | 23 | 376 | 104 | 221 | MEM3368514.1 hypothetical protein [Thermoproteota archaeon] | diamond | 354 | 215 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28847794 | 28847794 | PRJNA572587_P_NODE_16168_length_285_cov_9.300847_g15840_i0 | PRJNA572587 | 16168 | 285 | 9.300847 | 26.50741395 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 57.8 | 2.87e-7 | NR | MCV0399677.1 | 2026886 | g15840 | i0 | 45 | 1.05263157894737 | 60 | 32 | 63.2 | 1 | 29 | 208 | 255 | 313 | MCV0399677.1 glucose-1-phosphate thymidylyltransferase [Nitrosarchaeum sp.] | diamond | 300 | 57.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 29321507 | 29321507 | PRJNA572587_P_NODE_18649_length_263_cov_19.799065_g18321_i0 | PRJNA572587 | 18649 | 263 | 19.799065 | 52.07154095 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 69.3 | 9.38e-13 | NR | MDT7864681.1 | 2056631 | g18321 | i0 | 82.1 | 0.444866920152091 | 39 | 7 | 44.5 | 0 | 65 | 181 | 5 | 43 | MDT7864681.1 hypothetical protein [Thermoproteota archaeon] | diamond | 117 | 69.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29636959 | 29636959 | PRJNA572587_P_NODE_32330_length_195_cov_2.890411_g32002_i0 | PRJNA572587 | 32330 | 195 | 2.890411 | 5.63630145 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 97.8 | 1.08e-22 | NR | MEM3368607.1 | 2056631 | g32002 | i0 | 75 | 0.984615384615385 | 64 | 16 | 98.5 | 0 | 195 | 4 | 129 | 192 | MEM3368607.1 hypothetical protein [Thermoproteota archaeon] | diamond | 192 | 97.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30142346 | 30142346 | PRJNA572587_P_NODE_4932_length_572_cov_4.634799_g4618_i0 | PRJNA572587 | 4932 | 572 | 4.634799 | 26.51105028 | Desulfurococcaceae archaeon | 2184738 | Archaea | Archaea | 79 | 2.13e-13 | NR | MEM0326648.1 | 2184738 | g4618 | i0 | 43 | 0.597902097902098 | 114 | 60 | 59.3 | 3 | 67 | 405 | 207 | 316 | MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] | diamond | 342 | 79 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 30553296 | 30553296 | PRJNA572587_P_NODE_23673_length_231_cov_32.846154_g23345_i0 | PRJNA572587 | 23673 | 231 | 32.846154 | 75.87461574 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 106 | 5.03e-28 | NR | HET9806764.1 | 2169593 | g23345 | i0 | 86.2 | 0.844155844155844 | 65 | 8 | 83.1 | 1 | 202 | 11 | 21 | 85 | HET9806764.1 integrase core domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 195 | 106 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30679600 | 30679600 | PRJNA572587_P_NODE_23773_length_231_cov_4.747253_g23445_i0 | PRJNA572587 | 23773 | 231 | 4.747253 | 10.96615443 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 46.6 | 0.00144 | NR | MEM3368524.1 | 2056631 | g23445 | i0 | 72.7 | 0.428571428571429 | 33 | 9 | 42.9 | 0 | 133 | 231 | 9 | 41 | MEM3368524.1 hypothetical protein [Thermoproteota archaeon] | diamond | 99 | 46.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30932634 | 30932634 | PRJNA572587_P_NODE_17614_length_271_cov_17.725225_g17286_i0 | PRJNA572587 | 17614 | 271 | 17.725225 | 48.03535975 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 134 | 3.0599999999999993e-34 | NR | MEM3368524.1 | 2056631 | g17286 | i0 | 82.9 | 0.907749077490775 | 82 | 14 | 90.8 | 0 | 24 | 269 | 280 | 361 | MEM3368524.1 hypothetical protein [Thermoproteota archaeon] | diamond | 246 | 134 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30964327 | 30964327 | PRJNA572587_P_NODE_27674_length_212_cov_5.785276_g27346_i0 | PRJNA572587 | 27674 | 212 | 5.785276 | 12.26478512 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 117 | 1.2399999999999999e-28 | NR | MEM3368523.1 | 2056631 | g27346 | i0 | 85.5 | 0.976415094339623 | 69 | 9 | 96.2 | 1 | 209 | 6 | 347 | 415 | MEM3368523.1 hypothetical protein [Thermoproteota archaeon] | diamond | 207 | 117 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31027543 | 31027543 | PRJNA572587_P_NODE_35655_length_184_cov_18.029630_g35327_i0 | PRJNA572587 | 35655 | 184 | 18.02963 | 33.1745192 | Sulfolobales archaeon | 2268200 | Archaea | Archaea | 53.1 | 3.26e-6 | NR | MEM4591831.1 | 2268200 | g35327 | i0 | 71 | 0.505434782608696 | 31 | 9 | 50.5 | 0 | 25 | 117 | 253 | 283 | MEM4591831.1 MYG1 family protein [Sulfolobales archaeon] | diamond | 93 | 53.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobales archaeon | ||||
| 31185064 | 31185064 | PRJNA572587_P_NODE_15335_length_294_cov_3.093878_g15007_i0 | PRJNA572587 | 15335 | 294 | 3.093878 | 9.09600132 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 77.8 | 1.85e-14 | NR | MCD6593848.1 | 2026714 | g15007 | i0 | 45.7 | 2.78571428571429 | 92 | 48 | 91.8 | 1 | 5 | 274 | 12 | 103 | MCD6593848.1 4-hydroxythreonine-4-phosphate dehydrogenase PdxA [Candidatus Bathyarchaeota archaeon] | diamond | 819 | 77.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31438255 | 31438255 | PRJNA572587_P_NODE_2676_length_802_cov_8.986720_g2435_i0 | PRJNA572587 | 2676 | 802 | 8.98672 | 72.0734944 | Candidatus Brockarchaeota archaeon | 2815303 | Archaea | Archaea | 275 | 7.67e-90 | NR | MBO3757533.1 | 2815303 | g2435 | i0 | 95.8 | 0.534912718204489 | 143 | 6 | 53.5 | 0 | 492 | 64 | 1 | 143 | MBO3757533.1 hypothetical protein [Candidatus Brockarchaeota archaeon] | diamond | 429 | 275 | 1 | Archaea | Thermoproteati | Candidatus Brockarchaeota | Candidatus Brockarchaeota archaeon | ||||||
| 31831322 | 31831322 | PRJNA572587_P_NODE_13737_length_312_cov_24.456274_g13409_i0 | PRJNA572587 | 13737 | 312 | 24.456274 | 76.30357488 | root | 1 | Root_unresolved | Root_unresolved | 167 | 5.71e-48 | NR | WP_345803936.1 | 121277 | g13409 | i0 | 91.2 | 1.96153846153846 | 102 | 9 | 98.1 | 0 | 311 | 6 | 31 | 132 | WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] | diamond | 612 | 167 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 32166146 | 32166146 | PRJNA572587_P_NODE_37378_length_180_cov_1.206107_g37050_i0 | PRJNA572587 | 37378 | 180 | 1.206107 | 2.1709926 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 100 | 5.2699999999999997e-23 | NR | MEM3368556.1 | 2056631 | g37050 | i0 | 94.2 | 0.866666666666667 | 52 | 3 | 86.7 | 0 | 24 | 179 | 1174 | 1225 | MEM3368556.1 hypothetical protein [Thermoproteota archaeon] | diamond | 156 | 100 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32292896 | 32292896 | PRJNA572587_P_NODE_27379_length_213_cov_14.798780_g27051_i0 | PRJNA572587 | 27379 | 213 | 14.79878 | 31.5214014 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 98.2 | 7.3e-22 | NR | MEM3368525.1 | 2056631 | g27051 | i0 | 85.2 | 0.859154929577465 | 61 | 9 | 85.9 | 0 | 24 | 206 | 437 | 497 | MEM3368525.1 hypothetical protein [Thermoproteota archaeon] | diamond | 183 | 98.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32450983 | 32450983 | PRJNA572587_P_NODE_25019_length_224_cov_21.194286_g24691_i0 | PRJNA572587 | 25019 | 224 | 21.194286 | 47.47520064 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 81.6 | 1.27e-16 | NR | MEM3368580.1 | 2056631 | g24691 | i0 | 82.6 | 0.616071428571429 | 46 | 8 | 61.6 | 0 | 63 | 200 | 84 | 129 | MEM3368580.1 hypothetical protein [Thermoproteota archaeon] | diamond | 138 | 81.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32545852 | 32545852 | PRJNA572587_P_NODE_21779_length_242_cov_3.901554_g21451_i0 | PRJNA572587 | 21779 | 242 | 3.901554 | 9.44176068 | Candidatus Methanomethylicia archaeon | 2268187 | Archaea | Archaea | 102 | 4.4599999999999996e-23 | NR | MEM3394373.1 | 2268187 | g21451 | i0 | 92.5 | 0.65702479338843 | 53 | 4 | 65.7 | 0 | 184 | 26 | 488 | 540 | MEM3394373.1 hypothetical protein [Candidatus Methanomethylicia archaeon] | diamond | 159 | 102 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicia archaeon | |||||
| 32685085 | 32685085 | PRJNA572587_P_NODE_37080_length_180_cov_35.129771_g36752_i0 | PRJNA572587 | 37080 | 180 | 35.129771 | 63.2335878 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 6.29e-4 | NR | WP_345803883.1 | 121277 | g36752 | i0 | 56.8 | 2.83333333333333 | 44 | 13 | 70 | 2 | 137 | 12 | 78 | 117 | WP_345803883.1 hypothetical protein [Pyrobaculum arsenaticum] | diamond | 510 | 46.6 | 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);;