contig_metadata
4 rows where bioproject = "PRJNA352850", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27770014 | 27770014 | PRJNA352850_P_NODE_16604_length_744_cov_1.876259_g13942_i0 | PRJNA352850 | 16604 | 744 | 1.876259 | 13.95936696 | Coemansia sp. RSA 1843 | 2849849 | Fungi | Fungi | 49.3 | 0.01 | NR | KAJ1769322.1 | 2849849 | g13942 | i0 | 32.3 | 0.673387096774194 | 167 | 93 | 60.5 | 6 | 583 | 134 | 572 | 735 | KAJ1769322.1 hypothetical protein LPJ74_004149 [Coemansia sp. RSA 1843] | diamond | 501 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 1843 | |
| 32477850 | 32477850 | PRJNA352850_P_NODE_16419_length_750_cov_5.072753_g13760_i0 | PRJNA352850 | 16419 | 750 | 5.072753 | 38.0456475 | Syncephalis plumigaleata | 1851185 | Fungi | Fungi | 148 | 3.61e-39 | NR | KAI8055152.1 | 1851185 | g13760 | i0 | 44.6 | 1.388 | 168 | 93 | 67.2 | 0 | 241 | 744 | 120 | 287 | KAI8055152.1 hypothetical protein BDF22DRAFT_675676 [Syncephalis plumigaleata] | diamond | 1041 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata | |
| 32730064 | 32730064 | PRJNA352850_P_NODE_59540_length_302_cov_1.209486_g56707_i0 | PRJNA352850 | 59540 | 302 | 1.209486 | 3.65264772 | Martensiomyces pterosporus | 61414 | Fungi | Fungi | 139 | 1.7899999999999998e-37 | NR | KAI8322993.1 | 61414 | g56707 | i0 | 68 | 3.94370860927152 | 100 | 32 | 99.3 | 0 | 300 | 1 | 155 | 254 | KAI8322993.1 P-loop containing nucleoside triphosphate hydrolase protein [Martensiomyces pterosporus] | diamond | 1191 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 32747067 | 32747067 | PRJNA352850_P_NODE_63280_length_288_cov_3.112971_g60447_i0 | PRJNA352850 | 63280 | 288 | 3.112971 | 8.96535648 | Opisthokonta | 33154 | Fungi | Fungi | 65.1 | 2.88e-10 | NR | PVU98183.1 | 133385 | g60447 | i0 | 54 | 6.38541666666667 | 50 | 23 | 52.1 | 0 | 151 | 2 | 90 | 139 | PVU98183.1 hypothetical protein BB561_000050 [Smittium simulii] | diamond | 1839 | 65.5 | 0.993893129770992 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii |
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);;