contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5126189 | 5126189 | PRJEB28062_P_NODE_117525_length_266_cov_14.435233_g115162_i0 | PRJEB28062 | 117525 | 266 | 14.435233 | 38.39771978 | Smittium simulii | 133385 | Fungi | Fungi | 60.8 | 1.65e-8 | NR | PVU98264.1 | 133385 | g115162 | i0 | 64.6 | 0.541353383458647 | 48 | 17 | 54.1 | 0 | 26 | 169 | 229 | 276 | PVU98264.1 hypothetical protein BB561_000038 [Smittium simulii] | diamond | 144 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii | |
| 26646609 | 26646609 | PRJEB28062_P_NODE_126801_length_247_cov_0.885057_g124437_i0 | PRJEB28062 | 126801 | 247 | 0.885057 | 2.18609079 | Harpellales | 61421 | Fungi | Fungi | 105 | 3.45e-27 | NR | PVU85474.1 | 61424 | g124437 | i0 | 76.6 | 2.33198380566802 | 64 | 15 | 77.7 | 0 | 246 | 55 | 44 | 107 | PVU85474.1 hypothetical protein BB559_007000 [Furculomyces boomerangus] | diamond | 576 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 28233120 | 28233120 | PRJEB28062_P_NODE_115166_length_272_cov_8.000000_g112803_i0 | PRJEB28062 | 115166 | 272 | 8 | 21.76 | Entomophthora muscae | 34485 | Fungi | Fungi | 46.2 | 0.00313 | NR | KAJ9065681.1 | 34485 | g112803 | i0 | 47.9 | 0.529411764705882 | 48 | 20 | 52.9 | 1 | 228 | 85 | 506 | 548 | KAJ9065681.1 glutamate decarboxylase gad1 [Entomophthora muscae] | diamond | 144 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 30759982 | 30759982 | PRJEB28062_P_NODE_42454_length_555_cov_18.143154_g40118_i0 | PRJEB28062 | 42454 | 555 | 18.143154 | 100.6945047 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 59.3 | 9.44e-8 | NR | KAK9763158.1 | 34480 | g40118 | i0 | 47.4 | 0.308108108108108 | 57 | 30 | 30.8 | 0 | 487 | 317 | 19 | 75 | KAK9763158.1 hypothetical protein K7432_010426 [Basidiobolus ranarum] | diamond | 171 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 30848256 | 30848256 | PRJEB28062_P_NODE_52594_length_489_cov_8.132212_g50241_i0 | PRJEB28062 | 52594 | 489 | 8.1322120000000009 | 39.76651668 | Zoopagomycota | 1913638 | Fungi | Fungi | 46.2 | 0.00324 | NR | RKP39213.1 | 215637 | g50241 | i0 | 43.1 | 2.23926380368098 | 51 | 29 | 31.3 | 0 | 129 | 281 | 7 | 57 | RKP39213.1 hypothetical protein BJ085DRAFT_18658 [Dimargaris cristalligena] | diamond | 1095 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 31075976 | 31075976 | PRJEB28062_P_NODE_132815_length_233_cov_13.187500_g130451_i0 | PRJEB28062 | 132815 | 233 | 13.1875 | 30.726875 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 49.3 | 1.33e-4 | NR | QUQ05876.1 | 76012 | g130451 | i0 | 100 | 0.334763948497854 | 26 | 0 | 33.5 | 0 | 211 | 134 | 227 | 252 | QUQ05876.1 ATP synthase F0 subunit a [Neoconidiobolus thromboides] | diamond | 78 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 31360545 | 31360545 | PRJEB28062_P_NODE_41316_length_564_cov_24.610998_g38982_i0 | PRJEB28062 | 41316 | 564 | 24.610998 | 138.80602872 | Dispira parvispora | 1520584 | Fungi | Fungi | 54.3 | 4.58e-6 | NR | KAJ1962306.1 | 1520584 | g38982 | i0 | 50 | 0.287234042553192 | 54 | 27 | 28.7 | 0 | 397 | 236 | 7 | 60 | KAJ1962306.1 hypothetical protein IWQ62_003571, partial [Dispira parvispora] | diamond | 162 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora |
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);;