contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1123436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6658174 | 6658174 | PRJNA1123436_P_NODE_75046_length_287_cov_1.406542_g73832_i0 | PRJNA1123436 | 75046 | 287 | 1.406542 | 4.03677554 | Pleurotus djamor | 34470 | Fungi | Fungi | 184 | 6.36e-52 | NR | KAJ8508895.1 | 34470 | g73832 | i0 | 96.7 | 0.940766550522648 | 90 | 3 | 94.1 | 0 | 270 | 1 | 128 | 217 | KAJ8508895.1 hypothetical protein ONZ45_g8873 [Pleurotus djamor] | diamond | 270 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus djamor | |
| 19406534 | 19406534 | PRJNA1123436_P_NODE_89916_length_259_cov_2.166667_g88702_i0 | PRJNA1123436 | 89916 | 259 | 2.166667 | 5.61166753 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 97.8 | 2.83e-23 | NR | KAE9383837.1 | 1447944 | g88702 | i0 | 58.8 | 0.926640926640927 | 80 | 33 | 92.7 | 0 | 13 | 252 | 31 | 110 | KAE9383837.1 hypothetical protein BT96DRAFT_951000 [Gymnopus androsaceus JB14] | diamond | 240 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 26627043 | 26627043 | PRJNA1123436_P_NODE_71721_length_294_cov_1.045249_g70507_i0 | PRJNA1123436 | 71721 | 294 | 1.045249 | 3.07303206 | Ceratobasidium sp. AG-I | 305860 | Fungi | Fungi | 44.3 | 0.0192 | NR | KAF8609545.1 | 305860 | g70507 | i0 | 37 | 0.744897959183674 | 73 | 42 | 73.5 | 2 | 78 | 293 | 462 | 531 | KAF8609545.1 hypothetical protein BDV93DRAFT_147682 [Ceratobasidium sp. AG-I] | diamond | 219 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-I | |
| 26975269 | 26975269 | PRJNA1123436_P_NODE_61542_length_318_cov_2.461224_g60328_i0 | PRJNA1123436 | 61542 | 318 | 2.461224 | 7.82669232 | Auricularia subglabra TFB-1 | 1331295 | Fungi | Fungi | 59.3 | 1.3e-7 | NR | EJD49234.1 | 717982 | g60328 | i0 | 71.4 | 0.39622641509434 | 42 | 12 | 39.6 | 0 | 182 | 307 | 197 | 238 | EJD49234.1 cytochrome P450 [Auricularia subglabra TFB-10046 SS5] | diamond | 126 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra | |
| 27670670 | 27670670 | PRJNA1123436_P_NODE_128244_length_236_cov_3.233129_g127030_i0 | PRJNA1123436 | 128244 | 236 | 3.233129 | 7.63018444 | Gloeophyllum trabeum ATCC 11539 | 670483 | Fungi | Fungi | 42.4 | 0.0481 | NR | XP_007862683.1 | 670483 | g127030 | i0 | 40.3 | 0.851694915254237 | 67 | 39 | 83.9 | 1 | 220 | 23 | 715 | 781 | XP_007862683.1 ankyrin [Gloeophyllum trabeum ATCC 11539] | diamond | 201 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Gloeophyllum | Gloeophyllum trabeum | |
| 27796965 | 27796965 | PRJNA1123436_P_NODE_70604_length_296_cov_5.067265_g69390_i0 | PRJNA1123436 | 70604 | 296 | 5.067265 | 14.9991044 | Boletus edulis BED1 | 1328754 | Fungi | Fungi | 57 | 6.66e-7 | NR | KAF8443866.1 | 1328754 | g69390 | i0 | 61.7 | 0.476351351351351 | 47 | 18 | 47.6 | 0 | 8 | 148 | 34 | 80 | KAF8443866.1 hypothetical protein L210DRAFT_3643456 [Boletus edulis BED1] | diamond | 141 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Boletaceae | Boletus | Boletus edulis | |
| 27828361 | 27828361 | PRJNA1123436_P_NODE_114844_length_245_cov_0.895349_g113630_i0 | PRJNA1123436 | 114844 | 245 | 0.895349 | 2.19360505 | Agrocybe chaxingu | 84603 | Fungi | Fungi | 149 | 8.939999999999999e-43 | NR | KAJ3500278.1 | 84603 | g113630 | i0 | 88.9 | 0.991836734693878 | 81 | 9 | 99.2 | 0 | 243 | 1 | 113 | 193 | KAJ3500278.1 hypothetical protein NLJ89_g9870 [Agrocybe chaxingu] | diamond | 243 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Agrocybe | Agrocybe chaxingu | |
| 27943895 | 27943895 | PRJNA1123436_P_NODE_79465_length_279_cov_1.257282_g78251_i0 | PRJNA1123436 | 79465 | 279 | 1.257282 | 3.50781678 | Pleurotus | 5320 | Fungi | Fungi | 107 | 1.44e-24 | NR | KAG9225271.1 | 5321 | g78251 | i0 | 76.9 | 1.36559139784946 | 65 | 15 | 69.9 | 0 | 253 | 59 | 361 | 425 | KAG9225271.1 hypothetical protein CCMSSC00406_0009949 [Pleurotus cornucopiae] | diamond | 381 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus cornucopiae | |
| 28333495 | 28333495 | PRJNA1123436_P_NODE_128046_length_240_cov_2.233533_g126832_i0 | PRJNA1123436 | 128046 | 240 | 2.233533 | 5.3604792 | Serendipita sp. 4 | 1965286 | Fungi | Fungi | 42.4 | 0.0474 | NR | KAG8812541.1 | 2600214 | g126832 | i0 | 38.7 | 0.775 | 62 | 34 | 72.5 | 2 | 194 | 21 | 355 | 416 | KAG8812541.1 hypothetical protein FRC19_003071 [Serendipita sp. 401] | diamond | 186 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita sp. 401 | |
| 28775495 | 28775495 | PRJNA1123436_P_NODE_95327_length_251_cov_0.865169_g94113_i0 | PRJNA1123436 | 95327 | 251 | 0.865169 | 2.17157419 | Rhizoctonia solani AG-1 IA | 983506 | Fungi | Fungi | 42 | 0.0267 | NR | ELU36458.1 | 983506 | g94113 | i0 | 33.7 | 1.02788844621514 | 86 | 45 | 89.6 | 3 | 1 | 225 | 18 | 102 | ELU36458.1 hypothetical protein AG1IA_09514 [Rhizoctonia solani AG-1 IA] | diamond | 258 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 29143917 | 29143917 | PRJNA1123436_P_NODE_70569_length_297_cov_0.888393_g69355_i0 | PRJNA1123436 | 70569 | 297 | 0.888393 | 2.63852721 | Agaricales | 5338 | Fungi | Fungi | 75.5 | 7.59e-14 | NR | RDB24437.1 | 39966 | g69355 | i0 | 64.7 | 2.06060606060606 | 51 | 17 | 50.5 | 1 | 295 | 146 | 132 | 182 | RDB24437.1 hypothetical protein Hypma_008418 [Hypsizygus marmoreus] | diamond | 612 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 29690851 | 29690851 | PRJNA1123436_P_NODE_111830_length_246_cov_0.890173_g110616_i0 | PRJNA1123436 | 111830 | 246 | 0.890173 | 2.18982558 | Pleurotus cornucopiae | 5321 | Fungi | Fungi | 150 | 2.0799999999999994e-42 | NR | KAG9221812.1 | 5321 | g110616 | i0 | 90.1 | 0.98780487804878 | 81 | 8 | 98.8 | 0 | 2 | 244 | 152 | 232 | KAG9221812.1 hypothetical protein CCMSSC00406_0006755 [Pleurotus cornucopiae] | diamond | 243 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus cornucopiae | |
| 30153906 | 30153906 | PRJNA1123436_P_NODE_96332_length_251_cov_0.865169_g95118_i0 | PRJNA1123436 | 96332 | 251 | 0.865169 | 2.17157419 | Strophariaceae | 40562 | Fungi | Fungi | 52.4 | 1.56e-5 | NR | KJA17413.1 | 945553 | g95118 | i0 | 76.5 | 2.10358565737052 | 34 | 8 | 40.6 | 0 | 40 | 141 | 5 | 38 | KJA17413.1 hypothetical protein HYPSUDRAFT_146578 [Hypholoma sublateritium FD-334 SS-4] | diamond | 528 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Hypholoma | Hypholoma sublateritium | |
| 30544232 | 30544232 | PRJNA1123436_P_NODE_98793_length_250_cov_0.870056_g97579_i0 | PRJNA1123436 | 98793 | 250 | 0.870056 | 2.17514 | Guyanagaster necrorhizus MCA 395 | 856835 | Fungi | Fungi | 59.3 | 3.43e-8 | NR | XP_043037855.1 | 1450536 | g97579 | i0 | 60.4 | 0.636 | 53 | 21 | 63.6 | 0 | 247 | 89 | 188 | 240 | XP_043037855.1 uncharacterized protein BT62DRAFT_237991 [Guyanagaster necrorhizus MCA 3950] | diamond | 159 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Guyanagaster | Guyanagaster necrorhizus | |
| 31334072 | 31334072 | PRJNA1123436_P_NODE_81616_length_275_cov_1.316832_g80402_i0 | PRJNA1123436 | 81616 | 275 | 1.316832 | 3.621288 | Hypholoma sublateritium FD-334 SS-4 | 945553 | Fungi | Fungi | 51.2 | 5.6e-5 | NR | KJA19554.1 | 945553 | g80402 | i0 | 64.3 | 1.37454545454545 | 42 | 14 | 45.8 | 1 | 1 | 126 | 529 | 569 | KJA19554.1 hypothetical protein HYPSUDRAFT_44114 [Hypholoma sublateritium FD-334 SS-4] | diamond | 378 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Hypholoma | Hypholoma sublateritium | |
| 31555845 | 31555845 | PRJNA1123436_P_NODE_114916_length_245_cov_0.895349_g113702_i0 | PRJNA1123436 | 114916 | 245 | 0.895349 | 2.19360505 | Rhizoctonia solani | 456999 | Fungi | Fungi | 47.8 | 2.2e-4 | NR | QWC53669.1 | 456999 | g113702 | i0 | 41.3 | 0.771428571428571 | 63 | 35 | 77.1 | 1 | 189 | 1 | 11 | 71 | QWC53669.1 LAGLIDADG homing endonuclease [Rhizoctonia solani] | diamond | 189 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 31650266 | 31650266 | PRJNA1123436_P_NODE_45997_length_370_cov_1.178451_g44783_i0 | PRJNA1123436 | 45997 | 370 | 1.178451 | 4.3602687 | Tulasnella calospora MUT 4182 | 1051891 | Fungi | Fungi | 47.8 | 0.00253 | NR | KIO25968.1 | 1051891 | g44783 | i0 | 37.1 | 0.786486486486486 | 97 | 57 | 77.8 | 2 | 370 | 83 | 30 | 123 | KIO25968.1 hypothetical protein M407DRAFT_24718 [Tulasnella calospora MUT 4182] | diamond | 291 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella calospora | |
| 32030217 | 32030217 | PRJNA1123436_P_NODE_96998_length_251_cov_0.865169_g95784_i0 | PRJNA1123436 | 96998 | 251 | 0.865169 | 2.17157419 | Pleurotus eryngii | 5323 | Fungi | Fungi | 43.9 | 0.00179 | NR | KAF9490330.1 | 5323 | g95784 | i0 | 75 | 0.334661354581673 | 28 | 7 | 33.5 | 0 | 1 | 84 | 32 | 59 | KAF9490330.1 hypothetical protein BDN71DRAFT_1454446 [Pleurotus eryngii] | diamond | 84 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus eryngii | |
| 32082459 | 32082459 | PRJNA1123436_P_NODE_126218_length_241_cov_0.916667_g125004_i0 | PRJNA1123436 | 126218 | 241 | 0.916667 | 2.20916747 | Pleurotus | 5320 | Fungi | Fungi | 100 | 1.24e-22 | NR | KAF4579736.1 | 28995 | g125004 | i0 | 55.8 | 4.9792531120332 | 86 | 32 | 99.6 | 2 | 2 | 241 | 188 | 273 | KAF4579736.1 hypothetical protein EYR36_001555 [Pleurotus pulmonarius] | diamond | 1200 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus pulmonarius | |
| 32568194 | 32568194 | PRJNA1123436_P_NODE_107419_length_247_cov_0.885057_g106205_i0 | PRJNA1123436 | 107419 | 247 | 0.885057 | 2.18609079 | Exidia glandulosa HHB12 | 5219 | Fungi | Fungi | 158 | 6.529999999999998e-43 | NR | KZV99162.1 | 1314781 | g106205 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 247 | 2 | 79 | 160 | KZV99162.1 V0/A0 complex, 116-kDa subunit of ATPase [Exidia glandulosa HHB12029] | diamond | 246 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Exidiaceae | Exidia | Exidia glandulosa |
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);;