contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA849822" and tax_phylum = "Candidatus Heimdallarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26865343 | 26865343 | PRJNA849822_P_NODE_11661_length_433_cov_1.016667_g11487_i0 | PRJNA849822 | 11661 | 433 | 1.016667 | 4.40216811 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 57 | 2.5e-6 | NR | MCE7735028.1 | 2026747 | g11487 | i0 | 27.5 | 0.831408775981524 | 120 | 86 | 83.1 | 1 | 371 | 12 | 112 | 230 | MCE7735028.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 360 | 57 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27907537 | 27907537 | PRJNA849822_P_NODE_725_length_1781_cov_2.585480_g666_i0 | PRJNA849822 | 725 | 1781 | 2.58548 | 46.0473988 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 339 | 9.3e-99 | NR | UCE13464.1 | 2026747 | g666 | i0 | 35.8 | 1.99775407074677 | 600 | 294 | 98.2 | 22 | 1777 | 29 | 856 | 1381 | UCE13464.1 MAG: hypothetical protein JSV04_14935 [Candidatus Heimdallarchaeota archaeon] | diamond | 3558 | 339 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29738811 | 29738811 | PRJNA849822_P_NODE_41190_length_244_cov_0.912281_g41016_i0 | PRJNA849822 | 41190 | 244 | 0.912281 | 2.22596564 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 52.8 | 1.06e-5 | NR | MFQ5822235.1 | 2026747 | g41016 | i0 | 32.6 | 5.93852459016393 | 89 | 48 | 94.7 | 2 | 12 | 242 | 272 | 360 | MFQ5822235.1 aryl-sulfate sulfotransferase [Candidatus Heimdallarchaeota archaeon] | diamond | 1449 | 52.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30781609 | 30781609 | PRJNA849822_P_NODE_34134_length_252_cov_1.307263_g33960_i0 | PRJNA849822 | 34134 | 252 | 1.307263 | 3.29430276 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 54.7 | 2.49e-6 | NR | UCG04100.1 | 2026747 | g33960 | i0 | 40 | 0.892857142857143 | 75 | 37 | 82.1 | 3 | 208 | 2 | 299 | 371 | UCG04100.1 MAG: aryl-sulfate sulfotransferase [Candidatus Heimdallarchaeota archaeon] | diamond | 225 | 54.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30781614 | 30781614 | PRJNA849822_P_NODE_37674_length_248_cov_0.891429_g37500_i0 | PRJNA849822 | 37674 | 248 | 0.891429 | 2.21074392 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 57.8 | 1.95e-7 | NR | MFQ5980850.1 | 2026747 | g37500 | i0 | 45.6 | 1.5241935483871 | 57 | 31 | 69 | 0 | 172 | 2 | 154 | 210 | MFQ5980850.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 378 | 57.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31002913 | 31002913 | PRJNA849822_P_NODE_8114_length_534_cov_1.058568_g7942_i0 | PRJNA849822 | 8114 | 534 | 1.058568 | 5.65275312 | Candidatus Heimdallarchaeum endolithica | 2876572 | Archaea | Archaea | 82 | 1.62e-14 | NR | UJG44094.1 | 2876572 | g7942 | i0 | 31.4 | 1.80898876404494 | 159 | 104 | 89.3 | 2 | 57 | 533 | 473 | 626 | UJG44094.1 MAG: MMPL family transporter [Candidatus Heimdallarchaeum endolithica] | diamond | 966 | 82 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeia (ex Rinke et al. 2021) (nom. nud.) | Candidatus Heimdallarchaeales | Candidatus Heimdallarchaeaceae | Candidatus Heimdallarchaeum | Candidatus Heimdallarchaeum endolithica | ||
| 31200196 | 31200196 | PRJNA849822_P_NODE_19835_length_325_cov_1.476190_g19661_i0 | PRJNA849822 | 19835 | 325 | 1.47619 | 4.7976175 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 6.16e-4 | NR | MBN1329256.1 | 2026747 | g19661 | i0 | 48.1 | 2.52923076923077 | 52 | 20 | 48 | 2 | 155 | 310 | 9 | 53 | MBN1329256.1 arsenic resistance protein [Candidatus Heimdallarchaeota archaeon] | diamond | 822 | 48.9 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota 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);;