contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA493234" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1728895 | 1728895 | PRJNA493234_S_NODE_11082_length_301_cov_1.921053_g10989_i0 | PRJNA493234 | 11082 | 301 | 1.921053 | 5.78236953 | Didymella keratinophila | 2301244 | Fungi | Fungi | 171 | 3.39e-48 | NR | KAF3043544.1 | 2301244 | g10989 | i0 | 98.8 | 0.837209302325581 | 84 | 1 | 83.7 | 0 | 1 | 252 | 456 | 539 | KAF3043544.1 phosphatidylserine decarboxylase 1 [Didymella keratinophila] | diamond | 252 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 27708691 | 27708691 | PRJNA493234_S_NODE_18644_length_250_cov_1.745763_g18551_i0 | PRJNA493234 | 18644 | 250 | 1.745763 | 4.3644075 | Didymella keratinophila | 2301244 | Fungi | Fungi | 71.2 | 1.67e-12 | NR | KAF3040196.1 | 2301244 | g18551 | i0 | 88.1 | 0.504 | 42 | 5 | 50.4 | 0 | 249 | 124 | 232 | 273 | KAF3040196.1 hypothetical protein E8E11_007935 [Didymella keratinophila] | diamond | 126 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 29918622 | 29918622 | PRJNA493234_S_NODE_19571_length_247_cov_1.339080_g19478_i0 | PRJNA493234 | 19571 | 247 | 1.33908 | 3.3075276 | Didymella keratinophila | 2301244 | Fungi | Fungi | 135 | 9.779999999999996e-35 | NR | KAF3050714.1 | 2301244 | g19478 | i0 | 91.8 | 0.88663967611336 | 73 | 6 | 88.7 | 0 | 247 | 29 | 202 | 274 | KAF3050714.1 anaphase promoting complex subunit 5 [Didymella keratinophila] | diamond | 219 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 30013358 | 30013358 | PRJNA493234_S_NODE_7651_length_334_cov_3.237548_g7558_i0 | PRJNA493234 | 7651 | 334 | 3.237548 | 10.81341032 | Didymella keratinophila | 2301244 | Fungi | Fungi | 135 | 5.999999999999998e-39 | NR | KAF3046773.1 | 2301244 | g7558 | i0 | 85.7 | 0.691616766467066 | 77 | 11 | 69.2 | 0 | 282 | 52 | 1 | 77 | KAF3046773.1 hypothetical protein E8E11_008408 [Didymella keratinophila] | diamond | 231 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 30298086 | 30298086 | PRJNA493234_S_NODE_13252_length_284_cov_2.649289_g13159_i0 | PRJNA493234 | 13252 | 284 | 2.649289 | 7.52398076 | Didymella keratinophila | 2301244 | Fungi | Fungi | 183 | 1.48e-54 | NR | KAF3051193.1 | 2301244 | g13159 | i0 | 87.2 | 2.97887323943662 | 94 | 12 | 99.3 | 0 | 3 | 284 | 242 | 335 | KAF3051193.1 hypothetical protein E8E11_000918 [Didymella keratinophila] | diamond | 846 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 30329720 | 30329720 | PRJNA493234_S_NODE_12212_length_292_cov_2.515982_g12119_i0 | PRJNA493234 | 12212 | 292 | 2.515982 | 7.34666744 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 89.4 | 2.64e-18 | NR | XP_069227354.1 | 1052096 | g12119 | i0 | 60.9 | 0.657534246575342 | 64 | 25 | 65.8 | 0 | 71 | 262 | 460 | 523 | XP_069227354.1 uncharacterized protein WHR41_06708 [Cladosporium halotolerans] | diamond | 192 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30345729 | 30345729 | PRJNA493234_S_NODE_4252_length_382_cov_2.012945_g4159_i0 | PRJNA493234 | 4252 | 382 | 2.012945 | 7.6894499 | Didymella | 55170 | Fungi | Fungi | 151 | 8.059999999999999e-43 | NR | KAL1650095.1 | 749634 | g4159 | i0 | 96.1 | 1.19371727748691 | 76 | 3 | 59.7 | 0 | 3 | 230 | 178 | 253 | KAL1650095.1 J domain-containing protein 1 [Didymella pomorum] | diamond | 456 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella pomorum | |
| 30898032 | 30898032 | PRJNA493234_S_NODE_15734_length_267_cov_1.195876_g15641_i0 | PRJNA493234 | 15734 | 267 | 1.195876 | 3.19298892 | Didymella keratinophila | 2301244 | Fungi | Fungi | 144 | 2.42e-39 | NR | KAF3037549.1 | 2301244 | g15641 | i0 | 92.9 | 0.786516853932584 | 70 | 5 | 78.7 | 0 | 2 | 211 | 310 | 379 | KAF3037549.1 hypothetical protein E8E11_002093 [Didymella keratinophila] | diamond | 210 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 30914061 | 30914061 | PRJNA493234_S_NODE_13554_length_282_cov_1.856459_g13461_i0 | PRJNA493234 | 13554 | 282 | 1.856459 | 5.23521438 | Didymellaceae | 683158 | Fungi | Fungi | 80.1 | 4.16e-15 | NR | KAG9201993.1 | 105696 | g13461 | i0 | 88.9 | 1.90425531914894 | 45 | 5 | 47.9 | 0 | 5 | 139 | 497 | 541 | KAG9201993.1 hypothetical protein G6514_005188 [Epicoccum nigrum] | diamond | 537 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 31181960 | 31181960 | PRJNA493234_S_NODE_14795_length_273_cov_2.615000_g14702_i0 | PRJNA493234 | 14795 | 273 | 2.615 | 7.13895 | Didymella keratinophila | 2301244 | Fungi | Fungi | 139 | 2.66e-36 | NR | KAF3051032.1 | 2301244 | g14702 | i0 | 97.1 | 0.769230769230769 | 70 | 2 | 76.9 | 0 | 2 | 211 | 529 | 598 | KAF3051032.1 hypothetical protein E8E11_007954 [Didymella keratinophila] | diamond | 210 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 31640950 | 31640950 | PRJNA493234_S_NODE_14836_length_273_cov_1.550000_g14743_i0 | PRJNA493234 | 14836 | 273 | 1.55 | 4.2315 | Didymellaceae | 683158 | Fungi | Fungi | 133 | 9.149999999999999e-34 | NR | XP_033453156.1 | 1150837 | g14743 | i0 | 79.1 | 1.89010989010989 | 86 | 18 | 94.5 | 0 | 1 | 258 | 849 | 934 | XP_033453156.1 WD40 repeat-like protein [Didymella exigua CBS 183.55] | diamond | 516 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella exigua | |
| 31656509 | 31656509 | PRJNA493234_S_NODE_12237_length_292_cov_1.867580_g12144_i0 | PRJNA493234 | 12237 | 292 | 1.86758 | 5.4533336 | Didymella glomerata | 749621 | Fungi | Fungi | 121 | 4.2099999999999997e-32 | NR | KAJ4343613.1 | 749621 | g12144 | i0 | 100 | 0.678082191780822 | 66 | 0 | 67.8 | 0 | 292 | 95 | 154 | 219 | KAJ4343613.1 hypothetical protein N0V87_000380 [Didymella glomerata] | diamond | 198 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella glomerata | |
| 31972993 | 31972993 | PRJNA493234_S_NODE_17518_length_255_cov_3.417582_g17425_i0 | PRJNA493234 | 17518 | 255 | 3.417582 | 8.7148341 | Didymella keratinophila | 2301244 | Fungi | Fungi | 77.8 | 1.99e-14 | NR | KAF3050778.1 | 2301244 | g17425 | i0 | 86.8 | 0.447058823529412 | 38 | 5 | 44.7 | 0 | 3 | 116 | 1619 | 1656 | KAF3050778.1 hypothetical protein E8E11_010370 [Didymella keratinophila] | diamond | 114 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 31972994 | 31972994 | PRJNA493234_S_NODE_19758_length_246_cov_2.705202_g19665_i0 | PRJNA493234 | 19758 | 246 | 2.705202 | 6.65479692 | Didymella glomerata | 749621 | Fungi | Fungi | 102 | 1.0799999999999999e-23 | NR | KAJ4337623.1 | 749621 | g19665 | i0 | 100 | 0.597560975609756 | 49 | 0 | 59.8 | 0 | 1 | 147 | 298 | 346 | KAJ4337623.1 hypothetical protein N0V87_004579 [Didymella glomerata] | diamond | 147 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella glomerata | |
| 32605640 | 32605640 | PRJNA493234_S_NODE_21680_length_233_cov_2.906250_g21587_i0 | PRJNA493234 | 21680 | 233 | 2.90625 | 6.7715625 | Ascochyta lentis | 205686 | Fungi | Fungi | 108 | 2.6900000000000003e-27 | NR | KAF9693784.1 | 205686 | g21587 | i0 | 96.1 | 1.96995708154506 | 51 | 2 | 65.7 | 0 | 2 | 154 | 173 | 223 | KAF9693784.1 hypothetical protein EKO04_008275 [Ascochyta lentis] | diamond | 459 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta lentis |
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);;