contig_metadata
7 rows where bioproject = "PRJNA864829", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8889846 | 8889846 | PRJNA864829_S_NODE_5067_length_262_cov_25.938967_g4981_i0 | PRJNA864829 | 5067 | 262 | 25.938967 | 67.96009354 | Alphamyces | 1167811 | Fungi | Fungi | 159 | 1.37e-34 | NTclustered | gi|2468791078|gb|OQ702937.1| | 2011922 | g4981 | i0 | 79.498 | 37.793893129771 | 239 | 37 | 89 | 9 | 26 | 259 | 2765 | 2996 | Rhizophydiales sp. isolate PSC285 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9902 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiales sp. | |||
| 12716448 | 12716448 | PRJNA864829_S_NODE_4070_length_284_cov_39.757447_g3984_i0 | PRJNA864829 | 4070 | 284 | 39.757447 | 112.91114948 | Rhizophydium | 60186 | Fungi | Fungi | 137 | 7.04e-28 | NTclustered | gi|1780004527|gb|MN759467.1| | 2012212 | g3984 | i0 | 89.72 | 31.3978873239437 | 107 | 11 | 38 | 0 | 26 | 132 | 7 | 113 | Chytridiomycota sp. isolate OAS2 large subunit ribosomal RNA gene, partial sequence | blastn | 8917 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycota sp. | |||||
| 16149962 | 16149962 | PRJNA864829_S_NODE_2493_length_337_cov_20.284722_g2407_i0 | PRJNA864829 | 2493 | 337 | 20.284722 | 68.35951314 | Astrotestudinimyces divisus | 3079314 | Fungi | Fungi | 163 | 1.41e-35 | NTclustered | gi|2440585864|gb|OQ382927.1| | 3079314 | g2407 | i0 | 91.525 | 37.0385756676558 | 118 | 10 | 35 | 0 | 191 | 308 | 705 | 588 | Neocallimastigales sp. NHY-2023a clone BClone2 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12482 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Astrotestudinimyces | Astrotestudinimyces divisus | |||
| 16539437 | 16539437 | PRJNA864829_S_NODE_6073_length_245_cov_4.571429_g5987_i0 | PRJNA864829 | 6073 | 245 | 4.571429 | 11.20000105 | Spizellomycetales | 34478 | Fungi | Fungi | 255 | 1.57e-63 | NTclustered | gi|1866582793|gb|MT730968.1| | 4816 | g5987 | i0 | 87.783 | 90.0489795918367 | 221 | 23 | 90 | 4 | 1 | 220 | 4770 | 4553 | Spizellomyces acuminatus isolate PLAUS Ad 20 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22062 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces acuminatus | |
| 17425461 | 17425461 | PRJNA864829_S_NODE_2814_length_323_cov_4.281022_g2728_i0 | PRJNA864829 | 2814 | 323 | 4.281022 | 13.82770106 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 137 | 8.14e-28 | NTclustered | gi|311235598|ref|NG_027613.1| | 110093 | g2728 | i0 | 92.708 | 30.3529411764706 | 96 | 6 | 29 | 1 | 1 | 95 | 2254 | 2159 | Polychytrium aggregatum JEL 109 28S rRNA gene, partial sequence; from reference material | blastn | 9804 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21249456 | 21249456 | PRJNA864829_S_NODE_6557_length_238_cov_2.455026_g6471_i0 | PRJNA864829 | 6557 | 238 | 2.455026 | 5.84296188 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 129 | 2.4999999999999997e-36 | NR | KAI9006966.1 | 82268 | g6471 | i0 | 74.7 | 3.97058823529412 | 79 | 20 | 99.6 | 0 | 237 | 1 | 55 | 133 | KAI9006966.1 L30e-like protein [Hyaloraphidium curvatum] | diamond | 945 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30403109 | 30403109 | PRJNA864829_S_NODE_4693_length_271_cov_2.072072_g4607_i0 | PRJNA864829 | 4693 | 271 | 2.072072 | 5.61531512 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 108 | 1.44e-27 | NR | KAH9257010.1 | 1357716 | g4607 | i0 | 80.3 | 0.675276752767528 | 61 | 12 | 67.5 | 0 | 270 | 88 | 104 | 164 | KAH9257010.1 hypothetical protein BASA81_004831 [Batrachochytrium salamandrivorans] | diamond | 183 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;