contig_metadata
6 rows where bioproject = "PRJNA793147", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12695411 | 12695411 | PRJNA793147_P_NODE_12110_length_493_cov_7.601415_g11845_i0 | PRJNA793147 | 12110 | 493 | 7.601415 | 37.47497595 | Eukaryota | 2759 | Fungi | Fungi | 285 | 2.139999999999999e-96 | NR | KXS11134.1 | 1344416 | g11845 | i0 | 82.2 | 13.947261663286 | 163 | 28 | 99.2 | 1 | 490 | 2 | 1 | 162 | KXS11134.1 hypothetical protein M427DRAFT_73326 [Gonapodya prolifera JEL478] | diamond | 6876 | 286 | 0.996503496503496 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 13532006 | 13532006 | PRJNA793147_P_NODE_8311_length_611_cov_5.230627_g8053_i0 | PRJNA793147 | 8311 | 611 | 5.230627 | 31.95913097 | Eukaryota | 2759 | Fungi | Fungi | 70.5 | 4.57e-11 | NR | KAJ3056152.1 | 64517 | g8053 | i0 | 32.5 | 3.35351882160393 | 120 | 77 | 57 | 2 | 579 | 232 | 4 | 123 | KAJ3056152.1 hypothetical protein HK097_007876 [Rhizophlyctis rosea] | diamond | 2049 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 21180651 | 21180651 | PRJNA793147_P_NODE_54437_length_232_cov_0.883436_g54171_i0 | PRJNA793147 | 54437 | 232 | 0.883436 | 2.04957152 | Eukaryota | 2759 | Fungi | Fungi | 133 | 5.14e-34 | NR | KAJ3191732.1 | 109884 | g54171 | i0 | 79.7 | 124.396551724138 | 74 | 15 | 95.7 | 0 | 232 | 11 | 1283 | 1356 | KAJ3191732.1 hypothetical protein HK101_007445 [Irineochytrium annulatum] | diamond | 28860 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 30812028 | 30812028 | PRJNA793147_P_NODE_33474_length_290_cov_1.552036_g33208_i0 | PRJNA793147 | 33474 | 290 | 1.552036 | 4.5009044 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 77.4 | 4.16e-14 | NR | KAJ3051215.1 | 64517 | g33208 | i0 | 66.7 | 1.60344827586207 | 54 | 18 | 55.9 | 0 | 129 | 290 | 435 | 488 | KAJ3051215.1 hypothetical protein HK097_007818 [Rhizophlyctis rosea] | diamond | 465 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 32203513 | 32203513 | PRJNA793147_P_NODE_16138_length_420_cov_3.259259_g15872_i0 | PRJNA793147 | 16138 | 420 | 3.259259 | 13.6888878 | Kappamyces sp. JEL | 2040833 | Fungi | Fungi | 81.3 | 5.87e-16 | NR | KAJ3305496.1 | 2724216 | g15872 | i0 | 42.9 | 1.42142857142857 | 98 | 56 | 70 | 0 | 79 | 372 | 96 | 193 | KAJ3305496.1 hypothetical protein HDV03_001362 [Kappamyces sp. JEL0829] | diamond | 597 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Kappamycetaceae | Kappamyces | Kappamyces sp. JEL0829 | |
| 32614589 | 32614589 | PRJNA793147_P_NODE_58660_length_229_cov_0.900000_g58394_i0 | PRJNA793147 | 58660 | 229 | 0.9 | 2.061 | Podochytrium sp. JEL | 2750441 | Fungi | Fungi | 42.7 | 0.0308 | NR | KAJ3074662.1 | 2724200 | g58394 | i0 | 36.6 | 0.930131004366812 | 71 | 45 | 93 | 0 | 9 | 221 | 500 | 570 | KAJ3074662.1 hypothetical protein HDU98_010658 [Podochytrium sp. JEL0797] | diamond | 213 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Podochytrium | Podochytrium sp. JEL0797 |
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);;