contig_metadata
7 rows where bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29159070 | 29159070 | PRJNA340009_P_NODE_14029_length_314_cov_8.539623_g13722_i0 | PRJNA340009 | 14029 | 314 | 8.539623 | 26.81441622 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 52.4 | 7.51e-6 | NR | MEE9379621.1 | 3067280 | g13722 | i0 | 35.6 | 0.993630573248408 | 104 | 54 | 86.9 | 3 | 289 | 17 | 33 | 136 | MEE9379621.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 312 | 52.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29348502 | 29348502 | PRJNA340009_P_NODE_69649_length_164_cov_0.886957_g69342_i0 | PRJNA340009 | 69649 | 164 | 0.886957 | 1.45460948 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 75.9 | 2.06e-14 | NR | TFH10489.1 | 2053491 | g69342 | i0 | 70.4 | 0.98780487804878 | 54 | 15 | 98.8 | 1 | 163 | 2 | 216 | 268 | TFH10489.1 MAG: AAA family ATPase [Candidatus Thorarchaeota archaeon] | diamond | 162 | 75.9 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 30454087 | 30454087 | PRJNA340009_P_NODE_45753_length_190_cov_1.446809_g45446_i0 | PRJNA340009 | 45753 | 190 | 1.446809 | 2.7489371 | Candidatus Jordarchaeia archaeon | 3067279 | Archaea | Archaea | 57.4 | 1.26e-7 | NR | MBS7251858.1 | 3067279 | g45446 | i0 | 63.8 | 0.742105263157895 | 47 | 16 | 72.6 | 1 | 190 | 53 | 135 | 181 | MBS7251858.1 hypothetical protein [Candidatus Jordarchaeia archaeon] | diamond | 141 | 57.4 | 1 | Archaea | Promethearchaeati | Candidatus Jordarchaeia | Candidatus Jordarchaeia archaeon | ||||||
| 30485482 | 30485482 | PRJNA340009_P_NODE_29093_length_230_cov_1.558011_g28786_i0 | PRJNA340009 | 29093 | 230 | 1.558011 | 3.5834253 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 45.1 | 0.00355 | NR | MBY8996691.1 | 2053491 | g28786 | i0 | 40.9 | 0.573913043478261 | 44 | 26 | 57.4 | 0 | 59 | 190 | 156 | 199 | MBY8996691.1 hypothetical protein [Candidatus Thorarchaeota archaeon] | diamond | 132 | 45.1 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 31022631 | 31022631 | PRJNA340009_P_NODE_29335_length_229_cov_2.188889_g29028_i0 | PRJNA340009 | 29335 | 229 | 2.188889 | 5.01255581 | Candidatus Asgardarchaeum californiense | 3067292 | Archaea | Archaea | 51.6 | 1.94e-5 | NR | RLI65941.1 | 3067292 | g29028 | i0 | 45.9 | 1.67685589519651 | 61 | 30 | 79.9 | 1 | 12 | 194 | 38 | 95 | RLI65941.1 MAG: hypothetical protein DRO67_01925 [Candidatus Asgardarchaeum californiense] | diamond | 384 | 51.6 | 1 | Archaea | Promethearchaeati | Candidatus Asgardarchaeia (ex Tamarit et al. 2024) | Candidatus Asgardarchaeales (ex Tamarit et al. 2024) | Candidatus Asgardarchaeaceae | Candidatus Asgardarchaeum (ex Tamarit et al. 2024) | Candidatus Asgardarchaeum californiense | |||
| 31908034 | 31908034 | PRJNA340009_P_NODE_76957_length_161_cov_0.910714_g76650_i0 | PRJNA340009 | 76957 | 161 | 0.910714 | 1.46624954 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 65.1 | 3.77e-12 | NR | MBD3197985.1 | 2053489 | g76650 | i0 | 55.8 | 0.968944099378882 | 52 | 22 | 96.9 | 1 | 161 | 6 | 29 | 79 | MBD3197985.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 156 | 65.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32129676 | 32129676 | PRJNA340009_P_NODE_18498_length_279_cov_3.391304_g18191_i0 | PRJNA340009 | 18498 | 279 | 3.391304 | 9.46173816 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 102 | 8.0699999999999994e-23 | NR | MBY9010503.1 | 2053489 | g18191 | i0 | 52.7 | 2.97849462365591 | 93 | 43 | 98.9 | 1 | 278 | 3 | 406 | 498 | MBY9010503.1 thioredoxin domain-containing protein [Promethearchaeota archaeon] | diamond | 831 | 102 | 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);;