contig_metadata
8 rows where bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9205816 | 9205816 | PRJNA1122875_P_NODE_47348_length_247_cov_0.885057_g47124_i0 | PRJNA1122875 | 47348 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 136 | 2.25e-39 | NR | MBE3116355.1 | 2026714 | g47124 | i0 | 76.5 | 28.5303643724696 | 81 | 19 | 98.4 | 0 | 3 | 245 | 39 | 119 | MBE3116355.1 glycosyltransferase family 2 protein [Candidatus Bathyarchaeota archaeon] | diamond | 7047 | 137 | 0.992700729927007 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27765342 | 27765342 | PRJNA1122875_P_NODE_51264_length_243_cov_1.358824_g51040_i0 | PRJNA1122875 | 51264 | 243 | 1.358824 | 3.30194232 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 48.9 | 2.5e-4 | NR | MEE8355053.1 | 3045160 | g51040 | i0 | 39.5 | 0.530864197530864 | 43 | 22 | 53.1 | 1 | 100 | 228 | 339 | 377 | MEE8355053.1 glycoside hydrolase family 1 protein [Candidatus Bathyarchaeia archaeon] | diamond | 129 | 48.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28775379 | 28775379 | PRJNA1122875_P_NODE_34667_length_281_cov_1.365385_g34443_i0 | PRJNA1122875 | 34667 | 281 | 1.365385 | 3.83673185 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 67.4 | 1.09e-10 | NR | MEM2851084.1 | 3045160 | g34443 | i0 | 37.3 | 0.886120996441281 | 83 | 51 | 88.6 | 1 | 257 | 9 | 290 | 371 | MEM2851084.1 AAA family ATPase [Candidatus Bathyarchaeia archaeon] | diamond | 249 | 67.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29248960 | 29248960 | PRJNA1122875_P_NODE_28909_length_305_cov_1.659483_g28685_i0 | PRJNA1122875 | 28909 | 305 | 1.659483 | 5.06142315 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 112 | 3.31e-27 | NR | HYC19290.1 | 3045160 | g28685 | i0 | 54.9 | 2.99016393442623 | 102 | 44 | 99.3 | 2 | 2 | 304 | 102 | 202 | HYC19290.1 NAD(P)-dependent alcohol dehydrogenase [Candidatus Bathyarchaeia archaeon] | diamond | 912 | 112 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 30354993 | 30354993 | PRJNA1122875_P_NODE_31712_length_290_cov_1.419355_g31488_i0 | PRJNA1122875 | 31712 | 290 | 1.419355 | 4.1161295 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 43.5 | 0.0351 | NR | MBI1664090.1 | 2024843 | g31488 | i0 | 27.4 | 0.982758620689655 | 95 | 68 | 97.2 | 1 | 287 | 6 | 252 | 346 | MBI1664090.1 fibronectin type III domain-containing protein [Nitrosopumilus sp.] | diamond | 285 | 43.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 30449490 | 30449490 | PRJNA1122875_P_NODE_31273_length_292_cov_1.054795_g31049_i0 | PRJNA1122875 | 31273 | 292 | 1.054795 | 3.0800014 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 76.6 | 2.97e-14 | NR | HID90616.1 | 2026714 | g31049 | i0 | 44.3 | 2.76369863013699 | 97 | 42 | 99.7 | 4 | 292 | 2 | 38 | 122 | HID90616.1 DNA-directed RNA polymerase subunit D [Candidatus Bathyarchaeota archaeon] | diamond | 807 | 76.6 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30638755 | 30638755 | PRJNA1122875_P_NODE_8193_length_571_cov_0.993976_g7975_i0 | PRJNA1122875 | 8193 | 571 | 0.993976 | 5.67560296 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 52.8 | 7.81e-5 | NR | MDH3766400.1 | 2024843 | g7975 | i0 | 33.3 | 1.12959719789842 | 87 | 53 | 43.6 | 2 | 1 | 249 | 93 | 178 | MDH3766400.1 class I SAM-dependent methyltransferase [Nitrosopumilus sp.] | diamond | 645 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 32788151 | 32788151 | PRJNA1122875_P_NODE_22740_length_348_cov_1.556364_g22516_i0 | PRJNA1122875 | 22740 | 348 | 1.556364 | 5.41614672 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 76.6 | 1.6e-13 | NR | RLE92819.1 | 2250277 | g22516 | i0 | 72.7 | 0.379310344827586 | 44 | 12 | 37.9 | 0 | 2 | 133 | 660 | 703 | RLE92819.1 MAG: hypothetical protein DRN04_09125 [Thermoprotei archaeon] | diamond | 132 | 76.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei 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);;