contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13165321 | 13165321 | PRJNA395690_P_NODE_18191_length_191_cov_1.077465_g18039_i0 | PRJNA395690 | 18191 | 191 | 1.077465 | 2.05795815 | Syncephalis fuscata | 1851187 | Fungi | Fungi | 74.7 | 9.79e-14 | NR | KAI9596340.1 | 1851187 | g18039 | i0 | 64.6 | 0.753926701570681 | 48 | 17 | 75.4 | 0 | 187 | 44 | 401 | 448 | KAI9596340.1 thioredoxin-like domain-containing protein [Syncephalis fuscata] | diamond | 144 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis fuscata | |
| 27233416 | 27233416 | PRJNA395690_P_NODE_32083_length_164_cov_0.886957_g31931_i0 | PRJNA395690 | 32083 | 164 | 0.886957 | 1.45460948 | Piptocephalis tieghemiana | 1286916 | Fungi | Fungi | 86.3 | 7.98e-19 | NR | KAI9229916.1 | 1286916 | g31931 | i0 | 79.6 | 1.97560975609756 | 54 | 11 | 98.8 | 0 | 1 | 162 | 69 | 122 | KAI9229916.1 MAG: 60S ribosomal protein l7-like protein [Piptocephalis tieghemiana] | diamond | 324 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis tieghemiana | |
| 27580786 | 27580786 | PRJNA395690_P_NODE_20824_length_185_cov_1.014706_g20672_i0 | PRJNA395690 | 20824 | 185 | 1.014706 | 1.8772061 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 94.7 | 7.469999999999999e-24 | NR | RKP13625.1 | 1907219 | g20672 | i0 | 85.7 | 0.908108108108108 | 56 | 8 | 90.8 | 0 | 183 | 16 | 19 | 74 | RKP13625.1 ATP synthase subunit 9, mitochondrial [Piptocephalis cylindrospora] | diamond | 168 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 28134547 | 28134547 | PRJNA395690_P_NODE_28825_length_167_cov_0.864407_g28673_i0 | PRJNA395690 | 28825 | 167 | 0.864407 | 1.44355969 | Fungi | 4751 | Fungi | Fungi | 85.5 | 1.11e-18 | NR | KAJ1942653.1 | 61397 | g28673 | i0 | 72.7 | 9.84431137724551 | 55 | 15 | 98.8 | 0 | 166 | 2 | 20 | 74 | KAJ1942653.1 D-3-phosphoglycerate dehydrogenase 2 [Kickxella alabastrina] | diamond | 1644 | 86.3 | 0.990730011587486 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 28671255 | 28671255 | PRJNA395690_P_NODE_11147_length_244_cov_1.220513_g10995_i0 | PRJNA395690 | 11147 | 244 | 1.220513 | 2.97805172 | Fungi | 4751 | Fungi | Fungi | 114 | 1.17e-27 | NR | KAJ1952643.1 | 61395 | g10995 | i0 | 74.7 | 5.8155737704918 | 79 | 20 | 97.1 | 0 | 8 | 244 | 30 | 108 | KAJ1952643.1 hypothetical protein EC988_003441, partial [Linderina pennispora] | diamond | 1419 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 31339237 | 31339237 | PRJNA395690_P_NODE_30136_length_166_cov_0.871795_g29984_i0 | PRJNA395690 | 30136 | 166 | 0.871795 | 1.4471797 | Coemansia sp. RSA 678 | 2790277 | Fungi | Fungi | 55.8 | 3.14e-7 | NR | KAJ2143775.1 | 2790277 | g29984 | i0 | 41.7 | 4.53614457831325 | 72 | 25 | 99.4 | 1 | 2 | 166 | 256 | 327 | KAJ2143775.1 hypothetical protein IW136_001564 [Coemansia sp. RSA 678] | diamond | 753 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 678 | |
| 31687154 | 31687154 | PRJNA395690_P_NODE_26597_length_171_cov_1.254098_g26445_i0 | PRJNA395690 | 26597 | 171 | 1.254098 | 2.14450758 | Dispira simplex | 2789359 | Fungi | Fungi | 46.2 | 8.54e-4 | NR | KAJ1654474.1 | 2789359 | g26445 | i0 | 38.8 | 2.82456140350877 | 49 | 30 | 86 | 0 | 159 | 13 | 163 | 211 | KAJ1654474.1 hypothetical protein IWQ61_005600 [Dispira simplex] | diamond | 483 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira simplex | |
| 32368653 | 32368653 | PRJNA395690_P_NODE_16879_length_198_cov_0.973154_g16727_i0 | PRJNA395690 | 16879 | 198 | 0.973154 | 1.92684492 | Coemansia | 4863 | Fungi | Fungi | 112 | 4.69e-27 | NR | KAJ1722635.1 | 147472 | g16727 | i0 | 80.3 | 12.0151515151515 | 61 | 12 | 92.4 | 0 | 16 | 198 | 1 | 61 | KAJ1722635.1 Pyrimidine nucleotide transporter, mitochondrial [Coemansia erecta] | diamond | 2379 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia erecta | |
| 32526939 | 32526939 | PRJNA395690_P_NODE_14839_length_211_cov_1.265432_g14687_i0 | PRJNA395690 | 14839 | 211 | 1.265432 | 2.67006152 | Fungi | 4751 | Fungi | Fungi | 130 | 4.33e-35 | NR | PVU99297.1 | 61424 | g14687 | i0 | 87.1 | 17.8009478672986 | 70 | 9 | 99.5 | 0 | 1 | 210 | 53 | 122 | PVU99297.1 hypothetical protein BB559_000832 [Furculomyces boomerangus] | diamond | 3756 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus |
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);;