contig_metadata
7 rows where bioproject = "PRJNA498309", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 481306 | 481306 | PRJNA498309_P_NODE_74221_length_270_cov_3.377682_g72072_i0 | PRJNA498309 | 74221 | 270 | 3.377682 | 9.1197414 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1027028008|ref|XM_016756790.1| | 645134 | g72072 | i0 | 94.444 | 0.133333333333333 | 36 | 2 | 13 | 0 | 23 | 58 | 493 | 528 | Spizellomyces punctatus DAOM BR117 histone H3 (SPPG_08644), mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 15783376 | 15783376 | PRJNA498309_P_NODE_40093_length_436_cov_37.298246_g37987_i0 | PRJNA498309 | 40093 | 436 | 37.298246 | 162.62035256 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 298 | 4.9e-76 | NTclustered | gi|1027005164|ref|XM_016754649.1| | 645134 | g37987 | i0 | 84.076 | 39.7064220183486 | 314 | 44 | 71 | 6 | 85 | 395 | 460 | 150 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L44 (SPPG_06444), mRNA | blastn | 17312 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 19606110 | 19606110 | PRJNA498309_P_NODE_117196_length_159_cov_2.901639_g115047_i0 | PRJNA498309 | 117196 | 159 | 2.901639 | 4.61360601 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1026947804|ref|XM_016748426.1| | 645134 | g115047 | i0 | 100 | 0.182389937106918 | 29 | 0 | 18 | 0 | 43 | 71 | 760 | 788 | Spizellomyces punctatus DAOM BR117 uncharacterized protein (SPPG_00089), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 26697081 | 26697081 | PRJNA498309_P_NODE_59821_length_328_cov_8.106529_g57673_i0 | PRJNA498309 | 59821 | 328 | 8.106529 | 26.58941512 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 67 | 3.02e-10 | NR | KAJ3013248.1 | 1396496 | g57673 | i0 | 75.6 | 0.375 | 41 | 10 | 37.5 | 0 | 22 | 144 | 559 | 599 | KAJ3013248.1 Dihydroxyacetone kinase 2 [Thoreauomyces humboldtii] | diamond | 123 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 28277011 | 28277011 | PRJNA498309_P_NODE_18506_length_678_cov_10.942278_g16738_i0 | PRJNA498309 | 18506 | 678 | 10.942278 | 74.18864484 | Siphonaria sp. JEL | 2047469 | Fungi | Fungi | 122 | 9.909999999999998e-31 | NR | KAJ3027592.1 | 2723227 | g16738 | i0 | 45.3 | 0.606194690265487 | 137 | 75 | 60.6 | 0 | 165 | 575 | 10 | 146 | KAJ3027592.1 hypothetical protein HDU68_003525 [Siphonaria sp. JEL0065] | diamond | 411 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Siphonaria | Siphonaria sp. JEL0065 | |
| 28435135 | 28435135 | PRJNA498309_P_NODE_72226_length_277_cov_3.866667_g70077_i0 | PRJNA498309 | 72226 | 277 | 3.866667 | 10.71066759 | Phlyctochytrium arcticum | 1117335 | Fungi | Fungi | 72.8 | 1.52e-12 | NR | KAI9100368.1 | 1117335 | g70077 | i0 | 41.6 | 0.963898916967509 | 89 | 48 | 95.3 | 2 | 4 | 267 | 506 | 591 | KAI9100368.1 hypothetical protein DFS34DRAFT_592273 [Phlyctochytrium arcticum] | diamond | 267 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium arcticum | |
| 30740503 | 30740503 | PRJNA498309_P_NODE_74274_length_270_cov_2.502146_g72125_i0 | PRJNA498309 | 74274 | 270 | 2.502146 | 6.7557942 | Powellomyces hirtus | 109895 | Fungi | Fungi | 73.2 | 9.14e-14 | NR | TPX57767.1 | 109895 | g72125 | i0 | 60.8 | 0.566666666666667 | 51 | 20 | 56.7 | 0 | 248 | 96 | 126 | 176 | TPX57767.1 hypothetical protein PhCBS80983_g03586 [Powellomyces hirtus] | diamond | 153 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus |
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);;