contig_metadata
6 rows where bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2249386 | 2249386 | PRJNA986547_P_NODE_15202_length_216_cov_8.181818_g15120_i0 | PRJNA986547 | 15202 | 216 | 8.181818 | 17.67272688 | Coemansia sp. S146 | 2663918 | Fungi | Fungi | 84.7 | 1.25e-18 | NR | KAJ2059832.1 | 2663918 | g15120 | i0 | 66.7 | 1.66666666666667 | 60 | 20 | 83.3 | 0 | 2 | 181 | 111 | 170 | KAJ2059832.1 ribosomal 40S subunit protein S9B [Coemansia sp. S146] | diamond | 360 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. S146 | |
| 12453340 | 12453340 | PRJNA986547_P_NODE_14370_length_226_cov_2.869281_g14288_i0 | PRJNA986547 | 14370 | 226 | 2.869281 | 6.48457506 | Dimargaris xerosporica | 2761399 | Fungi | Fungi | 124 | 4.699999999999999e-33 | NR | KAJ1977276.1 | 2761399 | g14288 | i0 | 80.6 | 0.955752212389381 | 72 | 14 | 95.6 | 0 | 218 | 3 | 61 | 132 | KAJ1977276.1 cTPxI [Dimargaris xerosporica] | diamond | 216 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris xerosporica | |
| 17849929 | 17849929 | PRJNA986547_P_NODE_6574_length_264_cov_5.361257_g6492_i0 | PRJNA986547 | 6574 | 264 | 5.361257 | 14.15371848 | Linderina pennispora | 61395 | Fungi | Fungi | 103 | 3.4099999999999995e-24 | NR | KAJ1940866.1 | 61395 | g6492 | i0 | 59.3 | 3.90909090909091 | 86 | 35 | 97.7 | 0 | 7 | 264 | 19 | 104 | KAJ1940866.1 protein kinase A catalytic subunit [Linderina pennispora] | diamond | 1032 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 26899968 | 26899968 | PRJNA986547_P_NODE_17341_length_197_cov_12.483871_g17259_i0 | PRJNA986547 | 17341 | 197 | 12.483871 | 24.59322587 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 96.3 | 2.74e-23 | NR | KAJ1679270.1 | 68401 | g17259 | i0 | 83.6 | 7.53807106598985 | 55 | 9 | 83.8 | 0 | 32 | 196 | 1 | 55 | KAJ1679270.1 hypothetical protein EV182_002388 [Spiromyces aspiralis] | diamond | 1485 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 28794753 | 28794753 | PRJNA986547_P_NODE_4427_length_285_cov_8.509434_g4345_i0 | PRJNA986547 | 4427 | 285 | 8.509434 | 24.2518869 | Entomophthora muscae | 34485 | Fungi | Fungi | 148 | 4.11e-42 | NR | KAJ9062554.1 | 34485 | g4345 | i0 | 81.7 | 0.978947368421053 | 93 | 17 | 97.9 | 0 | 281 | 3 | 3 | 95 | KAJ9062554.1 hypothetical protein DSO57_1009610 [Entomophthora muscae] | diamond | 279 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 32556094 | 32556094 | PRJNA986547_P_NODE_6459_length_265_cov_4.229167_g6377_i0 | PRJNA986547 | 6459 | 265 | 4.229167 | 11.20729255 | Dimargaris cristalligena | 215637 | Fungi | Fungi | 141 | 5.019999999999999e-40 | NR | RKP33421.1 | 215637 | g6377 | i0 | 73.3 | 16.5622641509434 | 86 | 23 | 97.4 | 0 | 260 | 3 | 1 | 86 | RKP33421.1 60S ribosomal protein L10-A [Dimargaris cristalligena] | diamond | 4389 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena |
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);;