contig_metadata
4 rows where bioproject = "PRJNA890871" and tax_clade = "Candidatus Pacearchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27213407 | 27213407 | PRJNA890871_P_NODE_64022_length_251_cov_0.865169_g63887_i0 | PRJNA890871 | 64022 | 251 | 0.865169 | 2.17157419 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 53.1 | 1.16e-6 | NR | MCK5610392.1 | 2026773 | g63887 | i0 | 62.2 | 0.442231075697211 | 37 | 14 | 44.2 | 0 | 251 | 141 | 23 | 59 | MCK5610392.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 111 | 53.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30181826 | 30181826 | PRJNA890871_P_NODE_1732_length_1406_cov_5.355589_g1626_i0 | PRJNA890871 | 1732 | 1406 | 5.355589 | 75.29958134 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 79.3 | 4.62e-12 | NR | MFA5484894.1 | 2026773 | g1626 | i0 | 38.9 | 0.230440967283073 | 108 | 60 | 22.2 | 2 | 1405 | 1094 | 244 | 349 | MFA5484894.1 RNA ligase family protein [Candidatus Pacearchaeota archaeon] | diamond | 324 | 79.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 31287729 | 31287729 | PRJNA890871_P_NODE_81435_length_243_cov_0.905882_g81300_i0 | PRJNA890871 | 81435 | 243 | 0.905882 | 2.20129326 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 43.1 | 0.0258 | NR | MCK5615744.1 | 2026773 | g81300 | i0 | 53.1 | 0.395061728395062 | 32 | 15 | 39.5 | 0 | 146 | 241 | 1 | 32 | MCK5615744.1 major capsid protein [Candidatus Pacearchaeota archaeon] | diamond | 96 | 43.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32363651 | 32363651 | PRJNA890871_P_NODE_1979_length_1243_cov_3.142735_g1864_i0 | PRJNA890871 | 1979 | 1243 | 3.142735 | 39.06419605 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 73.6 | 9.5e-12 | NR | MAG25176.1 | 2026773 | g1864 | i0 | 40.5 | 0.279967819790829 | 116 | 46 | 22.7 | 4 | 687 | 968 | 15 | 129 | MAG25176.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 348 | 73.6 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota 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);;