contig_metadata
6 rows where bioproject = "PRJNA1082072", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1017106 | 1017106 | PRJNA1082072_P_NODE_1341_length_299_cov_2.084071_g1334_i0 | PRJNA1082072 | 1341 | 299 | 2.084071 | 6.23137229 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 158 | 2.97e-47 | NR | PVU86898.1 | 61424 | g1334 | i0 | 80.4 | 12.7725752508361 | 97 | 19 | 97.3 | 0 | 292 | 2 | 1 | 97 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 3819 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 1467765 | 1467765 | PRJNA1082072_P_NODE_642_length_397_cov_1.425926_g635_i0 | PRJNA1082072 | 642 | 397 | 1.425926 | 5.66092622 | Fungi | 4751 | Fungi | Fungi | 189 | 1.05e-58 | NR | RKP23686.1 | 1712513 | g635 | i0 | 69.7 | 2.99244332493703 | 132 | 40 | 99.7 | 0 | 1 | 396 | 38 | 169 | RKP23686.1 ribosomal protein L18e/L15P, partial [Syncephalis pseudoplumigaleata] | diamond | 1188 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis pseudoplumigaleata | |
| 28038197 | 28038197 | PRJNA1082072_P_NODE_665_length_393_cov_1.203125_g658_i0 | PRJNA1082072 | 665 | 393 | 1.203125 | 4.72828125 | Entomophthorales | 4857 | Fungi | Fungi | 94.7 | 7.03e-20 | NR | KAI0226058.1 | 348617 | g658 | i0 | 38.6 | 1.93893129770992 | 127 | 73 | 96.9 | 2 | 5 | 385 | 267 | 388 | KAI0226058.1 hypothetical protein L0F63_005441, partial [Massospora cicadina] | diamond | 762 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Massospora | Massospora cicadina | |
| 30067423 | 30067423 | PRJNA1082072_P_NODE_732_length_380_cov_1.674267_g725_i0 | PRJNA1082072 | 732 | 380 | 1.674267 | 6.3622146 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 100 | 2.6599999999999998e-24 | NR | KAI8872700.1 | 304332 | g725 | i0 | 41.9 | 0.923684210526316 | 117 | 60 | 92.4 | 1 | 14 | 364 | 13 | 121 | KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus] | diamond | 351 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 30383864 | 30383864 | PRJNA1082072_P_NODE_2953_length_241_cov_0.916667_g2946_i0 | PRJNA1082072 | 2953 | 241 | 0.916667 | 2.20916747 | Mycoemilia scoparia | 417184 | Fungi | Fungi | 138 | 1.46e-38 | NR | KAJ1918897.1 | 417184 | g2946 | i0 | 86.1 | 3.93360995850622 | 79 | 11 | 98.3 | 0 | 4 | 240 | 129 | 207 | KAJ1918897.1 60S ribosomal protein L8 [Mycoemilia scoparia] | diamond | 948 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia | |
| 31268218 | 31268218 | PRJNA1082072_P_NODE_1095_length_330_cov_0.898833_g1088_i0 | PRJNA1082072 | 1095 | 330 | 0.898833 | 2.9661489 | Smittium culicis | 133412 | Fungi | Fungi | 94 | 1.29e-21 | NR | OMJ24719.1 | 133412 | g1088 | i0 | 43.6 | 2 | 110 | 61 | 99.1 | 1 | 327 | 1 | 4 | 113 | OMJ24719.1 60S ribosomal protein L12 [Smittium culicis] | diamond | 660 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium culicis |
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);;