contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1002570" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10355266 | 10355266 | PRJNA1002570_P_NODE_13449_length_327_cov_4.708661_g13254_i0 | PRJNA1002570 | 13449 | 327 | 4.708661 | 15.39732147 | root | 1 | Root_unresolved | Root_unresolved | 177 | 3.02e-49 | NR | KAH0533695.1 | 1670608 | g13254 | i0 | 67.4 | 12.6880733944954 | 138 | 14 | 98.2 | 1 | 323 | 3 | 48 | 185 | KAH0533695.1 hypothetical protein FGG08_007594, partial [Glutinoglossum americanum] | diamond | 4149 | 177 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Geoglossomycetes | Geoglossales | Geoglossaceae | Glutinoglossum | Glutinoglossum americanum | |
| 20553387 | 20553387 | PRJNA1002570_P_NODE_20017_length_290_cov_1.783410_g19822_i0 | PRJNA1002570 | 20017 | 290 | 1.78341 | 5.171889 | Didymella keratinophila | 2301244 | Fungi | Fungi | 117 | 3.65e-28 | NR | KAF3053669.1 | 2301244 | g19822 | i0 | 82.6 | 0.713793103448276 | 69 | 12 | 71.4 | 0 | 1 | 207 | 604 | 672 | KAF3053669.1 hypothetical protein E8E11_010817 [Didymella keratinophila] | diamond | 207 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella keratinophila | |
| 26781364 | 26781364 | PRJNA1002570_P_NODE_39461_length_247_cov_0.885057_g39266_i0 | PRJNA1002570 | 39461 | 247 | 0.885057 | 2.18609079 | Cladobotryum mycophilum | 491253 | Fungi | Fungi | 69.7 | 1.25e-11 | NR | KAK5993841.1 | 491253 | g39266 | i0 | 47.5 | 0.97165991902834 | 80 | 42 | 97.2 | 0 | 2 | 241 | 326 | 405 | KAK5993841.1 bZIP transcription factor hapX [Cladobotryum mycophilum] | diamond | 240 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Cladobotryum | Cladobotryum mycophilum | |
| 27255625 | 27255625 | PRJNA1002570_P_NODE_42143_length_243_cov_1.900000_g41948_i0 | PRJNA1002570 | 42143 | 243 | 1.9 | 4.617 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 73.6 | 5.11e-13 | NR | XP_033660540.1 | 1080233 | g41948 | i0 | 47.3 | 0.91358024691358 | 74 | 35 | 91.4 | 1 | 227 | 6 | 354 | 423 | XP_033660540.1 uncharacterized protein M409DRAFT_29818 [Zasmidium cellare ATCC 36951] | diamond | 222 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 27855632 | 27855632 | PRJNA1002570_P_NODE_15005_length_311_cov_2.907563_g14810_i0 | PRJNA1002570 | 15005 | 311 | 2.907563 | 9.04252093 | Lachancea meyersii CBS 8951 | 1266667 | Fungi | Fungi | 57 | 7.79e-7 | NR | SCU85792.1 | 1266667 | g14810 | i0 | 44.3 | 0.67524115755627 | 70 | 33 | 61.7 | 2 | 109 | 300 | 96 | 165 | SCU85792.1 LAME_0D02828g1_1 [Lachancea meyersii CBS 8951] | diamond | 210 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Lachancea | Lachancea meyersii | |
| 28226916 | 28226916 | PRJNA1002570_P_NODE_27966_length_272_cov_2.281407_g27771_i0 | PRJNA1002570 | 27966 | 272 | 2.281407 | 6.20542704 | Fungi | 4751 | Fungi | Fungi | 113 | 9.23e-27 | NR | KAA6412648.1 | 136370 | g27771 | i0 | 55.8 | 3.72794117647059 | 86 | 38 | 94.9 | 0 | 270 | 13 | 813 | 898 | KAA6412648.1 MAG: phosphatidylserine decarboxylase [Lasallia pustulata] | diamond | 1014 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Umbilicariales | Umbilicariaceae | Lasallia | Lasallia pustulata | |
| 28424196 | 28424196 | PRJNA1002570_P_NODE_41766_length_244_cov_0.900585_g41571_i0 | PRJNA1002570 | 41766 | 244 | 0.900585 | 2.1974274 | Tuber melanosporum | 39416 | Fungi | Fungi | 51.2 | 3.46e-5 | NR | XP_002842467.1 | 39416 | g41571 | i0 | 59.5 | 0.454918032786885 | 37 | 15 | 45.5 | 0 | 115 | 225 | 251 | 287 | XP_002842467.1 uncharacterized protein GSTUM_00012217001 [Tuber melanosporum] | diamond | 111 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Tuber | Tuber melanosporum | |
| 29813194 | 29813194 | PRJNA1002570_P_NODE_33311_length_258_cov_2.081081_g33116_i0 | PRJNA1002570 | 33311 | 258 | 2.081081 | 5.36918898 | Talaromyces proteolyticus | 1131652 | Fungi | Fungi | 43.9 | 0.0176 | NR | XP_046067753.1 | 1131652 | g33116 | i0 | 50 | 0.395348837209302 | 34 | 17 | 39.5 | 0 | 112 | 213 | 393 | 426 | XP_046067753.1 uncharacterized protein BGW36DRAFT_400887 [Talaromyces proteolyticus] | diamond | 102 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces proteolyticus | |
| 30128861 | 30128861 | PRJNA1002570_P_NODE_20052_length_290_cov_1.580645_g19857_i0 | PRJNA1002570 | 20052 | 290 | 1.580645 | 4.5838705 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 160 | 1.08e-46 | NR | KAJ8138585.1 | 27326 | g19857 | i0 | 82.3 | 0.993103448275862 | 96 | 4 | 99.3 | 1 | 2 | 289 | 97 | 179 | KAJ8138585.1 hypothetical protein OY671_008202, partial [Metschnikowia pulcherrima] | diamond | 288 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30192314 | 30192314 | PRJNA1002570_P_NODE_34752_length_254_cov_1.701657_g34557_i0 | PRJNA1002570 | 34752 | 254 | 1.701657 | 4.32220878 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 53.9 | 2.32e-7 | NR | KAH2808747.1 | 746128 | g34557 | i0 | 100 | 0.330708661417323 | 28 | 0 | 33.1 | 0 | 171 | 254 | 1 | 28 | KAH2808747.1 hypothetical protein KXV85_005851, partial [Aspergillus fumigatus] | diamond | 84 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 30816879 | 30816879 | PRJNA1002570_P_NODE_19134_length_293_cov_2.918182_g18939_i0 | PRJNA1002570 | 19134 | 293 | 2.918182 | 8.55027326 | root | 1 | Root_unresolved | Root_unresolved | 168 | 6.41e-46 | NR | XP_044665385.1 | 2732470 | g18939 | i0 | 83.5 | 8.93856655290102 | 97 | 16 | 99.3 | 0 | 2 | 292 | 1848 | 1944 | XP_044665385.1 uncharacterized protein KY384_000095 [Bacidia gigantensis] | diamond | 2619 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Lecanorales | Ramalinaceae | Bacidia | Bacidia gigantensis | |
| 31202999 | 31202999 | PRJNA1002570_P_NODE_39715_length_246_cov_1.832370_g39520_i0 | PRJNA1002570 | 39715 | 246 | 1.83237 | 4.5076302 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 170 | 6.32e-52 | NR | KAH2775956.1 | 746128 | g39520 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 244 | 2 | 50 | 130 | KAH2775956.1 hypothetical protein KXW38_000907, partial [Aspergillus fumigatus] | diamond | 243 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 32176841 | 32176841 | PRJNA1002570_P_NODE_23238_length_283_cov_2.376190_g23043_i0 | PRJNA1002570 | 23238 | 283 | 2.37619 | 6.7246177 | Fusarium | 5506 | Fungi | Fungi | 97.8 | 2.04e-21 | NR | KAF4332946.1 | 44412 | g23043 | i0 | 97.9 | 1.52650176678445 | 48 | 1 | 50.9 | 0 | 139 | 282 | 246 | 293 | KAF4332946.1 hypothetical protein FBEOM_13247, partial [Fusarium beomiforme] | diamond | 432 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium beomiforme |
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);;