contig_metadata
7 rows where bioproject = "PRJNA1103784", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26909533 | 26909533 | PRJNA1103784_P_NODE_482_length_681_cov_2.743421_g428_i0 | PRJNA1103784 | 482 | 681 | 2.743421 | 18.68269701 | Phlyctochytrium planicorne | 261098 | Fungi | Fungi | 144 | 1.12e-39 | NR | KAJ3096340.1 | 261098 | g428 | i0 | 63.9 | 0.475770925110132 | 108 | 38 | 47.1 | 1 | 323 | 3 | 30 | 137 | KAJ3096340.1 hypothetical protein HDU97_006013 [Phlyctochytrium planicorne] | diamond | 324 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium planicorne | |
| 27762928 | 27762928 | PRJNA1103784_P_NODE_4944_length_264_cov_1.209424_g4889_i0 | PRJNA1103784 | 4944 | 264 | 1.209424 | 3.19287936 | Entophlyctis helioformis | 281842 | Fungi | Fungi | 84.7 | 1.79e-17 | NR | KAI8928617.1 | 281842 | g4889 | i0 | 52.6 | 3.54545454545455 | 78 | 36 | 87.5 | 1 | 232 | 2 | 92 | 169 | KAI8928617.1 hypothetical protein BC831DRAFT_397260 [Entophlyctis helioformis] | diamond | 936 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 29553448 | 29553448 | PRJNA1103784_P_NODE_7150_length_244_cov_0.900585_g7095_i0 | PRJNA1103784 | 7150 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | Fungi | Fungi | 45.8 | 0.00293 | NR | XP_052972014.1 | 110093 | g7095 | i0 | 37.7 | 3.33196721311475 | 61 | 38 | 75 | 0 | 48 | 230 | 64 | 124 | XP_052972014.1 uncharacterized protein BJ171DRAFT_11017 [Polychytrium aggregatum] | diamond | 813 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 30509992 | 30509992 | PRJNA1103784_P_NODE_2613_length_334_cov_1.896552_g2558_i0 | PRJNA1103784 | 2613 | 334 | 1.896552 | 6.33448368 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 93.2 | 2.18e-19 | NR | KAI8893489.1 | 382532 | g2558 | i0 | 39.1 | 1.40119760479042 | 156 | 50 | 99.7 | 1 | 333 | 1 | 180 | 335 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 468 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 31204676 | 31204676 | PRJNA1103784_P_NODE_7295_length_243_cov_1.147059_g7240_i0 | PRJNA1103784 | 7295 | 243 | 1.147059 | 2.78735337 | Piromyces sp. E2 | 73868 | Fungi | Fungi | 77.8 | 1.03e-14 | NR | OUM64579.1 | 73868 | g7240 | i0 | 57.4 | 3.30864197530864 | 61 | 26 | 75.3 | 0 | 1 | 183 | 135 | 195 | OUM64579.1 hypothetical protein PIROE2DRAFT_67290 [Piromyces sp. E2] | diamond | 804 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. E2 | |
| 31299990 | 31299990 | PRJNA1103784_P_NODE_3635_length_290_cov_2.239631_g3580_i0 | PRJNA1103784 | 3635 | 290 | 2.239631 | 6.4949299 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 75.9 | 1.95e-14 | NR | KXS08925.1 | 1344416 | g3580 | i0 | 45.2 | 2.41034482758621 | 93 | 47 | 93.1 | 2 | 8 | 277 | 116 | 207 | KXS08925.1 ras-domain-containing protein [Gonapodya prolifera JEL478] | diamond | 699 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 32777078 | 32777078 | PRJNA1103784_P_NODE_5440_length_254_cov_1.596685_g5385_i0 | PRJNA1103784 | 5440 | 254 | 1.596685 | 4.0555799 | Kappamyces | 261096 | Fungi | Fungi | 83.6 | 1.39e-16 | NR | KAJ3332353.1 | 2724210 | g5385 | i0 | 47.6 | 2.91732283464567 | 82 | 43 | 96.9 | 0 | 6 | 251 | 36 | 117 | KAJ3332353.1 COPII coat Sec23p-Sfb3p heterodimer component, partial [Kappamyces sp. JEL0680] | diamond | 741 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Kappamycetaceae | Kappamyces | Kappamyces sp. JEL0680 |
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);;