contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16156006 | 16156006 | PRJNA876641_P_NODE_5693_length_336_cov_1.171103_g5619_i0 | PRJNA876641 | 5693 | 336 | 1.171103 | 3.93490608 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 171 | 5.64e-50 | NR | MCH8905814.1 | 2026747 | g5619 | i0 | 74.1 | 5.94642857142857 | 112 | 27 | 99.1 | 2 | 3 | 335 | 105 | 215 | MCH8905814.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Heimdallarchaeota archaeon] | diamond | 1998 | 171 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27687446 | 27687446 | PRJNA876641_P_NODE_17424_length_249_cov_0.875000_g17350_i0 | PRJNA876641 | 17424 | 249 | 0.875 | 2.17875 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 73.6 | 4.18e-13 | NR | MCE7735028.1 | 2026747 | g17350 | i0 | 50.7 | 0.855421686746988 | 71 | 35 | 85.5 | 0 | 229 | 17 | 5 | 75 | MCE7735028.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 213 | 73.6 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27844772 | 27844772 | PRJNA876641_P_NODE_18984_length_247_cov_0.885057_g18910_i0 | PRJNA876641 | 18984 | 247 | 0.885057 | 2.18609079 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 56.2 | 5.58e-8 | NR | MCK4383457.1 | 2053489 | g18910 | i0 | 39.7 | 1.4331983805668 | 73 | 42 | 88.7 | 2 | 12 | 230 | 23 | 93 | MCK4383457.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 354 | 56.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28855127 | 28855127 | PRJNA876641_P_NODE_15848_length_251_cov_0.865169_g15774_i0 | PRJNA876641 | 15848 | 251 | 0.865169 | 2.17157419 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 65.1 | 1.38e-10 | NR | MBN1328499.1 | 2026747 | g15774 | i0 | 50 | 4.8406374501992 | 54 | 27 | 64.5 | 0 | 73 | 234 | 138 | 191 | MBN1328499.1 DUF1917 domain-containing protein [Candidatus Heimdallarchaeota archaeon] | diamond | 1215 | 65.1 | 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);;