contig_metadata
8 rows where bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9872810 | 9872810 | PRJNA971676_P_NODE_1788_length_565_cov_1.837398_g1700_i0 | PRJNA971676 | 1788 | 565 | 1.837398 | 10.3812987 | Fungi | 4751 | Fungi | Fungi | 175 | 1.62e-51 | NR | ORX94405.1 | 1314790 | g1700 | i0 | 58.4 | 5.25663716814159 | 161 | 62 | 83.4 | 3 | 485 | 15 | 79 | 238 | ORX94405.1 hypothetical protein K493DRAFT_315504 [Basidiobolus meristosporus CBS 931.73] | diamond | 2970 | 175 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 20071239 | 20071239 | PRJNA971676_P_NODE_16516_length_248_cov_1.337143_g16427_i0 | PRJNA971676 | 16516 | 248 | 1.337143 | 3.31611464 | Syncephalis pseudoplumigaleata | 1712513 | Fungi | Fungi | 113 | 1.07e-28 | NR | RKP27769.1 | 1712513 | g16427 | i0 | 67.1 | 6.94354838709677 | 82 | 26 | 98 | 1 | 247 | 5 | 73 | 154 | RKP27769.1 14-3-3 domain-containing protein [Syncephalis pseudoplumigaleata] | diamond | 1722 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis pseudoplumigaleata | |
| 21668790 | 21668790 | PRJNA971676_P_NODE_2377_length_497_cov_1.261792_g2288_i0 | PRJNA971676 | 2377 | 497 | 1.261792 | 6.27110624 | Fungi | 4751 | Fungi | Fungi | 123 | 7.01e-32 | NR | OLY80923.1 | 133383 | g2288 | i0 | 55.6 | 4.4486921529175 | 124 | 52 | 73 | 2 | 418 | 56 | 84 | 207 | OLY80923.1 Elongation factor 1-beta' [Smittium mucronatum] | diamond | 2211 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 29142032 | 29142032 | PRJNA971676_P_NODE_23789_length_234_cov_2.105590_g23700_i0 | PRJNA971676 | 23789 | 234 | 2.10559 | 4.9270806 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 95.5 | 8.810000000000001e-21 | NR | ORX85620.1 | 1314790 | g23700 | i0 | 51.9 | 6.91025641025641 | 77 | 37 | 98.7 | 0 | 232 | 2 | 322 | 398 | ORX85620.1 ARM repeat-containing protein [Basidiobolus meristosporus CBS 931.73] | diamond | 1617 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 29179837 | 29179837 | PRJNA971676_P_NODE_14229_length_251_cov_0.865169_g14140_i0 | PRJNA971676 | 14229 | 251 | 0.865169 | 2.17157419 | Zoopagomycota | 1913638 | Fungi | Fungi | 48.5 | 3.27e-4 | NR | KAK9701383.1 | 34480 | g14140 | i0 | 52.1 | 4.54183266932271 | 48 | 23 | 57.4 | 0 | 235 | 92 | 222 | 269 | KAK9701383.1 hypothetical protein K7432_011746 [Basidiobolus ranarum] | diamond | 1140 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 30120620 | 30120620 | PRJNA971676_P_NODE_18672_length_246_cov_0.890173_g18583_i0 | PRJNA971676 | 18672 | 246 | 0.890173 | 2.18982558 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 47.8 | 6.28e-4 | NR | KAK9766111.1 | 34480 | g18583 | i0 | 36 | 0.914634146341463 | 75 | 48 | 91.5 | 0 | 3 | 227 | 27 | 101 | KAK9766111.1 protein-ER retention protein [Basidiobolus ranarum] | diamond | 225 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 30727284 | 30727284 | PRJNA971676_P_NODE_15354_length_250_cov_0.870056_g15265_i0 | PRJNA971676 | 15354 | 250 | 0.870056 | 2.17514 | Fungi | 4751 | Fungi | Fungi | 81.6 | 2.28e-18 | NR | RKP08539.1 | 78915 | g15265 | i0 | 75.5 | 2.94 | 49 | 12 | 58.8 | 0 | 3 | 149 | 20 | 68 | RKP08539.1 ribosomal L39 protein-domain-containing protein [Thamnocephalis sphaerospora] | diamond | 735 | 82 | 0.995121951219512 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 31416406 | 31416406 | PRJNA971676_P_NODE_10236_length_284_cov_1.459716_g10147_i0 | PRJNA971676 | 10236 | 284 | 1.459716 | 4.14559344 | Coemansia sp. RSA 552 | 2663883 | Fungi | Fungi | 75.1 | 3.94e-15 | NR | KAJ2162350.1 | 2663883 | g10147 | i0 | 46.5 | 2.20774647887324 | 71 | 34 | 70.8 | 1 | 84 | 284 | 4 | 74 | KAJ2162350.1 60S ribosomal protein L33 [Coemansia sp. RSA 552] | diamond | 627 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 552 |
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);;