contig_metadata
6 rows where bioproject = "PRJNA1120771", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7406461 | 7406461 | PRJNA1120771_S_NODE_7306_length_375_cov_2.756024_g6906_i0 | PRJNA1120771 | 7306 | 375 | 2.756024 | 10.33509 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 138 | 1.39e-38 | NR | KAI9138263.1 | 1500003 | g6906 | i0 | 60.6 | 14.16 | 99 | 39 | 79.2 | 0 | 299 | 3 | 80 | 178 | KAI9138263.1 GAF domain-like protein [Paraphysoderma sedebokerense] | diamond | 5310 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28827674 | 28827674 | PRJNA1120771_S_NODE_39728_length_188_cov_5.400000_g39328_i0 | PRJNA1120771 | 39728 | 188 | 5.4 | 10.152 | Blastocladiales | 4805 | Fungi | Fungi | 88.6 | 1.2e-18 | NR | ORZ38083.1 | 765915 | g39328 | i0 | 71.7 | 5.13829787234043 | 53 | 15 | 84.6 | 0 | 186 | 28 | 449 | 501 | ORZ38083.1 P-loop containing nucleoside triphosphate hydrolase protein [Catenaria anguillulae PL171] | diamond | 966 | 89.4 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29501522 | 29501522 | PRJNA1120771_S_NODE_25290_length_238_cov_2.523077_g24890_i0 | PRJNA1120771 | 25290 | 238 | 2.523077 | 6.00492326 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 52.8 | 1.02e-5 | NR | KAI9168422.1 | 1313167 | g24890 | i0 | 65.6 | 0.403361344537815 | 32 | 11 | 40.3 | 0 | 1 | 96 | 510 | 541 | KAI9168422.1 Dihydrosphingosine phosphate lyase [Blastocladiella emersonii ATCC 22665] | diamond | 96 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30153850 | 30153850 | PRJNA1120771_S_NODE_26032_length_235_cov_1.958333_g25632_i0 | PRJNA1120771 | 26032 | 235 | 1.958333 | 4.60208255 | Fungi | 4751 | Fungi | Fungi | 95.1 | 7.740000000000001e-21 | NR | KAI9216227.1 | 64508 | g25632 | i0 | 65.6 | 11.4510638297872 | 64 | 22 | 81.7 | 0 | 2 | 193 | 367 | 430 | KAI9216227.1 GTP-binding protein YchF [Blastocladiella britannica] | diamond | 2691 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31207072 | 31207072 | PRJNA1120771_S_NODE_28395_length_227_cov_0.945652_g27995_i0 | PRJNA1120771 | 28395 | 227 | 0.945652 | 2.14663004 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 110 | 1.5e-26 | NR | KAI9146552.1 | 1500003 | g27995 | i0 | 62.7 | 0.991189427312775 | 75 | 28 | 99.1 | 0 | 227 | 3 | 291 | 365 | KAI9146552.1 CMGC/GSK protein kinase [Paraphysoderma sedebokerense] | diamond | 225 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31365884 | 31365884 | PRJNA1120771_S_NODE_8196_length_360_cov_15.624606_g7796_i0 | PRJNA1120771 | 8196 | 360 | 15.624606 | 56.2485816 | Allomyces arbusculus | 64504 | Fungi | Fungi | 165 | 4.36e-50 | NR | KAJ3373363.1 | 64504 | g7796 | i0 | 71.1 | 0.95 | 114 | 33 | 95 | 0 | 4 | 345 | 18 | 131 | KAJ3373363.1 60S ribosomal protein L32 [Allomyces arbusculus] | diamond | 342 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus |
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);;