contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183546 | 183546 | PRJNA1068830_P_NODE_72721_length_253_cov_0.866667_g72018_i0 | PRJNA1068830 | 72721 | 253 | 0.866667 | 2.19266751 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 132 | 1.67e-33 | NR | KAH6572390.1 | 1357716 | g72018 | i0 | 73.5 | 10.802371541502 | 83 | 22 | 98.4 | 0 | 3 | 251 | 515 | 597 | KAH6572390.1 hypothetical protein BASA60_006651 [Batrachochytrium salamandrivorans] | diamond | 2733 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 183843 | 183843 | PRJNA1068830_P_NODE_85161_length_244_cov_0.912281_g84458_i0 | PRJNA1068830 | 85161 | 244 | 0.912281 | 2.22596564 | Rhizoclosmatium | 109967 | Fungi | Fungi | 107 | 1.98e-25 | NR | ORY53088.1 | 329046 | g84458 | i0 | 63 | 5.97540983606557 | 81 | 28 | 99.6 | 1 | 244 | 2 | 315 | 393 | ORY53088.1 clathrin adaptor, mu subunit [Rhizoclosmatium globosum] | diamond | 1458 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium globosum | |
| 10386819 | 10386819 | PRJNA1068830_P_NODE_73589_length_252_cov_1.368715_g72886_i0 | PRJNA1068830 | 73589 | 252 | 1.368715 | 3.4491618 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 154 | 4.859999999999999e-43 | NR | KAH9252906.1 | 1357716 | g72886 | i0 | 86.9 | 1 | 84 | 11 | 100 | 0 | 1 | 252 | 188 | 271 | KAH9252906.1 elongation factor 1-alpha [Batrachochytrium salamandrivorans] | diamond | 252 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 12936843 | 12936843 | PRJNA1068830_P_NODE_54891_length_294_cov_1.411765_g54188_i0 | PRJNA1068830 | 54891 | 294 | 1.411765 | 4.1505891 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 181 | 1.3e-51 | NR | KAI8810678.1 | 109936 | g54188 | i0 | 84.4 | 11.7448979591837 | 96 | 15 | 98 | 0 | 293 | 6 | 12 | 107 | KAI8810678.1 tRNA synthetases class I (M)-domain-containing protein, partial [Cladochytrium replicatum] | diamond | 3453 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 26655586 | 26655586 | PRJNA1068830_P_NODE_88821_length_242_cov_0.923077_g88118_i0 | PRJNA1068830 | 88821 | 242 | 0.923077 | 2.23384634 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 68.6 | 2.46e-12 | NR | KAI8812082.1 | 109936 | g88118 | i0 | 69.2 | 0.483471074380165 | 39 | 12 | 48.3 | 0 | 3 | 119 | 115 | 153 | KAI8812082.1 LITAF-like zinc ribbon domain-containing protein [Cladochytrium replicatum] | diamond | 117 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 26909166 | 26909166 | PRJNA1068830_P_NODE_27902_length_436_cov_1.578512_g27199_i0 | PRJNA1068830 | 27902 | 436 | 1.578512 | 6.88231232 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 73.2 | 2.99e-13 | NR | KAJ1553457.1 | 2732417 | g27199 | i0 | 50.7 | 0.825688073394495 | 71 | 21 | 48.9 | 2 | 33 | 245 | 85 | 141 | KAJ1553457.1 hypothetical protein HK096_007771, partial [Nowakowskiella sp. JEL0078] | diamond | 360 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0078 | |
| 27193651 | 27193651 | PRJNA1068830_P_NODE_75442_length_251_cov_0.876404_g74739_i0 | PRJNA1068830 | 75442 | 251 | 0.876404 | 2.19977404 | Globomyces sp. JEL | 2786946 | Fungi | Fungi | 55.8 | 8.03e-7 | NR | KAJ2991791.1 | 2786946 | g74739 | i0 | 65.1 | 1.01593625498008 | 43 | 15 | 51.4 | 0 | 2 | 130 | 241 | 283 | KAJ2991791.1 hypothetical protein HDV02_003480 [Globomyces sp. JEL0801] | diamond | 255 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces sp. JEL0801 | |
| 28330566 | 28330566 | PRJNA1068830_P_NODE_85746_length_244_cov_0.912281_g85043_i0 | PRJNA1068830 | 85746 | 244 | 0.912281 | 2.22596564 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 128 | 1.83e-34 | NR | KAH9253668.1 | 1357716 | g85043 | i0 | 77.2 | 0.971311475409836 | 79 | 18 | 97.1 | 0 | 8 | 244 | 112 | 190 | KAH9253668.1 hypothetical protein BASA81_008286 [Batrachochytrium salamandrivorans] | diamond | 237 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29025600 | 29025600 | PRJNA1068830_P_NODE_80188_length_248_cov_0.891429_g79485_i0 | PRJNA1068830 | 80188 | 248 | 0.891429 | 2.21074392 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 48.9 | 2.45e-4 | NR | KAJ3091473.1 | 2654861 | g79485 | i0 | 42 | 0.834677419354839 | 69 | 37 | 83.5 | 1 | 27 | 233 | 186 | 251 | KAJ3091473.1 hypothetical protein HK102_000419 [Quaeritorhiza haematococci] | diamond | 207 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 29521963 | 29521963 | PRJNA1068830_P_NODE_85850_length_244_cov_0.912281_g85147_i0 | PRJNA1068830 | 85850 | 244 | 0.912281 | 2.22596564 | Fungi | 4751 | Fungi | Fungi | 43.5 | 0.0105 | NR | KAJ3208460.1 | 109932 | g85147 | i0 | 25.5 | 5.22540983606557 | 94 | 56 | 98.4 | 1 | 243 | 4 | 19 | 112 | KAJ3208460.1 N-alpha-acetyltransferase 50 [Entophlyctis luteolus] | diamond | 1275 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 29814526 | 29814526 | PRJNA1068830_P_NODE_76271_length_250_cov_1.604520_g75568_i0 | PRJNA1068830 | 76271 | 250 | 1.60452 | 4.0113 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 145 | 1.8299999999999999e-38 | NR | KAH9260241.1 | 1357716 | g75568 | i0 | 74.4 | 0.984 | 82 | 21 | 98.4 | 0 | 3 | 248 | 263 | 344 | KAH9260241.1 hypothetical protein BASA81_001410 [Batrachochytrium salamandrivorans] | diamond | 246 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30098798 | 30098798 | PRJNA1068830_P_NODE_58932_length_283_cov_2.538095_g58229_i0 | PRJNA1068830 | 58932 | 283 | 2.538095 | 7.18280885 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 43.1 | 0.0445 | NR | KAL2918971.1 | 2732419 | g58229 | i0 | 42.5 | 0.424028268551237 | 40 | 23 | 42.4 | 0 | 152 | 33 | 404 | 443 | KAL2918971.1 Anaphase-promoting complex subunit 8 [Polyrhizophydium stewartii] | diamond | 120 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 30153421 | 30153421 | PRJNA1068830_P_NODE_81252_length_247_cov_0.896552_g80549_i0 | PRJNA1068830 | 81252 | 247 | 0.896552 | 2.21448344 | Eukaryota | 2759 | Fungi | Fungi | 77 | 3.84e-16 | NR | KAH9257738.1 | 1357716 | g80549 | i0 | 73.1 | 1.60323886639676 | 52 | 14 | 63.2 | 0 | 165 | 10 | 5 | 56 | KAH9257738.1 hypothetical protein BASA81_004204 [Batrachochytrium salamandrivorans] | diamond | 396 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30762513 | 30762513 | PRJNA1068830_P_NODE_49114_length_313_cov_1.166667_g48411_i0 | PRJNA1068830 | 49114 | 313 | 1.166667 | 3.65166771 | Caulochytrium protostelioides | 1555241 | Fungi | Fungi | 114 | 1.4700000000000002e-27 | NR | RKP02551.1 | 1555241 | g48411 | i0 | 59.4 | 0.968051118210863 | 101 | 39 | 96.8 | 1 | 313 | 11 | 179 | 277 | RKP02551.1 hypothetical protein CXG81DRAFT_10663, partial [Caulochytrium protostelioides] | diamond | 303 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Caulochytriales | Caulochytriaceae | Caulochytrium | Caulochytrium protostelioides | |
| 30848781 | 30848781 | PRJNA1068830_P_NODE_51334_length_305_cov_1.870690_g50631_i0 | PRJNA1068830 | 51334 | 305 | 1.87069 | 5.7056045 | Eukaryota | 2759 | Fungi | Fungi | 84.3 | 1.86e-18 | NR | KAJ3176394.1 | 109894 | g50631 | i0 | 43.9 | 9.39344262295082 | 98 | 47 | 96.4 | 2 | 304 | 11 | 36 | 125 | KAJ3176394.1 60S ribosomal protein L31 [Geranomyces variabilis] | diamond | 2865 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 30952161 | 30952161 | PRJNA1068830_P_NODE_13874_length_662_cov_1.407470_g13201_i0 | PRJNA1068830 | 13874 | 662 | 1.40747 | 9.3174514 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 49.3 | 0.00586 | NR | XP_052971679.1 | 110093 | g13201 | i0 | 29.7 | 0.534743202416918 | 118 | 73 | 50.8 | 3 | 445 | 110 | 274 | 387 | XP_052971679.1 UEV domain-containing protein [Polychytrium aggregatum] | diamond | 354 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 31489693 | 31489693 | PRJNA1068830_P_NODE_81936_length_246_cov_1.398844_g81233_i0 | PRJNA1068830 | 81936 | 246 | 1.398844 | 3.44115624 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 53.9 | 4.49e-6 | NR | KXS17667.1 | 1344416 | g81233 | i0 | 35.4 | 2.95121951219512 | 82 | 52 | 98.8 | 1 | 243 | 1 | 355 | 436 | KXS17667.1 WD40 repeat-like protein [Gonapodya prolifera JEL478] | diamond | 726 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 32217111 | 32217111 | PRJNA1068830_P_NODE_72318_length_253_cov_0.888889_g71615_i0 | PRJNA1068830 | 72318 | 253 | 0.888889 | 2.24888917 | Siphonaria sp. JEL | 2047469 | Fungi | Fungi | 63.5 | 1.49e-9 | NR | KAJ3023600.1 | 2723227 | g71615 | i0 | 63.3 | 1.74308300395257 | 49 | 18 | 58.1 | 0 | 3 | 149 | 260 | 308 | KAJ3023600.1 hypothetical protein HDU68_008539 [Siphonaria sp. JEL0065] | diamond | 441 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Siphonaria | Siphonaria sp. JEL0065 |
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);;