contig_metadata
8 rows where bioproject = "PRJNA1012699", tax_clade = "Opisthokonta" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5260851 | 5260851 | PRJNA1012699_P_NODE_1405_length_318_cov_1.265306_g1373_i0 | PRJNA1012699 | 1405 | 318 | 1.265306 | 4.02367308 | Eukaryota | 2759 | Fungi | Fungi | 149 | 1.9899999999999992e-43 | NR | KAI9029398.1 | 82268 | g1373 | i0 | 66.7 | 13.122641509434 | 99 | 33 | 93.4 | 0 | 301 | 5 | 1 | 99 | KAI9029398.1 60S ribosomal protein L21-A [Hyaloraphidium curvatum] | diamond | 4173 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 29276825 | 29276825 | PRJNA1012699_P_NODE_549_length_467_cov_2.324873_g517_i0 | PRJNA1012699 | 549 | 467 | 2.324873 | 10.85715691 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 71.2 | 3.1e-11 | NR | KAJ3033509.1 | 64517 | g517 | i0 | 35.4 | 0.815845824411135 | 127 | 77 | 78.4 | 2 | 462 | 97 | 57 | 183 | KAJ3033509.1 hypothetical protein HDV00_006293 [Rhizophlyctis rosea] | diamond | 381 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 29592343 | 29592343 | PRJNA1012699_P_NODE_1490_length_310_cov_1.864979_g1458_i0 | PRJNA1012699 | 1490 | 310 | 1.864979 | 5.7814349 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 55.8 | 2e-6 | NR | KAI8892998.1 | 382532 | g1458 | i0 | 36.6 | 1.95483870967742 | 101 | 62 | 95.8 | 2 | 300 | 4 | 232 | 332 | KAI8892998.1 cytochrome P450 [Globomyces pollinis-pini] | diamond | 606 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 30027234 | 30027234 | PRJNA1012699_P_NODE_571_length_458_cov_1.737662_g539_i0 | PRJNA1012699 | 571 | 458 | 1.737662 | 7.95849196 | Eukaryota | 2759 | Fungi | Fungi | 126 | 8.57e-33 | NR | KAI9007179.1 | 109897 | g539 | i0 | 57 | 4.72270742358079 | 142 | 47 | 88.4 | 5 | 52 | 456 | 5 | 139 | KAI9007179.1 60S ribosomal protein L6 [Gaertneriomyces semiglobifer] | diamond | 2163 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 31322561 | 31322561 | PRJNA1012699_P_NODE_2835_length_251_cov_2.606742_g2803_i0 | PRJNA1012699 | 2835 | 251 | 2.606742 | 6.54292242 | Eukaryota | 2759 | Fungi | Fungi | 121 | 3.12e-33 | NR | KAJ3196669.1 | 109884 | g2803 | i0 | 69.5 | 17.6414342629482 | 82 | 24 | 98 | 1 | 4 | 249 | 18 | 98 | KAJ3196669.1 60S ribosomal protein L32 [Irineochytrium annulatum] | diamond | 4428 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 31709997 | 31709997 | PRJNA1012699_P_NODE_1677_length_295_cov_3.238739_g1645_i0 | PRJNA1012699 | 1677 | 295 | 3.238739 | 9.55428005 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 125 | 6.95e-33 | NR | KAJ1561653.1 | 2732417 | g1645 | i0 | 69.5 | 1.65762711864407 | 82 | 25 | 83.4 | 0 | 48 | 293 | 153 | 234 | KAJ1561653.1 hypothetical protein HK096_003849 [Nowakowskiella sp. JEL0078] | diamond | 489 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0078 | |
| 32398358 | 32398358 | PRJNA1012699_P_NODE_2039_length_278_cov_3.000000_g2007_i0 | PRJNA1012699 | 2039 | 278 | 3 | 8.34 | Eukaryota | 2759 | Fungi | Fungi | 88.2 | 4.18e-18 | NR | TPX39016.1 | 286115 | g2007 | i0 | 47.8 | 9.59352517985612 | 90 | 43 | 92.8 | 1 | 276 | 19 | 330 | 419 | TPX39016.1 hypothetical protein SeMB42_g06517 [Synchytrium endobioticum] | diamond | 2667 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 32595837 | 32595837 | PRJNA1012699_P_NODE_2380_length_262_cov_2.317460_g2348_i0 | PRJNA1012699 | 2380 | 262 | 2.31746 | 6.0717452 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 45.8 | 0.00323 | NR | KAJ3029042.1 | 64517 | g2348 | i0 | 28.2 | 0.893129770992366 | 78 | 54 | 87 | 1 | 237 | 10 | 43 | 120 | KAJ3029042.1 hypothetical protein HDV00_009804 [Rhizophlyctis rosea] | diamond | 234 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea |
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);;