contig_metadata
8 rows where bioproject = "PRJNA591127", tax_clade = "Opisthokonta" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13319068 | 13319068 | PRJNA591127_P_NODE_28011_length_154_cov_1.196581_g27842_i0 | PRJNA591127 | 28011 | 154 | 1.196581 | 1.84273474 | Entomophthora muscae | 34485 | Fungi | Fungi | 263 | 5.36e-66 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g27842 | i0 | 97.403 | 4.06493506493506 | 154 | 4 | 100 | 0 | 1 | 154 | 2015 | 1862 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 626 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 15867641 | 15867641 | PRJNA591127_P_NODE_11313_length_219_cov_1.928571_g11144_i0 | PRJNA591127 | 11313 | 219 | 1.928571 | 4.22357049 | Entomophthora planchoniana | 177370 | Fungi | Fungi | 399 | 6.009999999999999e-107 | NTclustered | gi|1390220560|gb|MH366738.1| | 177370 | g11144 | i0 | 99.543 | 50.5844748858447 | 219 | 1 | 100 | 0 | 1 | 219 | 329 | 547 | Entomophthora planchoniana voucher Number 9 large subunit ribosomal RNA gene, partial sequence | blastn | 11078 | 399 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora planchoniana | |
| 15867744 | 15867744 | PRJNA591127_P_NODE_21793_length_190_cov_0.921569_g21624_i0 | PRJNA591127 | 21793 | 190 | 0.921569 | 1.7509811 | Entomophthora muscae | 34485 | Fungi | Fungi | 335 | 1.4499999999999993e-87 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g21624 | i0 | 98.421 | 3.35263157894737 | 190 | 3 | 100 | 0 | 1 | 190 | 1880 | 1691 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 637 | 335 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 27142535 | 27142535 | PRJNA591127_P_NODE_19502_length_197_cov_1.981250_g19333_i0 | PRJNA591127 | 19502 | 197 | 1.98125 | 3.9030625 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 43.5 | 0.0106 | NR | KAI9298149.1 | 1314799 | g19333 | i0 | 75 | 0.730964467005076 | 24 | 6 | 36.5 | 0 | 74 | 3 | 149 | 172 | KAI9298149.1 delta6 fatty acid elongase [Neoconidiobolus thromboides FSU 785] | diamond | 144 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 27205859 | 27205859 | PRJNA591127_P_NODE_6922_length_280_cov_1.765432_g6754_i0 | PRJNA591127 | 6922 | 280 | 1.765432 | 4.9432096 | Smittium mucronatum | 133383 | Fungi | Fungi | 90.9 | 1.09e-20 | NR | OLY82642.1 | 133383 | g6754 | i0 | 48.4 | 1.99285714285714 | 93 | 48 | 99.6 | 0 | 280 | 2 | 54 | 146 | OLY82642.1 60S ribosomal protein L12 [Smittium mucronatum] | diamond | 558 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 27314586 | 27314586 | PRJNA591127_P_NODE_23243_length_179_cov_4.492958_g23074_i0 | PRJNA591127 | 23243 | 179 | 4.492958 | 8.04239482 | Eukaryota | 2759 | Fungi | Fungi | 95.1 | 6.14e-22 | NR | OLY79614.1 | 133383 | g23074 | i0 | 79.7 | 7.91061452513966 | 59 | 12 | 98.9 | 0 | 177 | 1 | 48 | 106 | OLY79614.1 40S ribosomal protein S0 [Smittium mucronatum] | diamond | 1416 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 27837625 | 27837625 | PRJNA591127_P_NODE_10724_length_225_cov_1.218085_g10556_i0 | PRJNA591127 | 10724 | 225 | 1.218085 | 2.74069125 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 58.9 | 1.34e-8 | NR | PVU86898.1 | 61424 | g10556 | i0 | 38.4 | 0.973333333333333 | 73 | 44 | 96 | 1 | 5 | 220 | 4 | 76 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 219 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 30743187 | 30743187 | PRJNA591127_P_NODE_16954_length_197_cov_2.637500_g16785_i0 | PRJNA591127 | 16954 | 197 | 2.6375 | 5.195875 | Smittium megazygosporum | 133381 | Fungi | Fungi | 68.9 | 1.16e-11 | NR | PVV04126.1 | 133381 | g16785 | i0 | 94.1 | 2.04060913705584 | 34 | 2 | 51.8 | 0 | 102 | 1 | 204 | 237 | PVV04126.1 hypothetical protein BB560_001381 [Smittium megazygosporum] | diamond | 402 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium megazygosporum |
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);;