contig_metadata
16 rows where bioproject = "PRJNA564013", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4375122 | 4375122 | PRJNA564013_P_NODE_152764_length_349_cov_3.819444_g149915_i0 | PRJNA564013 | 152764 | 349 | 3.819444 | 13.32985956 | Chytridiomycetes | 451435 | Fungi | Fungi | 156 | 2.29e-46 | NR | KAI9344314.1 | 110081 | g149915 | i0 | 75.3 | 5.05444126074499 | 93 | 23 | 79.9 | 0 | 23 | 301 | 51 | 143 | KAI9344314.1 hypothetical protein BDR26DRAFT_857599 [Obelidium mucronatum] | diamond | 1764 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Obelidium | Obelidium mucronatum | |
| 18983375 | 18983375 | PRJNA564013_P_NODE_221075_length_286_cov_9.435556_g218224_i0 | PRJNA564013 | 221075 | 286 | 9.435556 | 26.98569016 | Boothiomyces macroporosus | 261099 | Fungi | Fungi | 60.5 | 3.94e-9 | NR | KAJ3253754.1 | 261099 | g218224 | i0 | 44.6 | 0.870629370629371 | 83 | 39 | 83.9 | 4 | 250 | 11 | 43 | 121 | KAJ3253754.1 hypothetical protein HK103_000346 [Boothiomyces macroporosus] | diamond | 249 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces macroporosus | |
| 23498794 | 23498794 | PRJNA564013_P_NODE_101779_length_407_cov_5.606936_g98944_i0 | PRJNA564013 | 101779 | 407 | 5.606936 | 22.82022952 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 184 | 2.9999999999999994e-57 | NR | KAH9253693.1 | 1357716 | g98944 | i0 | 72.5 | 0.884520884520885 | 120 | 33 | 88.5 | 0 | 407 | 48 | 3 | 122 | KAH9253693.1 GTP cyclohydrolase I [Batrachochytrium salamandrivorans] | diamond | 360 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 26762675 | 26762675 | PRJNA564013_P_NODE_153741_length_348_cov_5.512195_g150892_i0 | PRJNA564013 | 153741 | 348 | 5.512195 | 19.1824386 | Boothiomyces macroporosus | 261099 | Fungi | Fungi | 70.1 | 2.89e-11 | NR | KAJ3251678.1 | 261099 | g150892 | i0 | 57.1 | 0.362068965517241 | 42 | 18 | 36.2 | 0 | 325 | 200 | 294 | 335 | KAJ3251678.1 hypothetical protein HK103_002201 [Boothiomyces macroporosus] | diamond | 126 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces macroporosus | |
| 26840173 | 26840173 | PRJNA564013_P_NODE_241901_length_268_cov_3.579710_g239049_i0 | PRJNA564013 | 241901 | 268 | 3.57971 | 9.5936228 | Eukaryota | 2759 | Fungi | Fungi | 59.7 | 5.31e-8 | NR | KAJ1567612.1 | 1604274 | g239049 | i0 | 40.3 | 1.99253731343284 | 72 | 40 | 80.6 | 1 | 18 | 233 | 4 | 72 | KAJ1567612.1 Dynamin- protein 5A, partial [Cladochytrium tenue] | diamond | 534 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 27427131 | 27427131 | PRJNA564013_P_NODE_79423_length_454_cov_23.145038_g76597_i0 | PRJNA564013 | 79423 | 454 | 23.145038 | 105.07847252 | Clydaea vesicula | 447962 | Fungi | Fungi | 61.6 | 9.07e-8 | NR | KAJ3216957.1 | 447962 | g76597 | i0 | 36.9 | 1.52643171806167 | 122 | 65 | 73.3 | 5 | 363 | 31 | 106 | 226 | KAJ3216957.1 Nucleolar Complex 2 protein, partial [Clydaea vesicula] | diamond | 693 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Clydaea | Clydaea vesicula | |
| 27774377 | 27774377 | PRJNA564013_P_NODE_232364_length_276_cov_8.581395_g229512_i0 | PRJNA564013 | 232364 | 276 | 8.581395 | 23.6846502 | Powellomyces hirtus | 109895 | Fungi | Fungi | 121 | 1.7299999999999998e-31 | NR | KAI8903474.1 | 109895 | g229512 | i0 | 96.6 | 1.26086956521739 | 58 | 2 | 63 | 0 | 184 | 11 | 1 | 58 | KAI8903474.1 organic solute transporter subunit alpha/Transmembrane protein [Powellomyces hirtus] | diamond | 348 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 28577324 | 28577324 | PRJNA564013_P_NODE_17287_length_873_cov_10.564039_g15155_i0 | PRJNA564013 | 17287 | 873 | 10.564039 | 92.22406047 | Eukaryota | 2759 | Fungi | Fungi | 143 | 2.94e-34 | NR | KAI9006777.1 | 82268 | g15155 | i0 | 33.6 | 11.3573883161512 | 277 | 135 | 95.2 | 4 | 851 | 21 | 176 | 403 | KAI9006777.1 phosphoenolpyruvate carboxylase [Hyaloraphidium curvatum] | diamond | 9915 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 28879163 | 28879163 | PRJNA564013_P_NODE_166748_length_336_cov_14.276364_g163898_i0 | PRJNA564013 | 166748 | 336 | 14.276364 | 47.96858304 | Piromyces finnis | 1754191 | Fungi | Fungi | 65.9 | 9.02e-10 | NR | ORX41716.1 | 1754191 | g163898 | i0 | 41.1 | 0.803571428571429 | 90 | 24 | 80.4 | 1 | 43 | 312 | 933 | 993 | ORX41716.1 L domain-like protein [Piromyces finnis] | diamond | 270 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces finnis | |
| 29037422 | 29037422 | PRJNA564013_P_NODE_304308_length_222_cov_29.316770_g301456_i0 | PRJNA564013 | 304308 | 222 | 29.316770000000002 | 65.0832294 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 44.3 | 0.00267 | NR | KAI8914252.1 | 382530 | g301456 | i0 | 55.9 | 0.459459459459459 | 34 | 14 | 45.9 | 1 | 220 | 119 | 65 | 97 | KAI8914252.1 delta subunit of GMP phosphodiesterase [Gorgonomyces haynaldii] | diamond | 102 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 29289735 | 29289735 | PRJNA564013_P_NODE_53009_length_545_cov_10.760331_g50245_i0 | PRJNA564013 | 53009 | 545 | 10.760331 | 58.64380395 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 107 | 3.639999999999999e-23 | NR | KAH9261246.1 | 1357716 | g50245 | i0 | 46.3 | 0.522935779816514 | 95 | 51 | 52.3 | 0 | 536 | 252 | 683 | 777 | KAH9261246.1 hypothetical protein BASA81_000950 [Batrachochytrium salamandrivorans] | diamond | 285 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30016160 | 30016160 | PRJNA564013_P_NODE_176611_length_328_cov_2.202247_g173761_i0 | PRJNA564013 | 176611 | 328 | 2.202247 | 7.22337016 | Obelidium mucronatum | 110081 | Fungi | Fungi | 47.4 | 0.0023 | NR | KAI9348119.1 | 110081 | g173761 | i0 | 32.6 | 0.86890243902439 | 95 | 59 | 84.1 | 3 | 316 | 41 | 56 | 148 | KAI9348119.1 hypothetical protein BDR26DRAFT_854006 [Obelidium mucronatum] | diamond | 285 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Obelidium | Obelidium mucronatum | |
| 30837573 | 30837573 | PRJNA564013_P_NODE_67134_length_492_cov_1.761021_g64328_i0 | PRJNA564013 | 67134 | 492 | 1.761021 | 8.66422332 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 87 | 1.76e-16 | NR | TPX47449.1 | 286115 | g64328 | i0 | 33.3 | 3.51829268292683 | 114 | 74 | 69.5 | 1 | 418 | 77 | 318 | 429 | TPX47449.1 hypothetical protein SeLEV6574_g02660 [Synchytrium endobioticum] | diamond | 1731 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 31248291 | 31248291 | PRJNA564013_P_NODE_33535_length_661_cov_15.200000_g30902_i0 | PRJNA564013 | 33535 | 661 | 15.2 | 100.472 | Powellomyces hirtus | 109895 | Fungi | Fungi | 65.1 | 3.42e-9 | NR | KAI8920031.1 | 109895 | g30902 | i0 | 36.8 | 1.32526475037821 | 95 | 56 | 41.8 | 3 | 563 | 288 | 58 | 151 | KAI8920031.1 ubiquitin-conjugating enzyme/RWD-like protein [Powellomyces hirtus] | diamond | 876 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 32401132 | 32401132 | PRJNA564013_P_NODE_237379_length_272_cov_3.265403_g234527_i0 | PRJNA564013 | 237379 | 272 | 3.265403 | 8.88189616 | Spizellomyces | 4815 | Fungi | Fungi | 98.6 | 2.98e-22 | NR | TPX72102.1 | 117820 | g234527 | i0 | 72.9 | 3.12132352941176 | 70 | 19 | 77.2 | 0 | 241 | 32 | 277 | 346 | TPX72102.1 hypothetical protein SpCBS45565_g00482 [Spizellomyces sp. 'palustris'] | diamond | 849 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 32828951 | 32828951 | PRJNA564013_P_NODE_129060_length_372_cov_8.327974_g126213_i0 | PRJNA564013 | 129060 | 372 | 8.327974 | 30.98006328 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 63.9 | 5.77e-9 | NR | KAJ3046891.1 | 64517 | g126213 | i0 | 59.6 | 0.379032258064516 | 47 | 19 | 37.9 | 0 | 197 | 337 | 111 | 157 | KAJ3046891.1 hypothetical protein HK097_000428 [Rhizophlyctis rosea] | diamond | 141 | 63.9 | 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);;