contig_metadata
8 rows where bioproject = "PRJNA983838", tax_clade = "Opisthokonta" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2240463 | 2240463 | PRJNA983838_P_NODE_4062_length_2401_cov_7.402921_g3594_i0 | PRJNA983838 | 4062 | 2401 | 7.402921 | 177.74413321 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 1082 | 0 | NR | KAI8903400.1 | 382530 | g3594 | i0 | 70.6 | 6.99333610995419 | 797 | 224 | 99 | 5 | 2 | 2377 | 219 | 1010 | KAI8903400.1 elongation factor EF-3 [Gorgonomyces haynaldii] | diamond | 16791 | 1082 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 27879213 | 27879213 | PRJNA983838_P_NODE_87165_length_283_cov_2.600000_g84798_i0 | PRJNA983838 | 87165 | 283 | 2.6 | 7.358 | Batrachochytrium dendrobatidis JAM81 | 684364 | Fungi | Fungi | 64.3 | 5.07e-10 | NR | XP_006681545.1 | 684364 | g84798 | i0 | 77.1 | 2.09893992932862 | 35 | 8 | 37.1 | 0 | 282 | 178 | 179 | 213 | XP_006681545.1 uncharacterized protein BATDEDRAFT_91122 [Batrachochytrium dendrobatidis JAM81] | diamond | 594 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 28068618 | 28068618 | PRJNA983838_P_NODE_65685_length_347_cov_1.138686_g63318_i0 | PRJNA983838 | 65685 | 347 | 1.138686 | 3.95124042 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 103 | 6.68e-24 | NR | KAI9018341.1 | 82268 | g63318 | i0 | 48.1 | 0.899135446685879 | 104 | 51 | 89 | 2 | 311 | 3 | 135 | 236 | KAI9018341.1 methyltransferase domain-containing protein [Hyaloraphidium curvatum] | diamond | 312 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30437361 | 30437361 | PRJNA983838_P_NODE_95833_length_267_cov_1.463918_g93466_i0 | PRJNA983838 | 95833 | 267 | 1.463918 | 3.90866106 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 82 | 5.4e-16 | NR | KAH9255253.1 | 1357716 | g93466 | i0 | 54.5 | 0.741573033707865 | 66 | 30 | 74.2 | 0 | 261 | 64 | 317 | 382 | KAH9255253.1 hypothetical protein BASA81_006693 [Batrachochytrium salamandrivorans] | diamond | 198 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31037720 | 31037720 | PRJNA983838_P_NODE_91435_length_275_cov_1.544554_g89068_i0 | PRJNA983838 | 91435 | 275 | 1.544554 | 4.2475235 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 77.8 | 1.06e-14 | NR | KAI9023467.1 | 82268 | g89068 | i0 | 39.3 | 2.83636363636364 | 89 | 53 | 96 | 1 | 1 | 264 | 155 | 243 | KAI9023467.1 dienelactone hydrolase family-domain-containing protein [Hyaloraphidium curvatum] | diamond | 780 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 31137885 | 31137885 | PRJNA983838_P_NODE_58775_length_378_cov_1.304918_g56408_i0 | PRJNA983838 | 58775 | 378 | 1.304918 | 4.93259004 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 1.89e-8 | NR | KAI9318861.1 | 110081 | g56408 | i0 | 33.1 | 1.8015873015873 | 121 | 63 | 81.7 | 1 | 1 | 309 | 61 | 181 | KAI9318861.1 hypothetical protein BDR26DRAFT_409796 [Obelidium mucronatum] | diamond | 681 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Obelidium | Obelidium mucronatum | |
| 31422762 | 31422762 | PRJNA983838_P_NODE_90916_length_276_cov_1.536946_g88549_i0 | PRJNA983838 | 90916 | 276 | 1.536946 | 4.24197096 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 7.55e-5 | NR | OAJ37111.1 | 403673 | g88549 | i0 | 30.8 | 1.55434782608696 | 78 | 54 | 84.8 | 0 | 42 | 275 | 69 | 146 | OAJ37111.1 hypothetical protein BDEG_21176 [Batrachochytrium dendrobatidis JEL423] | diamond | 429 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 32649862 | 32649862 | PRJNA983838_P_NODE_95940_length_267_cov_1.206186_g93573_i0 | PRJNA983838 | 95940 | 267 | 1.206186 | 3.22051662 | Neocallimastix lanati (nom. inval.) | 2767002 | Fungi | Fungi | 49.3 | 2.14e-4 | NR | KAG4096126.1 | 2767002 | g93573 | i0 | 33.3 | 2.74157303370787 | 78 | 44 | 85.4 | 2 | 5 | 232 | 30 | 101 | KAG4096126.1 PAC2 family-domain-containing protein [Neocallimastix lanati (nom. inval.)] | diamond | 732 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix lanati (nom. inval.) |
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);;