contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6968229 | 6968229 | PRJNA611476_P_NODE_71626_length_263_cov_1.589474_g70835_i0 | PRJNA611476 | 71626 | 263 | 1.589474 | 4.18031662 | Candidatus Culexarchaeum yellowstonense | 2928963 | Archaea | Archaea | 102 | 6.37e-24 | NR | WP_304330045.1 | 2928963 | g70835 | i0 | 55.2 | 2.97718631178707 | 87 | 39 | 99.2 | 0 | 1 | 261 | 43 | 129 | WP_304330045.1 phosphoribosylglycinamide formyltransferase [Candidatus Culexarchaeum yellowstonense] | diamond | 783 | 102 | 1 | Archaea | Thermoproteati | Candidatus Culexarchaeota | Candidatus Culexarchaeia | Candidatus Culexarchaeles | Candidatus Culexarchaeaceae | Candidatus Culexarchaeum | Candidatus Culexarchaeum yellowstonense | ||
| 27048698 | 27048698 | PRJNA611476_P_NODE_98762_length_246_cov_0.890173_g97971_i0 | PRJNA611476 | 98762 | 246 | 0.890173 | 2.18982558 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 69.3 | 1.73e-11 | NR | MCD6508967.1 | 2250277 | g97971 | i0 | 40.8 | 1.75609756097561 | 71 | 41 | 86.6 | 1 | 4 | 216 | 248 | 317 | MCD6508967.1 carbohydrate binding domain-containing protein [Thermoprotei archaeon] | diamond | 432 | 69.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 29101342 | 29101342 | PRJNA611476_P_NODE_38468_length_342_cov_1.144981_g37677_i0 | PRJNA611476 | 38468 | 342 | 1.144981 | 3.91583502 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 49.7 | 1.71e-4 | NR | NMJ87805.1 | 2026795 | g37677 | i0 | 51.4 | 0.324561403508772 | 37 | 18 | 32.5 | 0 | 230 | 340 | 16 | 52 | NMJ87805.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 111 | 49.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30396644 | 30396644 | PRJNA611476_P_NODE_76613_length_254_cov_1.044199_g75822_i0 | PRJNA611476 | 76613 | 254 | 1.044199 | 2.65226546 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 66.2 | 1.01e-10 | NR | HXW85872.1 | 3045160 | g75822 | i0 | 40.5 | 0.933070866141732 | 79 | 44 | 93.3 | 2 | 17 | 253 | 144 | 219 | HXW85872.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 237 | 66.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 32261897 | 32261897 | PRJNA611476_P_NODE_61018_length_283_cov_1.357143_g60227_i0 | PRJNA611476 | 61018 | 283 | 1.357143 | 3.84071469 | Candidatus Brockarchaeota archaeon | 2815303 | Archaea | Archaea | 50.4 | 1.1e-4 | NR | MBO3769293.1 | 2815303 | g60227 | i0 | 32.9 | 0.80565371024735 | 76 | 50 | 80.6 | 1 | 266 | 39 | 295 | 369 | MBO3769293.1 translation elongation factor EF-1 subunit alpha [Candidatus Brockarchaeota archaeon] | diamond | 228 | 50.4 | 1 | Archaea | Thermoproteati | Candidatus Brockarchaeota | Candidatus Brockarchaeota archaeon | ||||||
| 32672285 | 32672285 | PRJNA611476_P_NODE_62820_length_280_cov_1.164251_g62029_i0 | PRJNA611476 | 62820 | 280 | 1.164251 | 3.2599028 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 182 | 3.19e-56 | NR | HXV88298.1 | 2169593 | g62029 | i0 | 89.2 | 0.996428571428571 | 93 | 10 | 99.6 | 0 | 279 | 1 | 117 | 209 | HXV88298.1 MEDS domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 279 | 182 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;