contig_metadata
12 rows where bioproject = "PRJNA306153" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8029615 | 8029615 | PRJNA306153_S_NODE_627_length_296_cov_3.745318_g614_i0 | PRJNA306153 | 627 | 296 | 3.745318 | 11.08614128 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 147 | 9.07e-43 | NR | KAJ3050097.1 | 64517 | g614 | i0 | 78.6 | 3.96283783783784 | 98 | 21 | 99.3 | 0 | 295 | 2 | 27 | 124 | KAJ3050097.1 60S ribosomal protein L18 [Rhizophlyctis rosea] | diamond | 1173 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 14405351 | 14405351 | PRJNA306153_S_NODE_2332_length_163_cov_3.283582_g2319_i0 | PRJNA306153 | 2332 | 163 | 3.283582 | 5.35223866 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 95.1 | 4.44e-21 | NR | KAJ3233940.1 | 4814 | g2319 | i0 | 77.8 | 9.93865030674847 | 54 | 12 | 99.4 | 0 | 163 | 2 | 517 | 570 | KAJ3233940.1 hypothetical protein HDU77_000507, partial [Chytriomyces hyalinus] | diamond | 1620 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 23328388 | 23328388 | PRJNA306153_S_NODE_679_length_288_cov_4.648649_g666_i0 | PRJNA306153 | 679 | 288 | 4.648649 | 13.38810912 | Chytridiomycetes | 451435 | Fungi | Fungi | 130 | 9.14e-33 | NR | KAJ3201667.1 | 109932 | g666 | i0 | 69.2 | 9.54166666666667 | 91 | 28 | 94.8 | 0 | 286 | 14 | 232 | 322 | KAJ3201667.1 hypothetical protein HDU82_007948 [Entophlyctis luteolus] | diamond | 2748 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 27010866 | 27010866 | PRJNA306153_S_NODE_782_length_271_cov_3.185950_g769_i0 | PRJNA306153 | 782 | 271 | 3.18595 | 8.6339245 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 89 | 2.96e-18 | NR | KAJ3077812.1 | 2654861 | g769 | i0 | 52.2 | 1.01845018450184 | 92 | 42 | 99.6 | 1 | 270 | 1 | 143 | 234 | KAJ3077812.1 hypothetical protein HK102_004949 [Quaeritorhiza haematococci] | diamond | 276 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 27548134 | 27548134 | PRJNA306153_S_NODE_2444_length_159_cov_3.861538_g2431_i0 | PRJNA306153 | 2444 | 159 | 3.861538 | 6.13984542 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 47.4 | 2.86e-4 | NR | XP_031025953.1 | 1806994 | g2431 | i0 | 57.1 | 0.660377358490566 | 35 | 15 | 66 | 0 | 156 | 52 | 743 | 777 | XP_031025953.1 uncharacterized protein SmJEL517_g02151 [Synchytrium microbalum] | diamond | 105 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 27643094 | 27643094 | PRJNA306153_S_NODE_764_length_273_cov_8.934426_g751_i0 | PRJNA306153 | 764 | 273 | 8.934426 | 24.39098298 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 48.9 | 3.48e-4 | NR | KAI9007819.1 | 82268 | g751 | i0 | 50 | 0.351648351648352 | 32 | 16 | 35.2 | 0 | 271 | 176 | 51 | 82 | KAI9007819.1 hypothetical protein DFJ74DRAFT_375362 [Hyaloraphidium curvatum] | diamond | 96 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 28702552 | 28702552 | PRJNA306153_S_NODE_2707_length_153_cov_2.306452_g2694_i0 | PRJNA306153 | 2707 | 153 | 2.306452 | 3.52887156 | Eukaryota | 2759 | Fungi | Fungi | 99.4 | 1.23e-22 | NR | KAJ3388041.1 | 109889 | g2694 | i0 | 86 | 8.82352941176471 | 50 | 7 | 98 | 0 | 3 | 152 | 343 | 392 | KAJ3388041.1 Elongation factor 2 [Lobulomyces angularis] | diamond | 1350 | 100 | 0.994 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 30011199 | 30011199 | PRJNA306153_S_NODE_1371_length_206_cov_4.169492_g1358_i0 | PRJNA306153 | 1371 | 206 | 4.169492 | 8.58915352 | Gonapodya sp. JEL | 2107737 | Fungi | Fungi | 78.6 | 4.87e-15 | NR | KAJ3337232.1 | 2725673 | g1358 | i0 | 67.9 | 2.50485436893204 | 56 | 18 | 81.6 | 0 | 205 | 38 | 26 | 81 | KAJ3337232.1 hypothetical protein HDU93_001422 [Gonapodya sp. JEL0774] | diamond | 516 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya sp. JEL0774 | |
| 30105710 | 30105710 | PRJNA306153_S_NODE_992_length_240_cov_3.094787_g979_i0 | PRJNA306153 | 992 | 240 | 3.094787 | 7.4274888 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 43.1 | 0.00816 | NR | KAJ1564714.1 | 1604274 | g979 | i0 | 48.4 | 1.2625 | 64 | 27 | 78.8 | 3 | 235 | 47 | 27 | 85 | KAJ1564714.1 structural constituent of ribosome [Cladochytrium tenue] | diamond | 303 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 31418999 | 31418999 | PRJNA306153_S_NODE_2016_length_175_cov_3.623288_g2003_i0 | PRJNA306153 | 2016 | 175 | 3.623288 | 6.340754 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 91.3 | 1.78e-21 | NR | KAJ3127717.1 | 109957 | g2003 | i0 | 74.1 | 5.96571428571429 | 58 | 15 | 99.4 | 0 | 174 | 1 | 1 | 58 | KAJ3127717.1 60S ribosomal protein L12 [Physocladia obscura] | diamond | 1044 | 92 | 0.992391304347826 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 32508992 | 32508992 | PRJNA306153_S_NODE_819_length_264_cov_3.710638_g806_i0 | PRJNA306153 | 819 | 264 | 3.710638 | 9.79608432 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 111 | 3.81e-26 | NR | KAI8893489.1 | 382532 | g806 | i0 | 62.1 | 1.97727272727273 | 87 | 33 | 98.9 | 0 | 2 | 262 | 420 | 506 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 522 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 32666380 | 32666380 | PRJNA306153_S_NODE_2360_length_162_cov_3.894737_g2347_i0 | PRJNA306153 | 2360 | 162 | 3.894737 | 6.30947394 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 49.3 | 4.1e-5 | NR | KAI9002296.1 | 109897 | g2347 | i0 | 51 | 0.944444444444444 | 51 | 25 | 94.4 | 0 | 162 | 10 | 152 | 202 | KAI9002296.1 60S ribosomal protein L16 [Gaertneriomyces semiglobifer] | diamond | 153 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer |
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);;