contig_metadata
9 rows where bioproject = "PRJNA771359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9675496 | 9675496 | PRJNA771359_S_NODE_4028_length_168_cov_1.969466_g3945_i0 | PRJNA771359 | 4028 | 168 | 1.969466 | 3.30870288 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 92.8 | 3e-22 | NR | KAI8870089.1 | 304332 | g3945 | i0 | 84.3 | 1.91071428571429 | 51 | 8 | 91.1 | 0 | 153 | 1 | 28 | 78 | KAI8870089.1 hypothetical protein GQ42DRAFT_162991 [Ramicandelaber brevisporus] | diamond | 321 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 10951181 | 10951181 | PRJNA771359_S_NODE_849_length_349_cov_3.221154_g766_i0 | PRJNA771359 | 849 | 349 | 3.221154 | 11.24182746 | Asellaria ligiae | 1520586 | Fungi | Fungi | 62.1 | 5.48e-5 | NTclustered | gi|666440453|gb|KF848912.1| | 1520586 | g766 | i0 | 92.857 | 9.50429799426934 | 42 | 3 | 12 | 0 | 1 | 42 | 924 | 883 | Asellaria ligiae 28S ribosomal RNA gene, partial sequence | blastn | 3317 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Asellariomycetes | Asellariales | Asellaria | Asellaria ligiae | ||
| 26863785 | 26863785 | PRJNA771359_S_NODE_5141_length_151_cov_2.359649_g5058_i0 | PRJNA771359 | 5141 | 151 | 2.359649 | 3.56306999 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 73.2 | 1.26e-14 | NR | KAJ1675833.1 | 68401 | g5058 | i0 | 66 | 8.9205298013245 | 50 | 17 | 99.3 | 0 | 150 | 1 | 34 | 83 | KAJ1675833.1 ribosomal 40S subunit protein S18B [Spiromyces aspiralis] | diamond | 1347 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 27978809 | 27978809 | PRJNA771359_S_NODE_3545_length_179_cov_1.492958_g3462_i0 | PRJNA771359 | 3545 | 179 | 1.492958 | 2.67239482 | Opisthokonta | 33154 | Fungi | Fungi | 62.4 | 2.76e-11 | NR | KAJ2816886.1 | 327750 | g3462 | i0 | 83.3 | 7.81005586592179 | 36 | 6 | 60.3 | 0 | 2 | 109 | 20 | 55 | KAJ2816886.1 ribosomal protein S5, partial [Coemansia sp. 'formosensis'] | diamond | 1398 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. 'formosensis' | |
| 28853154 | 28853154 | PRJNA771359_S_NODE_968_length_332_cov_2.735593_g885_i0 | PRJNA771359 | 968 | 332 | 2.735593 | 9.08216876 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 101 | 5.41e-25 | NR | ORY03384.1 | 1314790 | g885 | i0 | 58.6 | 1.56325301204819 | 87 | 33 | 75.9 | 2 | 3 | 254 | 50 | 136 | ORY03384.1 hypothetical protein K493DRAFT_311750 [Basidiobolus meristosporus CBS 931.73] | diamond | 519 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 29169246 | 29169246 | PRJNA771359_S_NODE_4429_length_161_cov_1.556452_g4346_i0 | PRJNA771359 | 4429 | 161 | 1.556452 | 2.50588772 | Thamnocephalis sphaerospora | 78915 | Fungi | Fungi | 98.6 | 1.77e-25 | NR | RKP09846.1 | 78915 | g4346 | i0 | 93.9 | 0.91304347826087 | 49 | 3 | 91.3 | 0 | 1 | 147 | 29 | 77 | RKP09846.1 cytochrome b5-like heme/steroid binding domain-containing protein [Thamnocephalis sphaerospora] | diamond | 147 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 31453459 | 31453459 | PRJNA771359_S_NODE_4236_length_164_cov_2.141732_g4153_i0 | PRJNA771359 | 4236 | 164 | 2.141732 | 3.51244048 | Fungi | 4751 | Fungi | Fungi | 67.8 | 2.62e-13 | NR | KAJ1965696.1 | 4866 | g4153 | i0 | 75 | 3.29268292682927 | 48 | 12 | 87.8 | 0 | 164 | 21 | 22 | 69 | KAJ1965696.1 60S ribosomal protein L29 [Dipsacomyces acuminosporus] | diamond | 540 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Dipsacomyces | Dipsacomyces acuminosporus | |
| 31927747 | 31927747 | PRJNA771359_S_NODE_1277_length_299_cov_2.820611_g1194_i0 | PRJNA771359 | 1277 | 299 | 2.820611 | 8.43362689 | Eukaryota | 2759 | Fungi | Fungi | 146 | 3.11e-41 | NR | RKP08484.1 | 78915 | g1194 | i0 | 69.7 | 58.5953177257525 | 99 | 30 | 99.3 | 0 | 2 | 298 | 88 | 186 | RKP08484.1 40S ribosomal protein S4 [Thamnocephalis sphaerospora] | diamond | 17520 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 32434306 | 32434306 | PRJNA771359_S_NODE_1819_length_248_cov_2.014218_g1736_i0 | PRJNA771359 | 1819 | 248 | 2.014218 | 4.99526064 | Legeriomycetaceae | 4883 | Fungi | Fungi | 122 | 4.7699999999999996e-32 | NR | PVV02525.1 | 133381 | g1736 | i0 | 70.7 | 5.90322580645161 | 82 | 24 | 99.2 | 0 | 248 | 3 | 132 | 213 | PVV02525.1 hypothetical protein BB560_003012 [Smittium megazygosporum] | diamond | 1464 | 123 | 0.991869918699187 | 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);;