contig_metadata
8 rows where bioproject = "PRJNA674048", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6269737 | 6269737 | PRJNA674048_P_NODE_11025_length_281_cov_0.840517_g10822_i0 | PRJNA674048 | 11025 | 281 | 0.840517 | 2.36185277 | Fungi | 4751 | Fungi | Fungi | 134 | 4.6099999999999997e-38 | NR | RKP11106.1 | 78915 | g10822 | i0 | 71.4 | 7.77224199288256 | 91 | 25 | 97.2 | 1 | 278 | 6 | 15 | 104 | RKP11106.1 60S ribosomal protein L32 [Thamnocephalis sphaerospora] | diamond | 2184 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 27492632 | 27492632 | PRJNA674048_P_NODE_27983_length_168_cov_0.873950_g27780_i0 | PRJNA674048 | 27983 | 168 | 0.87395 | 1.468236 | Dipsacomyces acuminosporus | 4866 | Fungi | Fungi | 89.7 | 1.42e-20 | NR | KAJ1963151.1 | 4866 | g27780 | i0 | 89.1 | 3.26785714285714 | 46 | 5 | 82.1 | 0 | 2 | 139 | 111 | 156 | KAJ1963151.1 ribosomal 40S subunit protein S18B [Dipsacomyces acuminosporus] | diamond | 549 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Dipsacomyces | Dipsacomyces acuminosporus | |
| 28072730 | 28072730 | PRJNA674048_P_NODE_23105_length_183_cov_1.544776_g22902_i0 | PRJNA674048 | 23105 | 183 | 1.544776 | 2.82694008 | Zoopagomycota | 1913638 | Fungi | Fungi | 82.4 | 1.86e-18 | NR | PVU97332.1 | 61424 | g22902 | i0 | 72.2 | 12.0983606557377 | 54 | 15 | 88.5 | 0 | 164 | 3 | 9 | 62 | PVU97332.1 hypothetical protein BB559_002082 [Furculomyces boomerangus] | diamond | 2214 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 29525340 | 29525340 | PRJNA674048_P_NODE_10670_length_286_cov_2.632911_g10467_i0 | PRJNA674048 | 10670 | 286 | 2.632911 | 7.53012546 | Zoopagomycota | 1913638 | Fungi | Fungi | 123 | 3.42e-31 | NR | KAI9502195.1 | 417178 | g10467 | i0 | 61.6 | 1.82517482517483 | 86 | 33 | 90.2 | 0 | 258 | 1 | 143 | 228 | KAI9502195.1 ribosomal protein L3-domain-containing protein [Coemansia spiralis] | diamond | 522 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia spiralis | |
| 30504492 | 30504492 | PRJNA674048_P_NODE_5093_length_464_cov_2.501205_g4890_i0 | PRJNA674048 | 5093 | 464 | 2.501205 | 11.6055912 | Fungi | 4751 | Fungi | Fungi | 134 | 3.29e-36 | NR | KAK9719523.1 | 34480 | g4890 | i0 | 60.6 | 1.8426724137931 | 94 | 37 | 60.8 | 0 | 2 | 283 | 99 | 192 | KAK9719523.1 hypothetical protein K7432_004732 [Basidiobolus ranarum] | diamond | 855 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 30788791 | 30788791 | PRJNA674048_P_NODE_16074_length_222_cov_1.803468_g15871_i0 | PRJNA674048 | 16074 | 222 | 1.803468 | 4.00369896 | Smittium | 4888 | Fungi | Fungi | 67.8 | 4.33e-11 | NR | PWA02982.1 | 133377 | g15871 | i0 | 58.3 | 5.59459459459459 | 60 | 19 | 73 | 2 | 213 | 52 | 267 | 326 | PWA02982.1 hypothetical protein BB558_000856 [Smittium angustum] | diamond | 1242 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium angustum | |
| 32654018 | 32654018 | PRJNA674048_P_NODE_14600_length_235_cov_1.440860_g14397_i0 | PRJNA674048 | 14600 | 235 | 1.44086 | 3.386021 | Fungi | 4751 | Fungi | Fungi | 119 | 1.99e-32 | NR | KAK9763929.1 | 34480 | g14397 | i0 | 76.6 | 9.81702127659574 | 77 | 18 | 98.3 | 0 | 3 | 233 | 53 | 129 | KAK9763929.1 60S ribosomal protein L18, variant 2 [Basidiobolus ranarum] | diamond | 2307 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 32717334 | 32717334 | PRJNA674048_P_NODE_16040_length_222_cov_2.768786_g15837_i0 | PRJNA674048 | 16040 | 222 | 2.768786 | 6.14670492 | Fungi | 4751 | Fungi | Fungi | 67.4 | 6.99e-12 | NR | PVU94845.1 | 133385 | g15837 | i0 | 50.6 | 12.5540540540541 | 77 | 34 | 98.6 | 2 | 220 | 2 | 12 | 88 | PVU94845.1 hypothetical protein BB561_002225 [Smittium simulii] | diamond | 2787 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii |
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);;