contig_metadata
18 rows where bioproject = "PRJEB673", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12888501 | 12888501 | PRJEB673_P_NODE_4431_length_451_cov_1.783654_g4086_i0 | PRJEB673 | 4431 | 451 | 1.783654 | 8.04427954 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 150 | 1.8499999999999993e-43 | NR | KXS17504.1 | 1344416 | g4086 | i0 | 58.5 | 1.84257206208426 | 142 | 59 | 94.5 | 0 | 428 | 3 | 1 | 142 | KXS17504.1 hypothetical protein M427DRAFT_54448 [Gonapodya prolifera JEL478] | diamond | 831 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 14163246 | 14163246 | PRJEB673_P_NODE_10192_length_179_cov_1.111111_g9843_i0 | PRJEB673 | 10192 | 179 | 1.111111 | 1.98888869 | Geranomyces variabilis | 109894 | Fungi | Fungi | 107 | 1.01e-26 | NR | KAI8592014.1 | 109894 | g9843 | i0 | 86.2 | 1.92737430167598 | 58 | 8 | 97.2 | 0 | 179 | 6 | 7 | 64 | KAI8592014.1 translation protein SH3-like domain-containing protein [Geranomyces variabilis] | diamond | 345 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 15437413 | 15437413 | PRJEB673_P_NODE_4493_length_445_cov_1.443902_g4147_i0 | PRJEB673 | 4493 | 445 | 1.443902 | 6.4253639 | Phlyctochytrium bullatum | 1352834 | Fungi | Fungi | 162 | 4.49e-47 | NR | KAJ3115462.1 | 1352834 | g4147 | i0 | 62.3 | 3.05393258426966 | 151 | 46 | 98.4 | 3 | 1 | 438 | 85 | 229 | KAJ3115462.1 hypothetical protein HDU96_000621 [Phlyctochytrium bullatum] | diamond | 1359 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium bullatum | |
| 15437446 | 15437446 | PRJEB673_P_NODE_8433_length_276_cov_1.120332_g8084_i0 | PRJEB673 | 8433 | 276 | 1.120332 | 3.09211632 | Spizellomycetales | 34478 | Fungi | Fungi | 135 | 2.0599999999999997e-37 | NR | KAJ3155645.1 | 109894 | g8084 | i0 | 81.3 | 5.21739130434783 | 80 | 15 | 87 | 0 | 10 | 249 | 88 | 167 | KAJ3155645.1 hypothetical protein HDU89_006619 [Geranomyces variabilis] | diamond | 1440 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 16711612 | 16711612 | PRJEB673_P_NODE_674_length_1109_cov_2.152700_g519_i0 | PRJEB673 | 674 | 1109 | 2.1527 | 23.873443 | Eukaryota | 2759 | Fungi | Fungi | 216 | 4.98e-64 | NR | TPX55510.1 | 109895 | g519 | i0 | 72.4 | 5.41027953110911 | 156 | 37 | 40.6 | 1 | 232 | 681 | 64 | 219 | TPX55510.1 hypothetical protein PhCBS80983_g05255 [Powellomyces hirtus] | diamond | 6000 | 218 | 0.990825688073395 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 16711643 | 16711643 | PRJEB673_P_NODE_9734_length_189_cov_0.915584_g9385_i0 | PRJEB673 | 9734 | 189 | 0.915584 | 1.73045376 | Chytriomyces hyalinus | 4814 | Fungi | Fungi | 126 | 9.419999999999999e-25 | NTclustered | gi|358030877|dbj|AB609172.1| | 4814 | g9385 | i0 | 89.796 | 47.6190476190476 | 98 | 10 | 52 | 0 | 68 | 165 | 1123 | 1220 | Chytriomyces hyalinus EF2 gene for translation elongation factor 2, partial cds, strain: BR 097 | blastn | 9000 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 25221442 | 25221442 | PRJEB673_P_NODE_2660_length_605_cov_2.238596_g2364_i0 | PRJEB673 | 2660 | 605 | 2.238596 | 13.5435058 | Spizellomycetales | 34478 | Fungi | Fungi | 91.6 | 1.27e-13 | NTclustered | gi|1027025241|ref|XM_016756493.1| | 645134 | g2364 | i0 | 94.828 | 1.5404958677686 | 58 | 3 | 10 | 0 | 505 | 562 | 1011 | 1068 | Spizellomyces punctatus DAOM BR117 uncharacterized protein (SPPG_08336), mRNA | blastn | 932 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 27918452 | 27918452 | PRJEB673_P_NODE_10845_length_168_cov_1.436090_g10496_i0 | PRJEB673 | 10845 | 168 | 1.43609 | 2.4126312 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 107 | 2.22e-25 | NR | KAI9016760.1 | 82268 | g10496 | i0 | 87.3 | 0.982142857142857 | 55 | 7 | 98.2 | 0 | 3 | 167 | 717 | 771 | KAI9016760.1 P-loop containing nucleoside triphosphate hydrolase protein [Hyaloraphidium curvatum] | diamond | 165 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 28644886 | 28644886 | PRJEB673_P_NODE_2447_length_628_cov_2.563238_g2160_i0 | PRJEB673 | 2447 | 628 | 2.563238 | 16.09713464 | Neocallimastix californiae | 1754190 | Fungi | Fungi | 61.2 | 4.42e-8 | NR | ORY76186.1 | 1754190 | g2160 | i0 | 36.8 | 0.506369426751592 | 106 | 62 | 48.2 | 2 | 376 | 74 | 36 | 141 | ORY76186.1 ankyrin, partial [Neocallimastix californiae] | diamond | 318 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix californiae | |
| 29150343 | 29150343 | PRJEB673_P_NODE_5609_length_374_cov_1.870206_g5260_i0 | PRJEB673 | 5609 | 374 | 1.870206 | 6.99457044 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 62 | 2.97e-9 | NR | TPX38815.1 | 286115 | g5260 | i0 | 40.5 | 3.42513368983957 | 131 | 57 | 95.5 | 3 | 359 | 3 | 9 | 130 | TPX38815.1 hypothetical protein SeLEV6574_g07608 [Synchytrium endobioticum] | diamond | 1281 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 29371059 | 29371059 | PRJEB673_P_NODE_12009_length_157_cov_0.983607_g11660_i0 | PRJEB673 | 12009 | 157 | 0.983607 | 1.54426299 | Spizellomyces sp. 'palustris' | 117820 | Fungi | Fungi | 63.5 | 5.31e-10 | NR | TPX66965.1 | 117820 | g11660 | i0 | 55.8 | 1.98726114649682 | 52 | 23 | 99.4 | 0 | 157 | 2 | 782 | 833 | TPX66965.1 hypothetical protein SpCBS45565_g04145 [Spizellomyces sp. 'palustris'] | diamond | 312 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 31013532 | 31013532 | PRJEB673_P_NODE_12255_length_155_cov_1.158333_g11906_i0 | PRJEB673 | 12255 | 155 | 1.158333 | 1.79541615 | Lobulomycetales sp. | 2058121 | Fungi | Fungi | 55.5 | 3.62e-7 | NR | KAL3896030.1 | 2058121 | g11906 | i0 | 44 | 0.967741935483871 | 50 | 28 | 96.8 | 0 | 2 | 151 | 59 | 108 | KAL3896030.1 MAG: hypothetical protein SGCHY_004340 [Lobulomycetales sp.] | diamond | 150 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 31234637 | 31234637 | PRJEB673_P_NODE_7435_length_316_cov_1.772242_g7086_i0 | PRJEB673 | 7435 | 316 | 1.772242 | 5.60028472 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 101 | 4.36e-25 | NR | KXS22283.1 | 1344416 | g7086 | i0 | 47.3 | 1.04430379746835 | 110 | 48 | 94.9 | 2 | 16 | 315 | 1 | 110 | KXS22283.1 hypothetical protein M427DRAFT_150603 [Gonapodya prolifera JEL478] | diamond | 330 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 31393085 | 31393085 | PRJEB673_P_NODE_10336_length_176_cov_1.418440_g9987_i0 | PRJEB673 | 10336 | 176 | 1.41844 | 2.4964544 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 96.7 | 1.4399999999999994e-23 | NR | KAJ1569873.1 | 2732417 | g9987 | i0 | 69 | 11.8636363636364 | 58 | 18 | 98.9 | 0 | 176 | 3 | 60 | 117 | KAJ1569873.1 60S ribosomal protein L9 [Nowakowskiella sp. JEL0078] | diamond | 2088 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0078 | |
| 31519595 | 31519595 | PRJEB673_P_NODE_5096_length_400_cov_1.693151_g4747_i0 | PRJEB673 | 5096 | 400 | 1.693151 | 6.772604 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 124 | 2.53e-32 | NR | KAJ1569731.1 | 1604274 | g4747 | i0 | 56.5 | 4.6425 | 124 | 53 | 93 | 1 | 399 | 28 | 92 | 214 | KAJ1569731.1 40S ribosomal protein S6 [Cladochytrium tenue] | diamond | 1857 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 32152169 | 32152169 | PRJEB673_P_NODE_8858_length_230_cov_1.266667_g8509_i0 | PRJEB673 | 8858 | 230 | 1.266667 | 2.9133341 | Neocallimastix californiae | 1754190 | Fungi | Fungi | 97.1 | 2.3700000000000003e-21 | NR | ORY20291.1 | 1754190 | g8509 | i0 | 68.4 | 0.991304347826087 | 76 | 24 | 99.1 | 0 | 229 | 2 | 457 | 532 | ORY20291.1 hsp71-like protein [Neocallimastix californiae] | diamond | 228 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix californiae | |
| 32208285 | 32208285 | PRJEB673_P_NODE_6878_length_330_cov_2.030508_g6529_i0 | PRJEB673 | 6878 | 330 | 2.030508 | 6.7006764 | Eukaryota | 2759 | Fungi | Fungi | 62.8 | 2.13e-9 | NR | KAJ3050097.1 | 64517 | g6529 | i0 | 67.4 | 1.17272727272727 | 43 | 14 | 39.1 | 0 | 200 | 328 | 61 | 103 | KAJ3050097.1 60S ribosomal protein L18 [Rhizophlyctis rosea] | diamond | 387 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 32524980 | 32524980 | PRJEB673_P_NODE_9479_length_196_cov_1.242236_g9130_i0 | PRJEB673 | 9479 | 196 | 1.242236 | 2.43478256 | Fungi | 4751 | Fungi | Fungi | 84.7 | 3.25e-17 | NR | KAI8810892.1 | 109936 | g9130 | i0 | 62.1 | 2.00510204081633 | 66 | 24 | 99.5 | 1 | 1 | 195 | 478 | 543 | KAI8810892.1 hypothetical protein BJ742DRAFT_851550 [Cladochytrium replicatum] | diamond | 393 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum |
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);;