contig_metadata
9 rows where bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26700871 | 26700871 | PRJNA631119_P_NODE_21341_length_290_cov_1.414747_g21223_i0 | PRJNA631119 | 21341 | 290 | 1.414747 | 4.1027663 | Zestosphaera sp. | 2303494 | Archaea | Archaea | 44.7 | 0.0131 | NR | MEM4485815.1 | 2303494 | g21223 | i0 | 30.7 | 0.775862068965517 | 75 | 52 | 77.6 | 0 | 1 | 225 | 73 | 147 | MEM4485815.1 VWA domain-containing protein [Zestosphaera sp.] | diamond | 225 | 44.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Zestosphaera | Zestosphaera sp. | ||
| 26777134 | 26777134 | PRJNA631119_P_NODE_32221_length_249_cov_1.750000_g32103_i0 | PRJNA631119 | 32221 | 249 | 1.75 | 4.3575 | Nitrosopumilus | 338191 | Archaea | Archaea | 45.4 | 0.00449 | NR | WP_371504934.1 | 1580092 | g32103 | i0 | 42.9 | 2.60240963855422 | 42 | 24 | 50.6 | 0 | 143 | 18 | 315 | 356 | WP_371504934.1 polysaccharide deacetylase family protein [Nitrosopumilus adriaticus] | diamond | 648 | 45.8 | 0.991266375545852 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus adriaticus | ||
| 28660064 | 28660064 | PRJNA631119_P_NODE_9467_length_391_cov_1.452830_g9349_i0 | PRJNA631119 | 9467 | 391 | 1.45283 | 5.6805653 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 50.1 | 5.12e-4 | NR | MDH3489676.1 | 2024843 | g9349 | i0 | 33.3 | 0.552429667519182 | 72 | 47 | 55.2 | 1 | 283 | 68 | 319 | 389 | MDH3489676.1 polysaccharide deacetylase family protein [Nitrosopumilus sp.] | diamond | 216 | 50.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28691702 | 28691702 | PRJNA631119_P_NODE_13767_length_340_cov_1.730337_g13649_i0 | PRJNA631119 | 13767 | 340 | 1.730337 | 5.8831458 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 47 | 0.00331 | NR | HUV47141.1 | 3045160 | g13649 | i0 | 53.5 | 0.379411764705882 | 43 | 16 | 34.4 | 1 | 335 | 219 | 204 | 246 | HUV47141.1 putative metal-binding motif-containing protein [Candidatus Bathyarchaeia archaeon] | diamond | 129 | 47 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29954537 | 29954537 | PRJNA631119_P_NODE_19311_length_301_cov_1.026316_g19193_i0 | PRJNA631119 | 19311 | 301 | 1.026316 | 3.08921116 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 67 | 2.18e-10 | NR | MCE2497419.1 | 2202732 | g19193 | i0 | 39.1 | 0.916943521594684 | 92 | 55 | 91.7 | 1 | 1 | 276 | 197 | 287 | MCE2497419.1 VWA domain-containing protein [Nitrosopumilaceae archaeon] | diamond | 276 | 67 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 31503177 | 31503177 | PRJNA631119_P_NODE_33876_length_247_cov_1.752874_g33758_i0 | PRJNA631119 | 33876 | 247 | 1.752874 | 4.32959878 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 54.3 | 3.09e-6 | NR | MCC6012892.1 | 2250257 | g33758 | i0 | 48.5 | 1.63967611336032 | 66 | 33 | 78.9 | 1 | 218 | 24 | 13 | 78 | MCC6012892.1 peptide chain release factor aRF-1 [Candidatus Methanomethylicota archaeon] | diamond | 405 | 54.3 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 31629532 | 31629532 | PRJNA631119_P_NODE_14716_length_332_cov_1.486486_g14598_i0 | PRJNA631119 | 14716 | 332 | 1.486486 | 4.93513352 | Sulfolobales archaeon | 2268200 | Archaea | Archaea | 48.9 | 2.62e-4 | NR | MEM3904169.1 | 2268200 | g14598 | i0 | 37.5 | 1.1566265060241 | 64 | 40 | 57.8 | 0 | 52 | 243 | 54 | 117 | MEM3904169.1 radical SAM protein [Sulfolobales archaeon] | diamond | 384 | 48.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobales archaeon | ||||
| 32072410 | 32072410 | PRJNA631119_P_NODE_36938_length_244_cov_0.900585_g36820_i0 | PRJNA631119 | 36938 | 244 | 0.900585 | 2.1974274 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 68.6 | 5.1e-12 | NR | MBD3206148.1 | 2026714 | g36820 | i0 | 53.7 | 0.663934426229508 | 54 | 25 | 66.4 | 0 | 239 | 78 | 96 | 149 | MBD3206148.1 heme-binding protein [Candidatus Bathyarchaeota archaeon] | diamond | 162 | 68.6 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32211624 | 32211624 | PRJNA631119_P_NODE_3318_length_601_cov_1.166667_g3206_i0 | PRJNA631119 | 3318 | 601 | 1.166667 | 7.01166867 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 8.98e-4 | NR | RLG94632.1 | 2026714 | g3206 | i0 | 51.1 | 2.43594009983361 | 45 | 22 | 22.5 | 0 | 5 | 139 | 55 | 99 | RLG94632.1 MAG: thioredoxin [Candidatus Bathyarchaeota archaeon] | diamond | 1464 | 48.9 | 0.991820040899796 | 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);;