contig_metadata
5 rows where bioproject = "PRJNA793147", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8430764 | 8430764 | PRJNA793147_P_NODE_27367_length_318_cov_2.004016_g27101_i0 | PRJNA793147 | 27367 | 318 | 2.004016 | 6.37277088 | Fungi | 4751 | Fungi | Fungi | 179 | 3.8999999999999997e-53 | NR | KAJ1938000.1 | 61395 | g27101 | i0 | 80.2 | 93.7735849056604 | 106 | 21 | 100 | 0 | 1 | 318 | 93 | 198 | KAJ1938000.1 asparagine synthetase [Linderina pennispora] | diamond | 29820 | 180 | 0.994444444444444 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 28064484 | 28064484 | PRJNA793147_P_NODE_52825_length_233_cov_1.756098_g52559_i0 | PRJNA793147 | 52825 | 233 | 1.756098 | 4.09170834 | Entomophthora muscae | 34485 | Fungi | Fungi | 106 | 2.27e-25 | NR | KAJ9088763.1 | 34485 | g52559 | i0 | 59.3 | 15.1158798283262 | 81 | 29 | 99.1 | 1 | 231 | 1 | 188 | 268 | KAJ9088763.1 hypothetical protein DSO57_1019915 [Entomophthora muscae] | diamond | 3522 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 29494509 | 29494509 | PRJNA793147_P_NODE_54010_length_232_cov_1.797546_g53744_i0 | PRJNA793147 | 54010 | 232 | 1.797546 | 4.17030672 | Fungi | 4751 | Fungi | Fungi | 115 | 4.67e-29 | NR | KAI8320404.1 | 61414 | g53744 | i0 | 85.9 | 22.3448275862069 | 64 | 9 | 82.8 | 0 | 2 | 193 | 278 | 341 | KAI8320404.1 electron transfer flavoprotein, alpha subunit [Martensiomyces pterosporus] | diamond | 5184 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 31570953 | 31570953 | PRJNA793147_P_NODE_22036_length_354_cov_4.382456_g21770_i0 | PRJNA793147 | 22036 | 354 | 4.382456 | 15.51389424 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 48.9 | 1.93e-4 | NR | KAK9767721.1 | 34480 | g21770 | i0 | 47.7 | 0.796610169491525 | 44 | 23 | 37.3 | 0 | 43 | 174 | 16 | 59 | KAK9767721.1 hypothetical protein K7432_002242 [Basidiobolus ranarum] | diamond | 282 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 31855360 | 31855360 | PRJNA793147_P_NODE_34137_length_287_cov_1.981651_g33871_i0 | PRJNA793147 | 34137 | 287 | 1.981651 | 5.68733837 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 63.2 | 3.92e-9 | NR | KAI9295766.1 | 1314799 | g33871 | i0 | 60.2 | 1.52613240418118 | 93 | 36 | 96.2 | 1 | 279 | 4 | 172 | 264 | KAI9295766.1 Calreticulin [Neoconidiobolus thromboides FSU 785] | diamond | 438 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides |
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);;