contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1723434 | 1723434 | PRJNA484127_P_NODE_38562_length_242_cov_1.295858_g38413_i0 | PRJNA484127 | 38562 | 242 | 1.295858 | 3.13597636 | Vermiconidia calcicola | 1690605 | Fungi | Fungi | 119 | 4.21e-29 | NR | KAK3724411.1 | 1690605 | g38413 | i0 | 73.8 | 1.94628099173554 | 80 | 21 | 99.2 | 0 | 2 | 241 | 884 | 963 | KAK3724411.1 NAD-dependent glutamate dehydrogenase [Vermiconidia calcicola] | diamond | 471 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Vermiconidia | Vermiconidia calcicola | |
| 11927006 | 11927006 | PRJNA484127_P_NODE_16190_length_319_cov_1.223577_g16041_i0 | PRJNA484127 | 16190 | 319 | 1.223577 | 3.90321063 | Ascomycota | 4890 | Fungi | Fungi | 107 | 2.81e-27 | NR | XP_066771658.1 | 56418 | g16041 | i0 | 55.2 | 2.96238244514107 | 105 | 47 | 98.7 | 0 | 318 | 4 | 1 | 105 | XP_066771658.1 NAC domain-containing protein [Lipomyces arxii] | diamond | 945 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces arxii | |
| 15751365 | 15751365 | PRJNA484127_P_NODE_35913_length_245_cov_1.558140_g35764_i0 | PRJNA484127 | 35913 | 245 | 1.55814 | 3.817443 | Fungi | 4751 | Fungi | Fungi | 73.6 | 5.34e-13 | NR | KAI9897107.1 | 47278 | g35764 | i0 | 55.6 | 18.3061224489796 | 63 | 27 | 75.9 | 1 | 188 | 3 | 44 | 106 | KAI9897107.1 hypothetical protein N3K66_008129 [Trichothecium roseum] | diamond | 4485 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Trichothecium | Trichothecium roseum | ||
| 18948843 | 18948843 | PRJNA484127_P_NODE_8355_length_410_cov_3.044510_g8206_i0 | PRJNA484127 | 8355 | 410 | 3.04451 | 12.482491 | Tortispora caseinolytica NRRL Y-17796 | 767744 | Fungi | Fungi | 131 | 1.36e-32 | NR | ODV88461.1 | 767744 | g8206 | i0 | 48.2 | 4.06829268292683 | 141 | 65 | 99.5 | 3 | 2 | 409 | 135 | 272 | ODV88461.1 hypothetical protein CANCADRAFT_70868 [Tortispora caseinolytica NRRL Y-17796] | diamond | 1668 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Trigonopsidomycetes | Trigonopsidales | Trigonopsidaceae | Tortispora | Tortispora caseinolytica | |
| 26855011 | 26855011 | PRJNA484127_P_NODE_12101_length_356_cov_0.992933_g11952_i0 | PRJNA484127 | 12101 | 356 | 0.992933 | 3.53484148 | Cytospora schulzeri | 448051 | Fungi | Fungi | 45.8 | 0.0032 | NR | ROW04706.1 | 448051 | g11952 | i0 | 36.5 | 0.438202247191011 | 52 | 23 | 35.4 | 1 | 151 | 276 | 33 | 84 | ROW04706.1 hypothetical protein VMCG_04795 [Cytospora schulzeri] | diamond | 156 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora schulzeri | |
| 27913464 | 27913464 | PRJNA484127_P_NODE_20205_length_294_cov_0.895928_g20056_i0 | PRJNA484127 | 20205 | 294 | 0.895928 | 2.63402832 | Fungi | 4751 | Fungi | Fungi | 60.8 | 3.12e-8 | NR | XP_018226651.1 | 1408658 | g20056 | i0 | 31.3 | 4 | 96 | 63 | 98 | 1 | 4 | 291 | 932 | 1024 | XP_018226651.1 hypothetical protein T552_00873 [Pneumocystis carinii B80] | diamond | 1176 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis carinii | |
| 27992387 | 27992387 | PRJNA484127_P_NODE_27585_length_260_cov_1.668449_g27436_i0 | PRJNA484127 | 27585 | 260 | 1.668449 | 4.3379674 | Rachicladosporium sp. CCFEE 5 | 2040939 | Fungi | Fungi | 45.4 | 0.0051 | NR | OQO29773.1 | 1974281 | g27436 | i0 | 40.6 | 0.738461538461539 | 64 | 27 | 61.2 | 2 | 10 | 168 | 517 | 580 | OQO29773.1 hypothetical protein B0A51_03688 [Rachicladosporium sp. CCFEE 5018] | diamond | 192 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Rachicladosporium | Rachicladosporium sp. CCFEE 5018 | |
| 28071409 | 28071409 | PRJNA484127_P_NODE_26465_length_264_cov_2.041885_g26316_i0 | PRJNA484127 | 26465 | 264 | 2.041885 | 5.3905764 | Saccharomycetaceae | 4893 | Fungi | Fungi | 75.1 | 1.91e-13 | NR | XP_017988954.1 | 45286 | g26316 | i0 | 63.6 | 7.90909090909091 | 55 | 20 | 62.5 | 0 | 203 | 39 | 284 | 338 | XP_017988954.1 serine C-palmitoyltransferase LCB1 [Eremothecium sinecaudum] | diamond | 2088 | 75.5 | 0.994701986754967 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Eremothecium | Eremothecium sinecaudum | |
| 28166298 | 28166298 | PRJNA484127_P_NODE_18465_length_304_cov_1.350649_g18316_i0 | PRJNA484127 | 18465 | 304 | 1.350649 | 4.10597296 | Fungi | 4751 | Fungi | Fungi | 84.3 | 6.11e-19 | NR | KAL2313328.1 | 4896 | g18316 | i0 | 61.1 | 9.43421052631579 | 72 | 27 | 71.1 | 1 | 69 | 284 | 11 | 81 | KAL2313328.1 60S ribosomal protein L38-1 [Schizosaccharomyces pombe] | diamond | 2868 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 28402748 | 28402748 | PRJNA484127_P_NODE_12746_length_349_cov_1.130435_g12597_i0 | PRJNA484127 | 12746 | 349 | 1.130435 | 3.94521815 | Apiospora hydei | 1337664 | Fungi | Fungi | 53.5 | 1.44e-5 | NR | XP_066667791.1 | 1337664 | g12597 | i0 | 28.7 | 0.868194842406877 | 101 | 69 | 84.2 | 2 | 23 | 316 | 101 | 201 | XP_066667791.1 Initiation-specific alpha-1-6-mannosyltransferase [Apiospora hydei] | diamond | 303 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora hydei | |
| 28402758 | 28402758 | PRJNA484127_P_NODE_25406_length_269_cov_1.193878_g25257_i0 | PRJNA484127 | 25406 | 269 | 1.193878 | 3.21153182 | Yamadazyma tenuis | 2315449 | Fungi | Fungi | 70.5 | 8.17e-12 | NR | XP_006685504.1 | 2315449 | g25257 | i0 | 44.8 | 0.747211895910781 | 67 | 37 | 74.7 | 0 | 59 | 259 | 353 | 419 | XP_006685504.1 uncharacterized protein PSN45_005037 [Yamadazyma tenuis] | diamond | 201 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Yamadazyma | Yamadazyma tenuis | |
| 28987388 | 28987388 | PRJNA484127_P_NODE_38288_length_242_cov_4.686391_g38139_i0 | PRJNA484127 | 38288 | 242 | 4.686391 | 11.34106622 | Orbilia | 47022 | Fungi | Fungi | 41.2 | 0.0283 | NR | KAK6544423.1 | 2528407 | g38139 | i0 | 72 | 1.38842975206612 | 25 | 7 | 31 | 0 | 82 | 156 | 54 | 78 | KAK6544423.1 hypothetical protein TWF694_001118 [Orbilia ellipsospora] | diamond | 336 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia ellipsospora | |
| 29286690 | 29286690 | PRJNA484127_P_NODE_5489_length_489_cov_1.778846_g5341_i0 | PRJNA484127 | 5489 | 489 | 1.778846 | 8.69855694 | Candida jiufengensis | 497108 | Fungi | Fungi | 218 | 4.81e-65 | NR | XP_051621114.1 | 497108 | g5341 | i0 | 66 | 0.993865030674847 | 162 | 54 | 98.8 | 1 | 5 | 487 | 181 | 342 | XP_051621114.1 CCT6 [Candida jiufengensis] | diamond | 486 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida jiufengensis | |
| 29712972 | 29712972 | PRJNA484127_P_NODE_26810_length_263_cov_1.631579_g26661_i0 | PRJNA484127 | 26810 | 263 | 1.631579 | 4.29105277 | Venturia | 5024 | Fungi | Fungi | 55.8 | 1.16e-6 | NR | RDI77750.1 | 5025 | g26661 | i0 | 31.6 | 3.27376425855513 | 95 | 57 | 99.2 | 2 | 2 | 262 | 37 | 131 | RDI77750.1 SH3 domain-containing protein [Venturia inaequalis] | diamond | 861 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Venturiaceae | Venturia | Venturia inaequalis | |
| 30266149 | 30266149 | PRJNA484127_P_NODE_25812_length_267_cov_1.474227_g25663_i0 | PRJNA484127 | 25812 | 267 | 1.474227 | 3.93618609 | Sarocladium strictum | 5046 | Fungi | Fungi | 103 | 1.9499999999999994e-23 | NR | KAK0387719.1 | 5046 | g25663 | i0 | 94 | 1.12359550561798 | 50 | 3 | 56.2 | 0 | 1 | 150 | 10 | 59 | KAK0387719.1 hypothetical protein NLU13_3964 [Sarocladium strictum] | diamond | 300 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31213316 | 31213316 | PRJNA484127_P_NODE_38215_length_243_cov_0.917647_g38066_i0 | PRJNA484127 | 38215 | 243 | 0.917647 | 2.22988221 | Vermiconidia calcicola | 1690605 | Fungi | Fungi | 79.3 | 4.49e-15 | NR | KAK3698197.1 | 1690605 | g38066 | i0 | 57.6 | 0.814814814814815 | 66 | 28 | 81.5 | 0 | 45 | 242 | 1 | 66 | KAK3698197.1 hypothetical protein LTR37_017022 [Vermiconidia calcicola] | diamond | 198 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Vermiconidia | Vermiconidia calcicola | |
| 31293021 | 31293021 | PRJNA484127_P_NODE_22455_length_282_cov_1.325359_g22306_i0 | PRJNA484127 | 22455 | 282 | 1.325359 | 3.73751238 | Ascomycota | 4890 | Fungi | Fungi | 84 | 1.86e-16 | NR | XP_024666263.1 | 45607 | g22306 | i0 | 49.4 | 12.4574468085106 | 87 | 41 | 92.6 | 1 | 2 | 262 | 146 | 229 | XP_024666263.1 Myo-inositol transporter 2 [Wickerhamiella sorbophila] | diamond | 3513 | 84 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella sorbophila | |
| 31798987 | 31798987 | PRJNA484127_P_NODE_23037_length_279_cov_1.509709_g22888_i0 | PRJNA484127 | 23037 | 279 | 1.509709 | 4.21208811 | Ascomycota | 4890 | Fungi | Fungi | 82.8 | 1.89e-16 | NR | XP_018737773.1 | 796027 | g22888 | i0 | 71.2 | 1.11827956989247 | 52 | 15 | 55.9 | 0 | 83 | 238 | 265 | 316 | XP_018737773.1 Rad23p [Sugiyamaella lignohabitans] | diamond | 312 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Sugiyamaella | Sugiyamaella lignohabitans | |
| 32258009 | 32258009 | PRJNA484127_P_NODE_12798_length_348_cov_1.963636_g12649_i0 | PRJNA484127 | 12798 | 348 | 1.963636 | 6.83345328 | Tothia fuscella | 1048955 | Fungi | Fungi | 63.5 | 5.84e-9 | NR | KAF2436676.1 | 1048955 | g12649 | i0 | 37.7 | 0.663793103448276 | 77 | 45 | 66.4 | 1 | 66 | 296 | 8 | 81 | KAF2436676.1 glycoside hydrolase [Tothia fuscella] | diamond | 231 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Cylindrosympodiaceae | Tothia | Tothia fuscella |
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);;