contig_metadata
8 rows where bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27084583 | 27084583 | PRJNA756891_P_NODE_15502_length_243_cov_0.905882_g15433_i0 | PRJNA756891 | 15502 | 243 | 0.905882 | 2.20129326 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 55.1 | 1.62e-6 | NR | MCE7735028.1 | 2026747 | g15433 | i0 | 37 | 1.80246913580247 | 73 | 40 | 90.1 | 2 | 25 | 243 | 255 | 321 | MCE7735028.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 438 | 55.1 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27432423 | 27432423 | PRJNA756891_P_NODE_6083_length_346_cov_1.128205_g6014_i0 | PRJNA756891 | 6083 | 346 | 1.128205 | 3.9035893 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 60.8 | 5.17e-8 | NR | MCE7735885.1 | 2026747 | g6014 | i0 | 30.9 | 0.953757225433526 | 110 | 71 | 95.4 | 1 | 337 | 8 | 281 | 385 | MCE7735885.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 330 | 60.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30821092 | 30821092 | PRJNA756891_P_NODE_10374_length_272_cov_1.160804_g10305_i0 | PRJNA756891 | 10374 | 272 | 1.160804 | 3.15738688 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 5.51e-6 | NR | MCY3414232.1 | 2026747 | g10305 | i0 | 45.8 | 2.66911764705882 | 59 | 31 | 65.1 | 1 | 95 | 271 | 4 | 61 | MCY3414232.1 threonine/serine dehydratase [Candidatus Heimdallarchaeota archaeon] | diamond | 726 | 53.9 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31664659 | 31664659 | PRJNA756891_P_NODE_11977_length_252_cov_1.290503_g11908_i0 | PRJNA756891 | 11977 | 252 | 1.290503 | 3.25206756 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 50.8 | 5.67e-5 | NR | MCE7735028.1 | 2026747 | g11908 | i0 | 37.7 | 0.726190476190476 | 61 | 37 | 72.6 | 1 | 67 | 249 | 292 | 351 | MCE7735028.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 183 | 50.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31917852 | 31917852 | PRJNA756891_P_NODE_12137_length_251_cov_0.865169_g12068_i0 | PRJNA756891 | 12137 | 251 | 0.865169 | 2.17157419 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 45.1 | 0.00614 | NR | MCE7735883.1 | 2026747 | g12068 | i0 | 36.5 | 1.80478087649402 | 74 | 44 | 84.9 | 2 | 6 | 218 | 314 | 387 | MCE7735883.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 453 | 45.1 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32297930 | 32297930 | PRJNA756891_P_NODE_11959_length_252_cov_1.463687_g11890_i0 | PRJNA756891 | 11959 | 252 | 1.463687 | 3.68849124 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 47.4 | 9.36e-4 | NR | MCE7735885.1 | 2026747 | g11890 | i0 | 37.7 | 0.821428571428571 | 69 | 41 | 82.1 | 1 | 209 | 3 | 347 | 413 | MCE7735885.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 207 | 47.4 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32644905 | 32644905 | PRJNA756891_P_NODE_6940_length_326_cov_1.324111_g6871_i0 | PRJNA756891 | 6940 | 326 | 1.324111 | 4.31660186 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 95.9 | 1.22e-20 | NR | MCE7744595.1 | 2026747 | g6871 | i0 | 44.4 | 0.993865030674847 | 108 | 60 | 99.4 | 0 | 1 | 324 | 225 | 332 | MCE7744595.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 324 | 95.9 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32739801 | 32739801 | PRJNA756891_P_NODE_40_length_2495_cov_7.151528_g33_i0 | PRJNA756891 | 40 | 2495 | 7.151528 | 178.4306236 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 194 | 2.39e-50 | NR | MCE7735885.1 | 2026747 | g33 | i0 | 29.3 | 0.512224448897796 | 426 | 279 | 50.9 | 9 | 2426 | 1158 | 23 | 429 | MCE7735885.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 1278 | 194 | 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);;