contig_metadata
4 rows where bioproject = "PRJNA683902", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12144638 | 12144638 | PRJNA683902_S_NODE_21210_length_227_cov_7.731579_g20766_i0 | PRJNA683902 | 21210 | 227 | 7.731579 | 17.55068433 | Zoophagus sp. CGW-2021a | 2876187 | Fungi | Fungi | 414 | 2.2399999999999998e-111 | NTclustered | gi|2095779121|gb|OK156471.1| | 2876187 | g20766 | i0 | 99.559 | 63.6696035242291 | 227 | 1 | 100 | 0 | 1 | 227 | 648 | 874 | Zoophagus sp. CGW-2021a strain Tk1 small subunit ribosomal RNA gene, partial sequence | blastn | 14453 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Zoopagaceae | Zoophagus | Zoophagus sp. CGW-2021a | |
| 13419241 | 13419241 | PRJNA683902_S_NODE_24431_length_206_cov_2.053254_g23987_i0 | PRJNA683902 | 24431 | 206 | 2.053254 | 4.22970324 | Entomophthoraceae sp. ARSEF 7942 | 423453 | Fungi | Fungi | 126 | 1.05e-24 | NTclustered | gi|145307981|gb|EF392517.1| | 423453 | g23987 | i0 | 88.571 | 4.19417475728155 | 105 | 11 | 50 | 1 | 1 | 104 | 121 | 17 | Entomophthoraceae sp. ARSEF 7942 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 864 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthoraceae sp. ARSEF 7942 | ||
| 28388587 | 28388587 | PRJNA683902_S_NODE_28486_length_185_cov_1.047297_g28042_i0 | PRJNA683902 | 28486 | 185 | 1.047297 | 1.93749945 | Piptocephalis | 78916 | Fungi | Fungi | 64.3 | 4.17e-10 | NR | KAI9226564.1 | 1286916 | g28042 | i0 | 59.3 | 2.9027027027027 | 59 | 24 | 95.7 | 0 | 8 | 184 | 560 | 618 | KAI9226564.1 MAG: hsp70-like protein [Piptocephalis tieghemiana] | diamond | 537 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis tieghemiana | |
| 29146787 | 29146787 | PRJNA683902_S_NODE_13949_length_328_cov_2.178694_g13505_i0 | PRJNA683902 | 13949 | 328 | 2.178694 | 7.14611632 | Eukaryota | 2759 | Fungi | Fungi | 87.8 | 3.05e-19 | NR | OLY82642.1 | 133383 | g13505 | i0 | 42.9 | 3.85060975609756 | 105 | 60 | 96 | 0 | 317 | 3 | 31 | 135 | OLY82642.1 60S ribosomal protein L12 [Smittium mucronatum] | diamond | 1263 | 88.2 | 0.99546485260771 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum |
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);;