contig_metadata
12 rows where bioproject = "PRJNA594101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26763244 | 26763244 | PRJNA594101_S_NODE_40281_length_274_cov_1.532338_g39979_i0 | PRJNA594101 | 40281 | 274 | 1.532338 | 4.19860612 | Candidatus Lokiarchaeum sp. GC14_75 | 1538547 | Archaea | Archaea | 48.1 | 3.75e-4 | NR | KKK45081.1 | 1538547 | g39979 | i0 | 48.8 | 0.470802919708029 | 43 | 22 | 47.1 | 0 | 70 | 198 | 140 | 182 | KKK45081.1 MAG: small GTP-binding domain protein [Candidatus Lokiarchaeum sp. GC14_75] | diamond | 129 | 48.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Lokiarchaeum | Candidatus Lokiarchaeum sp. GC14_75 | ||
| 27079735 | 27079735 | PRJNA594101_S_NODE_14062_length_441_cov_1.983696_g13760_i0 | PRJNA594101 | 14062 | 441 | 1.983696 | 8.74809936 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 67 | 1.03e-9 | NR | MDH5403417.1 | 2026747 | g13760 | i0 | 37.6 | 0.63265306122449 | 93 | 56 | 63.3 | 2 | 34 | 312 | 297 | 387 | MDH5403417.1 pre-peptidase C-terminal domain-containing protein [Candidatus Heimdallarchaeota archaeon] | diamond | 279 | 67 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27806479 | 27806479 | PRJNA594101_S_NODE_19124_length_382_cov_1.718447_g18822_i0 | PRJNA594101 | 19124 | 382 | 1.718447 | 6.56446754 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 44.7 | 0.0336 | NR | MBY8984010.1 | 2053489 | g18822 | i0 | 29.3 | 0.643979057591623 | 82 | 52 | 59.7 | 1 | 247 | 20 | 164 | 245 | MBY8984010.1 orotidine 5'-phosphate decarboxylase [Promethearchaeota archaeon] | diamond | 246 | 44.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28879719 | 28879719 | PRJNA594101_S_NODE_3408_length_861_cov_4.258883_g3165_i0 | PRJNA594101 | 3408 | 861 | 4.258883 | 36.66898263 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 155 | 2.3e-42 | NR | MDH5401859.1 | 2026747 | g3165 | i0 | 37.2 | 0.777003484320557 | 223 | 138 | 77.7 | 1 | 843 | 175 | 8 | 228 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 669 | 155 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29006495 | 29006495 | PRJNA594101_S_NODE_11368_length_488_cov_1.559036_g11067_i0 | PRJNA594101 | 11368 | 488 | 1.559036 | 7.60809568 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 89.7 | 9.34e-19 | NR | MBD3254099.1 | 2053489 | g11067 | i0 | 33.3 | 1.88114754098361 | 153 | 98 | 94.1 | 1 | 460 | 2 | 25 | 173 | MBD3254099.1 TATA-box-binding protein [Promethearchaeota archaeon] | diamond | 918 | 89.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29890367 | 29890367 | PRJNA594101_S_NODE_31731_length_305_cov_1.327586_g31429_i0 | PRJNA594101 | 31731 | 305 | 1.327586 | 4.0491373 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 42 | 0.0225 | NR | MEJ2295707.1 | 2053489 | g31429 | i0 | 47.1 | 0.334426229508197 | 34 | 18 | 33.4 | 0 | 11 | 112 | 39 | 72 | MEJ2295707.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 102 | 42 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29921949 | 29921949 | PRJNA594101_S_NODE_37711_length_283_cov_0.938095_g37409_i0 | PRJNA594101 | 37711 | 283 | 0.938095 | 2.65480885 | Candidatus Heimdallarchaeota archaeon LC_2 | 1841597 | Archaea | Archaea | 44.7 | 0.0125 | NR | OLS20773.1 | 1841597 | g37409 | i0 | 39.1 | 0.487632508833922 | 46 | 28 | 48.8 | 0 | 61 | 198 | 12 | 57 | OLS20773.1 MAG: hypothetical protein HeimC2_35920 [Candidatus Heimdallarchaeota archaeon LC_2] | diamond | 138 | 44.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon LC_2 | ||||||
| 30079594 | 30079594 | PRJNA594101_S_NODE_40812_length_272_cov_2.236181_g40510_i0 | PRJNA594101 | 40812 | 272 | 2.236181 | 6.08241232 | Candidatus Odinarchaeota archaeon | 2053490 | Archaea | Archaea | 93.2 | 4.49e-20 | NR | MCD6513866.1 | 2053490 | g40510 | i0 | 62 | 7.08088235294118 | 71 | 27 | 78.3 | 0 | 9 | 221 | 135 | 205 | MCD6513866.1 actin family protein [Candidatus Odinarchaeota archaeon] | diamond | 1926 | 93.2 | 1 | Archaea | Promethearchaeati | Candidatus Odinarchaeota | Candidatus Odinarchaeota archaeon | ||||||
| 30901345 | 30901345 | PRJNA594101_S_NODE_51854_length_247_cov_1.718391_g51552_i0 | PRJNA594101 | 51854 | 247 | 1.718391 | 4.24442577 | Candidatus Freyrarchaeum guaymasense | 3036978 | Archaea | Archaea | 65.5 | 1.23e-10 | NR | MEX2706285.1 | 3036978 | g51552 | i0 | 38.5 | 0.947368421052632 | 78 | 47 | 93.5 | 1 | 234 | 4 | 19 | 96 | MEX2706285.1 Rab family GTPase [Candidatus Freyrarchaeum guaymaensis] | diamond | 234 | 65.5 | 1 | Archaea | Promethearchaeati | Candidatus Freyarchaeota | Candidatus Freyrarchaeia | Candidatus Freyrarchaeales | Candidatus Freyrarchaeaceae | Candidatus Freyrarchaeum | Candidatus Freyrarchaeum guaymasense | ||
| 31167105 | 31167105 | PRJNA594101_S_NODE_24595_length_341_cov_1.149254_g24293_i0 | PRJNA594101 | 24595 | 341 | 1.149254 | 3.91895614 | Candidatus Freyarchaeota | 2827219 | Archaea | Archaea | 43.9 | 0.0244 | NR | MEX2704099.1 | 3036978 | g24293 | i0 | 61 | 0.721407624633431 | 41 | 15 | 36.1 | 1 | 6 | 128 | 133 | 172 | MEX2704099.1 GTP-binding protein [Candidatus Freyrarchaeum guaymaensis] | diamond | 246 | 43.9 | 1 | Archaea | Promethearchaeati | Candidatus Freyarchaeota | Candidatus Freyrarchaeia | Candidatus Freyrarchaeales | Candidatus Freyrarchaeaceae | Candidatus Freyrarchaeum | Candidatus Freyrarchaeum guaymasense | ||
| 31913067 | 31913067 | PRJNA594101_S_NODE_4497_length_761_cov_3.428779_g4225_i0 | PRJNA594101 | 4497 | 761 | 3.428779 | 26.09300819 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 155 | 8.179999999999999e-43 | NR | MDH5401859.1 | 2026747 | g4225 | i0 | 36.6 | 0.839684625492773 | 213 | 133 | 83.6 | 2 | 732 | 97 | 10 | 221 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 639 | 155 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32071275 | 32071275 | PRJNA594101_S_NODE_51598_length_248_cov_0.880000_g51296_i0 | PRJNA594101 | 51598 | 248 | 0.88 | 2.1824 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 54.3 | 3.22e-6 | NR | TFF94460.1 | 2053489 | g51296 | i0 | 50 | 2.78225806451613 | 54 | 27 | 65.3 | 0 | 219 | 58 | 90 | 143 | TFF94460.1 MAG: MFS transporter [Promethearchaeota archaeon] | diamond | 690 | 54.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota 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);;