contig_metadata
13 rows where bioproject = "PRJNA395690", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9339850 | 9339850 | PRJNA395690_P_NODE_29628_length_166_cov_0.871795_g29476_i0 | PRJNA395690 | 29628 | 166 | 0.871795 | 1.4471797 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 115 | 1.58e-29 | NR | KAI9349450.1 | 2211651 | g29476 | i0 | 96.4 | 3.97590361445783 | 55 | 2 | 99.4 | 0 | 165 | 1 | 156 | 210 | KAI9349450.1 succinyl-CoA ligase subunit alpha [Zopfochytrium polystomum] | diamond | 660 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 13165610 | 13165610 | PRJNA395690_P_NODE_7211_length_300_cov_2.776892_g7059_i0 | PRJNA395690 | 7211 | 300 | 2.776892 | 8.330676 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 4.51e-25 | NTclustered | gi|2432058563|ref|XM_053065718.1| | 1396493 | g7059 | i0 | 79.558 | 2.76 | 181 | 35 | 60 | 2 | 31 | 210 | 259 | 80 | Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA | blastn | 828 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 14440349 | 14440349 | PRJNA395690_P_NODE_14692_length_212_cov_1.564417_g14540_i0 | PRJNA395690 | 14692 | 212 | 1.564417 | 3.31656404 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 120 | 2.41e-32 | NR | KAH9254165.1 | 1357716 | g14540 | i0 | 80 | 0.990566037735849 | 70 | 14 | 99.1 | 0 | 1 | 210 | 105 | 174 | KAH9254165.1 hypothetical protein BASA81_007754 [Batrachochytrium salamandrivorans] | diamond | 210 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 20813297 | 20813297 | PRJNA395690_P_NODE_2557_length_488_cov_2.200456_g2409_i0 | PRJNA395690 | 2557 | 488 | 2.200456 | 10.73822528 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 208 | 6.97e-60 | NR | KAI8893489.1 | 382532 | g2409 | i0 | 63.2 | 1.00204918032787 | 163 | 59 | 99.6 | 1 | 2 | 487 | 379 | 541 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 489 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 24637820 | 24637820 | PRJNA395690_P_NODE_11320_length_242_cov_1.321244_g11168_i0 | PRJNA395690 | 11320 | 242 | 1.321244 | 3.19741048 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 213 | 9.45e-51 | NTclustered | gi|2432072489|ref|XM_053067168.1| | 1396493 | g11168 | i0 | 83.051 | 64.2768595041322 | 236 | 38 | 97 | 2 | 2 | 236 | 216 | 450 | Fimicolochytrium jonesii beta-tubulin (EV422DRAFT_430739), mRNA | blastn | 15555 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 27580796 | 27580796 | PRJNA395690_P_NODE_29764_length_166_cov_0.871795_g29612_i0 | PRJNA395690 | 29764 | 166 | 0.871795 | 1.4471797 | Irineochytrium annulatum | 109884 | Fungi | Fungi | 52 | 4.19e-6 | NR | KAJ3192691.1 | 109884 | g29612 | i0 | 51.9 | 2.80120481927711 | 52 | 25 | 94 | 0 | 165 | 10 | 150 | 201 | KAJ3192691.1 60S ribosomal protein L16B [Irineochytrium annulatum] | diamond | 465 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 28102676 | 28102676 | PRJNA395690_P_NODE_13785_length_219_cov_1.500000_g13633_i0 | PRJNA395690 | 13785 | 219 | 1.5 | 3.285 | Opisthokonta | 33154 | Fungi | Fungi | 77.4 | 2.47e-16 | NR | KAI8897850.1 | 382532 | g13633 | i0 | 73.2 | 1.10958904109589 | 41 | 11 | 56.2 | 0 | 28 | 150 | 11 | 51 | KAI8897850.1 hypothetical protein BC833DRAFT_620851 [Globomyces pollinis-pini] | diamond | 243 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 29050152 | 29050152 | PRJNA395690_P_NODE_34448_length_162_cov_0.902655_g34296_i0 | PRJNA395690 | 34448 | 162 | 0.902655 | 1.4623011 | Eukaryota | 2759 | Fungi | Fungi | 50.4 | 2.31e-5 | NR | KAI8904331.1 | 382530 | g34296 | i0 | 63.9 | 1.2962962962963 | 36 | 13 | 66.7 | 0 | 47 | 154 | 353 | 388 | KAI8904331.1 Aldehyde/histidinol dehydrogenase [Gorgonomyces haynaldii] | diamond | 210 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 29506806 | 29506806 | PRJNA395690_P_NODE_36050_length_161_cov_0.910714_g35898_i0 | PRJNA395690 | 36050 | 161 | 0.910714 | 1.46624954 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 78.2 | 3.82e-15 | NR | TPX48653.1 | 286115 | g35898 | i0 | 64.2 | 13.8074534161491 | 53 | 19 | 98.8 | 0 | 159 | 1 | 334 | 386 | TPX48653.1 pyruvate kinase [Synchytrium endobioticum] | diamond | 2223 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 30643915 | 30643915 | PRJNA395690_P_NODE_30793_length_165_cov_0.879310_g30641_i0 | PRJNA395690 | 30793 | 165 | 0.87931 | 1.4508615 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 87 | 2.8e-18 | NR | KAL2918738.1 | 2732419 | g30641 | i0 | 66.7 | 2.94545454545455 | 54 | 18 | 98.2 | 0 | 3 | 164 | 307 | 360 | KAL2918738.1 hypothetical protein HK105_201572 [Polyrhizophydium stewartii] | diamond | 486 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 30787231 | 30787231 | PRJNA395690_P_NODE_9914_length_258_cov_1.555024_g9762_i0 | PRJNA395690 | 9914 | 258 | 1.555024 | 4.01196192 | Chytridiomycota | 4761 | Fungi | Fungi | 94.7 | 1.04e-22 | NR | XP_016605787.1 | 645134 | g9762 | i0 | 60.5 | 5.34883720930233 | 76 | 27 | 84.9 | 1 | 2 | 220 | 59 | 134 | XP_016605787.1 uncharacterized protein SPPG_06748 [Spizellomyces punctatus DAOM BR117] | diamond | 1380 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 30833657 | 30833657 | PRJNA395690_P_NODE_31274_length_165_cov_0.879310_g31122_i0 | PRJNA395690 | 31274 | 165 | 0.87931 | 1.4508615 | Entophlyctis sp. JEL | 2012325 | Fungi | Fungi | 62 | 2.12e-9 | NR | KAJ3392024.1 | 2724211 | g31122 | i0 | 54.7 | 1.94545454545455 | 53 | 24 | 96.4 | 0 | 162 | 4 | 698 | 750 | KAJ3392024.1 GDP/GTP exchange factor for ARF [Entophlyctis sp. JEL0112] | diamond | 321 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis sp. JEL0112 | |
| 31781968 | 31781968 | PRJNA395690_P_NODE_7657_length_291_cov_22.512397_g7505_i0 | PRJNA395690 | 7657 | 291 | 22.512397 | 65.51107527 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 50.4 | 5.4e-6 | NR | ORX33265.1 | 1754192 | g7505 | i0 | 70.3 | 1.06185567010309 | 37 | 11 | 38.1 | 0 | 2 | 112 | 12 | 48 | ORX33265.1 hypothetical protein BCR32DRAFT_239461, partial [Anaeromyces robustus] | diamond | 309 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus |
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);;