contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1129273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9211260 | 9211260 | PRJNA1129273_P_NODE_4548_length_336_cov_5.174905_g4268_i0 | PRJNA1129273 | 4548 | 336 | 5.174905 | 17.3876808 | Tulasnella | 5240 | Fungi | Fungi | 164 | 2.05e-49 | NR | KAG8958778.1 | 2600224 | g4268 | i0 | 86.5 | 4.00892857142857 | 89 | 12 | 79.5 | 0 | 290 | 24 | 60 | 148 | KAG8958778.1 60S ribosomal protein L43 [Tulasnella sp. 408] | diamond | 1347 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 408 | |
| 18135009 | 18135009 | PRJNA1129273_P_NODE_2375_length_505_cov_2.787037_g2099_i0 | PRJNA1129273 | 2375 | 505 | 2.787037 | 14.07453685 | Rhodotorula | 5533 | Fungi | Fungi | 193 | 3.56e-60 | NR | CDR36346.1 | 5286 | g2099 | i0 | 70.5 | 7.37227722772277 | 139 | 38 | 81.4 | 2 | 438 | 28 | 11 | 148 | CDR36346.1 RHTO0S02e00738g1_1 [Rhodotorula toruloides] | diamond | 3723 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 26658577 | 26658577 | PRJNA1129273_P_NODE_7341_length_267_cov_2.350515_g7061_i0 | PRJNA1129273 | 7341 | 267 | 2.350515 | 6.27587505 | Malassezia restricta | 76775 | Fungi | Fungi | 147 | 4.89e-40 | NR | XP_027486675.1 | 76775 | g7061 | i0 | 77.5 | 1 | 89 | 19 | 98.9 | 1 | 3 | 266 | 4 | 92 | XP_027486675.1 DUF500 domain protein [Malassezia restricta] | diamond | 267 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27196564 | 27196564 | PRJNA1129273_P_NODE_6642_length_278_cov_1.517073_g6362_i0 | PRJNA1129273 | 6642 | 278 | 1.517073 | 4.21746294 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 57.4 | 3.99e-7 | NR | CAD6586109.1 | 2778381 | g6362 | i0 | 36.1 | 1.7589928057554 | 83 | 48 | 89.6 | 1 | 263 | 15 | 237 | 314 | CAD6586109.1 MAG: Protein phosphatase PP2A regulatory subunit B [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 489 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 27912042 | 27912042 | PRJNA1129273_P_NODE_7305_length_268_cov_1.210256_g7025_i0 | PRJNA1129273 | 7305 | 268 | 1.210256 | 3.24348608 | Puccinia | 5296 | Fungi | Fungi | 91.7 | 3.12e-20 | NR | KAA1099733.1 | 56615 | g7025 | i0 | 71.6 | 1.65671641791045 | 74 | 20 | 82.8 | 1 | 264 | 43 | 182 | 254 | KAA1099733.1 hypothetical protein PGT21_018732 [Puccinia graminis f. sp. tritici] | diamond | 444 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 27923131 | 27923131 | PRJNA1129273_P_NODE_3225_length_412_cov_6.020649_g2946_i0 | PRJNA1129273 | 3225 | 412 | 6.020649 | 24.80507388 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 116 | 2.41e-30 | NR | KAG8920536.1 | 2600225 | g2946 | i0 | 50 | 0.946601941747573 | 130 | 61 | 91.7 | 1 | 12 | 389 | 6 | 135 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 390 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 | |
| 28144397 | 28144397 | PRJNA1129273_P_NODE_7745_length_262_cov_1.529101_g7465_i0 | PRJNA1129273 | 7745 | 262 | 1.529101 | 4.00624462 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 151 | 2.6499999999999993e-40 | NR | WFD16437.1 | 1514897 | g7465 | i0 | 98.8 | 0.984732824427481 | 86 | 1 | 98.5 | 0 | 4 | 261 | 2631 | 2716 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 258 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 28322654 | 28322654 | PRJNA1129273_P_NODE_4486_length_339_cov_1.124060_g4206_i0 | PRJNA1129273 | 4486 | 339 | 1.12406 | 3.8105634 | Tremellales | 5234 | Fungi | Fungi | 84.7 | 3.48e-17 | NR | XP_066080535.1 | 1423913 | g4206 | i0 | 40.4 | 12.8053097345133 | 104 | 62 | 92 | 0 | 26 | 337 | 69 | 172 | XP_066080535.1 uncharacterized protein V865_000608 [Kwoniella europaea PYCC6329] | diamond | 4341 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella europaea | |
| 28354250 | 28354250 | PRJNA1129273_P_NODE_6106_length_287_cov_1.294393_g5826_i0 | PRJNA1129273 | 6106 | 287 | 1.294393 | 3.71490791 | Lyophyllaceae | 930979 | Fungi | Fungi | 46.6 | 0.00256 | NR | KAG6842620.1 | 530045 | g5826 | i0 | 35.7 | 4.03484320557491 | 98 | 55 | 98.3 | 4 | 4 | 285 | 192 | 285 | KAG6842620.1 hypothetical protein C0991_000146 [Blastosporella zonata] | diamond | 1158 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Blastosporella | Blastosporella zonata | |
| 28396757 | 28396757 | PRJNA1129273_P_NODE_5126_length_313_cov_1.937500_g4846_i0 | PRJNA1129273 | 5126 | 313 | 1.9375 | 6.064375 | Coprinellus micaceus | 71717 | Fungi | Fungi | 154 | 1.6799999999999994e-42 | NR | TEB35933.1 | 71717 | g4846 | i0 | 75.3 | 8.76996805111821 | 89 | 22 | 85.3 | 0 | 298 | 32 | 65 | 153 | TEB35933.1 tryptophanyl-tRNA synthetase [Coprinellus micaceus] | diamond | 2745 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus micaceus | |
| 28954448 | 28954448 | PRJNA1129273_P_NODE_3988_length_361_cov_1.062500_g3708_i0 | PRJNA1129273 | 3988 | 361 | 1.0625 | 3.835625 | Puccinia | 5296 | Fungi | Fungi | 218 | 5.04e-65 | NR | WAR57032.1 | 208348 | g3708 | i0 | 91.5 | 1.94459833795014 | 117 | 10 | 97.2 | 0 | 352 | 2 | 242 | 358 | WAR57032.1 hypothetical protein PtB15_8B76 [Puccinia triticina] | diamond | 702 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 28965262 | 28965262 | PRJNA1129273_P_NODE_10788_length_238_cov_2.751515_g10508_i0 | PRJNA1129273 | 10788 | 238 | 2.751515 | 6.5486057 | Apiotrichum porosum | 105984 | Fungi | Fungi | 43.5 | 0.0174 | NR | XP_028473648.1 | 105984 | g10508 | i0 | 65.5 | 0.365546218487395 | 29 | 10 | 36.6 | 0 | 92 | 6 | 2 | 30 | XP_028473648.1 uncharacterized protein EHS24_002226 [Apiotrichum porosum] | diamond | 87 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 29596248 | 29596248 | PRJNA1129273_P_NODE_10110_length_244_cov_0.906433_g9830_i0 | PRJNA1129273 | 10110 | 244 | 0.906433 | 2.21169652 | Fomes fomentarius | 40442 | Fungi | Fungi | 138 | 3.75e-37 | NR | KAI0787954.1 | 40442 | g9830 | i0 | 87.1 | 1.04508196721311 | 85 | 6 | 98.4 | 1 | 242 | 3 | 97 | 181 | KAI0787954.1 hypothetical protein C8Q74DRAFT_1366749 [Fomes fomentarius] | diamond | 255 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Fomes | Fomes fomentarius | |
| 29627709 | 29627709 | PRJNA1129273_P_NODE_9070_length_249_cov_0.880682_g8790_i0 | PRJNA1129273 | 9070 | 249 | 0.880682 | 2.19289818 | Fomes fomentarius | 40442 | Fungi | Fungi | 158 | 7.92e-43 | NR | KAI0779655.1 | 40442 | g8790 | i0 | 97.6 | 0.987951807228916 | 82 | 2 | 98.8 | 0 | 248 | 3 | 726 | 807 | KAI0779655.1 hypothetical protein C8Q74DRAFT_706892 [Fomes fomentarius] | diamond | 246 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Fomes | Fomes fomentarius | |
| 29912553 | 29912553 | PRJNA1129273_P_NODE_11031_length_230_cov_2.917197_g10751_i0 | PRJNA1129273 | 11031 | 230 | 2.917197 | 6.7095531 | Psilocybe cyanescens | 93625 | Fungi | Fungi | 45.4 | 0.00356 | NR | PPQ96021.1 | 93625 | g10751 | i0 | 41.7 | 1.55217391304348 | 60 | 31 | 78.3 | 1 | 229 | 50 | 801 | 856 | PPQ96021.1 hypothetical protein CVT25_013883 [Psilocybe cyanescens] | diamond | 357 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cyanescens | |
| 30228225 | 30228225 | PRJNA1129273_P_NODE_2832_length_449_cov_1.223404_g2554_i0 | PRJNA1129273 | 2832 | 449 | 1.223404 | 5.49308396 | Cronartium quercuum f. sp. fusiforme G11 | 708437 | Fungi | Fungi | 103 | 2.7599999999999995e-23 | NR | KAG0145771.1 | 708437 | g2554 | i0 | 39 | 1.06236080178174 | 159 | 78 | 96.2 | 5 | 18 | 449 | 17 | 171 | KAG0145771.1 hypothetical protein CROQUDRAFT_658287 [Cronartium quercuum f. sp. fusiforme G11] | diamond | 477 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Coleosporiaceae | Cronartium | Cronartium quercuum | |
| 30355203 | 30355203 | PRJNA1129273_P_NODE_9092_length_249_cov_0.880682_g8812_i0 | PRJNA1129273 | 9092 | 249 | 0.880682 | 2.19289818 | Clavulina sp. PMI_39 | 1745192 | Fungi | Fungi | 56.2 | 7.04e-7 | NR | KAF8316152.1 | 1486700 | g8812 | i0 | 40 | 0.783132530120482 | 65 | 37 | 78.3 | 1 | 207 | 13 | 49 | 111 | KAF8316152.1 hypothetical protein DL93DRAFT_2111686 [Clavulina sp. PMI_390] | diamond | 195 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Clavulina | Clavulina sp. PMI_390 | |
| 31271072 | 31271072 | PRJNA1129273_P_NODE_7235_length_269_cov_1.168367_g6955_i0 | PRJNA1129273 | 7235 | 269 | 1.168367 | 3.14290723 | Sporobolomyces salmoneus | 183962 | Fungi | Fungi | 43.1 | 0.00762 | NR | GAA5892705.1 | 183962 | g6955 | i0 | 44.4 | 0.602230483271376 | 54 | 28 | 60.2 | 1 | 106 | 267 | 42 | 93 | GAA5892705.1 hypothetical protein JCM6883_007446 [Sporobolomyces salmoneus] | diamond | 162 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmoneus | |
| 31492604 | 31492604 | PRJNA1129273_P_NODE_5256_length_309_cov_4.233051_g4976_i0 | PRJNA1129273 | 5256 | 309 | 4.233051 | 13.08012759 | Tremellales sp. Tagirdzhanova- | 1920939 | Fungi | Fungi | 89.4 | 3.45e-18 | NR | CAD6578322.1 | 2778382 | g4976 | i0 | 85.7 | 1.42718446601942 | 49 | 7 | 47.6 | 0 | 148 | 2 | 398 | 446 | CAD6578322.1 MAG: Adaptor for signal transduction [Tremellales sp. Tagirdzhanova-0007] | diamond | 441 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Tagirdzhanova-0007 | |||
| 31745353 | 31745353 | PRJNA1129273_P_NODE_8377_length_253_cov_2.466667_g8097_i0 | PRJNA1129273 | 8377 | 253 | 2.466667 | 6.24066751 | Apiotrichum porosum | 105984 | Fungi | Fungi | 78.6 | 3.98e-15 | NR | XP_028473215.1 | 105984 | g8097 | i0 | 68.4 | 0.675889328063241 | 57 | 18 | 67.6 | 0 | 81 | 251 | 4 | 60 | XP_028473215.1 uncharacterized protein EHS24_002523 [Apiotrichum porosum] | diamond | 171 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 32050894 | 32050894 | PRJNA1129273_P_NODE_6698_length_277_cov_1.514706_g6418_i0 | PRJNA1129273 | 6698 | 277 | 1.514706 | 4.19573562 | Puccinia | 5296 | Fungi | Fungi | 151 | 2.94e-41 | NR | KAA1117418.1 | 56615 | g6418 | i0 | 92.4 | 2.56678700361011 | 79 | 6 | 85.6 | 0 | 239 | 3 | 93 | 171 | KAA1117418.1 Serine/threonine-protein kinase 17A [Puccinia graminis f. sp. tritici] | diamond | 711 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 32840461 | 32840461 | PRJNA1129273_P_NODE_540_length_1206_cov_6.001765_g377_i0 | PRJNA1129273 | 540 | 1206 | 6.001765 | 72.3812859 | Opisthokonta | 33154 | Fungi | Fungi | 353 | 3.9899999999999984e-116 | NR | KAI8461260.1 | 170000 | g377 | i0 | 54 | 14.634328358209 | 335 | 150 | 83.1 | 3 | 5 | 1006 | 1 | 332 | KAI8461260.1 ribosomal protein L4 domain-containing protein [Phakopsora pachyrhizi] | diamond | 17649 | 355 | 0.994366197183099 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi |
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);;