contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1722530 | 1722530 | PRJNA478247_P_NODE_802_length_469_cov_1.759091_g697_i0 | PRJNA478247 | 802 | 469 | 1.759091 | 8.2501367900000009 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 192 | 1.1699999999999995e-55 | NR | TPX42294.1 | 286115 | g697 | i0 | 62.3 | 1.91257995735608 | 151 | 56 | 95.9 | 1 | 20 | 469 | 12 | 162 | TPX42294.1 hypothetical protein SeLEV6574_g05679 [Synchytrium endobioticum] | diamond | 897 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 9375584 | 9375584 | PRJNA478247_P_NODE_368_length_786_cov_4.343461_g285_i0 | PRJNA478247 | 368 | 786 | 4.343461 | 34.13960346 | Eukaryota | 2759 | Fungi | Fungi | 406 | 2.15e-140 | NR | TPX52260.1 | 286115 | g285 | i0 | 77.3 | 20.3129770992366 | 255 | 57 | 96.9 | 1 | 771 | 10 | 41 | 295 | TPX52260.1 hypothetical protein SeMB42_g01519 [Synchytrium endobioticum] | diamond | 15966 | 410 | 0.990243902439024 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 10651464 | 10651464 | PRJNA478247_P_NODE_3429_length_158_cov_1.465116_g3323_i0 | PRJNA478247 | 3429 | 158 | 1.465116 | 2.31488328 | Opisthokonta | 33154 | Fungi | Fungi | 96.3 | 2.88e-22 | NR | KAI9009425.1 | 109897 | g3323 | i0 | 86.5 | 14.7721518987342 | 52 | 7 | 98.7 | 0 | 1 | 156 | 140 | 191 | KAI9009425.1 mitochondrial carrier domain-containing protein [Gaertneriomyces semiglobifer] | diamond | 2334 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 27092374 | 27092374 | PRJNA478247_P_NODE_862_length_447_cov_4.418660_g757_i0 | PRJNA478247 | 862 | 447 | 4.41866 | 19.7514102 | Chytridiomycota | 4761 | Fungi | Fungi | 153 | 7.669999999999999e-45 | NR | KAI8928609.1 | 281842 | g757 | i0 | 63.9 | 5.77852348993289 | 122 | 44 | 81.9 | 0 | 419 | 54 | 4 | 125 | KAI8928609.1 ribosomal protein L23/L15e core domain-containing protein, partial [Entophlyctis helioformis] | diamond | 2583 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 27265987 | 27265987 | PRJNA478247_P_NODE_923_length_430_cov_3.593516_g817_i0 | PRJNA478247 | 923 | 430 | 3.593516 | 15.4521188 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 164 | 3.72e-49 | NR | XP_052968709.1 | 110093 | g817 | i0 | 66.9 | 0.823255813953488 | 118 | 39 | 82.3 | 0 | 17 | 370 | 1 | 118 | XP_052968709.1 ribosomal protein L34e-domain-containing protein [Polychytrium aggregatum] | diamond | 354 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 28008524 | 28008524 | PRJNA478247_P_NODE_925_length_430_cov_2.583541_g819_i0 | PRJNA478247 | 925 | 430 | 2.583541 | 11.1092263 | Chytridiomycota | 4761 | Fungi | Fungi | 164 | 1.73e-49 | NR | KAJ3221447.1 | 4814 | g819 | i0 | 62.7 | 7.03255813953488 | 126 | 47 | 87.9 | 0 | 382 | 5 | 1 | 126 | KAJ3221447.1 profilin, required for normal timing of actin polymerization in response to thermal stress [Chytriomyces hyalinus] | diamond | 3024 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 28150275 | 28150275 | PRJNA478247_P_NODE_1145_length_370_cov_3.410557_g1039_i0 | PRJNA478247 | 1145 | 370 | 3.410557 | 12.6190609 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 60.1 | 1.21e-7 | NR | KAJ1567084.1 | 1604274 | g1039 | i0 | 46.7 | 0.486486486486487 | 60 | 30 | 47 | 1 | 35 | 208 | 200 | 259 | KAJ1567084.1 hypothetical protein HK405_007235 [Cladochytrium tenue] | diamond | 180 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 29065897 | 29065897 | PRJNA478247_P_NODE_748_length_488_cov_2.058824_g643_i0 | PRJNA478247 | 748 | 488 | 2.058824 | 10.04706112 | Chytriomyces confervae | 246404 | Fungi | Fungi | 50.4 | 9.15e-4 | NR | TPX76543.1 | 246404 | g643 | i0 | 34.8 | 0.799180327868853 | 66 | 43 | 40.6 | 0 | 82 | 279 | 695 | 760 | TPX76543.1 hypothetical protein CcCBS67573_g02204 [Chytriomyces confervae] | diamond | 390 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 30076155 | 30076155 | PRJNA478247_P_NODE_3412_length_158_cov_2.480620_g3306_i0 | PRJNA478247 | 3412 | 158 | 2.48062 | 3.9193796 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 97.4 | 8.169999999999999e-23 | NR | TPX52260.1 | 286115 | g3306 | i0 | 82.7 | 9.87341772151899 | 52 | 9 | 98.7 | 0 | 156 | 1 | 116 | 167 | TPX52260.1 hypothetical protein SeMB42_g01519 [Synchytrium endobioticum] | diamond | 1560 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 30155271 | 30155271 | PRJNA478247_P_NODE_272_length_945_cov_5.341703_g208_i0 | PRJNA478247 | 272 | 945 | 5.341703 | 50.47909335 | Chytridiomycetes | 451435 | Fungi | Fungi | 472 | 5.19e-161 | NR | KAJ3199733.1 | 109932 | g208 | i0 | 71.4 | 5.86984126984127 | 311 | 85 | 97.5 | 1 | 931 | 11 | 289 | 599 | KAJ3199733.1 hypothetical protein HDU82_000197 [Entophlyctis luteolus] | diamond | 5547 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 30739742 | 30739742 | PRJNA478247_P_NODE_154_length_1186_cov_2.669836_g112_i0 | PRJNA478247 | 154 | 1186 | 2.669836 | 31.66425496 | Lobulomycetales sp. | 2058121 | Fungi | Fungi | 425 | 2.87e-139 | NR | KAL3896030.1 | 2058121 | g112 | i0 | 73.4 | 0.733558178752108 | 290 | 72 | 72.1 | 2 | 5 | 859 | 341 | 630 | KAL3896030.1 MAG: hypothetical protein SGCHY_004340 [Lobulomycetales sp.] | diamond | 870 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 30819119 | 30819119 | PRJNA478247_P_NODE_314_length_862_cov_4.306122_g241_i0 | PRJNA478247 | 314 | 862 | 4.306122 | 37.11877164 | Chytridiomycota | 4761 | Fungi | Fungi | 254 | 9.69e-81 | NR | XP_016604523.1 | 645134 | g241 | i0 | 59.8 | 2.56844547563805 | 244 | 92 | 83.9 | 3 | 849 | 127 | 1 | 241 | XP_016604523.1 40S ribosomal protein S6 [Spizellomyces punctatus DAOM BR117] | diamond | 2214 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 30945586 | 30945586 | PRJNA478247_P_NODE_2814_length_189_cov_1.950000_g2708_i0 | PRJNA478247 | 2814 | 189 | 1.95 | 3.6855 | Fungi | 4751 | Fungi | Fungi | 49.7 | 5.25e-5 | NR | XP_016604523.1 | 645134 | g2708 | i0 | 62.2 | 2.9047619047619 | 45 | 17 | 71.4 | 0 | 3 | 137 | 192 | 236 | XP_016604523.1 40S ribosomal protein S6 [Spizellomyces punctatus DAOM BR117] | diamond | 549 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 31008660 | 31008660 | PRJNA478247_P_NODE_1814_length_264_cov_2.697872_g1708_i0 | PRJNA478247 | 1814 | 264 | 2.697872 | 7.12238208 | Fungi | 4751 | Fungi | Fungi | 113 | 9.27e-30 | NR | KAH9258566.1 | 1357716 | g1708 | i0 | 68.4 | 7.86363636363636 | 76 | 24 | 86.4 | 0 | 36 | 263 | 11 | 86 | KAH9258566.1 40S ribosomal protein S16 [Batrachochytrium salamandrivorans] | diamond | 2076 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31672561 | 31672561 | PRJNA478247_P_NODE_1557_length_297_cov_1.485075_g1451_i0 | PRJNA478247 | 1557 | 297 | 1.485075 | 4.41067275 | Eukaryota | 2759 | Fungi | Fungi | 66.6 | 1.8e-10 | NR | KAJ3049047.1 | 64517 | g1451 | i0 | 65.2 | 2.61616161616162 | 46 | 16 | 46.5 | 0 | 292 | 155 | 16 | 61 | KAJ3049047.1 Carbohydrate esterase 4 protein [Rhizophlyctis rosea] | diamond | 777 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 32162852 | 32162852 | PRJNA478247_P_NODE_2238_length_226_cov_2.131980_g2132_i0 | PRJNA478247 | 2238 | 226 | 2.13198 | 4.8182748 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 67 | 1.56e-11 | NR | XP_052969381.1 | 110093 | g2132 | i0 | 59.6 | 0.623893805309734 | 47 | 19 | 62.4 | 0 | 145 | 5 | 61 | 107 | XP_052969381.1 Cerato-platanin-domain-containing protein [Polychytrium aggregatum] | diamond | 141 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 32368898 | 32368898 | PRJNA478247_P_NODE_1079_length_386_cov_5.969188_g973_i0 | PRJNA478247 | 1079 | 386 | 5.969188 | 23.04106568 | Fungi | 4751 | Fungi | Fungi | 129 | 8.8e-36 | NR | KAJ3092365.1 | 2654861 | g973 | i0 | 54.4 | 6.82383419689119 | 125 | 52 | 93.3 | 2 | 26 | 385 | 1 | 125 | KAJ3092365.1 60S ribosomal protein L27 [Quaeritorhiza haematococci] | diamond | 2634 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 32527172 | 32527172 | PRJNA478247_P_NODE_3339_length_161_cov_1.712121_g3233_i0 | PRJNA478247 | 3339 | 161 | 1.712121 | 2.75651481 | Fungi | 4751 | Fungi | Fungi | 77.8 | 1.91e-16 | NR | KAI8923218.1 | 281842 | g3233 | i0 | 63.5 | 1.90062111801242 | 52 | 19 | 96.9 | 0 | 157 | 2 | 93 | 144 | KAI8923218.1 Ran binding domain-containing protein, partial [Entophlyctis helioformis] | diamond | 306 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis |
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);;