contig_metadata
9 rows where bioproject = "PRJEB55122", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21393864 | 21393864 | PRJEB55122_P_NODE_11257_length_372_cov_2.495356_g10860_i0 | PRJEB55122 | 11257 | 372 | 2.495356 | 9.28272432 | Eukaryota | 2759 | Fungi | Fungi | 202 | 3.32e-47 | NTclustered | gi|311235598|ref|NG_027613.1| | 110093 | g10860 | i0 | 89.809 | 47.7876344086022 | 157 | 16 | 42 | 0 | 1 | 157 | 2833 | 2677 | Polychytrium aggregatum JEL 109 28S rRNA gene, partial sequence; from reference material | blastn | 17777 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 27033527 | 27033527 | PRJEB55122_P_NODE_7102_length_521_cov_2.614407_g6712_i0 | PRJEB55122 | 7102 | 521 | 2.614407 | 13.62106047 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 52.4 | 5.48e-5 | NR | KAH9253512.1 | 1357716 | g6712 | i0 | 29.3 | 0.765834932821497 | 133 | 78 | 76.6 | 3 | 447 | 49 | 1 | 117 | KAH9253512.1 hypothetical protein BASA81_008559 [Batrachochytrium salamandrivorans] | diamond | 399 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28707476 | 28707476 | PRJEB55122_P_NODE_31987_length_184_cov_1.777778_g31590_i0 | PRJEB55122 | 31987 | 184 | 1.777778 | 3.27111152 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 81.3 | 6.46e-18 | NR | KAL2916487.1 | 2732419 | g31590 | i0 | 69.5 | 1.94021739130435 | 59 | 16 | 96.2 | 1 | 7 | 183 | 43 | 99 | KAL2916487.1 60S ribosomal protein L26A [Polyrhizophydium stewartii] | diamond | 357 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 28960209 | 28960209 | PRJEB55122_P_NODE_41648_length_164_cov_0.904348_g41251_i0 | PRJEB55122 | 41648 | 164 | 0.904348 | 1.48313072 | Spizellomyces sp. 'palustris' | 117820 | Fungi | Fungi | 70.5 | 2.08e-12 | NR | TPX66860.1 | 117820 | g41251 | i0 | 72.9 | 0.878048780487805 | 48 | 13 | 87.8 | 0 | 159 | 16 | 428 | 475 | TPX66860.1 hypothetical protein SpCBS45565_g04242 [Spizellomyces sp. 'palustris'] | diamond | 144 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 30058228 | 30058228 | PRJEB55122_P_NODE_35931_length_171_cov_1.057377_g35534_i0 | PRJEB55122 | 35931 | 171 | 1.057377 | 1.80811467 | Chytridiales | 4810 | Fungi | Fungi | 44.3 | 0.00394 | NR | KAI8925827.1 | 281842 | g35534 | i0 | 86.4 | 3.2280701754386 | 22 | 3 | 38.6 | 0 | 3 | 68 | 326 | 347 | KAI8925827.1 WD40-repeat-containing domain protein [Entophlyctis helioformis] | diamond | 552 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 30476037 | 30476037 | PRJEB55122_P_NODE_39833_length_166_cov_0.888889_g39436_i0 | PRJEB55122 | 39833 | 166 | 0.888889 | 1.47555574 | Terramyces sp. JEL | 2040976 | Fungi | Fungi | 41.2 | 0.0475 | NR | KAJ3274117.1 | 2724204 | g39436 | i0 | 37.3 | 0.921686746987952 | 51 | 29 | 92.2 | 2 | 160 | 8 | 164 | 211 | KAJ3274117.1 hypothetical protein HDV01_003400 [Terramyces sp. JEL0728] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Terramyces | Terramyces sp. JEL0728 | |
| 30570436 | 30570436 | PRJEB55122_P_NODE_41613_length_164_cov_0.904348_g41216_i0 | PRJEB55122 | 41613 | 164 | 0.904348 | 1.48313072 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 53.9 | 1.44e-6 | NR | KAH9251130.1 | 1357716 | g41216 | i0 | 55.3 | 0.695121951219512 | 38 | 17 | 69.5 | 0 | 115 | 2 | 363 | 400 | KAH9251130.1 hypothetical protein BASA81_011029 [Batrachochytrium salamandrivorans] | diamond | 114 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31708667 | 31708667 | PRJEB55122_P_NODE_42517_length_163_cov_0.912281_g42120_i0 | PRJEB55122 | 42517 | 163 | 0.912281 | 1.48701803 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 57 | 1.12e-7 | NR | KAH9256028.1 | 1357716 | g42120 | i0 | 48.1 | 0.957055214723926 | 52 | 27 | 95.7 | 0 | 161 | 6 | 301 | 352 | KAH9256028.1 hypothetical protein BASA81_005804 [Batrachochytrium salamandrivorans] | diamond | 156 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32246857 | 32246857 | PRJEB55122_P_NODE_13518_length_326_cov_3.176895_g13121_i0 | PRJEB55122 | 13518 | 326 | 3.176895 | 10.3566777 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 44.7 | 0.0185 | NR | KAJ3006379.1 | 1396496 | g13121 | i0 | 35.7 | 0.773006134969325 | 84 | 47 | 70.9 | 1 | 325 | 95 | 251 | 334 | KAJ3006379.1 GPN-loop GTPase 1 [Thoreauomyces humboldtii] | diamond | 252 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii |
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);;