contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 813646 | 813646 | PRJNA812715_P_NODE_52501_length_370_cov_0.824916_g50703_i0 | PRJNA812715 | 52501 | 370 | 0.824916 | 3.0521892 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 202 | 3.3e-47 | NTclustered | gi|2432161565|ref|XM_053111915.1| | 110093 | g50703 | i0 | 83.796 | 52.9405405405405 | 216 | 31 | 58 | 2 | 7 | 220 | 94 | 307 | Polychytrium aggregatum ribosomal protein S17e (BJ171DRAFT_515216), mRNA | blastn | 19588 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 2089070 | 2089070 | PRJNA812715_P_NODE_43982_length_417_cov_9.895349_g42187_i0 | PRJNA812715 | 43982 | 417 | 9.895349 | 41.26360533 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 283 | 1.31e-71 | NTclustered | gi|1027029543|ref|XR_001677161.1| | 645134 | g42187 | i0 | 94.086 | 54.4196642685851 | 186 | 11 | 45 | 0 | 1 | 186 | 3852 | 4037 | Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11002), rRNA | blastn | 22693 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 7189981 | 7189981 | PRJNA812715_P_NODE_105426_length_249_cov_1.238636_g103625_i0 | PRJNA812715 | 105426 | 249 | 1.238636 | 3.08420364 | Neocallimastix patriciarum | 4758 | Fungi | Fungi | 71.3 | 6.22e-8 | NTclustered | gi|560648|gb|S71569.1| | 4758 | g103625 | i0 | 93.617 | 0.365461847389558 | 47 | 3 | 19 | 0 | 165 | 211 | 2513 | 2559 | xynB=Xylanase B [Neocallimastix patriciarum, mRNA, 2819 nt] | blastn | 91 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix patriciarum | |
| 7602936 | 7602936 | PRJNA812715_P_NODE_22526_length_693_cov_5.335484_g20847_i0 | PRJNA812715 | 22526 | 693 | 5.335484 | 36.97490412 | Gallinipes | 2304323 | Fungi | Fungi | 545 | 2.6e-150 | NTclustered | gi|1866582577|gb|MT730752.1| | 117822 | g20847 | i0 | 87.169 | 76.9033189033189 | 491 | 49 | 77 | 10 | 1 | 490 | 3926 | 4403 | Gallinipes pseudodichotomus isolate JEL0583 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 53294 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gallinipes | Gallinipes pseudodichotomus | |
| 8466641 | 8466641 | PRJNA812715_P_NODE_53467_length_365_cov_1.880137_g51668_i0 | PRJNA812715 | 53467 | 365 | 1.880137 | 6.86250005 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 472 | 2.24e-128 | NTclustered | gi|1866582436|gb|MT730611.1| | 382530 | g51668 | i0 | 90.411 | 100.117808219178 | 365 | 26 | 100 | 6 | 1 | 365 | 1595 | 1240 | Gorgonomyces haynaldii isolate ARG036 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 36543 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 11016377 | 11016377 | PRJNA812715_P_NODE_18189_length_818_cov_3.495302_g16636_i0 | PRJNA812715 | 18189 | 818 | 3.495302 | 28.59157036 | Rhizophydium sphaerotheca | 109902 | Fungi | Fungi | 185 | 7.769999999999998e-42 | NTclustered | gi|82398246|gb|DQ273781.1| | 109902 | g16636 | i0 | 80.534 | 14.8545232273839 | 262 | 34 | 30 | 8 | 7 | 252 | 2006 | 1746 | Rhizophydium sphaerotheca isolate AFTOL-ID 37 28S ribosomal RNA gene, partial sequence | blastn | 12151 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiaceae | Rhizophydium | Rhizophydium sphaerotheca | |
| 13568451 | 13568451 | PRJNA812715_P_NODE_93031_length_264_cov_1.073298_g91230_i0 | PRJNA812715 | 93031 | 264 | 1.073298 | 2.83350672 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 239 | 1.72e-58 | NTclustered | gi|1759163857|ref|XM_031171354.1| | 1806994 | g91230 | i0 | 83.019 | 145.147727272727 | 265 | 43 | 100 | 2 | 1 | 264 | 2760 | 2497 | Synchytrium microbalum uncharacterized protein (SmJEL517_g05428), partial mRNA | blastn | 38319 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 21216465 | 21216465 | PRJNA812715_P_NODE_74417_length_295_cov_0.873874_g72617_i0 | PRJNA812715 | 74417 | 295 | 0.873874 | 2.5779283 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 193 | 1.55e-44 | NTclustered | gi|2432058109|ref|XM_053065686.1| | 1396493 | g72617 | i0 | 79.926 | 5.9864406779661 | 269 | 48 | 90 | 5 | 1 | 266 | 477 | 212 | Fimicolochytrium jonesii elongation factor alpha-like protein (EV422DRAFT_244629), mRNA | blastn | 1766 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;