contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA382357" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1678595 | 1678595 | PRJNA382357_P_NODE_40002_length_362_cov_4.538206_g39263_i0 | PRJNA382357 | 40002 | 362 | 4.538206 | 16.42830572 | root | 1 | Root_unresolved | Root_unresolved | 110 | 2.5200000000000003e-27 | NR | MBA4453716.1 | 2202732 | g39263 | i0 | 96.4 | 1.44198895027624 | 55 | 2 | 45.6 | 0 | 272 | 108 | 1 | 55 | MBA4453716.1 aminodeoxychorismate/anthranilate synthase component II [Nitrosopumilaceae archaeon] | diamond | 522 | 111 | 0.990990990990991 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27092062 | 27092062 | PRJNA382357_P_NODE_64242_length_294_cov_1.330472_g63503_i0 | PRJNA382357 | 64242 | 294 | 1.330472 | 3.91158768 | Archaea | 2157 | Archaea | Archaea | 43.9 | 0.0258 | NR | HDO81471.1 | 2026714 | g63503 | i0 | 42.9 | 0.857142857142857 | 42 | 24 | 42.9 | 0 | 285 | 160 | 345 | 386 | HDO81471.1 AAA family ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 252 | 44.3 | 0.99097065462754 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27896276 | 27896276 | PRJNA382357_P_NODE_88045_length_256_cov_1.333333_g87306_i0 | PRJNA382357 | 88045 | 256 | 1.333333 | 3.41333248 | Sulfolobus sp. A2 | 2288 | Archaea | Archaea | 79 | 6.77e-15 | NR | TRM73985.1 | 2200880 | g87306 | i0 | 72.5 | 0.59765625 | 51 | 14 | 59.8 | 0 | 252 | 100 | 164 | 214 | TRM73985.1 hypothetical protein DJ532_14000 [Sulfolobus sp. A20-N-F8] | diamond | 153 | 79 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobus | Sulfolobus sp. A20-N-F8 | ||
| 28875063 | 28875063 | PRJNA382357_P_NODE_108368_length_233_cov_56.656977_g107629_i0 | PRJNA382357 | 108368 | 233 | 56.656977 | 132.01075641 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 70.9 | 3.11e-12 | NR | HEX9613614.1 | 3045160 | g107629 | i0 | 82.9 | 1.05579399141631 | 41 | 7 | 52.8 | 0 | 233 | 111 | 261 | 301 | HEX9613614.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 246 | 70.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28969865 | 28969865 | PRJNA382357_P_NODE_128988_length_215_cov_1.688312_g128249_i0 | PRJNA382357 | 128988 | 215 | 1.688312 | 3.6298708 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 55.8 | 5.77e-7 | NR | HWY33017.1 | 2202732 | g128249 | i0 | 59.5 | 0.586046511627907 | 42 | 17 | 58.6 | 0 | 158 | 33 | 117 | 158 | HWY33017.1 ATP-binding protein [Nitrosopumilaceae archaeon] | diamond | 126 | 55.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 29285415 | 29285415 | PRJNA382357_P_NODE_117769_length_225_cov_1.548780_g117030_i0 | PRJNA382357 | 117769 | 225 | 1.54878 | 3.484755 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 59.7 | 3.03e-8 | NR | NIT99516.1 | 2202732 | g117030 | i0 | 65.1 | 0.573333333333333 | 43 | 15 | 57.3 | 0 | 221 | 93 | 552 | 594 | NIT99516.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 129 | 59.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 29380333 | 29380333 | PRJNA382357_P_NODE_37229_length_374_cov_1.738019_g36490_i0 | PRJNA382357 | 37229 | 374 | 1.738019 | 6.50019106 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 89 | 7.96e-18 | NR | HJS63236.1 | 2169593 | g36490 | i0 | 33.9 | 1.98128342245989 | 124 | 74 | 93 | 2 | 19 | 366 | 256 | 379 | HJS63236.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 741 | 89 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30485847 | 30485847 | PRJNA382357_P_NODE_153453_length_203_cov_0.915493_g152714_i0 | PRJNA382357 | 153453 | 203 | 0.915493 | 1.85845079 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 54.3 | 7.87e-7 | NR | MDG6949145.1 | 2026795 | g152714 | i0 | 67.7 | 0.458128078817734 | 31 | 10 | 45.8 | 0 | 190 | 98 | 157 | 187 | MDG6949145.1 site-specific integrase [Nitrososphaerota archaeon] | diamond | 93 | 54.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30612009 | 30612009 | PRJNA382357_P_NODE_107973_length_234_cov_1.491329_g107234_i0 | PRJNA382357 | 107973 | 234 | 1.491329 | 3.48970986 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 43.5 | 0.00185 | NR | NMJ87812.1 | 2026795 | g107234 | i0 | 76 | 0.320512820512821 | 25 | 6 | 32.1 | 0 | 6 | 80 | 16 | 40 | NMJ87812.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 75 | 43.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30850281 | 30850281 | PRJNA382357_P_NODE_121234_length_222_cov_1.453416_g120495_i0 | PRJNA382357 | 121234 | 222 | 1.453416 | 3.22658352 | Nitrososphaeraceae | 1033997 | Archaea | Archaea | 104 | 5.19e-25 | NR | WP_292643163.1 | 1971748 | g120495 | i0 | 65.3 | 1.94594594594595 | 72 | 25 | 97.3 | 0 | 222 | 7 | 21 | 92 | WP_292643163.1 DUF5655 domain-containing protein [Nitrososphaera sp.] | diamond | 432 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30928302 | 30928302 | PRJNA382357_P_NODE_60494_length_302_cov_0.887967_g59755_i0 | PRJNA382357 | 60494 | 302 | 0.887967 | 2.68166034 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 83.2 | 9.18e-17 | NR | MEK0324373.1 | 2024843 | g59755 | i0 | 56.5 | 2.90066225165563 | 69 | 30 | 68.5 | 0 | 208 | 2 | 120 | 188 | MEK0324373.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 876 | 83.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 31086151 | 31086151 | PRJNA382357_P_NODE_22875_length_465_cov_1.608911_g22139_i0 | PRJNA382357 | 22875 | 465 | 1.608911 | 7.48143615 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 124 | 5.68e-30 | NR | MCJ7767164.1 | 2026714 | g22139 | i0 | 58.3 | 0.696774193548387 | 108 | 45 | 69.7 | 0 | 465 | 142 | 97 | 204 | MCJ7767164.1 DNA cytosine methyltransferase [Candidatus Bathyarchaeota archaeon] | diamond | 324 | 124 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31180536 | 31180536 | PRJNA382357_P_NODE_111815_length_230_cov_3.508876_g111076_i0 | PRJNA382357 | 111815 | 230 | 3.508876 | 8.0704148 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 113 | 9.43e-28 | NR | WP_345803900.1 | 121277 | g111076 | i0 | 91.7 | 0.782608695652174 | 60 | 5 | 78.3 | 0 | 223 | 44 | 153 | 212 | WP_345803900.1 flagellar hook-associated protein FlgL [Pyrobaculum arsenaticum] | diamond | 180 | 113 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 31180595 | 31180595 | PRJNA382357_P_NODE_41195_length_358_cov_1.087542_g40456_i0 | PRJNA382357 | 41195 | 358 | 1.087542 | 3.89340036 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 129 | 9.229999999999999e-35 | NR | HEY0579649.1 | 2109671 | g40456 | i0 | 56.3 | 0.863128491620112 | 103 | 45 | 86.3 | 0 | 356 | 48 | 127 | 229 | HEY0579649.1 methyltransferase domain-containing protein [Candidatus Nitrosocosmicus sp.] | diamond | 309 | 129 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 32730342 | 32730342 | PRJNA382357_P_NODE_46620_length_339_cov_1.338129_g45881_i0 | PRJNA382357 | 46620 | 339 | 1.338129 | 4.53625731 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 54.3 | 6.56e-6 | NR | MDG6912588.1 | 2026795 | g45881 | i0 | 33.6 | 0.946902654867257 | 107 | 64 | 92.9 | 3 | 327 | 13 | 121 | 222 | MDG6912588.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 321 | 54.3 | 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);;