contig_metadata
9 rows where bioproject = "PRJEB8827", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25530306 | 25530306 | PRJEB8827h_S_NODE_1673_length_247_cov_5.183962_g1654_i0 | PRJEB8827 | 1673 | 247 | 5.183962 | 12.80438614 | Eukaryota | 2759 | Fungi | Fungi | 73.2 | 2.04e-14 | NR | KAI8326355.1 | 61414 | g1654 | i0 | 59.3 | 6.44939271255061 | 59 | 24 | 71.7 | 0 | 235 | 59 | 62 | 120 | KAI8326355.1 ribosomal protein L22e, partial [Martensiomyces pterosporus] | diamond | 1593 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 25530368 | 25530368 | PRJEB8827h_S_NODE_49961_length_152_cov_2.179487_g49942_i0 | PRJEB8827 | 49961 | 152 | 2.179487 | 3.31282024 | Smittium culicis | 133412 | Fungi | Fungi | 84.3 | 1.72e-19 | NR | OMJ17335.1 | 133412 | g49942 | i0 | 81.6 | 1.93421052631579 | 49 | 9 | 96.7 | 0 | 4 | 150 | 51 | 99 | OMJ17335.1 60S ribosomal protein L34-B [Smittium culicis] | diamond | 294 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium culicis | |
| 25801660 | 25801660 | PRJEB8827e_S_NODE_14651_length_185_cov_3.246667_g14623_i0 | PRJEB8827 | 14651 | 185 | 3.246667 | 6.00633395 | Smittium mucronatum | 133383 | Fungi | Fungi | 110 | 9.24e-20 | NTclustered | gi|666440451|gb|KF848910.1| | 133383 | g14623 | i0 | 86.869 | 28.7837837837838 | 99 | 11 | 54 | 1 | 1 | 99 | 2803 | 2899 | Smittium mucronatum strain FRA-12-3 28S ribosomal RNA gene, partial sequence | blastn | 5325 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 25802514 | 25802514 | PRJEB8827h_S_NODE_859_length_308_cov_1901.373626_g840_i0 | PRJEB8827 | 859 | 308 | 1901.373626 | 5856.23076808 | Fungi | 4751 | Fungi | Fungi | 80.1 | 1.77e-15 | NR | KXN68762.1 | 796925 | g840 | i0 | 55.2 | 3.81818181818182 | 67 | 30 | 65.3 | 0 | 308 | 108 | 195 | 261 | KXN68762.1 60S ribosomal protein L8 [Conidiobolus coronatus NRRL 28638] | diamond | 1176 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 26074141 | 26074141 | PRJEB8827f_S_NODE_1149_length_349_cov_11.401274_g1129_i0 | PRJEB8827 | 1149 | 349 | 11.401274 | 39.79044626 | Smittium culicis | 133412 | Fungi | Fungi | 72 | 1.48e-13 | NR | OMJ17335.1 | 133412 | g1129 | i0 | 78.3 | 1.18624641833811 | 46 | 10 | 39.5 | 0 | 347 | 210 | 63 | 108 | OMJ17335.1 60S ribosomal protein L34-B [Smittium culicis] | diamond | 414 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium culicis | |
| 32982774 | 32982774 | PRJEB8827h_S_NODE_11811_length_189_cov_3.714286_g11792_i0 | PRJEB8827 | 11811 | 189 | 3.714286 | 7.02000054 | Coemansia reversa NRRL 1564 | 763665 | Fungi | Fungi | 45.8 | 9.65e-4 | NR | PIA13397.1 | 763665 | g11792 | i0 | 63.4 | 1.28571428571429 | 41 | 13 | 63.5 | 2 | 3 | 122 | 137 | 176 | PIA13397.1 60S ribosomal protein L18-A [Coemansia reversa NRRL 1564] | diamond | 243 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia reversa | |
| 33033861 | 33033861 | PRJEB8827h_S_NODE_644_length_340_cov_6.354098_g625_i0 | PRJEB8827 | 644 | 340 | 6.354098 | 21.6039332 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 95.5 | 3.6000000000000003e-22 | NR | PVU86898.1 | 61424 | g625 | i0 | 43.6 | 2.66470588235294 | 101 | 57 | 89.1 | 0 | 2 | 304 | 64 | 164 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 906 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 33050791 | 33050791 | PRJEB8827g_S_NODE_1565_length_249_cov_3.752336_g1544_i0 | PRJEB8827 | 1565 | 249 | 3.752336 | 9.34331664 | Linderina pennispora | 61395 | Fungi | Fungi | 68.9 | 1.23e-12 | NR | XP_040744554.1 | 61395 | g1544 | i0 | 60 | 1.32530120481928 | 55 | 22 | 66.3 | 0 | 247 | 83 | 80 | 134 | XP_040744554.1 uncharacterized protein DL89DRAFT_322311 [Linderina pennispora] | diamond | 330 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 33170308 | 33170308 | PRJEB8827g_S_NODE_13600_length_153_cov_2.000000_g13579_i0 | PRJEB8827 | 13600 | 153 | 2 | 3.06 | Coemansia biformis | 1286918 | Fungi | Fungi | 40.8 | 0.0476 | NR | KAJ1734016.1 | 1286918 | g13579 | i0 | 53.3 | 0.882352941176471 | 45 | 21 | 88.2 | 0 | 147 | 13 | 158 | 202 | KAJ1734016.1 60S ribosomal protein L16A [Coemansia biformis] | diamond | 135 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia biformis |
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);;