contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA358049" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9326548 | 9326548 | PRJNA358049_S_NODE_12088_length_190_cov_1.106383_g12040_i0 | PRJNA358049 | 12088 | 190 | 1.106383 | 2.1021277 | Eukaryota | 2759 | Fungi | Fungi | 86.7 | 1.84e-18 | NR | CAD6575676.1 | 2778382 | g12040 | i0 | 67.7 | 1.97368421052632 | 62 | 20 | 97.9 | 0 | 186 | 1 | 11 | 72 | CAD6575676.1 MAG: hypothetical protein TREMPRED_001470 [Tremellales sp. Tagirdzhanova-0007] | diamond | 375 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Tagirdzhanova-0007 | |||
| 11877426 | 11877426 | PRJNA358049_S_NODE_530_length_729_cov_2.255882_g498_i0 | PRJNA358049 | 530 | 729 | 2.255882 | 16.44537978 | Tremella mesenterica DSM 1558 | 578456 | Fungi | Fungi | 377 | 9.209999999999999e-126 | NR | XP_007003323.1 | 578456 | g498 | i0 | 75.4 | 2 | 244 | 58 | 99.6 | 1 | 4 | 729 | 97 | 340 | XP_007003323.1 uncharacterized protein TREMEDRAFT_38441 [Tremella mesenterica DSM 1558] | diamond | 1458 | 377 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 24624868 | 24624868 | PRJNA358049_S_NODE_18940_length_157_cov_3.537037_g18892_i0 | PRJNA358049 | 18940 | 157 | 3.537037 | 5.55314809 | Kwoniella bestiolae CBS 1 | 324769 | Fungi | Fungi | 100 | 4.4799999999999997e-23 | NR | XP_019046080.1 | 1296100 | g18892 | i0 | 82.4 | 3.89808917197452 | 51 | 9 | 97.5 | 0 | 155 | 3 | 54 | 104 | XP_019046080.1 uncharacterized protein I302_105700 [Kwoniella bestiolae CBS 10118] | diamond | 612 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella bestiolae | |
| 26631707 | 26631707 | PRJNA358049_S_NODE_5061_length_270_cov_1.642534_g5013_i0 | PRJNA358049 | 5061 | 270 | 1.642534 | 4.4348418 | Kwoniella heveanensis BCC8398 | 1296120 | Fungi | Fungi | 74.7 | 2.87e-13 | NR | OCF35433.1 | 1296120 | g5013 | i0 | 47.3 | 3.22222222222222 | 91 | 46 | 98.9 | 1 | 268 | 2 | 532 | 622 | OCF35433.1 hypothetical protein I316_02985 [Kwoniella heveanensis BCC8398] | diamond | 870 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 26996915 | 26996915 | PRJNA358049_S_NODE_10182_length_202_cov_1.771242_g10134_i0 | PRJNA358049 | 10182 | 202 | 1.771242 | 3.57790884 | Kwoniella | 490731 | Fungi | Fungi | 44.7 | 0.00362 | NR | XP_031858776.1 | 1734106 | g10134 | i0 | 69 | 1.85643564356436 | 29 | 9 | 43.1 | 0 | 200 | 114 | 183 | 211 | XP_031858776.1 uncharacterized protein CI109_102101 [Kwoniella shandongensis] | diamond | 375 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 27707095 | 27707095 | PRJNA358049_S_NODE_19064_length_155_cov_2.056604_g19016_i0 | PRJNA358049 | 19064 | 155 | 2.056604 | 3.1877362 | Tremellales sp. Uapishka_1 | 3038892 | Fungi | Fungi | 74.3 | 8.08e-14 | NR | KAK4687089.1 | 3038892 | g19016 | i0 | 78.4 | 0.987096774193548 | 51 | 10 | 96.8 | 1 | 3 | 152 | 567 | 617 | KAK4687089.1 heat shock 70kDa protein 1/2/6/8, partial [Tremellales sp. Uapishka_1] | diamond | 153 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Uapishka_1 | |||
| 28527819 | 28527819 | PRJNA358049_S_NODE_1147_length_531_cov_1.906639_g1106_i0 | PRJNA358049 | 1147 | 531 | 1.906639 | 10.12425309 | Kwoniella pini CBS 1 | 453459 | Fungi | Fungi | 180 | 2.66e-53 | NR | XP_019013252.1 | 1296096 | g1106 | i0 | 66.7 | 3.21468926553672 | 138 | 45 | 77.4 | 1 | 415 | 5 | 1 | 138 | XP_019013252.1 uncharacterized protein I206_103683 [Kwoniella pini CBS 10737] | diamond | 1707 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella pini | |
| 28527820 | 28527820 | PRJNA358049_S_NODE_11987_length_190_cov_3.638298_g11939_i0 | PRJNA358049 | 11987 | 190 | 3.638298 | 6.9127662 | Trichosporon asahii | 82508 | Fungi | Fungi | 45.1 | 0.00285 | NR | ADN44281.1 | 82508 | g11939 | i0 | 51.1 | 0.710526315789474 | 45 | 21 | 69.5 | 1 | 133 | 2 | 5 | 49 | ADN44281.1 lanosterol 14-alpha-demethylase [Trichosporon asahii] | diamond | 135 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 28622453 | 28622453 | PRJNA358049_S_NODE_6907_length_236_cov_1.304813_g6859_i0 | PRJNA358049 | 6907 | 236 | 1.304813 | 3.07935868 | Malassezia restricta | 76775 | Fungi | Fungi | 67.4 | 5.96e-11 | NR | XP_027484288.1 | 76775 | g6859 | i0 | 58.7 | 0.584745762711864 | 46 | 19 | 58.5 | 0 | 235 | 98 | 305 | 350 | XP_027484288.1 WD repeat protein 61 [Malassezia restricta] | diamond | 138 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28969678 | 28969678 | PRJNA358049_S_NODE_12688_length_186_cov_1.343066_g12640_i0 | PRJNA358049 | 12688 | 186 | 1.343066 | 2.49810276 | Ceratobasidium sp. 395 | 2600204 | Fungi | Fungi | 74.7 | 2.14e-14 | NR | KAG8689877.1 | 2600204 | g12640 | i0 | 75.4 | 0.919354838709677 | 57 | 11 | 87.1 | 2 | 164 | 3 | 171 | 227 | KAG8689877.1 hypothetical protein FRC09_012219 [Ceratobasidium sp. 395] | diamond | 171 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 395 | |
| 29001606 | 29001606 | PRJNA358049_S_NODE_17228_length_165_cov_1.318966_g17180_i0 | PRJNA358049 | 17228 | 165 | 1.318966 | 2.1762939 | Malassezia globosa CBS 7966 | 425265 | Fungi | Fungi | 42.7 | 0.0127 | NR | XP_001728602.1 | 425265 | g17180 | i0 | 60.7 | 0.509090909090909 | 28 | 11 | 50.9 | 0 | 164 | 81 | 295 | 322 | XP_001728602.1 uncharacterized protein MGL_4260 [Malassezia globosa CBS 7966] | diamond | 84 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 29821877 | 29821877 | PRJNA358049_S_NODE_6851_length_237_cov_1.090426_g6803_i0 | PRJNA358049 | 6851 | 237 | 1.090426 | 2.58430962 | Kwoniella shandongensis | 1734106 | Fungi | Fungi | 124 | 1.38e-32 | NR | XP_031861437.1 | 1734106 | g6803 | i0 | 81 | 3 | 79 | 15 | 100 | 0 | 1 | 237 | 117 | 195 | XP_031861437.1 uncharacterized protein CI109_105700 [Kwoniella shandongensis] | diamond | 711 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 30028907 | 30028907 | PRJNA358049_S_NODE_5951_length_252_cov_1.669951_g5903_i0 | PRJNA358049 | 5951 | 252 | 1.669951 | 4.20827652 | Tremellales | 5234 | Fungi | Fungi | 93.6 | 5.35e-20 | NR | ORY30595.1 | 71784 | g5903 | i0 | 69.5 | 2.75 | 59 | 18 | 70.2 | 0 | 250 | 74 | 800 | 858 | ORY30595.1 hypothetical protein BCR39DRAFT_529076 [Naematelia encephala] | diamond | 693 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 30091786 | 30091786 | PRJNA358049_S_NODE_17132_length_165_cov_1.767241_g17084_i0 | PRJNA358049 | 17132 | 165 | 1.767241 | 2.91594765 | Tremellales | 5234 | Fungi | Fungi | 43.1 | 0.00832 | NR | KAK1925477.1 | 5418 | g17084 | i0 | 73.1 | 0.909090909090909 | 26 | 7 | 47.3 | 0 | 163 | 86 | 192 | 217 | KAK1925477.1 hypothetical protein DB88DRAFT_484083 [Papiliotrema laurentii] | diamond | 150 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 30106351 | 30106351 | PRJNA358049_S_NODE_3772_length_307_cov_1.790698_g3724_i0 | PRJNA358049 | 3772 | 307 | 1.790698 | 5.49744286 | Saitozyma podzolica | 1890683 | Fungi | Fungi | 110 | 1.78e-25 | NR | RSH91270.1 | 1890683 | g3724 | i0 | 81.2 | 2.0228013029316 | 69 | 13 | 67.4 | 0 | 1 | 207 | 698 | 766 | RSH91270.1 hypothetical protein EHS25_009569 [Saitozyma podzolica] | diamond | 621 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Trimorphomycetaceae | Saitozyma | Saitozyma podzolica | |
| 30359718 | 30359718 | PRJNA358049_S_NODE_7112_length_233_cov_1.923913_g7064_i0 | PRJNA358049 | 7112 | 233 | 1.923913 | 4.48271729 | Tremella mesenterica DSM 1558 | 578456 | Fungi | Fungi | 58.2 | 2.05e-8 | NR | XP_007008494.1 | 578456 | g7064 | i0 | 63.6 | 0.566523605150215 | 44 | 16 | 56.7 | 0 | 2 | 133 | 101 | 144 | XP_007008494.1 uncharacterized protein TREMEDRAFT_66382 [Tremella mesenterica DSM 1558] | diamond | 132 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 30801443 | 30801443 | PRJNA358049_S_NODE_11254_length_194_cov_1.772414_g11206_i0 | PRJNA358049 | 11254 | 194 | 1.772414 | 3.43848316 | Kwoniella shivajii | 564305 | Fungi | Fungi | 61.6 | 4.23e-9 | NR | XP_062788638.1 | 564305 | g11206 | i0 | 82.1 | 0.43298969072165 | 28 | 5 | 43.3 | 0 | 103 | 186 | 623 | 650 | XP_062788638.1 uncharacterized protein IL334_000824 [Kwoniella shivajii] | diamond | 84 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 31180360 | 31180360 | PRJNA358049_S_NODE_3455_length_320_cov_2.088561_g3407_i0 | PRJNA358049 | 3455 | 320 | 2.088561 | 6.6833952 | Saitozyma podzolica | 1890683 | Fungi | Fungi | 86.3 | 4.89e-17 | NR | RSH91270.1 | 1890683 | g3407 | i0 | 84.1 | 0.4125 | 44 | 7 | 41.3 | 0 | 319 | 188 | 792 | 835 | RSH91270.1 hypothetical protein EHS25_009569 [Saitozyma podzolica] | diamond | 132 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Trimorphomycetaceae | Saitozyma | Saitozyma podzolica | |
| 31781468 | 31781468 | PRJNA358049_S_NODE_3497_length_318_cov_2.531599_g3449_i0 | PRJNA358049 | 3497 | 318 | 2.531599 | 8.05048482 | Tremella mesenterica DSM 1558 | 578456 | Fungi | Fungi | 136 | 4.21e-35 | NR | XP_007003323.1 | 578456 | g3449 | i0 | 74.7 | 2.34905660377358 | 83 | 21 | 78.3 | 0 | 317 | 69 | 462 | 544 | XP_007003323.1 uncharacterized protein TREMEDRAFT_38441 [Tremella mesenterica DSM 1558] | diamond | 747 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 32193026 | 32193026 | PRJNA358049_S_NODE_9538_length_207_cov_1.816456_g9490_i0 | PRJNA358049 | 9538 | 207 | 1.816456 | 3.76006392 | Tremellales sp. Uapishka_1 | 3038892 | Fungi | Fungi | 100 | 1.15e-22 | NR | KAK4683508.1 | 3038892 | g9490 | i0 | 61.8 | 0.985507246376812 | 68 | 26 | 98.6 | 0 | 3 | 206 | 254 | 321 | KAK4683508.1 alpha-1,3-mannosyltransferase, partial [Tremellales sp. Uapishka_1] | diamond | 204 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Uapishka_1 |
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);;