contig_metadata
3 rows where bioproject = "PRJNA270367", tax_phylum = "Candidatus Heimdallarchaeota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26996705 | 26996705 | PRJNA270367_P_NODE_30042_length_203_cov_2.025974_g29837_i0 | PRJNA270367 | 30042 | 203 | 2.025974 | 4.11272722 | Promethearchaeati | 1935183 | Archaea | Archaea | 90.5 | 3.1400000000000002e-19 | NR | NHJ04299.1 | 2026747 | g29837 | i0 | 61.2 | 6.93103448275862 | 67 | 24 | 99 | 1 | 202 | 2 | 456 | 520 | NHJ04299.1 elongation factor 1-alpha [Candidatus Heimdallarchaeota archaeon] | diamond | 1407 | 90.9 | 0.995599559955996 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27944649 | 27944649 | PRJNA270367_P_NODE_23625_length_239_cov_1.642105_g23420_i0 | PRJNA270367 | 23625 | 239 | 1.642105 | 3.92463095 | Promethearchaeati | 1935183 | Archaea | Archaea | 103 | 8.27e-24 | NR | MBN1329488.1 | 2026747 | g23420 | i0 | 57 | 2.97489539748954 | 79 | 34 | 99.2 | 0 | 238 | 2 | 265 | 343 | MBN1329488.1 elongation factor 1-alpha [Candidatus Heimdallarchaeota archaeon] | diamond | 711 | 103 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 28874030 | 28874030 | PRJNA270367_P_NODE_2748_length_834_cov_2.332484_g2574_i0 | PRJNA270367 | 2748 | 834 | 2.332484 | 19.45291656 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 55.8 | 9.22e-6 | NR | MCG3226821.1 | 2026747 | g2574 | i0 | 28.7 | 0.834532374100719 | 115 | 69 | 36.7 | 2 | 492 | 797 | 6 | 120 | MCG3226821.1 single-stranded DNA-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 696 | 55.8 | 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);;