contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA949785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3483836 | 3483836 | PRJNA949785_P_NODE_4403_length_543_cov_1.142553_g4208_i0 | PRJNA949785 | 4403 | 543 | 1.142553 | 6.20406279 | Fungi | 4751 | Fungi | Fungi | 148 | 1.39e-38 | NR | KAF8799902.1 | 171480 | g4208 | i0 | 63.1 | 16.1436464088398 | 111 | 40 | 61.3 | 1 | 338 | 6 | 61 | 170 | KAF8799902.1 putative NADH dehydrogenase 49K chain [Phlegmacium glaucopus] | diamond | 8766 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Cortinariaceae | Phlegmacium | Phlegmacium glaucopus | |
| 11136836 | 11136836 | PRJNA949785_P_NODE_4789_length_516_cov_7.119639_g4593_i0 | PRJNA949785 | 4789 | 516 | 7.119639 | 36.73733724 | Opisthokonta | 33154 | Fungi | Fungi | 187 | 3.11e-51 | NR | GEM07500.1 | 5286 | g4593 | i0 | 77.6 | 28.2151162790698 | 107 | 24 | 62.2 | 0 | 353 | 33 | 468 | 574 | GEM07500.1 transcription factor [Rhodotorula toruloides] | diamond | 14559 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 22610166 | 22610166 | PRJNA949785_P_NODE_16958_length_247_cov_0.885057_g16761_i0 | PRJNA949785 | 16958 | 247 | 0.885057 | 2.18609079 | Malassezia furfur | 55194 | Fungi | Fungi | 175 | 2.46e-50 | NR | KAI3627308.1 | 55194 | g16761 | i0 | 98.8 | 2.98785425101215 | 82 | 1 | 99.6 | 0 | 246 | 1 | 252 | 333 | KAI3627308.1 HRT2 [Malassezia furfur] | diamond | 738 | 175 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 26715181 | 26715181 | PRJNA949785_P_NODE_12561_length_287_cov_1.079439_g12364_i0 | PRJNA949785 | 12561 | 287 | 1.079439 | 3.09798993 | Opisthokonta | 33154 | Fungi | Fungi | 65.5 | 6.52e-10 | NR | TFK47347.1 | 5364 | g12364 | i0 | 44.2 | 8.91637630662021 | 86 | 40 | 86.8 | 3 | 275 | 27 | 655 | 735 | TFK47347.1 antiviral helicase [Heliocybe sulcata] | diamond | 2559 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Heliocybe | Heliocybe sulcata | |
| 26867529 | 26867529 | PRJNA949785_P_NODE_16501_length_248_cov_0.880000_g16304_i0 | PRJNA949785 | 16501 | 248 | 0.88 | 2.1824 | Malassezia obtusa | 76774 | Fungi | Fungi | 157 | 1.18e-46 | NR | WFD02267.1 | 76774 | g16304 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 3 | 248 | 2 | 83 | WFD02267.1 hypothetical protein MOBT1_000949 [Malassezia obtusa] | diamond | 246 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 26867541 | 26867541 | PRJNA949785_P_NODE_8761_length_355_cov_2.085106_g8564_i0 | PRJNA949785 | 8761 | 355 | 2.085106 | 7.4021263 | Ceratobasidium sp. UAMH 1175 | 1768090 | Fungi | Fungi | 46.6 | 0.00157 | NR | KAG9073418.1 | 2601501 | g8564 | i0 | 36.8 | 0.574647887323944 | 68 | 37 | 52.4 | 1 | 245 | 60 | 12 | 79 | KAG9073418.1 hypothetical protein FS749_015244 [Ceratobasidium sp. UAMH 11750] | diamond | 204 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. UAMH 11750 | |
| 27057204 | 27057204 | PRJNA949785_P_NODE_4242_length_556_cov_1.979296_g4048_i0 | PRJNA949785 | 4242 | 556 | 1.979296 | 11.00488576 | Phakopsora pachyrhizi | 170000 | Fungi | Fungi | 184 | 2.18e-56 | NR | KAI8455471.1 | 170000 | g4048 | i0 | 67.8 | 0.77158273381295 | 143 | 45 | 77.2 | 1 | 85 | 513 | 3 | 144 | KAI8455471.1 dUTP diphosphatase [Phakopsora pachyrhizi] | diamond | 429 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 27594367 | 27594367 | PRJNA949785_P_NODE_14924_length_257_cov_1.347826_g14727_i0 | PRJNA949785 | 14924 | 257 | 1.347826 | 3.46391282 | Tephrocybe sp. NHM5 | 2012023 | Fungi | Fungi | 84.7 | 4.08e-19 | NR | KAG6831969.1 | 2724996 | g14727 | i0 | 51.2 | 5.95330739299611 | 86 | 41 | 99.2 | 1 | 255 | 1 | 16 | 101 | KAG6831969.1 Ubiquitin- modifier 1 [Tephrocybe sp. NHM501043] | diamond | 1530 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Tephrocybe | Tephrocybe sp. NHM501043 | |
| 27689357 | 27689357 | PRJNA949785_P_NODE_18544_length_242_cov_0.911243_g18347_i0 | PRJNA949785 | 18544 | 242 | 0.911243 | 2.20520806 | Malassezia furfur | 55194 | Fungi | Fungi | 59.3 | 5.17e-8 | NR | KAI3623062.1 | 55194 | g18347 | i0 | 100 | 0.322314049586777 | 26 | 0 | 32.2 | 0 | 79 | 2 | 1 | 26 | KAI3623062.1 hypothetical protein CBS14141_004395 [Malassezia furfur] | diamond | 78 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28573000 | 28573000 | PRJNA949785_P_NODE_9427_length_340_cov_0.865169_g9230_i0 | PRJNA949785 | 9427 | 340 | 0.865169 | 2.9415746 | Rhodotorula sphaerocarpa | 86839 | Fungi | Fungi | 43.9 | 0.0437 | NR | GAA6015296.1 | 86839 | g9230 | i0 | 35.4 | 0.873529411764706 | 99 | 38 | 67.1 | 2 | 338 | 111 | 100 | 195 | GAA6015296.1 hypothetical protein JCM8202_002415 [Rhodotorula sphaerocarpa] | diamond | 297 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sphaerocarpa | |
| 28579729 | 28579729 | PRJNA949785_P_NODE_5787_length_462_cov_3.843188_g5590_i0 | PRJNA949785 | 5787 | 462 | 3.843188 | 17.75552856 | Eukaryota | 2759 | Fungi | Fungi | 144 | 7.56e-41 | NR | XP_053016441.1 | 208348 | g5590 | i0 | 61.3 | 8.68181818181818 | 106 | 41 | 68.8 | 0 | 449 | 132 | 30 | 135 | XP_053016441.1 uncharacterized protein PtA15_1A224 [Puccinia triticina] | diamond | 4011 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 28952163 | 28952163 | PRJNA949785_P_NODE_13408_length_276_cov_1.182266_g13211_i0 | PRJNA949785 | 13408 | 276 | 1.182266 | 3.26305416 | Cryptococcus depauperatus CBS 7841 | 1295531 | Fungi | Fungi | 63.2 | 3.47e-9 | NR | XP_066070131.1 | 1295531 | g13211 | i0 | 37.3 | 2.51086956521739 | 83 | 41 | 78.3 | 2 | 217 | 2 | 164 | 246 | XP_066070131.1 uncharacterized protein L203_104654 [Cryptococcus depauperatus CBS 7841] | diamond | 693 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus depauperatus | |
| 29677778 | 29677778 | PRJNA949785_P_NODE_18570_length_242_cov_0.911243_g18373_i0 | PRJNA949785 | 18570 | 242 | 0.911243 | 2.20520806 | Malassezia cuniculi | 948313 | Fungi | Fungi | 96.7 | 8.51e-22 | NR | WFD35524.1 | 948313 | g18373 | i0 | 59 | 1.02892561983471 | 83 | 31 | 99.2 | 1 | 241 | 2 | 122 | 204 | WFD35524.1 proteasome regulatory particle base subunit rpn10 [Malassezia cuniculi] | diamond | 249 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 29810888 | 29810888 | PRJNA949785_P_NODE_16191_length_249_cov_0.875000_g15994_i0 | PRJNA949785 | 16191 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | Fungi | Fungi | 59.7 | 6.49e-9 | NR | KAI5453913.1 | 100951 | g15994 | i0 | 42.1 | 2.80722891566265 | 76 | 40 | 88 | 3 | 4 | 222 | 27 | 101 | KAI5453913.1 hypothetical protein NCC49_004908 [Naganishia albida] | diamond | 699 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 29968902 | 29968902 | PRJNA949785_P_NODE_1291_length_1046_cov_4.725591_g1167_i0 | PRJNA949785 | 1291 | 1046 | 4.725591 | 49.42968186 | Opisthokonta | 33154 | Fungi | Fungi | 232 | 7.42e-70 | NR | TRM58836.1 | 97359 | g1167 | i0 | 38.1 | 15.8001912045889 | 339 | 197 | 96.1 | 6 | 1005 | 1 | 18 | 347 | TRM58836.1 farnesyl-diphosphate synthase [Schizophyllum amplum] | diamond | 16527 | 233 | 0.995708154506438 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum amplum | |
| 30120173 | 30120173 | PRJNA949785_P_NODE_1952_length_847_cov_1.624031_g1799_i0 | PRJNA949785 | 1952 | 847 | 1.624031 | 13.75554257 | Tulasnella sp. JGI-2 | 1905295 | Fungi | Fungi | 49.7 | 0.0121 | NR | KAG8979723.1 | 2600232 | g1799 | i0 | 27.9 | 0.456906729634002 | 129 | 75 | 39.3 | 3 | 847 | 515 | 725 | 853 | KAG8979723.1 hypothetical protein FRB93_009887 [Tulasnella sp. JGI-2019a] | diamond | 387 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella sp. JGI-2019a | ||
| 30468163 | 30468163 | PRJNA949785_P_NODE_4513_length_535_cov_1.413420_g4317_i0 | PRJNA949785 | 4513 | 535 | 1.41342 | 7.561797 | Peniophora sp. CONT | 1314672 | Fungi | Fungi | 53.9 | 8.74e-5 | NR | KZV73194.1 | 1314672 | g4317 | i0 | 31.7 | 0.914018691588785 | 101 | 57 | 52.1 | 3 | 13 | 291 | 574 | 670 | KZV73194.1 ATP-dependent DNA helicase [Peniophora sp. CONT] | diamond | 489 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CONT | |
| 31043513 | 31043513 | PRJNA949785_P_NODE_11235_length_306_cov_1.914163_g11038_i0 | PRJNA949785 | 11235 | 306 | 1.914163 | 5.85733878 | Fungi | 4751 | Fungi | Fungi | 122 | 1.03e-29 | NR | KAJ3567282.1 | 56174 | g11038 | i0 | 60.6 | 27.156862745098 | 99 | 39 | 97.1 | 0 | 304 | 8 | 244 | 342 | KAJ3567282.1 hypothetical protein NP233_g6464 [Leucocoprinus birnbaumii] | diamond | 8310 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucocoprinus | Leucocoprinus birnbaumii | |
| 31162694 | 31162694 | PRJNA949785_P_NODE_7635_length_389_cov_0.911392_g7438_i0 | PRJNA949785 | 7635 | 389 | 0.911392 | 3.54531488 | Lentinula raphanica | 153919 | Fungi | Fungi | 62.8 | 1.29e-8 | NR | KAJ3726058.1 | 153919 | g7438 | i0 | 34 | 5.96915167095116 | 144 | 63 | 86.4 | 4 | 49 | 384 | 12 | 155 | KAJ3726058.1 PPP4R2-domain-containing protein [Lentinula raphanica] | diamond | 2322 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula raphanica | |
| 31422560 | 31422560 | PRJNA949785_P_NODE_19276_length_236_cov_2.171779_g19079_i0 | PRJNA949785 | 19276 | 236 | 2.171779 | 5.12539844 | Fungi | 4751 | Fungi | Fungi | 51.2 | 2.05e-5 | NR | KAF9069107.1 | 206335 | g19079 | i0 | 42.1 | 3.43220338983051 | 57 | 33 | 72.5 | 0 | 64 | 234 | 97 | 153 | KAF9069107.1 acyl-CoA N-acyltransferase [Rhodocollybia butyracea] | diamond | 810 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Rhodocollybia | Rhodocollybia butyracea | |
| 31960273 | 31960273 | PRJNA949785_P_NODE_7177_length_403_cov_1.872727_g6980_i0 | PRJNA949785 | 7177 | 403 | 1.872727 | 7.54708981 | Basidiomycota | 5204 | Fungi | Fungi | 65.9 | 1.91e-9 | NR | UZJ54920.1 | 63378 | g6980 | i0 | 29.3 | 3.43920595533499 | 123 | 84 | 90.1 | 3 | 370 | 8 | 469 | 590 | UZJ54920.1 hypothetical protein CBS101457_004240 [Exobasidium rhododendri] | diamond | 1386 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium rhododendri | |
| 32530101 | 32530101 | PRJNA949785_P_NODE_10259_length_323_cov_2.684000_g10062_i0 | PRJNA949785 | 10259 | 323 | 2.684 | 8.66932 | Agaricomycetes | 155619 | Fungi | Fungi | 47 | 0.00318 | NR | KAF8532039.1 | 112417 | g10062 | i0 | 38 | 3.52012383900929 | 71 | 42 | 64.1 | 1 | 92 | 298 | 460 | 530 | KAF8532039.1 ARM repeat-containing protein [Gautieria morchelliformis] | diamond | 1137 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Gautieria | Gautieria morchelliformis | |
| 32712327 | 32712327 | PRJNA949785_P_NODE_10740_length_315_cov_1.136364_g10543_i0 | PRJNA949785 | 10740 | 315 | 1.136364 | 3.5795466 | Sanghuangporus baumii | 108892 | Fungi | Fungi | 51.2 | 9.1e-5 | NR | OCB84092.1 | 108892 | g10543 | i0 | 30.6 | 1.54285714285714 | 85 | 58 | 81 | 1 | 281 | 27 | 396 | 479 | OCB84092.1 nucleolar complex-associated protein 3 [Sanghuangporus baumii] | diamond | 486 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Sanghuangporus | Sanghuangporus baumii |
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);;