contig_metadata
9 rows where bioproject = "PRJNA399711", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25701627 | 25701627 | PRJNA399711_S_NODE_99762_length_155_cov_2.576271_g99620_i0 | PRJNA399711 | 99762 | 155 | 2.576271 | 3.99322005 | Batrachochytrium dendrobatidis JAM81 | 684364 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|575473373|ref|XM_006675917.1| | 684364 | g99620 | i0 | 94.444 | 0.232258064516129 | 36 | 2 | 23 | 0 | 69 | 104 | 301 | 336 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_84629), partial mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 32935041 | 32935041 | PRJNA399711_S_NODE_84137_length_165_cov_1.976562_g83995_i0 | PRJNA399711 | 84137 | 165 | 1.976562 | 3.2613273 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 60.8 | 4.99e-9 | NR | KAJ3190506.1 | 2724198 | g83995 | i0 | 63.3 | 1.76363636363636 | 49 | 18 | 89.1 | 0 | 3 | 149 | 301 | 349 | KAJ3190506.1 hypothetical protein HDU85_000808 [Gaertneriomyces sp. JEL0708] | diamond | 291 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 32986411 | 32986411 | PRJNA399711_S_NODE_73467_length_173_cov_3.036765_g73325_i0 | PRJNA399711 | 73467 | 173 | 3.036765 | 5.25360345 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 43.9 | 0.00566 | NR | KAI8807887.1 | 109936 | g73325 | i0 | 58.8 | 0.589595375722543 | 34 | 14 | 59 | 0 | 105 | 4 | 15 | 48 | KAI8807887.1 hypothetical protein BJ742DRAFT_811130 [Cladochytrium replicatum] | diamond | 102 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 32992603 | 32992603 | PRJNA399711_S_NODE_58619_length_188_cov_2.092715_g58477_i0 | PRJNA399711 | 58619 | 188 | 2.092715 | 3.9343042 | Gorgonomycetaceae | 1395787 | Fungi | Fungi | 76.6 | 1.37e-16 | NR | KAI8906878.1 | 382530 | g58477 | i0 | 64.9 | 10.9148936170213 | 57 | 20 | 91 | 0 | 3 | 173 | 25 | 81 | KAI8906878.1 ribosomal protein L32e [Gorgonomyces haynaldii] | diamond | 2052 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 33009585 | 33009585 | PRJNA399711_S_NODE_37091_length_221_cov_10.760870_g36949_i0 | PRJNA399711 | 37091 | 221 | 10.76087 | 23.7815227 | Eukaryota | 2759 | Fungi | Fungi | 62 | 5.79e-10 | NR | TPX58422.1 | 109895 | g36949 | i0 | 60.8 | 3.54298642533937 | 51 | 20 | 69.2 | 0 | 219 | 67 | 84 | 134 | TPX58422.1 hypothetical protein PhCBS80983_g03137 [Powellomyces hirtus] | diamond | 783 | 62.4 | 0.993589743589744 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 33071369 | 33071369 | PRJNA399711_S_NODE_54557_length_193_cov_1.884615_g54415_i0 | PRJNA399711 | 54557 | 193 | 1.884615 | 3.63730695 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 77.8 | 4.87e-17 | NR | XP_031026441.1 | 1806994 | g54415 | i0 | 79.2 | 0.746113989637306 | 48 | 9 | 74.6 | 1 | 191 | 48 | 22 | 68 | XP_031026441.1 uncharacterized protein SmJEL517_g01473 [Synchytrium microbalum] | diamond | 144 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 33088257 | 33088257 | PRJNA399711_S_NODE_17742_length_287_cov_5.304000_g17600_i0 | PRJNA399711 | 17742 | 287 | 5.304 | 15.22248 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 77 | 1.42e-15 | NR | XP_031024367.1 | 1806994 | g17600 | i0 | 61 | 1.87108013937282 | 59 | 20 | 58.5 | 1 | 8 | 175 | 76 | 134 | XP_031024367.1 uncharacterized protein SmJEL517_g03786 [Synchytrium microbalum] | diamond | 537 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 33088510 | 33088510 | PRJNA399711_S_NODE_51542_length_197_cov_2.368750_g51400_i0 | PRJNA399711 | 51542 | 197 | 2.36875 | 4.6664375 | Siphonaria sp. JEL | 2047469 | Fungi | Fungi | 42 | 0.0172 | NR | KAJ3028393.1 | 2723227 | g51400 | i0 | 43.9 | 0.624365482233503 | 41 | 19 | 62.4 | 1 | 4 | 126 | 91 | 127 | KAJ3028393.1 Cytoplasmic thioredoxin isoenzyme 2 [Siphonaria sp. JEL0065] | diamond | 123 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Siphonaria | Siphonaria sp. JEL0065 | |
| 33111845 | 33111845 | PRJNA399711_S_NODE_55638_length_191_cov_7.058442_g55496_i0 | PRJNA399711 | 55638 | 191 | 7.058442 | 13.48162422 | Opisthokonta | 33154 | Fungi | Fungi | 70.5 | 1.95e-12 | NR | KAJ3032314.1 | 64517 | g55496 | i0 | 71.4 | 1.96335078534031 | 42 | 12 | 66 | 0 | 2 | 127 | 255 | 296 | KAJ3032314.1 hypothetical protein HDV00_007689 [Rhizophlyctis rosea] | diamond | 375 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea |
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);;