contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA188516" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11258423 | 11258423 | PRJNA188516_P_NODE_3629_length_178_cov_1.209302_g3579_i0 | PRJNA188516 | 3629 | 178 | 1.209302 | 2.15255756 | Clydaea vesicula | 447962 | Fungi | Fungi | 108 | 7.5599999999999995e-28 | NR | KAJ3198918.1 | 447962 | g3579 | i0 | 94.9 | 2.98314606741573 | 59 | 3 | 99.4 | 0 | 2 | 178 | 59 | 117 | KAJ3198918.1 40S ribosomal protein S9 [Clydaea vesicula] | diamond | 531 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Clydaea | Clydaea vesicula | |
| 19491804 | 19491804 | PRJNA188516_P_NODE_3956_length_170_cov_1.289256_g3906_i0 | PRJNA188516 | 3956 | 170 | 1.289256 | 2.1917352 | Chytridium lagenaria | 64509 | Fungi | Fungi | 102 | 4.75e-27 | NR | KAI8848400.1 | 64509 | g3906 | i0 | 83.7 | 3.45882352941176 | 49 | 8 | 86.5 | 0 | 2 | 148 | 8 | 56 | KAI8848400.1 40S ribosomal protein S29 [Chytridium lagenaria] | diamond | 588 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 20767357 | 20767357 | PRJNA188516_P_NODE_5257_length_165_cov_0.896552_g5207_i0 | PRJNA188516 | 5257 | 165 | 0.896552 | 1.4793108 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 95.1 | 4.64e-23 | NR | KAH9259618.1 | 1357716 | g5207 | i0 | 96.1 | 0.927272727272727 | 51 | 2 | 92.7 | 0 | 155 | 3 | 1 | 51 | KAH9259618.1 60S ribosomal protein L11 [Batrachochytrium salamandrivorans] | diamond | 153 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 23317916 | 23317916 | PRJNA188516_P_NODE_3639_length_178_cov_0.829457_g3589_i0 | PRJNA188516 | 3639 | 178 | 0.829457 | 1.47643346 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 103 | 8.11e-25 | NR | KAH9254230.1 | 1357716 | g3589 | i0 | 74.6 | 0.99438202247191 | 59 | 15 | 99.4 | 0 | 177 | 1 | 80 | 138 | KAH9254230.1 hypothetical protein BASA81_007831 [Batrachochytrium salamandrivorans] | diamond | 177 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27168546 | 27168546 | PRJNA188516_P_NODE_6002_length_162_cov_0.920354_g5952_i0 | PRJNA188516 | 6002 | 162 | 0.920354 | 1.49097348 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 80.5 | 7.21e-17 | NR | KXS14289.1 | 1344416 | g5952 | i0 | 71.7 | 4.85185185185185 | 53 | 15 | 98.1 | 0 | 161 | 3 | 134 | 186 | KXS14289.1 ribosomal protein L10e [Gonapodya prolifera JEL478] | diamond | 786 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 27186381 | 27186381 | PRJNA188516_P_NODE_4142_length_169_cov_0.866667_g4092_i0 | PRJNA188516 | 4142 | 169 | 0.866667 | 1.46466723 | Eukaryota | 2759 | Fungi | Fungi | 58.9 | 2.56e-8 | NR | KAL3897430.1 | 2058121 | g4092 | i0 | 58.7 | 1.59763313609467 | 46 | 19 | 81.7 | 0 | 140 | 3 | 4 | 49 | KAL3897430.1 MAG: hypothetical protein SGCHY_003421 [Lobulomycetales sp.] | diamond | 270 | 59.3 | 0.993254637436762 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 27358592 | 27358592 | PRJNA188516_P_NODE_2503_length_217_cov_1.214286_g2453_i0 | PRJNA188516 | 2503 | 217 | 1.214286 | 2.63500062 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 39.7 | 0.0394 | NR | KXS10009.1 | 1344416 | g2453 | i0 | 76 | 0.345622119815668 | 25 | 6 | 34.6 | 0 | 135 | 61 | 17 | 41 | KXS10009.1 hypothetical protein M427DRAFT_63061 [Gonapodya prolifera JEL478] | diamond | 75 | 39.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 27881377 | 27881377 | PRJNA188516_P_NODE_1845_length_257_cov_1.096154_g1795_i0 | PRJNA188516 | 1845 | 257 | 1.096154 | 2.81711578 | Eukaryota | 2759 | Fungi | Fungi | 62.8 | 4.76e-10 | NR | KAJ3231887.1 | 4814 | g1795 | i0 | 46.3 | 5.75486381322957 | 82 | 37 | 94.6 | 3 | 1 | 243 | 69 | 144 | KAJ3231887.1 profilin, required for normal timing of actin polymerization in response to thermal stress [Chytriomyces hyalinus] | diamond | 1479 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 28463701 | 28463701 | PRJNA188516_P_NODE_4026_length_169_cov_0.866667_g3976_i0 | PRJNA188516 | 4026 | 169 | 0.866667 | 1.46466723 | Chytriomyces confervae | 246404 | Fungi | Fungi | 45.8 | 0.00113 | NR | TPX72599.1 | 246404 | g3976 | i0 | 53.7 | 0.958579881656805 | 54 | 16 | 83.4 | 2 | 163 | 23 | 174 | 225 | TPX72599.1 hypothetical protein CcCBS67573_g05723 [Chytriomyces confervae] | diamond | 162 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 28955171 | 28955171 | PRJNA188516_P_NODE_5888_length_162_cov_2.761062_g5838_i0 | PRJNA188516 | 5888 | 162 | 2.761062 | 4.47292044 | Kappamyces | 261096 | Fungi | Fungi | 68.2 | 4.69e-13 | NR | KAJ3327085.1 | 2724210 | g5838 | i0 | 70 | 1.85185185185185 | 50 | 15 | 92.6 | 0 | 13 | 162 | 5 | 54 | KAJ3327085.1 40S ribosomal protein S20, partial [Kappamyces sp. JEL0680] | diamond | 300 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Kappamycetaceae | Kappamyces | Kappamyces sp. JEL0680 | |
| 29049790 | 29049790 | PRJNA188516_P_NODE_2788_length_205_cov_1.666667_g2738_i0 | PRJNA188516 | 2788 | 205 | 1.666667 | 3.41666735 | Eukaryota | 2759 | Fungi | Fungi | 77.4 | 2.7e-16 | NR | KAI9005567.1 | 82268 | g2738 | i0 | 63.6 | 21.1170731707317 | 55 | 20 | 80.5 | 0 | 3 | 167 | 69 | 123 | KAI9005567.1 putative SNU13-component of the U4/U6.U5 snRNP [Hyaloraphidium curvatum] | diamond | 4329 | 77.8 | 0.994858611825193 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 29537019 | 29537019 | PRJNA188516_P_NODE_4090_length_169_cov_0.866667_g4040_i0 | PRJNA188516 | 4090 | 169 | 0.866667 | 1.46466723 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 54.7 | 8.34e-7 | NR | KAH9251342.1 | 1357716 | g4040 | i0 | 49.1 | 0.976331360946746 | 55 | 28 | 97.6 | 0 | 1 | 165 | 313 | 367 | KAH9251342.1 hypothetical protein BASA81_010753 [Batrachochytrium salamandrivorans] | diamond | 165 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29712325 | 29712325 | PRJNA188516_P_NODE_4510_length_168_cov_0.873950_g4460_i0 | PRJNA188516 | 4510 | 168 | 0.87395 | 1.468236 | Fungi | 4751 | Fungi | Fungi | 104 | 1.37e-27 | NR | KAJ3191513.1 | 109884 | g4460 | i0 | 83.9 | 8.92857142857143 | 56 | 9 | 100 | 0 | 168 | 1 | 19 | 74 | KAJ3191513.1 hypothetical protein HK101_007653 [Irineochytrium annulatum] | diamond | 1500 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 30136747 | 30136747 | PRJNA188516_P_NODE_2592_length_213_cov_0.951220_g2542_i0 | PRJNA188516 | 2592 | 213 | 0.95122 | 2.0260986 | Piromyces sp. E2 | 73868 | Fungi | Fungi | 76.3 | 6.74e-16 | NR | OUM66308.1 | 73868 | g2542 | i0 | 60.3 | 1.74647887323944 | 63 | 20 | 88.7 | 2 | 3 | 191 | 58 | 115 | OUM66308.1 hypothetical protein PIROE2DRAFT_59484 [Piromyces sp. E2] | diamond | 372 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. E2 | |
| 30832188 | 30832188 | PRJNA188516_P_NODE_5294_length_165_cov_0.896552_g5244_i0 | PRJNA188516 | 5294 | 165 | 0.896552 | 1.4793108 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 49.3 | 5.97e-5 | NR | KAI9356781.1 | 2211651 | g5244 | i0 | 62.7 | 2.89090909090909 | 51 | 19 | 92.7 | 0 | 163 | 11 | 70 | 120 | KAI9356781.1 ribosomal protein L30, ferredoxin-like fold domain-containing protein [Zopfochytrium polystomum] | diamond | 477 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 31337806 | 31337806 | PRJNA188516_P_NODE_4716_length_167_cov_0.881356_g4666_i0 | PRJNA188516 | 4716 | 167 | 0.881356 | 1.47186452 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 64.3 | 2.6200000000000003e-10 | NR | KAH9261705.1 | 1357716 | g4666 | i0 | 53.8 | 11.1017964071856 | 52 | 24 | 93.4 | 0 | 156 | 1 | 59 | 110 | KAH9261705.1 hypothetical protein BASA81_000361 [Batrachochytrium salamandrivorans] | diamond | 1854 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31780563 | 31780563 | PRJNA188516_P_NODE_5857_length_163_cov_0.912281_g5807_i0 | PRJNA188516 | 5857 | 163 | 0.912281 | 1.48701803 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 67.8 | 1.86e-11 | NR | KAJ3092457.1 | 2654861 | g5807 | i0 | 56.9 | 0.938650306748466 | 51 | 22 | 93.9 | 0 | 153 | 1 | 380 | 430 | KAJ3092457.1 hypothetical protein HK102_007081 [Quaeritorhiza haematococci] | diamond | 153 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 32033839 | 32033839 | PRJNA188516_P_NODE_2618_length_212_cov_0.957055_g2568_i0 | PRJNA188516 | 2618 | 212 | 0.957055 | 2.0289566 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 44.3 | 0.00692 | NR | KAI9002515.1 | 82268 | g2568 | i0 | 46.4 | 0.792452830188679 | 56 | 29 | 77.8 | 1 | 166 | 2 | 62 | 117 | KAI9002515.1 hypothetical protein DFJ74DRAFT_695896 [Hyaloraphidium curvatum] | diamond | 168 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum |
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);;