contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10416840 | 10416840 | PRJNA1108487_P_NODE_1969_length_484_cov_2.836983_g1903_i0 | PRJNA1108487 | 1969 | 484 | 2.836983 | 13.73099772 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 283 | 1.54e-71 | NTclustered | gi|2432061697|ref|XM_053067628.1| | 1396493 | g1903 | i0 | 77.547 | 17.1177685950413 | 481 | 100 | 99 | 8 | 8 | 484 | 519 | 43 | Fimicolochytrium jonesii translation protein SH3-like domain-containing protein (EV422DRAFT_492826), partial mRNA | blastn | 8285 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 10416881 | 10416881 | PRJNA1108487_P_NODE_7889_length_259_cov_1.655914_g7823_i0 | PRJNA1108487 | 7889 | 259 | 1.655914 | 4.28881726 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 183 | 8.02e-42 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g7823 | i0 | 82.609 | 79.6216216216216 | 207 | 36 | 80 | 0 | 50 | 256 | 502 | 296 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 20622 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 14242236 | 14242236 | PRJNA1108487_P_NODE_7012_length_273_cov_1.095000_g6946_i0 | PRJNA1108487 | 7012 | 273 | 1.095 | 2.98935 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 167 | 8.579999999999999e-37 | NTclustered | gi|2432151864|ref|XM_053111326.1| | 110093 | g6946 | i0 | 77.903 | 4.64468864468865 | 267 | 59 | 98 | 0 | 1 | 267 | 738 | 472 | Polychytrium aggregatum glucosamine-6-phosphate isomerase (BJ171DRAFT_508873), mRNA | blastn | 1268 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16323099 | 16323099 | PRJNA1108487_P_NODE_1293_length_586_cov_1.668616_g1228_i0 | PRJNA1108487 | 1293 | 586 | 1.668616 | 9.77808976 | Spizellomycetales | 34478 | Fungi | Fungi | 453 | 1.36e-122 | NTclustered | gi|1027028346|ref|XM_016756817.1| | 645134 | g1228 | i0 | 82.109 | 88.6058020477816 | 531 | 93 | 90 | 2 | 1 | 530 | 1782 | 1253 | Spizellomyces punctatus DAOM BR117 ADP,ATP carrier protein 1, mitochondrial, variant (SPPG_08669), partial mRNA | blastn | 51923 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 19339313 | 19339313 | PRJNA1108487_P_NODE_7996_length_257_cov_2.489130_g7930_i0 | PRJNA1108487 | 7996 | 257 | 2.48913 | 6.3970641 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 121 | 6.319999999999999e-23 | NTclustered | gi|575480991|ref|XM_006679727.1| | 684364 | g7930 | i0 | 81.046 | 1.40466926070039 | 153 | 27 | 59 | 2 | 51 | 202 | 176 | 25 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_12294), partial mRNA | blastn | 361 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis |
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);;