contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7415875 | 7415875 | PRJNA1159911_P_NODE_52006_length_339_cov_1.736842_g51464_i0 | PRJNA1159911 | 52006 | 339 | 1.736842 | 5.88789438 | Fungi | 4751 | Fungi | Fungi | 117 | 2.3599999999999998e-31 | NR | KAL4746927.1 | 138288 | g51464 | i0 | 63.7 | 3.20353982300885 | 91 | 33 | 80.5 | 0 | 63 | 335 | 9 | 99 | KAL4746927.1 hypothetical protein BDW72DRAFT_183873 [Aspergillus terricola var. indicus] | diamond | 1086 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus terricola | |
| 11786721 | 11786721 | PRJNA1159911_P_NODE_57610_length_318_cov_2.151020_g57068_i0 | PRJNA1159911 | 57610 | 318 | 2.15102 | 6.8402436 | Aureobasidium sp. EXF-12298 | 2894281 | Fungi | Fungi | 81.3 | 1.7e-16 | NR | KAI4743579.1 | 2894281 | g57068 | i0 | 62 | 7.38679245283019 | 71 | 26 | 67 | 1 | 316 | 104 | 123 | 192 | KAI4743579.1 ribosomal protein L6 [Aureobasidium sp. EXF-12298] | diamond | 2349 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium sp. EXF-12298 | |
| 26787310 | 26787310 | PRJNA1159911_P_NODE_96921_length_244_cov_0.900585_g96379_i0 | PRJNA1159911 | 96921 | 244 | 0.900585 | 2.1974274 | Extremus antarcticus | 702011 | Fungi | Fungi | 57.4 | 2.44e-7 | NR | KAK3050627.1 | 702011 | g96379 | i0 | 55.6 | 2.27459016393443 | 45 | 20 | 55.3 | 0 | 4 | 138 | 306 | 350 | KAK3050627.1 hypothetical protein LTR09_008267 [Extremus antarcticus] | diamond | 555 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 26850689 | 26850689 | PRJNA1159911_P_NODE_69361_length_285_cov_1.608491_g68819_i0 | PRJNA1159911 | 69361 | 285 | 1.608491 | 4.58419935 | Mycothermus thermophilus | 85995 | Fungi | Fungi | 60.8 | 2.62e-8 | NR | XP_069217475.1 | 85995 | g68819 | i0 | 50 | 0.673684210526316 | 64 | 31 | 67.4 | 1 | 32 | 223 | 701 | 763 | XP_069217475.1 uncharacterized protein VTJ04DRAFT_8147 [Mycothermus thermophilus] | diamond | 192 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Mycothermus | Mycothermus thermophilus | |
| 27293226 | 27293226 | PRJNA1159911_P_NODE_101263_length_241_cov_0.916667_g100721_i0 | PRJNA1159911 | 101263 | 241 | 0.916667 | 2.20916747 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 132 | 6.27e-34 | NR | XP_069230716.1 | 1052096 | g100721 | i0 | 78.2 | 0.970954356846473 | 78 | 17 | 97.1 | 0 | 236 | 3 | 492 | 569 | XP_069230716.1 uncharacterized protein WHR41_03678 [Cladosporium halotolerans] | diamond | 234 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27975672 | 27975672 | PRJNA1159911_P_NODE_78185_length_266_cov_1.595855_g77643_i0 | PRJNA1159911 | 78185 | 266 | 1.595855 | 4.2449743 | Opisthokonta | 33154 | Fungi | Fungi | 94.7 | 3.2899999999999996e-23 | NR | PUU75945.1 | 42251 | g77643 | i0 | 59.2 | 29.2669172932331 | 76 | 30 | 85.7 | 1 | 37 | 264 | 3 | 77 | PUU75945.1 40S ribosomal protein S21 [Tuber borchii] | diamond | 7785 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Tuber | Tuber borchii | |
| 28417947 | 28417947 | PRJNA1159911_P_NODE_44846_length_372_cov_1.742475_g44304_i0 | PRJNA1159911 | 44846 | 372 | 1.742475 | 6.482007 | Trichoderma | 5543 | Fungi | Fungi | 52.4 | 6.16e-5 | NR | OTA01508.1 | 858221 | g44304 | i0 | 40 | 2.25806451612903 | 60 | 34 | 48.4 | 1 | 32 | 211 | 367 | 424 | OTA01508.1 Cytochrome P450 CYP2 subfamily [Trichoderma parareesei] | diamond | 840 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma parareesei | |
| 28619629 | 28619629 | PRJNA1159911_P_NODE_35227_length_440_cov_1.318801_g34685_i0 | PRJNA1159911 | 35227 | 440 | 1.318801 | 5.8027244 | Glarea lozoyensis 74 | 101852 | Fungi | Fungi | 49.3 | 0.00147 | NR | EHL02041.1 | 1104152 | g34685 | i0 | 32.3 | 1.65 | 124 | 76 | 79.1 | 4 | 55 | 402 | 222 | 345 | EHL02041.1 putative Uncharacterized monooxygenase [Glarea lozoyensis 74030] | diamond | 726 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Helotiaceae | Glarea | Glarea lozoyensis | |
| 29175716 | 29175716 | PRJNA1159911_P_NODE_73229_length_276_cov_1.926108_g72687_i0 | PRJNA1159911 | 73229 | 276 | 1.926108 | 5.31605808 | Ascomycota | 4890 | Fungi | Fungi | 104 | 6.5e-27 | NR | KLU81502.1 | 644358 | g72687 | i0 | 65.8 | 7.45652173913043 | 76 | 26 | 82.6 | 0 | 228 | 1 | 1 | 76 | KLU81502.1 U6 snRNA-associated Sm-like protein LSm2 [Magnaporthiopsis poae ATCC 64411] | diamond | 2058 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Magnaporthaceae | Magnaporthiopsis | Magnaporthiopsis poae | |
| 29219493 | 29219493 | PRJNA1159911_P_NODE_46489_length_364_cov_1.106529_g45947_i0 | PRJNA1159911 | 46489 | 364 | 1.106529 | 4.02776556 | Orbilia oligospora ATCC 24927 | 756982 | Fungi | Fungi | 94.4 | 1.14e-21 | NR | XP_011117184.1 | 756982 | g45947 | i0 | 68.9 | 1.52472527472527 | 61 | 19 | 50.3 | 0 | 361 | 179 | 100 | 160 | XP_011117184.1 hypothetical protein AOL_s00004g232 [Orbilia oligospora ATCC 24927] | diamond | 555 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia oligospora | |
| 30293569 | 30293569 | PRJNA1159911_P_NODE_5392_length_1510_cov_4.388309_g5125_i0 | PRJNA1159911 | 5392 | 1510 | 4.388309 | 66.2634659 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 252 | 9.6e-79 | NR | KAJ8134499.1 | 27326 | g5125 | i0 | 92.7 | 0.272185430463576 | 137 | 10 | 27.2 | 0 | 753 | 343 | 1 | 137 | KAJ8134499.1 hypothetical protein OY671_012288, partial [Metschnikowia pulcherrima] | diamond | 411 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30577248 | 30577248 | PRJNA1159911_P_NODE_28333_length_511_cov_2.573059_g27793_i0 | PRJNA1159911 | 28333 | 511 | 2.573059 | 13.14833149 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 97.8 | 6.709999999999999e-23 | NR | XP_023629431.1 | 112498 | g27793 | i0 | 59.8 | 0.657534246575342 | 112 | 42 | 65.2 | 2 | 463 | 131 | 1 | 110 | XP_023629431.1 probable ribosomal protein P2 [Ramularia collo-cygni] | diamond | 336 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 30628205 | 30628205 | PRJNA1159911_P_NODE_102773_length_234_cov_2.732919_g102231_i0 | PRJNA1159911 | 102773 | 234 | 2.732919 | 6.39503046 | Ascomycota | 4890 | Fungi | Fungi | 122 | 7.069999999999999e-31 | NR | KAK9453517.1 | 27313 | g102231 | i0 | 72.4 | 8.76923076923077 | 76 | 21 | 97.4 | 0 | 2 | 229 | 260 | 335 | KAK9453517.1 pyridoxal phosphate-dependent transferase [Dipodascopsis uninucleata] | diamond | 2052 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis uninucleata | |
| 30988365 | 30988365 | PRJNA1159911_P_NODE_69454_length_285_cov_1.358491_g68912_i0 | PRJNA1159911 | 69454 | 285 | 1.358491 | 3.87169935 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 64.3 | 1.6e-9 | NR | KAK5103427.1 | 1690604 | g68912 | i0 | 40 | 0.894736842105263 | 85 | 49 | 89.5 | 1 | 3 | 257 | 689 | 771 | KAK5103427.1 metalloprotease [Lithohypha guttulata] | diamond | 255 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 31715490 | 31715490 | PRJNA1159911_P_NODE_56957_length_320_cov_2.591093_g56415_i0 | PRJNA1159911 | 56957 | 320 | 2.591093 | 8.2914976 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 125 | 9.529999999999999e-35 | NR | KAJ8134883.1 | 27326 | g56415 | i0 | 98.4 | 0.590625 | 63 | 1 | 59.1 | 0 | 132 | 320 | 1 | 63 | KAJ8134883.1 hypothetical protein OY671_011904, partial [Metschnikowia pulcherrima] | diamond | 189 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 31734670 | 31734670 | PRJNA1159911_P_NODE_56057_length_324_cov_0.840637_g55515_i0 | PRJNA1159911 | 56057 | 324 | 0.840637 | 2.72366388 | Fungi | 4751 | Fungi | Fungi | 106 | 4.37e-27 | NR | XP_001487242.1 | 294746 | g55515 | i0 | 59.6 | 27.2777777777778 | 99 | 35 | 87 | 1 | 283 | 2 | 2 | 100 | XP_001487242.1 histone H2A.2 [Meyerozyma guilliermondii ATCC 6260] | diamond | 8838 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 32126977 | 32126977 | PRJNA1159911_P_NODE_89818_length_249_cov_0.875000_g89276_i0 | PRJNA1159911 | 89818 | 249 | 0.875 | 2.17875 | Lipomyces starkeyi | 29829 | Fungi | Fungi | 50.8 | 3.73e-5 | NR | KAK9313905.1 | 29829 | g89276 | i0 | 47.6 | 0.506024096385542 | 42 | 22 | 50.6 | 0 | 12 | 137 | 30 | 71 | KAK9313905.1 hypothetical protein V1524DRAFT_448443 [Lipomyces starkeyi] | diamond | 126 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces starkeyi |
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);;