contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA454154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1716819 | 1716819 | PRJNA454154_S_NODE_162_length_242_cov_7.463415_g159_i0 | PRJNA454154 | 162 | 242 | 7.463415 | 18.0614643 | Eukaryota | 2759 | Fungi | Fungi | 103 | 3.18e-25 | NR | TPX76562.1 | 246404 | g159 | i0 | 84.6 | 9.08677685950413 | 52 | 8 | 64.5 | 0 | 241 | 86 | 164 | 215 | TPX76562.1 hypothetical protein CcCBS67573_g02181 [Chytriomyces confervae] | diamond | 2199 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 2992593 | 2992593 | PRJNA454154_S_NODE_183_length_236_cov_3.030151_g180_i0 | PRJNA454154 | 183 | 236 | 3.030151 | 7.15115636 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 99 | 1.06e-23 | NR | TPX44958.1 | 286115 | g180 | i0 | 63.6 | 0.978813559322034 | 77 | 28 | 97.9 | 0 | 6 | 236 | 92 | 168 | TPX44958.1 hypothetical protein SeLEV6574_g04175 [Synchytrium endobioticum] | diamond | 231 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 2992597 | 2992597 | PRJNA454154_S_NODE_583_length_159_cov_0.918033_g580_i0 | PRJNA454154 | 583 | 159 | 0.918033 | 1.4596724700000001 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 104 | 2.49e-25 | NR | TPX74992.1 | 246404 | g580 | i0 | 90.2 | 9.62264150943396 | 51 | 5 | 96.2 | 0 | 6 | 158 | 256 | 306 | TPX74992.1 succinate dehydrogenase [Chytriomyces confervae] | diamond | 1530 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 26664321 | 26664321 | PRJNA454154_S_NODE_421_length_179_cov_4.908451_g418_i0 | PRJNA454154 | 421 | 179 | 4.908451 | 8.78612729 | Powellomyces hirtus | 109895 | Fungi | Fungi | 72 | 7.07e-13 | NR | TPX53717.1 | 109895 | g418 | i0 | 52.6 | 0.955307262569832 | 57 | 27 | 95.5 | 0 | 2 | 172 | 361 | 417 | TPX53717.1 hypothetical protein PhCBS80983_g06210 [Powellomyces hirtus] | diamond | 171 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 30424064 | 30424064 | PRJNA454154_S_NODE_153_length_249_cov_4.853774_g150_i0 | PRJNA454154 | 153 | 249 | 4.853774 | 12.08589726 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 80.1 | 3.22e-17 | NR | KXS13505.1 | 1344416 | g150 | i0 | 79.2 | 1.27710843373494 | 53 | 11 | 63.9 | 0 | 247 | 89 | 62 | 114 | KXS13505.1 ribosomal protein L36e [Gonapodya prolifera JEL478] | diamond | 318 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 30581432 | 30581432 | PRJNA454154_S_NODE_293_length_198_cov_1.962733_g290_i0 | PRJNA454154 | 293 | 198 | 1.962733 | 3.88621134 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 45.1 | 0.00324 | NR | KAH9257691.1 | 1357716 | g290 | i0 | 62.5 | 0.484848484848485 | 32 | 12 | 48.5 | 0 | 4 | 99 | 576 | 607 | KAH9257691.1 hypothetical protein BASA81_004149 [Batrachochytrium salamandrivorans] | diamond | 96 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30629282 | 30629282 | PRJNA454154_S_NODE_313_length_194_cov_5.375796_g310_i0 | PRJNA454154 | 313 | 194 | 5.375796 | 10.42904424 | Fungi | 4751 | Fungi | Fungi | 94.4 | 1.9799999999999998e-23 | NR | XP_052971640.1 | 110093 | g310 | i0 | 78.2 | 31.4845360824742 | 55 | 12 | 85.1 | 0 | 6 | 170 | 37 | 91 | XP_052971640.1 60S ribosomal protein L37 [Polychytrium aggregatum] | diamond | 6108 | 95.1 | 0.992639327024185 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 31308382 | 31308382 | PRJNA454154_S_NODE_535_length_164_cov_3.700787_g532_i0 | PRJNA454154 | 535 | 164 | 3.700787 | 6.06929068 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 48.9 | 2.04e-5 | NR | KAI8898586.1 | 382532 | g532 | i0 | 64.5 | 1.40853658536585 | 31 | 11 | 56.7 | 0 | 163 | 71 | 90 | 120 | KAI8898586.1 ribosomal protein L22e [Globomyces pollinis-pini] | diamond | 231 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 31530037 | 31530037 | PRJNA454154_S_NODE_616_length_155_cov_3.271186_g613_i0 | PRJNA454154 | 616 | 155 | 3.271186 | 5.0703383 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 50.8 | 1.56e-5 | NR | KAH9246773.1 | 1357716 | g613 | i0 | 58.3 | 3.48387096774194 | 36 | 15 | 69.7 | 0 | 6 | 113 | 802 | 837 | KAH9246773.1 elongation factor 2 [Batrachochytrium salamandrivorans] | diamond | 540 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32337237 | 32337237 | PRJNA454154_S_NODE_579_length_159_cov_1.795082_g576_i0 | PRJNA454154 | 579 | 159 | 1.795082 | 2.85418038 | Chytridiomycota | 4761 | Fungi | Fungi | 78.6 | 1.19e-15 | NR | KAJ3093258.1 | 109957 | g576 | i0 | 72.9 | 6.15094339622642 | 48 | 13 | 90.6 | 0 | 155 | 12 | 221 | 268 | KAJ3093258.1 cross-pathway control WD-repeat protein cpc2, partial [Physocladia obscura] | diamond | 978 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 32447590 | 32447590 | PRJNA454154_S_NODE_379_length_185_cov_1.243243_g376_i0 | PRJNA454154 | 379 | 185 | 1.243243 | 2.29999955 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 92.4 | 4.97e-20 | NR | KAH9251794.1 | 1357716 | g376 | i0 | 81.1 | 0.859459459459459 | 53 | 10 | 85.9 | 0 | 184 | 26 | 470 | 522 | KAH9251794.1 hypothetical protein BASA81_010237 [Batrachochytrium salamandrivorans] | diamond | 159 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;