contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1032461" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26654985 | 26654985 | PRJNA1032461_S_NODE_18201_length_165_cov_0.896552_g18103_i0 | PRJNA1032461 | 18201 | 165 | 0.896552 | 1.4793108 | Malassezia obtusa | 76774 | Fungi | Fungi | 115 | 2.37e-28 | NR | WFD02549.1 | 76774 | g18103 | i0 | 100 | 1 | 55 | 0 | 100 | 0 | 1 | 165 | 939 | 993 | WFD02549.1 hypothetical protein MOBT1_001233 [Malassezia obtusa] | diamond | 165 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 26869161 | 26869161 | PRJNA1032461_S_NODE_21701_length_162_cov_0.920354_g21603_i0 | PRJNA1032461 | 21701 | 162 | 0.920354 | 1.49097348 | Malassezia | 55193 | Fungi | Fungi | 85.9 | 7.63e-18 | NR | AYO43640.1 | 425264 | g21603 | i0 | 96.2 | 1.96296296296296 | 53 | 2 | 98.1 | 0 | 161 | 3 | 80 | 132 | AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877] | diamond | 318 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27098302 | 27098302 | PRJNA1032461_S_NODE_8542_length_208_cov_1.308176_g8444_i0 | PRJNA1032461 | 8542 | 208 | 1.308176 | 2.72100608 | Hypsizygus marmoreus | 39966 | Fungi | Fungi | 62.4 | 7.72e-10 | NR | RDB19011.1 | 39966 | g8444 | i0 | 46.4 | 1.96153846153846 | 69 | 31 | 92.3 | 2 | 7 | 198 | 33 | 100 | RDB19011.1 hypothetical protein Hypma_014368 [Hypsizygus marmoreus] | diamond | 408 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 27951211 | 27951211 | PRJNA1032461_S_NODE_21485_length_162_cov_0.920354_g21387_i0 | PRJNA1032461 | 21485 | 162 | 0.920354 | 1.49097348 | Microthyrium microscopicum | 703497 | Fungi | Fungi | 50.4 | 2.24e-5 | NR | KAF2672478.1 | 703497 | g21387 | i0 | 66.7 | 0.944444444444444 | 51 | 14 | 94.4 | 1 | 157 | 5 | 5 | 52 | KAF2672478.1 hypothetical protein BT63DRAFT_369857 [Microthyrium microscopicum] | diamond | 153 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Microthyriales | Microthyriaceae | Microthyrium | Microthyrium microscopicum | |
| 28393167 | 28393167 | PRJNA1032461_S_NODE_21766_length_162_cov_0.920354_g21668_i0 | PRJNA1032461 | 21766 | 162 | 0.920354 | 1.49097348 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 103 | 5.28e-25 | NR | SHO78712.1 | 1230383 | g21668 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 2 | 160 | 243 | 295 | SHO78712.1 Similar to S.cerevisiae protein MUP1 (High affinity methionine permease) [Malassezia sympodialis ATCC 42132] | diamond | 159 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 28574584 | 28574584 | PRJNA1032461_S_NODE_12407_length_178_cov_1.209302_g12309_i0 | PRJNA1032461 | 12407 | 178 | 1.209302 | 2.15255756 | Eukaryota | 2759 | Fungi | Fungi | 43.9 | 0.00622 | NR | XP_062793271.1 | 564305 | g12309 | i0 | 62.5 | 1.14606741573034 | 24 | 9 | 40.4 | 0 | 1 | 72 | 395 | 418 | XP_062793271.1 uncharacterized protein IL334_005508 [Kwoniella shivajii] | diamond | 204 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 29403592 | 29403592 | PRJNA1032461_S_NODE_13009_length_174_cov_2.032000_g12911_i0 | PRJNA1032461 | 13009 | 174 | 2.032 | 3.53568 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 67 | 4.17e-11 | NR | WFD16437.1 | 1514897 | g12911 | i0 | 66.1 | 1.06896551724138 | 62 | 9 | 86.2 | 1 | 4 | 153 | 932 | 993 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 186 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 29434817 | 29434817 | PRJNA1032461_S_NODE_14550_length_169_cov_0.866667_g14452_i0 | PRJNA1032461 | 14550 | 169 | 0.866667 | 1.46466723 | Thielaviopsis punctulata | 72032 | Fungi | Fungi | 104 | 2.2799999999999998e-24 | NR | KKA29303.1 | 72032 | g14452 | i0 | 83.9 | 1.98816568047337 | 56 | 9 | 99.4 | 0 | 168 | 1 | 406 | 461 | KKA29303.1 hypothetical protein TD95_002379 [Thielaviopsis punctulata] | diamond | 336 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Thielaviopsis | Thielaviopsis punctulata | |
| 29521842 | 29521842 | PRJNA1032461_S_NODE_17130_length_166_cov_0.888889_g17032_i0 | PRJNA1032461 | 17130 | 166 | 0.888889 | 1.47555574 | Rhizophagus | 295919 | Fungi | Fungi | 92 | 3.3800000000000003e-21 | NR | EXX69254.1 | 1432141 | g17032 | i0 | 72.2 | 3.90361445783133 | 54 | 15 | 97.6 | 0 | 163 | 2 | 158 | 211 | EXX69254.1 ribosomal 40S subunit protein S4A [Rhizophagus irregularis DAOM 197198w] | diamond | 648 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 29719013 | 29719013 | PRJNA1032461_S_NODE_2850_length_328_cov_2.544803_g2752_i0 | PRJNA1032461 | 2850 | 328 | 2.544803 | 8.34695384 | Colletotrichum higginsianum | 80884 | Fungi | Fungi | 40.8 | 0.042 | NR | CCF41183.1 | 80884 | g2752 | i0 | 62.5 | 0.219512195121951 | 24 | 9 | 22 | 0 | 31 | 102 | 8 | 31 | CCF41183.1 cellular nucleic acid-binding protein [Colletotrichum higginsianum] | diamond | 72 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum higginsianum | |
| 29971911 | 29971911 | PRJNA1032461_S_NODE_20071_length_163_cov_0.912281_g19973_i0 | PRJNA1032461 | 20071 | 163 | 0.912281 | 1.48701803 | Ceratocystis platani | 88771 | Fungi | Fungi | 85.1 | 1.49e-17 | NR | KKF96983.1 | 88771 | g19973 | i0 | 75.9 | 0.993865030674847 | 54 | 13 | 99.4 | 0 | 162 | 1 | 823 | 876 | KKF96983.1 putative RNA-binding protein.04c [Ceratocystis platani] | diamond | 162 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Ceratocystis | Ceratocystis platani | |
| 30003650 | 30003650 | PRJNA1032461_S_NODE_15691_length_168_cov_0.873950_g15593_i0 | PRJNA1032461 | 15691 | 168 | 0.87395 | 1.468236 | Triangularia setosa | 2587417 | Fungi | Fungi | 90.5 | 2.18e-22 | NR | KAK4171144.1 | 2587417 | g15593 | i0 | 76 | 0.892857142857143 | 50 | 12 | 89.3 | 0 | 151 | 2 | 1 | 50 | KAK4171144.1 hypothetical protein QBC36DRAFT_199970 [Triangularia setosa] | diamond | 150 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Triangularia | Triangularia setosa | |
| 31425528 | 31425528 | PRJNA1032461_S_NODE_15176_length_168_cov_0.873950_g15078_i0 | PRJNA1032461 | 15176 | 168 | 0.87395 | 1.468236 | Elasticomyces elasticus | 574655 | Fungi | Fungi | 81.3 | 3.47e-16 | NR | KAK4890533.1 | 574655 | g15078 | i0 | 78.6 | 1.5 | 42 | 9 | 75 | 0 | 41 | 166 | 496 | 537 | KAK4890533.1 hypothetical protein LTR27_010814 [Elasticomyces elasticus] | diamond | 252 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus | |
| 31741732 | 31741732 | PRJNA1032461_S_NODE_15537_length_168_cov_0.873950_g15439_i0 | PRJNA1032461 | 15537 | 168 | 0.87395 | 1.468236 | Xylaria palmicola | 665665 | Fungi | Fungi | 41.2 | 0.0441 | NR | KAI0407747.1 | 665665 | g15439 | i0 | 45.2 | 0.75 | 42 | 20 | 75 | 1 | 9 | 134 | 125 | 163 | KAI0407747.1 hypothetical protein F4802DRAFT_525740 [Xylaria palmicola] | diamond | 126 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria palmicola | |
| 31900038 | 31900038 | PRJNA1032461_S_NODE_17917_length_165_cov_1.327586_g17819_i0 | PRJNA1032461 | 17917 | 165 | 1.327586 | 2.1905169 | Malassezia obtusa | 76774 | Fungi | Fungi | 79.3 | 1.68e-15 | NR | WFD03248.1 | 76774 | g17819 | i0 | 85.5 | 1 | 55 | 8 | 100 | 0 | 165 | 1 | 1520 | 1574 | WFD03248.1 snoRNA-binding rRNA-processing protein utp10 [Malassezia obtusa] | diamond | 165 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 32658631 | 32658631 | PRJNA1032461_S_NODE_18660_length_165_cov_0.896552_g18562_i0 | PRJNA1032461 | 18660 | 165 | 0.896552 | 1.4793108 | Kwoniella shivajii | 564305 | Fungi | Fungi | 54.7 | 8.07e-7 | NR | XP_062792105.1 | 564305 | g18562 | i0 | 54.8 | 0.763636363636364 | 42 | 19 | 76.4 | 0 | 7 | 132 | 305 | 346 | XP_062792105.1 uncharacterized protein IL334_004336 [Kwoniella shivajii] | diamond | 126 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii |
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);;