contig_metadata
17 rows where bioproject = "PRJEB12982", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6088807 | 6088807 | PRJEB12982_P_NODE_21185_length_161_cov_0.910714_g21022_i0 | PRJEB12982 | 21185 | 161 | 0.910714 | 1.46624954 | Spizellomyces | 4815 | Fungi | Fungi | 130 | 6.01e-26 | NTclustered | gi|358030875|dbj|AB609171.1| | 109760 | g21022 | i0 | 83.453 | 53.1987577639752 | 139 | 23 | 86 | 0 | 4 | 142 | 1650 | 1512 | Spizellomyces punctatus EF2 gene for translation elongation factor 2, partial cds, strain: BR117A | blastn | 8565 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 10223712 | 10223712 | PRJEB12982_P_NODE_18929_length_164_cov_0.886957_g18766_i0 | PRJEB12982 | 18929 | 164 | 0.886957 | 1.45460948 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 117 | 1.02e-29 | NR | KAH9256009.1 | 1357716 | g18766 | i0 | 92.6 | 1.97560975609756 | 54 | 4 | 98.8 | 0 | 163 | 2 | 57 | 110 | KAH9256009.1 hypothetical protein BASA81_005785 [Batrachochytrium salamandrivorans] | diamond | 324 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 11499116 | 11499116 | PRJEB12982_P_NODE_9710_length_227_cov_1.146067_g9547_i0 | PRJEB12982 | 9710 | 227 | 1.146067 | 2.60157209 | Chytridiomycota | 4761 | Fungi | Fungi | 134 | 2.48e-34 | NR | KAI9016760.1 | 82268 | g9547 | i0 | 78.7 | 6.93832599118943 | 75 | 16 | 99.1 | 0 | 3 | 227 | 734 | 808 | KAI9016760.1 P-loop containing nucleoside triphosphate hydrolase protein [Hyaloraphidium curvatum] | diamond | 1575 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 26900215 | 26900215 | PRJEB12982_P_NODE_17661_length_166_cov_0.871795_g17498_i0 | PRJEB12982 | 17661 | 166 | 0.871795 | 1.4471797 | Chytridiomycetes | 451435 | Fungi | Fungi | 51.2 | 1.33e-5 | NR | KAJ3054942.1 | 64517 | g17498 | i0 | 69.7 | 6.50602409638554 | 33 | 10 | 59.6 | 0 | 99 | 1 | 271 | 303 | KAJ3054942.1 Serine/threonine-protein phosphatase 2A activator 2 [Rhizophlyctis rosea] | diamond | 1080 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 27601931 | 27601931 | PRJEB12982_P_NODE_12624_length_197_cov_1.378378_g12461_i0 | PRJEB12982 | 12624 | 197 | 1.378378 | 2.71540466 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 43.9 | 6.84e-4 | NR | ORX76604.1 | 1754192 | g12461 | i0 | 52 | 1.47715736040609 | 50 | 16 | 65.5 | 2 | 67 | 195 | 3 | 51 | ORX76604.1 hypothetical protein BCR32DRAFT_208919, partial [Anaeromyces robustus] | diamond | 291 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus | |
| 28264640 | 28264640 | PRJEB12982_P_NODE_17306_length_167_cov_0.864407_g17143_i0 | PRJEB12982 | 17306 | 167 | 0.864407 | 1.44355969 | Globomyces sp. JEL | 2786946 | Fungi | Fungi | 51.6 | 9.12e-6 | NR | KAJ2997452.1 | 2786946 | g17143 | i0 | 50 | 1.72455089820359 | 48 | 24 | 86.2 | 0 | 22 | 165 | 53 | 100 | KAJ2997452.1 hypothetical protein HDV02_005493 [Globomyces sp. JEL0801] | diamond | 288 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces sp. JEL0801 | |
| 28289865 | 28289865 | PRJEB12982_P_NODE_9786_length_226_cov_1.440678_g9623_i0 | PRJEB12982 | 9786 | 226 | 1.440678 | 3.25593228 | Eukaryota | 2759 | Fungi | Fungi | 86.3 | 2.07e-18 | NR | XP_006676755.1 | 684364 | g9623 | i0 | 60 | 4.30088495575221 | 65 | 26 | 86.3 | 0 | 31 | 225 | 1 | 65 | XP_006676755.1 uncharacterized protein BATDEDRAFT_32888 [Batrachochytrium dendrobatidis JAM81] | diamond | 972 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 28296268 | 28296268 | PRJEB12982_P_NODE_14106_length_185_cov_1.830882_g13943_i0 | PRJEB12982 | 14106 | 185 | 1.830882 | 3.3871317 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 79 | 2.95e-15 | NR | KXS19902.1 | 1344416 | g13943 | i0 | 64.2 | 7.18378378378378 | 53 | 19 | 85.9 | 0 | 159 | 1 | 475 | 527 | KXS19902.1 ADK-domain-containing protein [Gonapodya prolifera JEL478] | diamond | 1329 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 28296271 | 28296271 | PRJEB12982_P_NODE_20386_length_162_cov_0.902655_g20223_i0 | PRJEB12982 | 20386 | 162 | 0.902655 | 1.4623011 | Piromyces finnis | 1754191 | Fungi | Fungi | 48.9 | 8.56e-5 | NR | ORX43360.1 | 1754191 | g20223 | i0 | 43.4 | 0.981481481481482 | 53 | 30 | 98.1 | 0 | 1 | 159 | 655 | 707 | ORX43360.1 clathrin heavy chain [Piromyces finnis] | diamond | 159 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces finnis | |
| 28864646 | 28864646 | PRJEB12982_P_NODE_10428_length_218_cov_1.846154_g10265_i0 | PRJEB12982 | 10428 | 218 | 1.846154 | 4.02461572 | Dinochytrium kinnereticum | 1774096 | Fungi | Fungi | 48.9 | 1.72e-4 | NR | KAJ3210420.1 | 1774096 | g10265 | i0 | 62.9 | 0.481651376146789 | 35 | 13 | 48.2 | 0 | 107 | 3 | 200 | 234 | KAJ3210420.1 hypothetical protein HDU67_005333 [Dinochytrium kinnereticum] | diamond | 105 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Dinochytrium | Dinochytrium kinnereticum | |
| 29268637 | 29268637 | PRJEB12982_P_NODE_18269_length_165_cov_0.879310_g18106_i0 | PRJEB12982 | 18269 | 165 | 0.87931 | 1.4508615 | Fungi | 4751 | Fungi | Fungi | 82.8 | 9.66e-17 | NR | KAJ3050989.1 | 64517 | g18106 | i0 | 61.1 | 11.7636363636364 | 54 | 21 | 98.2 | 0 | 2 | 163 | 597 | 650 | KAJ3050989.1 hypothetical protein HK097_008030 [Rhizophlyctis rosea] | diamond | 1941 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 29369963 | 29369963 | PRJEB12982_P_NODE_7769_length_259_cov_1.695238_g7606_i0 | PRJEB12982 | 7769 | 259 | 1.695238 | 4.39066642 | Boothiomyces macroporosus | 261099 | Fungi | Fungi | 140 | 2.1299999999999998e-39 | NR | KAJ3261415.1 | 261099 | g7606 | i0 | 83.7 | 0.996138996138996 | 86 | 14 | 99.6 | 0 | 259 | 2 | 26 | 111 | KAJ3261415.1 40S ribosomal protein S3 [Boothiomyces macroporosus] | diamond | 258 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces macroporosus | |
| 29432730 | 29432730 | PRJEB12982_P_NODE_18990_length_164_cov_0.886957_g18827_i0 | PRJEB12982 | 18990 | 164 | 0.886957 | 1.45460948 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 89.7 | 3.54e-19 | NR | KAH9258978.1 | 1357716 | g18827 | i0 | 77.8 | 0.98780487804878 | 54 | 12 | 98.8 | 0 | 1 | 162 | 1004 | 1057 | KAH9258978.1 hypothetical protein BASA81_002598 [Batrachochytrium salamandrivorans] | diamond | 162 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29489685 | 29489685 | PRJEB12982_P_NODE_20170_length_162_cov_1.035398_g20007_i0 | PRJEB12982 | 20170 | 162 | 1.035398 | 1.67734476 | Opisthokonta | 33154 | Fungi | Fungi | 84.7 | 2.8e-18 | NR | KAJ3047154.1 | 64517 | g20007 | i0 | 70.4 | 10 | 54 | 16 | 100 | 0 | 162 | 1 | 135 | 188 | KAJ3047154.1 60S ribosomal protein L7 [Rhizophlyctis rosea] | diamond | 1620 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 29780336 | 29780336 | PRJEB12982_P_NODE_17571_length_166_cov_0.871795_g17408_i0 | PRJEB12982 | 17571 | 166 | 0.871795 | 1.4471797 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 62 | 6.63e-11 | NR | KAH9258993.1 | 1357716 | g17408 | i0 | 56.8 | 0.795180722891566 | 44 | 19 | 79.5 | 0 | 134 | 3 | 27 | 70 | KAH9258993.1 hypothetical protein BASA81_002613 [Batrachochytrium salamandrivorans] | diamond | 132 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32309577 | 32309577 | PRJEB12982_P_NODE_17219_length_167_cov_0.864407_g17056_i0 | PRJEB12982 | 17219 | 167 | 0.864407 | 1.44355969 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 48.5 | 6.08e-5 | NR | KAL2911160.1 | 2732419 | g17056 | i0 | 49.1 | 1.97604790419162 | 55 | 27 | 98.8 | 1 | 166 | 2 | 92 | 145 | KAL2911160.1 hypothetical protein HK105_209368 [Polyrhizophydium stewartii] | diamond | 330 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 32845770 | 32845770 | PRJEB12982_P_NODE_17680_length_166_cov_0.871795_g17517_i0 | PRJEB12982 | 17680 | 166 | 0.871795 | 1.4471797 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 83.6 | 3.44e-18 | NR | KAH9253165.1 | 1357716 | g17517 | i0 | 64.2 | 0.957831325301205 | 53 | 19 | 95.8 | 0 | 165 | 7 | 81 | 133 | KAH9253165.1 hypothetical protein BASA81_008847 [Batrachochytrium salamandrivorans] | diamond | 159 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;