contig_metadata
8 rows where bioproject = "PRJNA986547", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8627119 | 8627119 | PRJNA986547_P_NODE_13127_length_234_cov_4.484472_g13045_i0 | PRJNA986547 | 13127 | 234 | 4.484472 | 10.49366448 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 85.5 | 7.4e-18 | NR | KAJ1561653.1 | 2732417 | g13045 | i0 | 48.7 | 3.91025641025641 | 76 | 37 | 97.4 | 1 | 234 | 7 | 179 | 252 | KAJ1561653.1 hypothetical protein HK096_003849 [Nowakowskiella sp. JEL0078] | diamond | 915 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0078 | |
| 19123564 | 19123564 | PRJNA986547_P_NODE_12235_length_240_cov_5.664671_g12153_i0 | PRJNA986547 | 12235 | 240 | 5.664671 | 13.5952104 | Fungi | 4751 | Fungi | Fungi | 156 | 1.6e-33 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g12153 | i0 | 91.228 | 54.2416666666667 | 114 | 10 | 48 | 0 | 33 | 146 | 523 | 410 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13018 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 27885192 | 27885192 | PRJNA986547_P_NODE_6985_length_261_cov_3.085106_g6903_i0 | PRJNA986547 | 6985 | 261 | 3.085106 | 8.05212666 | Eukaryota | 2759 | Fungi | Fungi | 126 | 2.1099999999999998e-31 | NR | KAI8847627.1 | 64509 | g6903 | i0 | 67.4 | 41.8620689655172 | 86 | 28 | 98.9 | 0 | 4 | 261 | 1306 | 1391 | KAI8847627.1 armadillo-type protein [Chytridium lagenaria] | diamond | 10926 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 28321293 | 28321293 | PRJNA986547_P_NODE_6886_length_262_cov_1.629630_g6804_i0 | PRJNA986547 | 6886 | 262 | 1.62963 | 4.2696306 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 83.6 | 9.16e-17 | NR | KAI9360018.1 | 2211651 | g6804 | i0 | 48.1 | 7.91221374045802 | 79 | 41 | 90.5 | 0 | 262 | 26 | 208 | 286 | KAI9360018.1 JAB1/Mov34/MPN/PAD-1 ubiquitin protease-domain-containing protein [Zopfochytrium polystomum] | diamond | 2073 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 29211510 | 29211510 | PRJNA986547_P_NODE_1569_length_368_cov_7.976271_g1487_i0 | PRJNA986547 | 1569 | 368 | 7.976271 | 29.35267728 | Chytridiomycota | 4761 | Fungi | Fungi | 166 | 3.88e-48 | NR | KAI9026238.1 | 82268 | g1487 | i0 | 77.1 | 2.64130434782609 | 105 | 24 | 85.6 | 0 | 317 | 3 | 6 | 110 | KAI9026238.1 putative mitochondrial ADP/ATP translocase [Hyaloraphidium curvatum] | diamond | 972 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 29615549 | 29615549 | PRJNA986547_P_NODE_8390_length_251_cov_5.432584_g8308_i0 | PRJNA986547 | 8390 | 251 | 5.432584 | 13.63578584 | Spizellomyces punctatus DAOM BR117 | 645134 | Fungi | Fungi | 122 | 2.6e-30 | NR | XP_016605169.1 | 645134 | g8308 | i0 | 64.2 | 1.93625498007968 | 81 | 29 | 96.8 | 0 | 2 | 244 | 135 | 215 | XP_016605169.1 uncharacterized protein SPPG_07522 [Spizellomyces punctatus DAOM BR117] | diamond | 486 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 30531890 | 30531890 | PRJNA986547_P_NODE_1773_length_352_cov_4.487455_g1691_i0 | PRJNA986547 | 1773 | 352 | 4.487455 | 15.7958416 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 203 | 7.65e-63 | NR | KAI9360856.1 | 2211651 | g1691 | i0 | 80.2 | 1.98579545454545 | 116 | 23 | 98.9 | 0 | 2 | 349 | 155 | 270 | KAI9360856.1 ATP/ADP translocator [Zopfochytrium polystomum] | diamond | 699 | 203 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 32081110 | 32081110 | PRJNA986547_P_NODE_17098_length_199_cov_10.952381_g17016_i0 | PRJNA986547 | 17098 | 199 | 10.952381 | 21.79523819 | Phlyctochytrium planicorne | 261098 | Fungi | Fungi | 57.8 | 1.03e-7 | NR | KAJ3109844.1 | 261098 | g17016 | i0 | 37.9 | 2.98492462311558 | 66 | 41 | 99.5 | 0 | 198 | 1 | 222 | 287 | KAJ3109844.1 hypothetical protein HDU97_000074 [Phlyctochytrium planicorne] | diamond | 594 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium planicorne |
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);;