contig_metadata
8 rows where bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5423658 | 5423658 | PRJNA1192965_P_NODE_785_length_426_cov_0.852691_g766_i0 | PRJNA1192965 | 785 | 426 | 0.852691 | 3.63246366 | root | 1 | Root_unresolved | Root_unresolved | 214 | 6.66e-65 | NR | KAI8325671.1 | 61414 | g766 | i0 | 71.6 | 54.5845070422535 | 141 | 40 | 99.3 | 0 | 2 | 424 | 284 | 424 | KAI8325671.1 translation elongation factor 1-alpha [Martensiomyces pterosporus] | diamond | 23253 | 216 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 26838490 | 26838490 | PRJNA1192965_P_NODE_921_length_402_cov_4.851064_g902_i0 | PRJNA1192965 | 921 | 402 | 4.851064 | 19.50127728 | Coemansia | 4863 | Fungi | Fungi | 164 | 2.2e-45 | NR | KAJ2909322.1 | 417176 | g902 | i0 | 64.2 | 12.1417910447761 | 123 | 44 | 91.8 | 0 | 34 | 402 | 138 | 260 | KAJ2909322.1 translation initiation factor eIF4A [Coemansia aciculifera] | diamond | 4881 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia aciculifera | |
| 27262130 | 27262130 | PRJNA1192965_P_NODE_4703_length_243_cov_1.358824_g4684_i0 | PRJNA1192965 | 4703 | 243 | 1.358824 | 3.30194232 | Entomophthora muscae | 34485 | Fungi | Fungi | 137 | 2.71e-35 | NR | KAJ9085438.1 | 34485 | g4684 | i0 | 77.8 | 46 | 81 | 18 | 100 | 0 | 243 | 1 | 698 | 778 | KAJ9085438.1 hypothetical protein DSO57_1014089 [Entomophthora muscae] | diamond | 11178 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28418057 | 28418057 | PRJNA1192965_P_NODE_2186_length_290_cov_1.419355_g2167_i0 | PRJNA1192965 | 2186 | 290 | 1.419355 | 4.1161295 | Fungi | 4751 | Fungi | Fungi | 123 | 5.2e-31 | NR | KAI0226058.1 | 348617 | g2167 | i0 | 57 | 29.8034482758621 | 93 | 40 | 96.2 | 0 | 285 | 7 | 236 | 328 | KAI0226058.1 hypothetical protein L0F63_005441, partial [Massospora cicadina] | diamond | 8643 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Massospora | Massospora cicadina | |
| 28525277 | 28525277 | PRJNA1192965_P_NODE_567_length_491_cov_4.272727_g548_i0 | PRJNA1192965 | 567 | 491 | 4.272727 | 20.97908957 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 136 | 2.1799999999999996e-37 | NR | PVU86898.1 | 61424 | g548 | i0 | 41 | 0.983706720977597 | 161 | 94 | 97.8 | 1 | 4 | 483 | 4 | 164 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 483 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 29377594 | 29377594 | PRJNA1192965_P_NODE_2149_length_292_cov_1.054795_g2130_i0 | PRJNA1192965 | 2149 | 292 | 1.054795 | 3.0800014 | Coemansia spiralis | 417178 | Fungi | Fungi | 67 | 1.97e-10 | NR | KAJ2711461.1 | 417178 | g2130 | i0 | 36.5 | 1.96232876712329 | 96 | 46 | 98.6 | 1 | 3 | 290 | 1123 | 1203 | KAJ2711461.1 U3 snoRNP protein, partial [Coemansia spiralis] | diamond | 573 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia spiralis | |
| 29756351 | 29756351 | PRJNA1192965_P_NODE_1251_length_358_cov_5.112281_g1232_i0 | PRJNA1192965 | 1251 | 358 | 5.112281 | 18.30196598 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 96.3 | 6.749999999999999e-23 | NR | KAI8872700.1 | 304332 | g1232 | i0 | 41.3 | 0.91340782122905 | 109 | 56 | 91.3 | 1 | 330 | 4 | 13 | 113 | KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus] | diamond | 327 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 29787894 | 29787894 | PRJNA1192965_P_NODE_4551_length_244_cov_0.900585_g4532_i0 | PRJNA1192965 | 4551 | 244 | 0.900585 | 2.1974274 | Syncephalis plumigaleata | 1851185 | Fungi | Fungi | 82.8 | 3.03e-16 | NR | KAI8056850.1 | 1851185 | g4532 | i0 | 50.8 | 1.6844262295082 | 65 | 32 | 79.9 | 0 | 5 | 199 | 930 | 994 | KAI8056850.1 hypothetical protein BDF22DRAFT_668242 [Syncephalis plumigaleata] | diamond | 411 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata |
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);;