contig_metadata
8 rows where bioproject = "PRJNA1073005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16763893 | 16763893 | PRJNA1073005_P_NODE_5074_length_422_cov_2.206304_g4955_i0 | PRJNA1073005 | 5074 | 422 | 2.206304 | 9.31060288 | Orpinomyces sp. OUS1 | 301046 | Fungi | Fungi | 137 | 1.09e-27 | NTclustered | gi|55859492|emb|AJ864475.1| | 301046 | g4955 | i0 | 85.714 | 24.9763033175355 | 133 | 15 | 31 | 4 | 291 | 421 | 4720 | 4590 | Orpinomyces sp. OUS1 partial 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and partial 28S rRNA, clone V5-1 | blastn | 10540 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Orpinomyces | Orpinomyces sp. OUS1 | |
| 24412897 | 24412897 | PRJNA1073005_P_NODE_9560_length_247_cov_0.885057_g9441_i0 | PRJNA1073005 | 9560 | 247 | 0.885057 | 2.18609079 | Fungi | 4751 | Fungi | Fungi | 144 | 5.68e-38 | NR | TPX74221.1 | 246404 | g9441 | i0 | 80.5 | 10.7975708502024 | 82 | 16 | 99.6 | 0 | 1 | 246 | 807 | 888 | TPX74221.1 hypothetical protein CcCBS67573_g04511 [Chytriomyces confervae] | diamond | 2667 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 27193701 | 27193701 | PRJNA1073005_P_NODE_5382_length_404_cov_1.395770_g5263_i0 | PRJNA1073005 | 5382 | 404 | 1.39577 | 5.6389108 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 120 | 1.71e-30 | NR | KAI8909765.1 | 382530 | g5263 | i0 | 52.7 | 2.87376237623762 | 129 | 51 | 92.8 | 4 | 1 | 375 | 137 | 259 | KAI8909765.1 ribosomal protein S2, flavodoxin-like domain-containing protein [Gorgonomyces haynaldii] | diamond | 1161 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 28574755 | 28574755 | PRJNA1073005_P_NODE_5347_length_406_cov_1.387387_g5228_i0 | PRJNA1073005 | 5347 | 406 | 1.387387 | 5.63279122 | Fungi | 4751 | Fungi | Fungi | 210 | 1.11e-65 | NR | KAI9014143.1 | 82268 | g5228 | i0 | 74 | 28.9581280788177 | 131 | 34 | 96.8 | 0 | 13 | 405 | 1 | 131 | KAI9014143.1 ribosomal family S4e-domain-containing protein [Hyaloraphidium curvatum] | diamond | 11757 | 211 | 0.995260663507109 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30067314 | 30067314 | PRJNA1073005_P_NODE_9052_length_250_cov_1.502825_g8933_i0 | PRJNA1073005 | 9052 | 250 | 1.502825 | 3.7570625 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 46.6 | 0.00163 | NR | KAJ3175031.1 | 2724198 | g8933 | i0 | 67.7 | 0.372 | 31 | 8 | 37.2 | 1 | 248 | 156 | 284 | 312 | KAJ3175031.1 F-actin-capping protein subunit alpha, partial [Gaertneriomyces sp. JEL0708] | diamond | 93 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 31132860 | 31132860 | PRJNA1073005_P_NODE_10335_length_241_cov_0.916667_g10216_i0 | PRJNA1073005 | 10335 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | Fungi | Fungi | 60.5 | 1.7e-9 | NR | XP_052966054.1 | 110093 | g10216 | i0 | 47.4 | 7.73029045643154 | 78 | 33 | 97.1 | 3 | 240 | 7 | 12 | 81 | XP_052966054.1 ribosomal L28e/Mak16 [Polychytrium aggregatum] | diamond | 1863 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 31481332 | 31481332 | PRJNA1073005_P_NODE_8516_length_265_cov_1.276042_g8397_i0 | PRJNA1073005 | 8516 | 265 | 1.276042 | 3.3815113 | root | 1 | Root_unresolved | Root_unresolved | 155 | 1.6099999999999996e-41 | NR | KAI8815042.1 | 109936 | g8397 | i0 | 76.1 | 9.7811320754717 | 88 | 20 | 98.5 | 1 | 263 | 3 | 466 | 553 | KAI8815042.1 GTP-utilizing phosphoenolpyruvate carboxykinase [Cladochytrium replicatum] | diamond | 2592 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 31733843 | 31733843 | PRJNA1073005_P_NODE_6437_length_350_cov_1.111913_g6318_i0 | PRJNA1073005 | 6437 | 350 | 1.111913 | 3.8916955 | Chytridiomycetes | 451435 | Fungi | Fungi | 88.6 | 1.07e-17 | NR | KAJ3233940.1 | 4814 | g6318 | i0 | 41.9 | 3.6 | 105 | 60 | 89.1 | 1 | 312 | 1 | 30 | 134 | KAJ3233940.1 hypothetical protein HDU77_000507, partial [Chytriomyces hyalinus] | diamond | 1260 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus |
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);;