contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA849822" and tax_kingdom = "Promethearchaeati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26778501 | 26778501 | PRJNA849822_P_NODE_8901_length_506_cov_1.353349_g8729_i0 | PRJNA849822 | 8901 | 506 | 1.353349 | 6.84794594 | root | 1 | Root_unresolved | Root_unresolved | 130 | 7.6899999999999985e-34 | NR | MCJ7649449.1 | 2053489 | g8729 | i0 | 50.7 | 12.6284584980237 | 136 | 67 | 80.6 | 0 | 98 | 505 | 131 | 266 | MCJ7649449.1 bile acid:sodium symporter [Promethearchaeota archaeon] | diamond | 6390 | 130 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 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 | ||||||
| 27402691 | 27402691 | PRJNA849822_P_NODE_28723_length_272_cov_2.015075_g28549_i0 | PRJNA849822 | 28723 | 272 | 2.015075 | 5.481004 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 50.8 | 7.54e-5 | NR | TFG30161.1 | 2053489 | g28549 | i0 | 37.2 | 2.61397058823529 | 78 | 46 | 86 | 2 | 32 | 265 | 35 | 109 | TFG30161.1 MAG: hypothetical protein EU532_01615 [Promethearchaeota archaeon] | diamond | 711 | 50.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota 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 | ||||||
| 28223340 | 28223340 | PRJNA849822_P_NODE_28186_length_275_cov_1.282178_g28012_i0 | PRJNA849822 | 28186 | 275 | 1.282178 | 3.5259895 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 92.8 | 3.65e-20 | NR | MBE0527221.1 | 2053491 | g28012 | i0 | 61.4 | 3.84 | 88 | 32 | 96 | 1 | 12 | 275 | 2 | 87 | MBE0527221.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Candidatus Thorarchaeota archaeon] | diamond | 1056 | 92.8 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota 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 | ||||||
| 31223783 | 31223783 | PRJNA849822_P_NODE_22135_length_308_cov_1.327660_g21961_i0 | PRJNA849822 | 22135 | 308 | 1.32766 | 4.0891928 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 119 | 5.710000000000001e-29 | NR | NHJ49193.1 | 2591838 | g21961 | i0 | 67.5 | 2.33766233766234 | 80 | 26 | 77.9 | 0 | 308 | 69 | 110 | 189 | NHJ49193.1 elongation factor 1-alpha [Promethearchaeati archaeon] | diamond | 720 | 119 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 32173195 | 32173195 | PRJNA849822_P_NODE_22898_length_303_cov_1.017391_g22724_i0 | PRJNA849822 | 22898 | 303 | 1.017391 | 3.08269473 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 83.2 | 3.83e-16 | NR | NHK32115.1 | 2591838 | g22724 | i0 | 67.2 | 0.603960396039604 | 61 | 20 | 60.4 | 0 | 301 | 119 | 375 | 435 | NHK32115.1 saccharopine dehydrogenase [Promethearchaeati archaeon] | diamond | 183 | 83.2 | 1 | Archaea | Promethearchaeati | Promethearchaeati 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);;