contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5943011 | 5943011 | PRJNA853194_S_NODE_1545_length_1275_cov_5.613145_g1151_i0 | PRJNA853194 | 1545 | 1275 | 5.613145 | 71.56759875 | Opisthokonta | 33154 | Fungi | Fungi | 86.7 | 1.76e-14 | NR | ETS64261.1 | 84754 | g1151 | i0 | 44.6 | 2.07294117647059 | 92 | 49 | 21.6 | 1 | 85 | 360 | 8 | 97 | ETS64261.1 hypothetical protein PaG_01508 [Moesziomyces aphidis] | diamond | 2643 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces aphidis | |
| 12319318 | 12319318 | PRJNA853194_S_NODE_2770_length_1025_cov_180.915966_g2160_i0 | PRJNA853194 | 2770 | 1025 | 180.915966 | 1854.3886515 | Violaceomyces palustris | 1673888 | Fungi | Fungi | 148 | 4.029999999999999e-40 | NR | PWN52911.1 | 1673888 | g2160 | i0 | 58 | 1.44 | 119 | 50 | 34.8 | 0 | 952 | 596 | 13 | 131 | PWN52911.1 hypothetical protein IE53DRAFT_384625 [Violaceomyces palustris] | diamond | 1476 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Violaceomycetales | Violaceomycetaceae | Violaceomyces | Violaceomyces palustris | |
| 13594082 | 13594082 | PRJNA853194_S_NODE_39491_length_340_cov_8.573034_g38400_i0 | PRJNA853194 | 39491 | 340 | 8.573034 | 29.1483156 | Kwoniella | 490731 | Fungi | Fungi | 74.3 | 2.21e-14 | NR | XP_062789400.1 | 564305 | g38400 | i0 | 46.4 | 3.59117647058824 | 69 | 36 | 60 | 1 | 253 | 50 | 17 | 85 | XP_062789400.1 cytochrome c oxidase assembly protein COX19 [Kwoniella shivajii] | diamond | 1221 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 27915909 | 27915909 | PRJNA853194_S_NODE_27385_length_395_cov_2.208075_g26294_i0 | PRJNA853194 | 27385 | 395 | 2.208075 | 8.72189625 | Agaricomycetes | 155619 | Fungi | Fungi | 189 | 1.5599999999999998e-54 | NR | KAF8492920.1 | 112417 | g26294 | i0 | 73.1 | 42.4784810126582 | 119 | 32 | 90.4 | 0 | 394 | 38 | 197 | 315 | KAF8492920.1 lysyl-tRNA synthetase [Gautieria morchelliformis] | diamond | 16779 | 190 | 0.994736842105263 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Gautieria | Gautieria morchelliformis | |
| 28539559 | 28539559 | PRJNA853194_S_NODE_12827_length_536_cov_183.012959_g11753_i0 | PRJNA853194 | 12827 | 536 | 183.012959 | 980.94946024 | Serendipita vermifera | 109899 | Fungi | Fungi | 71.2 | 6.21e-12 | NR | PVG00374.1 | 109899 | g11753 | i0 | 32.8 | 1.51119402985075 | 137 | 90 | 76.7 | 2 | 519 | 109 | 18 | 152 | PVG00374.1 prenylated rab acceptor PRA1 [Serendipita vermifera] | diamond | 810 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 29454577 | 29454577 | PRJNA853194_S_NODE_11130_length_569_cov_176.012097_g10075_i0 | PRJNA853194 | 11130 | 569 | 176.012097 | 1001.50883193 | Phakopsora pachyrhizi | 170000 | Fungi | Fungi | 184 | 2.53e-56 | NR | KAI8455471.1 | 170000 | g10075 | i0 | 67.8 | 0.753954305799649 | 143 | 45 | 75.4 | 1 | 498 | 70 | 3 | 144 | KAI8455471.1 dUTP diphosphatase [Phakopsora pachyrhizi] | diamond | 429 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 29810392 | 29810392 | PRJNA853194_S_NODE_22171_length_429_cov_19.289326_g21080_i0 | PRJNA853194 | 22171 | 429 | 19.289326 | 82.75120854 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 9.43e-7 | NR | XP_036633870.1 | 5322 | g21080 | i0 | 33.7 | 8.17482517482518 | 92 | 60 | 63.6 | 1 | 428 | 156 | 252 | 343 | XP_036633870.1 WD repeat-containing protein 38-like [Pleurotus ostreatus] | diamond | 3507 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 30118094 | 30118094 | PRJNA853194_S_NODE_8372_length_644_cov_10.338004_g7372_i0 | PRJNA853194 | 8372 | 644 | 10.338004 | 66.57674576 | Volvariella volvacea WC 439 | 1457512 | Fungi | Fungi | 48.9 | 0.00889 | NR | KAF8665791.1 | 1457512 | g7372 | i0 | 29.6 | 1.00155279503106 | 115 | 61 | 47 | 2 | 640 | 338 | 502 | 610 | KAF8665791.1 hypothetical protein AX16_000236 [Volvariella volvacea WC 439] | diamond | 645 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Volvariella | Volvariella volvacea | |
| 30371402 | 30371402 | PRJNA853194_S_NODE_36192_length_353_cov_1.796429_g35101_i0 | PRJNA853194 | 36192 | 353 | 1.796429 | 6.34139437 | Amanita brunnescens Koide BX | 87326 | Fungi | Fungi | 44.3 | 0.0382 | NR | KAF8744910.1 | 1457509 | g35101 | i0 | 37 | 0.620396600566572 | 73 | 45 | 61.2 | 1 | 238 | 23 | 612 | 684 | KAF8744910.1 hypothetical protein AX14_012737 [Amanita brunnescens Koide BX004] | diamond | 219 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita brunnescens | |
| 30371404 | 30371404 | PRJNA853194_S_NODE_4052_length_873_cov_15.363750_g2998_i1 | PRJNA853194 | 4052 | 873 | 15.36375 | 134.1255375 | Candolleomyces aberdarensis | 2316362 | Fungi | Fungi | 77.8 | 3.7e-13 | NR | RXW18227.1 | 2316362 | g2998 | i1 | 44.7 | 0.515463917525773 | 76 | 42 | 26.1 | 0 | 106 | 333 | 8 | 83 | RXW18227.1 hypothetical protein EST38_g7609 [Candolleomyces aberdarensis] | diamond | 450 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Candolleomyces | Candolleomyces aberdarensis | |
| 30592036 | 30592036 | PRJNA853194_S_NODE_13453_length_525_cov_31.931416_g12376_i0 | PRJNA853194 | 13453 | 525 | 31.931416 | 167.639934 | Lactarius hengduanensis | 1932122 | Fungi | Fungi | 47.4 | 0.00295 | NR | KAH9011688.1 | 1932122 | g12376 | i0 | 52.5 | 0.954285714285714 | 40 | 19 | 22.9 | 0 | 499 | 380 | 1 | 40 | KAH9011688.1 WD40-repeat-containing domain protein, partial [Lactarius hengduanensis] | diamond | 501 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius hengduanensis | |
| 30655228 | 30655228 | PRJNA853194_S_NODE_65833_length_270_cov_3.477157_g64742_i0 | PRJNA853194 | 65833 | 270 | 3.477157 | 9.3883239 | Apiotrichum porosum | 105984 | Fungi | Fungi | 48.5 | 5.01e-4 | NR | XP_028477566.1 | 105984 | g64742 | i0 | 31.3 | 1.93333333333333 | 112 | 47 | 91.1 | 3 | 1 | 246 | 703 | 814 | XP_028477566.1 putative ATP-dependent RNA helicase DHR1 [Apiotrichum porosum] | diamond | 522 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 30781681 | 30781681 | PRJNA853194_S_NODE_84974_length_241_cov_2.553571_g83883_i0 | PRJNA853194 | 84974 | 241 | 2.553571 | 6.15410611 | Naganishia adeliensis | 92952 | Fungi | Fungi | 42 | 0.0411 | NR | KAJ9114933.1 | 92952 | g83883 | i0 | 47.7 | 0.547717842323652 | 44 | 22 | 53.5 | 1 | 229 | 101 | 21 | 64 | KAJ9114933.1 hypothetical protein QFC20_001307 [Naganishia adeliensis] | diamond | 132 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia adeliensis | |
| 30971418 | 30971418 | PRJNA853194_S_NODE_38254_length_345_cov_2.294118_g37163_i0 | PRJNA853194 | 38254 | 345 | 2.294118 | 7.9147071 | Jaminaea rosea | 1569628 | Fungi | Fungi | 58.5 | 3.57e-7 | NR | XP_025363723.1 | 1569628 | g37163 | i0 | 66.7 | 0.28695652173913 | 33 | 11 | 28.7 | 0 | 287 | 189 | 128 | 160 | XP_025363723.1 hypothetical protein BDZ90DRAFT_278501 [Jaminaea rosea] | diamond | 99 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Jaminaea | Jaminaea rosea | ||
| 30979666 | 30979666 | PRJNA853194_S_NODE_9814_length_600_cov_6.783681_g8779_i0 | PRJNA853194 | 9814 | 600 | 6.783681 | 40.702086 | Opisthokonta | 33154 | Fungi | Fungi | 56.2 | 2.18e-5 | NR | KAG2369868.1 | 5383 | g8779 | i0 | 28.1 | 2.56 | 153 | 89 | 69 | 5 | 17 | 430 | 623 | 769 | KAG2369868.1 WD40-repeat-containing domain protein [Suillus spraguei] | diamond | 1536 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus spraguei | |
| 31043048 | 31043048 | PRJNA853194_S_NODE_21595_length_434_cov_2.977839_g20504_i0 | PRJNA853194 | 21595 | 434 | 2.977839 | 12.92382126 | Basidiomycota | 5204 | Fungi | Fungi | 128 | 4.239999999999999e-31 | NR | KAI0269827.1 | 205761 | g20504 | i0 | 44.5 | 5.78571428571429 | 146 | 79 | 99.5 | 1 | 1 | 432 | 858 | 1003 | KAI0269827.1 P-loop containing nucleoside triphosphate hydrolase protein [Gloeopeniophorella convolvens] | diamond | 2511 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Gloeopeniophorella | Gloeopeniophorella convolvens | ||
| 31540443 | 31540443 | PRJNA853194_S_NODE_12616_length_540_cov_5.635974_g11544_i0 | PRJNA853194 | 12616 | 540 | 5.635974 | 30.4342596 | Gautieria morchelliformis | 112417 | Fungi | Fungi | 56.6 | 1.11e-5 | NR | KAF8502442.1 | 112417 | g11544 | i0 | 27.5 | 0.927777777777778 | 167 | 103 | 90 | 6 | 34 | 519 | 929 | 1082 | KAF8502442.1 ras guanine nucleotide exchange factor domain-containing protein [Gautieria morchelliformis] | diamond | 501 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Gautieria | Gautieria morchelliformis | |
| 32046554 | 32046554 | PRJNA853194_S_NODE_3718_length_906_cov_11.007203_g2998_i0 | PRJNA853194 | 3718 | 906 | 11.007203 | 99.72525918 | Schizophyllum commune | 5334 | Fungi | Fungi | 173 | 1.15e-47 | NR | KAL1690381.1 | 5334 | g2998 | i0 | 43.6 | 0.645695364238411 | 195 | 100 | 64.6 | 2 | 94 | 678 | 172 | 356 | KAL1690381.1 WD40-repeat-containing domain protein [Schizophyllum commune] | diamond | 585 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 32086351 | 32086351 | PRJNA853194_S_NODE_52398_length_301_cov_1.109649_g51307_i0 | PRJNA853194 | 52398 | 301 | 1.109649 | 3.34004349 | Opisthokonta | 33154 | Fungi | Fungi | 44.3 | 0.0212 | NR | KAF7374711.1 | 230812 | g51307 | i0 | 30.1 | 1.88372093023256 | 73 | 46 | 67.8 | 1 | 301 | 98 | 26 | 98 | KAF7374711.1 hypothetical protein MSAN_00356300 [Mycena sanguinolenta] | diamond | 567 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena sanguinolenta | |
| 32899020 | 32899020 | PRJNA853194_S_NODE_82680_length_244_cov_1.309942_g81589_i0 | PRJNA853194 | 82680 | 244 | 1.309942 | 3.19625848 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 85.9 | 2.42e-17 | NR | KAG0653788.1 | 5537 | g81589 | i0 | 97.5 | 0.491803278688525 | 40 | 1 | 49.2 | 0 | 244 | 125 | 520 | 559 | KAG0653788.1 hexose transporter hxt1 [Rhodotorula mucilaginosa] | diamond | 120 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa |
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);;