contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7051530 | 7051530 | PRJNA692200_S_NODE_5066_length_287_cov_41.063025_g5009_i0 | PRJNA692200 | 5066 | 287 | 41.063025 | 117.85088175 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 81.3 | 7.9e-16 | NR | KAJ3175031.1 | 2724198 | g5009 | i0 | 53.9 | 0.794425087108014 | 76 | 32 | 78.4 | 2 | 283 | 59 | 246 | 319 | KAJ3175031.1 F-actin-capping protein subunit alpha, partial [Gaertneriomyces sp. JEL0708] | diamond | 228 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 8326019 | 8326019 | PRJNA692200_S_NODE_527_length_499_cov_1001.920000_g494_i0 | PRJNA692200 | 527 | 499 | 1001.92 | 4999.5808 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 151 | 7.52e-44 | NR | KAJ1568147.1 | 1604274 | g494 | i0 | 60.9 | 2.33867735470942 | 128 | 50 | 77 | 0 | 489 | 106 | 4 | 131 | KAJ1568147.1 60S ribosomal protein L32 [Cladochytrium tenue] | diamond | 1167 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 15975671 | 15975671 | PRJNA692200_S_NODE_6213_length_268_cov_2.050228_g6156_i0 | PRJNA692200 | 6213 | 268 | 2.050228 | 5.49461104 | Fungi | 4751 | Fungi | Fungi | 120 | 7.42e-30 | NR | TPX76640.1 | 246404 | g6156 | i0 | 66.7 | 6.8955223880597 | 87 | 29 | 97.4 | 0 | 264 | 4 | 293 | 379 | TPX76640.1 hypothetical protein CcCBS67573_g02099 [Chytriomyces confervae] | diamond | 1848 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 18524777 | 18524777 | PRJNA692200_S_NODE_2295_length_366_cov_1031.227129_g2238_i0 | PRJNA692200 | 2295 | 366 | 1031.227129 | 3774.29129214 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 132 | 3.66e-33 | NR | KAI9011104.1 | 109897 | g2238 | i0 | 79 | 3.35245901639344 | 81 | 17 | 66.4 | 0 | 14 | 256 | 646 | 726 | KAI9011104.1 Thiolase, N-terminal domain-containing protein [Gaertneriomyces semiglobifer] | diamond | 1227 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 19799951 | 19799951 | PRJNA692200_S_NODE_96_length_673_cov_794.480769_g77_i0 | PRJNA692200 | 96 | 673 | 794.480769 | 5346.85557537 | Eukaryota | 2759 | Fungi | Fungi | 126 | 5.39e-32 | NR | KAJ3408147.1 | 4814 | g77 | i0 | 39.4 | 6.75780089153046 | 155 | 94 | 69.1 | 0 | 673 | 209 | 31 | 185 | KAJ3408147.1 ribosomal protein P0 (A0) (L10E), partial [Chytriomyces hyalinus] | diamond | 4548 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 27051035 | 27051035 | PRJNA692200_S_NODE_21982_length_162_cov_1.353982_g21925_i0 | PRJNA692200 | 21982 | 162 | 1.353982 | 2.19345084 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 78.6 | 9.77e-17 | NR | KAH9257341.1 | 1357716 | g21925 | i0 | 72 | 1.87037037037037 | 50 | 14 | 92.6 | 0 | 3 | 152 | 61 | 110 | KAH9257341.1 hypothetical protein BASA81_004498 [Batrachochytrium salamandrivorans] | diamond | 303 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27251894 | 27251894 | PRJNA692200_S_NODE_11303_length_212_cov_2.134969_g11246_i0 | PRJNA692200 | 11303 | 212 | 2.134969 | 4.52613428 | Eukaryota | 2759 | Fungi | Fungi | 47 | 7.76e-4 | NR | TPX33282.1 | 286115 | g11246 | i0 | 37.7 | 4.99528301886792 | 53 | 33 | 75 | 0 | 52 | 210 | 101 | 153 | TPX33282.1 hypothetical protein SeMB42_g07503 [Synchytrium endobioticum] | diamond | 1059 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 27524933 | 27524933 | PRJNA692200_S_NODE_203_length_589_cov_22.642593_g178_i0 | PRJNA692200 | 203 | 589 | 22.642593 | 133.36487277 | Physocladia obscura | 109957 | Fungi | Fungi | 137 | 1.25e-37 | NR | KAJ3100757.1 | 109957 | g178 | i0 | 45.4 | 4.58404074702886 | 152 | 66 | 77.4 | 1 | 574 | 119 | 4 | 138 | KAJ3100757.1 40S ribosomal protein S19 [Physocladia obscura] | diamond | 2700 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 27998729 | 27998729 | PRJNA692200_S_NODE_17685_length_175_cov_1.206349_g17628_i0 | PRJNA692200 | 17685 | 175 | 1.206349 | 2.11111075 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 52.8 | 6.24e-7 | NR | KAJ3090611.1 | 2654861 | g17628 | i0 | 46.8 | 2.31428571428571 | 47 | 24 | 78.9 | 1 | 174 | 37 | 11 | 57 | KAJ3090611.1 hypothetical protein HK102_003202 [Quaeritorhiza haematococci] | diamond | 405 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 28661722 | 28661722 | PRJNA692200_S_NODE_1207_length_425_cov_16.015957_g1159_i0 | PRJNA692200 | 1207 | 425 | 16.015957 | 68.06781725 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 52 | 7.08e-5 | NR | KAI9002296.1 | 109897 | g1159 | i0 | 49.1 | 0.374117647058824 | 53 | 27 | 37.4 | 0 | 2 | 160 | 150 | 202 | KAI9002296.1 60S ribosomal protein L16 [Gaertneriomyces semiglobifer] | diamond | 159 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 28787694 | 28787694 | PRJNA692200_S_NODE_11327_length_212_cov_1.380368_g11270_i0 | PRJNA692200 | 11327 | 212 | 1.380368 | 2.92638016 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 49.7 | 9.01e-5 | NR | XP_031022575.1 | 1806994 | g11270 | i0 | 88 | 1.40094339622642 | 25 | 3 | 35.4 | 0 | 210 | 136 | 697 | 721 | XP_031022575.1 tetrahydrofolate synthase [Synchytrium microbalum] | diamond | 297 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 29072242 | 29072242 | PRJNA692200_S_NODE_12928_length_200_cov_2.430464_g12871_i0 | PRJNA692200 | 12928 | 200 | 2.430464 | 4.860928 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 39.3 | 0.0452 | NR | KXS10009.1 | 1344416 | g12871 | i0 | 80 | 0.375 | 25 | 5 | 37.5 | 0 | 148 | 74 | 17 | 41 | KXS10009.1 hypothetical protein M427DRAFT_63061 [Gonapodya prolifera JEL478] | diamond | 75 | 39.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 29293042 | 29293042 | PRJNA692200_S_NODE_6709_length_261_cov_2.811321_g6652_i0 | PRJNA692200 | 6709 | 261 | 2.811321 | 7.33754781 | Blyttiomyces sp. JEL | 2750429 | Fungi | Fungi | 42.7 | 0.00534 | NR | KAJ3268768.1 | 2724214 | g6652 | i0 | 50 | 0.390804597701149 | 34 | 17 | 39.1 | 0 | 3 | 104 | 20 | 53 | KAJ3268768.1 hypothetical protein HDU76_011373, partial [Blyttiomyces sp. JEL0837] | diamond | 102 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces sp. JEL0837 | |||
| 30725760 | 30725760 | PRJNA692200_S_NODE_11814_length_208_cov_1.716981_g11757_i0 | PRJNA692200 | 11814 | 208 | 1.716981 | 3.57132048 | Eukaryota | 2759 | Fungi | Fungi | 42.4 | 0.033 | NR | TPX46814.1 | 286115 | g11757 | i0 | 48.5 | 1.44230769230769 | 33 | 17 | 47.6 | 0 | 4 | 102 | 566 | 598 | TPX46814.1 hypothetical protein SeLEV6574_g03014 [Synchytrium endobioticum] | diamond | 300 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 31346641 | 31346641 | PRJNA692200_S_NODE_14476_length_190_cov_7.056738_g14419_i0 | PRJNA692200 | 14476 | 190 | 7.056738 | 13.4078022 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 45.1 | 0.00176 | NR | KAH9262945.1 | 1357716 | g14419 | i0 | 80.8 | 0.821052631578947 | 26 | 5 | 41.1 | 0 | 134 | 57 | 51 | 76 | KAH9262945.1 hypothetical protein BASA82_000043 [Batrachochytrium salamandrivorans] | diamond | 156 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31947363 | 31947363 | PRJNA692200_S_NODE_21117_length_164_cov_1.321739_g21060_i0 | PRJNA692200 | 21117 | 164 | 1.321739 | 2.16765196 | Boothiomyces macroporosus | 261099 | Fungi | Fungi | 59.3 | 1.72e-8 | NR | KAJ3252293.1 | 261099 | g21060 | i0 | 57.4 | 2.74390243902439 | 47 | 20 | 86 | 0 | 147 | 7 | 306 | 352 | KAJ3252293.1 hypothetical protein HK103_001638 [Boothiomyces macroporosus] | diamond | 450 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces macroporosus |
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);;