contig_metadata
9 rows where bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26861276 | 26861276 | PRJNA690592_S_NODE_148901_length_278_cov_1.126829_g147887_i0 | PRJNA690592 | 148901 | 278 | 1.126829 | 3.13258462 | Candidatus Heimdallarchaeota archaeon LC_3 | 1841598 | Archaea | Archaea | 115 | 9.04e-29 | NR | OLS21962.1 | 1841598 | g147887 | i0 | 61.5 | 1.96402877697842 | 91 | 32 | 98.2 | 1 | 277 | 5 | 55 | 142 | OLS21962.1 MAG: Ornithine carbamoyltransferase [Candidatus Heimdallarchaeota archaeon LC_3] | diamond | 546 | 115 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon LC_3 | ||||||
| 28503694 | 28503694 | PRJNA690592_S_NODE_65927_length_390_cov_1.438486_g64913_i0 | PRJNA690592 | 65927 | 390 | 1.438486 | 5.6100954 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 130 | 1.4399999999999999e-32 | NR | MCG3218901.1 | 2026747 | g64913 | i0 | 59.3 | 1.8 | 113 | 45 | 86.9 | 1 | 30 | 368 | 196 | 307 | MCG3218901.1 glutamine-hydrolyzing GMP synthase [Candidatus Heimdallarchaeota archaeon] | diamond | 702 | 130 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29734665 | 29734665 | PRJNA690592_S_NODE_14290_length_777_cov_12.302557_g13417_i0 | PRJNA690592 | 14290 | 777 | 12.302557 | 95.59086789 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 149 | 3.35e-40 | NR | MDH5401859.1 | 2026747 | g13417 | i0 | 36.1 | 0.876447876447876 | 227 | 140 | 87.6 | 2 | 9 | 689 | 5 | 226 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 681 | 149 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29893068 | 29893068 | PRJNA690592_S_NODE_111791_length_313_cov_1.662500_g110777_i0 | PRJNA690592 | 111791 | 313 | 1.6625 | 5.203625 | Candidatus Heimdallarchaeota archaeon LC_2 | 1841597 | Archaea | Archaea | 63.9 | 2.96e-9 | NR | OLS20167.1 | 1841597 | g110777 | i0 | 36.4 | 1.67731629392971 | 88 | 47 | 80.5 | 2 | 266 | 15 | 521 | 603 | OLS20167.1 MAG: hypothetical protein HeimC2_38570 [Candidatus Heimdallarchaeota archaeon LC_2] | diamond | 525 | 63.9 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon LC_2 | ||||||
| 30441537 | 30441537 | PRJNA690592_S_NODE_14453_length_773_cov_4.208571_g13576_i0 | PRJNA690592 | 14453 | 773 | 4.208571 | 32.53225383 | root | 1 | Root_unresolved | Root_unresolved | 150 | 1.29e-40 | NR | MDH5401349.1 | 2026747 | g13576 | i0 | 38.4 | 2.57697283311772 | 216 | 129 | 83.1 | 3 | 83 | 724 | 18 | 231 | MDH5401349.1 DNA alkylation repair protein [Candidatus Heimdallarchaeota archaeon] | diamond | 1992 | 150 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31346521 | 31346521 | PRJNA690592_S_NODE_16516_length_728_cov_13.593893_g15601_i0 | PRJNA690592 | 16516 | 728 | 13.593893 | 98.96354104 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 152 | 1.29e-41 | NR | MDH5401859.1 | 2026747 | g15601 | i0 | 34.3 | 1.81318681318681 | 213 | 138 | 87.4 | 2 | 702 | 67 | 10 | 221 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 1320 | 152 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32422070 | 32422070 | PRJNA690592_S_NODE_186759_length_251_cov_0.865169_g185745_i0 | PRJNA690592 | 186759 | 251 | 0.865169 | 2.17157419 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 72.4 | 3.61e-13 | NR | MDH5401859.1 | 2026747 | g185745 | i0 | 53.2 | 0.741035856573705 | 62 | 29 | 74.1 | 0 | 187 | 2 | 130 | 191 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 186 | 72.4 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32433677 | 32433677 | PRJNA690592_S_NODE_140079_length_285_cov_1.518868_g139065_i0 | PRJNA690592 | 140079 | 285 | 1.518868 | 4.3287738 | Promethearchaeati | 1935183 | Archaea | Archaea | 62.8 | 2.96e-9 | NR | RLI71604.1 | 2026747 | g139065 | i0 | 44.8 | 3.55789473684211 | 67 | 36 | 69.5 | 1 | 285 | 88 | 176 | 242 | RLI71604.1 MAG: GTP-binding protein, partial [Candidatus Heimdallarchaeota archaeon] | diamond | 1014 | 62.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32706103 | 32706103 | PRJNA690592_S_NODE_91460_length_339_cov_2.830827_g90446_i0 | PRJNA690592 | 91460 | 339 | 2.830827 | 9.59650353 | Candidatus Heimdallarchaeota archaeon LC_3 | 1841598 | Archaea | Archaea | 46.6 | 0.00258 | NR | OLS24410.1 | 1841598 | g90446 | i0 | 36.7 | 0.699115044247788 | 79 | 38 | 69 | 3 | 238 | 5 | 75 | 142 | OLS24410.1 MAG: Transforming protein p29 precursor [Candidatus Heimdallarchaeota archaeon LC_3] | diamond | 237 | 46.6 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon LC_3 |
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);;