contig_metadata
12 rows where bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5748207 | 5748207 | PRJNA674308_P_NODE_31625_length_180_cov_1.221374_g31390_i0 | PRJNA674308 | 31625 | 180 | 1.221374 | 2.1984732 | Thermoproteati | 1783275 | Archaea | Archaea | 97.1 | 3.82e-22 | NR | MEM2043052.1 | 2026795 | g31390 | i0 | 67.8 | 13.95 | 59 | 19 | 98.3 | 0 | 4 | 180 | 81 | 139 | MEM2043052.1 AAA family ATPase [Nitrososphaerota archaeon] | diamond | 2511 | 97.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 26733246 | 26733246 | PRJNA674308_P_NODE_43021_length_166_cov_0.888889_g42786_i0 | PRJNA674308 | 43021 | 166 | 0.888889 | 1.47555574 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 62.4 | 1.55e-9 | NR | MDG6922547.1 | 2026795 | g42786 | i0 | 58.2 | 0.993975903614458 | 55 | 22 | 97.6 | 1 | 1 | 162 | 220 | 274 | MDG6922547.1 DDE-type integrase/transposase/recombinase [Nitrososphaerota archaeon] | diamond | 165 | 62.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 26745187 | 26745187 | PRJNA674308_P_NODE_25621_length_198_cov_1.208054_g25386_i0 | PRJNA674308 | 25621 | 198 | 1.208054 | 2.39194692 | root | 1 | Root_unresolved | Root_unresolved | 93.2 | 1.69e-20 | NR | HZW85781.1 | 2268197 | g25386 | i0 | 65.6 | 3.84848484848485 | 64 | 22 | 97 | 0 | 7 | 198 | 118 | 181 | HZW85781.1 molybdopterin-synthase adenylyltransferase MoeB [Nitrososphaerales archaeon] | diamond | 762 | 94 | 0.991489361702128 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 27776915 | 27776915 | PRJNA674308_P_NODE_3784_length_493_cov_1.740991_g3550_i0 | PRJNA674308 | 3784 | 493 | 1.740991 | 8.58308563 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 89.7 | 5.78e-18 | NR | MDA7495390.1 | 2024843 | g3550 | i0 | 37.2 | 0.882352941176471 | 145 | 75 | 85.8 | 5 | 433 | 11 | 160 | 292 | MDA7495390.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 435 | 89.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28060856 | 28060856 | PRJNA674308_P_NODE_7085_length_357_cov_1.730519_g6850_i0 | PRJNA674308 | 7085 | 357 | 1.730519 | 6.17795283 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 76.3 | 1.29e-13 | NR | MDA7495390.1 | 2024843 | g6850 | i0 | 33.3 | 1.00840336134454 | 120 | 72 | 96.6 | 3 | 1 | 345 | 11 | 127 | MDA7495390.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 360 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28092466 | 28092466 | PRJNA674308_P_NODE_39225_length_168_cov_0.873950_g38990_i0 | PRJNA674308 | 39225 | 168 | 0.87395 | 1.468236 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 99.4 | 1.6000000000000002e-22 | NR | HJX22932.1 | 3045160 | g38990 | i0 | 83.9 | 17 | 56 | 9 | 100 | 0 | 168 | 1 | 797 | 852 | HJX22932.1 RNase H-like domain-containing protein [Candidatus Bathyarchaeia archaeon] | diamond | 2856 | 99.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29008458 | 29008458 | PRJNA674308_P_NODE_29488_length_186_cov_1.138686_g29253_i0 | PRJNA674308 | 29488 | 186 | 1.138686 | 2.11795596 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 75.9 | 4.71e-15 | NR | MBA3284293.1 | 2024843 | g29253 | i0 | 56.1 | 1.91935483870968 | 57 | 25 | 91.9 | 0 | 11 | 181 | 86 | 142 | MBA3284293.1 class I SAM-dependent methyltransferase [Nitrosopumilus sp.] | diamond | 357 | 75.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29103017 | 29103017 | PRJNA674308_P_NODE_50088_length_163_cov_0.912281_g49853_i0 | PRJNA674308 | 50088 | 163 | 0.912281 | 1.48701803 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 72.8 | 3.22e-13 | NR | MDG6922547.1 | 2026795 | g49853 | i0 | 68.5 | 0.993865030674847 | 54 | 17 | 99.4 | 0 | 162 | 1 | 818 | 871 | MDG6922547.1 DDE-type integrase/transposase/recombinase [Nitrososphaerota archaeon] | diamond | 162 | 72.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29809287 | 29809287 | PRJNA674308_P_NODE_5551_length_403_cov_1.728814_g5316_i0 | PRJNA674308 | 5551 | 403 | 1.728814 | 6.96712042 | Archaea | 2157 | Archaea | Archaea | 50.1 | 5.57e-5 | NR | MCD6492090.1 | 2056631 | g5316 | i0 | 45.6 | 0.84863523573201 | 57 | 29 | 42.4 | 1 | 400 | 230 | 26 | 80 | MCD6492090.1 tetratricopeptide repeat protein [Thermoproteota archaeon] | diamond | 342 | 50.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30081639 | 30081639 | PRJNA674308_P_NODE_31772_length_179_cov_2.800000_g31537_i0 | PRJNA674308 | 31772 | 179 | 2.8 | 5.012 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 62.8 | 1.22e-9 | NR | MEJ2272760.1 | 2026714 | g31537 | i0 | 50 | 0.972067039106145 | 58 | 29 | 97.2 | 0 | 2 | 175 | 255 | 312 | MEJ2272760.1 GntG family PLP-dependent aldolase [Candidatus Bathyarchaeota archaeon] | diamond | 174 | 62.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31187282 | 31187282 | PRJNA674308_P_NODE_10155_length_299_cov_1.716000_g9920_i0 | PRJNA674308 | 10155 | 299 | 1.716 | 5.13084 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 42.4 | 0.0405 | NR | RLG48071.1 | 2056631 | g9920 | i0 | 35.1 | 0.57190635451505 | 57 | 34 | 57.2 | 1 | 199 | 29 | 41 | 94 | RLG48071.1 MAG: rhomboid family intramembrane serine protease, partial [Thermoproteota archaeon] | diamond | 171 | 42.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31377531 | 31377531 | PRJNA674308_P_NODE_6576_length_371_cov_1.437888_g6341_i0 | PRJNA674308 | 6576 | 371 | 1.437888 | 5.33456448 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 49.7 | 5.57e-4 | NR | TLY02951.1 | 2026795 | g6341 | i0 | 30.7 | 0.921832884097035 | 114 | 66 | 81.7 | 4 | 63 | 365 | 203 | 316 | TLY02951.1 MAG: hypothetical protein E6K87_06980, partial [Nitrososphaerota archaeon] | diamond | 342 | 49.7 | 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);;