contig_metadata
9 rows where bioproject = "PRJNA385396" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1681790 | 1681790 | PRJNA385396_P_NODE_21222_length_241_cov_0.916667_g21130_i0 | PRJNA385396 | 21222 | 241 | 0.916667 | 2.20916747 | Candidatus Culexarchaeum yellowstonense | 2928963 | Archaea | Archaea | 92.8 | 2.79e-20 | NR | WP_304330045.1 | 2928963 | g21130 | i0 | 53.8 | 3.88381742738589 | 78 | 36 | 97.1 | 0 | 4 | 237 | 46 | 123 | WP_304330045.1 phosphoribosylglycinamide formyltransferase [Candidatus Culexarchaeum yellowstonense] | diamond | 936 | 92.8 | 1 | Archaea | Thermoproteati | Candidatus Culexarchaeota | Candidatus Culexarchaeia | Candidatus Culexarchaeles | Candidatus Culexarchaeaceae | Candidatus Culexarchaeum | Candidatus Culexarchaeum yellowstonense | ||
| 5510787 | 5510787 | PRJNA385396_P_NODE_3605_length_409_cov_1.357143_g3513_i0 | PRJNA385396 | 3605 | 409 | 1.357143 | 5.55071487 | archaeon | 1906665 | Archaea | Archaea | 150 | 2.24e-41 | NR | RYH13701.1 | 1906665 | g3513 | i0 | 68.8 | 0.821515892420538 | 112 | 35 | 82.2 | 0 | 407 | 72 | 184 | 295 | RYH13701.1 MAG: 50S ribosomal protein L4 [archaeon] | diamond | 336 | 150 | 1 | Archaea | archaeon | ||||||||
| 8060045 | 8060045 | PRJNA385396_P_NODE_13307_length_251_cov_1.275281_g13215_i0 | PRJNA385396 | 13307 | 251 | 1.275281 | 3.20095531 | archaeon | 1906665 | Archaea | Archaea | 84 | 1.16e-17 | NR | MDP2436279.1 | 1906665 | g13215 | i0 | 65 | 0.717131474103586 | 60 | 21 | 71.7 | 0 | 70 | 249 | 1 | 60 | MDP2436279.1 hypothetical protein [archaeon] | diamond | 180 | 84 | 1 | Archaea | archaeon | ||||||||
| 26917036 | 26917036 | PRJNA385396_P_NODE_15022_length_249_cov_0.875000_g14930_i0 | PRJNA385396 | 15022 | 249 | 0.875 | 2.17875 | archaeon | 1906665 | Archaea | Archaea | 71.6 | 1.61e-12 | NR | RYY32008.1 | 1906665 | g14930 | i0 | 47.6 | 0.987951807228916 | 82 | 41 | 98.8 | 1 | 247 | 2 | 186 | 265 | RYY32008.1 MAG: hypothetical protein EON62_05930, partial [archaeon] | diamond | 246 | 71.6 | 1 | Archaea | archaeon | ||||||||
| 28054258 | 28054258 | PRJNA385396_P_NODE_20105_length_243_cov_0.876471_g20013_i0 | PRJNA385396 | 20105 | 243 | 0.876471 | 2.12982453 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 78.6 | 7.88e-15 | NR | RLG38098.1 | 2056631 | g20013 | i0 | 46.8 | 1.95061728395062 | 79 | 42 | 97.5 | 0 | 6 | 242 | 69 | 147 | RLG38098.1 MAG: IMP dehydrogenase, partial [Thermoproteota archaeon] | diamond | 474 | 78.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28559660 | 28559660 | PRJNA385396_P_NODE_20487_length_242_cov_0.911243_g20395_i0 | PRJNA385396 | 20487 | 242 | 0.911243 | 2.20520806 | Sulfolobus sp. E5 | 2200884 | Archaea | Archaea | 141 | 4.3999999999999996e-38 | NR | TRM73770.1 | 2200884 | g20395 | i0 | 93.8 | 0.991735537190083 | 80 | 5 | 99.2 | 0 | 240 | 1 | 113 | 192 | TRM73770.1 acetaldehyde dehydrogenase [Sulfolobus sp. E5] | diamond | 240 | 141 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobus | Sulfolobus sp. E5 | ||
| 30675384 | 30675384 | PRJNA385396_P_NODE_19293_length_244_cov_0.900585_g19201_i0 | PRJNA385396 | 19293 | 244 | 0.900585 | 2.1974274 | archaeon | 1906665 | Archaea | Archaea | 122 | 6.239999999999999e-31 | NR | MCP4764199.1 | 1906665 | g19201 | i0 | 66.3 | 1.95491803278689 | 80 | 27 | 98.4 | 0 | 5 | 244 | 193 | 272 | MCP4764199.1 aspartate aminotransferase family protein [archaeon] | diamond | 477 | 122 | 1 | Archaea | archaeon | ||||||||
| 31339095 | 31339095 | PRJNA385396_P_NODE_20636_length_242_cov_0.911243_g20544_i0 | PRJNA385396 | 20636 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 90.5 | 1.41e-19 | NR | RYG65511.1 | 1906665 | g20544 | i0 | 62 | 0.979338842975207 | 79 | 30 | 97.9 | 0 | 238 | 2 | 96 | 174 | RYG65511.1 MAG: hypothetical protein EON64_11755 [archaeon] | diamond | 237 | 90.5 | 1 | Archaea | archaeon | ||||||||
| 32761856 | 32761856 | PRJNA385396_P_NODE_1640_length_575_cov_1.450199_g1548_i0 | PRJNA385396 | 1640 | 575 | 1.450199 | 8.33864425 | Natrialba chahannaoensis | 68911 | Archaea | Archaea | 44.3 | 0.0243 | NR | WP_006165844.1 | 68911 | g1548 | i0 | 34.9 | 0.43304347826087 | 83 | 51 | 41.7 | 2 | 209 | 448 | 12 | 94 | WP_006165844.1 PAAR domain-containing protein [Natrialba chahannaoensis] | diamond | 249 | 44.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba chahannaoensis |
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);;