contig_metadata
16 rows where bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1568017 | 1568017 | PRJNA1148190_P_NODE_283362_length_327_cov_1.212598_g272191_i0 | PRJNA1148190 | 283362 | 327 | 1.212598 | 3.96519546 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 175 | 1.36e-50 | NR | RLI70627.1 | 2026747 | g272191 | i0 | 71 | 7.85321100917431 | 107 | 31 | 98.2 | 0 | 327 | 7 | 59 | 165 | RLI70627.1 MAG: hypothetical protein DRO91_06540 [Candidatus Heimdallarchaeota archaeon] | diamond | 2568 | 175 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 20694392 | 20694392 | PRJNA1148190_P_NODE_252617_length_342_cov_1.167286_g241447_i0 | PRJNA1148190 | 252617 | 342 | 1.167286 | 3.99211812 | Candidatus Heimdallarchaeum endolithica | 2876572 | Archaea | Archaea | 54.7 | 0.009 | NTclustered | gi|2180470024|gb|CP084167.1| | 2876572 | g241447 | i0 | 100 | 0.0847953216374269 | 29 | 0 | 8 | 0 | 176 | 204 | 2348859 | 2348831 | MAG: Candidatus Heimdallarchaeum endolithica isolate PR6 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeia (ex Rinke et al. 2021) (nom. nud.) | Candidatus Heimdallarchaeales | Candidatus Heimdallarchaeaceae | Candidatus Heimdallarchaeum | Candidatus Heimdallarchaeum endolithica | ||
| 26691838 | 26691838 | PRJNA1148190_P_NODE_73221_length_647_cov_2.146341_g62121_i0 | PRJNA1148190 | 73221 | 647 | 2.146341 | 13.88682627 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 79.7 | 2.92e-13 | NR | HUT87311.1 | 2026747 | g62121 | i0 | 45.6 | 1.93817619783617 | 79 | 43 | 36.6 | 0 | 401 | 637 | 48 | 126 | HUT87311.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 1254 | 79.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27702986 | 27702986 | PRJNA1148190_P_NODE_234104_length_352_cov_2.010753_g222934_i0 | PRJNA1148190 | 234104 | 352 | 2.010753 | 7.07785056 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 72 | 1.97e-13 | NR | MCK5344108.1 | 2026747 | g222934 | i0 | 41.7 | 0.715909090909091 | 84 | 45 | 71.6 | 2 | 348 | 97 | 33 | 112 | MCK5344108.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 252 | 72 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27892882 | 27892882 | PRJNA1148190_P_NODE_743465_length_243_cov_0.905882_g732292_i0 | PRJNA1148190 | 743465 | 243 | 0.905882 | 2.20129326 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 103 | 9.16e-25 | NR | MFV2014007.1 | 2026747 | g732292 | i0 | 61.3 | 0.987654320987654 | 80 | 31 | 98.8 | 0 | 4 | 243 | 76 | 155 | MFV2014007.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 240 | 103 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 28271616 | 28271616 | PRJNA1148190_P_NODE_71346_length_658_cov_2.047863_g60255_i0 | PRJNA1148190 | 71346 | 658 | 2.047863 | 13.47493854 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 215 | 7.64e-66 | NR | MCK5342968.1 | 2026747 | g60255 | i0 | 51.9 | 0.984802431610942 | 216 | 104 | 98.5 | 0 | 656 | 9 | 80 | 295 | MCK5342968.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 648 | 215 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29345011 | 29345011 | PRJNA1148190_P_NODE_488129_length_269_cov_1.244898_g476956_i0 | PRJNA1148190 | 488129 | 269 | 1.244898 | 3.34877562 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 103 | 1.53e-23 | NR | MCK4844855.1 | 2026747 | g476956 | i0 | 56.2 | 2.94423791821561 | 89 | 38 | 98.1 | 1 | 265 | 2 | 438 | 526 | MCK4844855.1 TSCPD domain-containing protein [Candidatus Heimdallarchaeota archaeon] | diamond | 792 | 103 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29565322 | 29565322 | PRJNA1148190_P_NODE_154610_length_423_cov_1.302857_g143443_i0 | PRJNA1148190 | 154610 | 423 | 1.302857 | 5.51108511 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 54.7 | 3.86e-7 | NR | MCK5343245.1 | 2026747 | g143443 | i0 | 62.5 | 0.283687943262411 | 40 | 15 | 28.4 | 0 | 355 | 236 | 7 | 46 | MCK5343245.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 120 | 54.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29724013 | 29724013 | PRJNA1148190_P_NODE_755150_length_242_cov_1.479290_g743977_i0 | PRJNA1148190 | 755150 | 242 | 1.47929 | 3.5798818 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 91.3 | 1.16e-19 | NR | HUT87073.1 | 2026747 | g743977 | i0 | 53.8 | 4.79752066115702 | 78 | 36 | 96.7 | 0 | 1 | 234 | 270 | 347 | HUT87073.1 alpha/beta hydrolase [Candidatus Heimdallarchaeota archaeon] | diamond | 1161 | 91.3 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29870097 | 29870097 | PRJNA1148190_P_NODE_696571_length_245_cov_1.418605_g685398_i0 | PRJNA1148190 | 696571 | 245 | 1.418605 | 3.47558225 | root | 1 | Root_unresolved | Root_unresolved | 90.1 | 1.99e-20 | NR | MCK5347511.1 | 2026747 | g685398 | i0 | 51.9 | 1.93469387755102 | 81 | 33 | 91.8 | 1 | 19 | 243 | 85 | 165 | MCK5347511.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 474 | 90.1 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30197057 | 30197057 | PRJNA1148190_P_NODE_240832_length_348_cov_2.240000_g229662_i0 | PRJNA1148190 | 240832 | 348 | 2.24 | 7.7952 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 57.8 | 5.12e-8 | NR | MCE7739988.1 | 2026747 | g229662 | i0 | 37 | 0.698275862068966 | 81 | 47 | 69 | 2 | 329 | 90 | 33 | 110 | MCE7739988.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 243 | 57.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30387437 | 30387437 | PRJNA1148190_P_NODE_361213_length_296_cov_1.955157_g350040_i0 | PRJNA1148190 | 361213 | 296 | 1.955157 | 5.78726472 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 71.6 | 1.44e-13 | NR | MCK5344108.1 | 2026747 | g350040 | i0 | 42.2 | 0.841216216216216 | 83 | 44 | 84.1 | 2 | 296 | 48 | 34 | 112 | MCK5344108.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 249 | 71.6 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30735329 | 30735329 | PRJNA1148190_P_NODE_97694_length_541_cov_3.027778_g86541_i0 | PRJNA1148190 | 97694 | 541 | 3.027778 | 16.38027898 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 92.8 | 1.58e-20 | NR | HUT87313.1 | 2026747 | g86541 | i0 | 48.5 | 0.548983364140481 | 99 | 50 | 54.3 | 1 | 295 | 2 | 27 | 125 | HUT87313.1 co-chaperone GroES [Candidatus Heimdallarchaeota archaeon] | diamond | 297 | 92.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31967701 | 31967701 | PRJNA1148190_P_NODE_455718_length_275_cov_1.524752_g444545_i0 | PRJNA1148190 | 455718 | 275 | 1.524752 | 4.193068 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 96.7 | 4.19e-22 | NR | MFV2016890.1 | 2026747 | g444545 | i0 | 48.4 | 0.992727272727273 | 91 | 47 | 99.3 | 0 | 2 | 274 | 100 | 190 | MFV2016890.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 273 | 96.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32241127 | 32241127 | PRJNA1148190_P_NODE_235878_length_351_cov_1.902878_g224708_i0 | PRJNA1148190 | 235878 | 351 | 1.902878 | 6.67910178 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 0.00108 | NR | MCK5344483.1 | 2026747 | g224708 | i0 | 32.1 | 1.25641025641026 | 81 | 52 | 66.7 | 1 | 295 | 62 | 294 | 374 | MCK5344483.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 441 | 48.5 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32694395 | 32694395 | PRJNA1148190_P_NODE_215300_length_365_cov_1.054795_g204130_i0 | PRJNA1148190 | 215300 | 365 | 1.054795 | 3.85000175 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 72.4 | 1.4e-12 | NR | MDH5401859.1 | 2026747 | g204130 | i0 | 34.4 | 0.73972602739726 | 90 | 59 | 74 | 0 | 327 | 58 | 135 | 224 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 270 | 72.4 | 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);;