contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1093380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25245572 | 25245572 | PRJNA1093380_P_NODE_15100_length_245_cov_0.895349_g14994_i0 | PRJNA1093380 | 15100 | 245 | 0.895349 | 2.19360505 | Pleurotaceae | 104366 | Fungi | Fungi | 147 | 2.8199999999999998e-40 | NR | KAL0951110.1 | 104357 | g14994 | i0 | 86.4 | 13.8857142857143 | 81 | 11 | 99.2 | 0 | 1 | 243 | 179 | 259 | KAL0951110.1 hypothetical protein HGRIS_007847 [Hohenbuehelia grisea] | diamond | 3402 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Hohenbuehelia | Hohenbuehelia grisea | |
| 26846358 | 26846358 | PRJNA1093380_P_NODE_8801_length_269_cov_1.357143_g8695_i0 | PRJNA1093380 | 8801 | 269 | 1.357143 | 3.65071467 | Lentinula edodes | 5353 | Fungi | Fungi | 115 | 7.81e-31 | NR | XP_046081528.1 | 5353 | g8695 | i0 | 69.5 | 0.91449814126394 | 82 | 24 | 90.3 | 1 | 243 | 1 | 33 | 114 | XP_046081528.1 uncharacterized protein C8R40DRAFT_1026785, partial [Lentinula edodes] | diamond | 246 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 27027282 | 27027282 | PRJNA1093380_P_NODE_13002_length_249_cov_0.875000_g12896_i0 | PRJNA1093380 | 13002 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 55.1 | 1.87e-6 | NR | XP_001729800.1 | 425265 | g12896 | i0 | 35.1 | 4.2289156626506 | 77 | 48 | 90.4 | 1 | 249 | 25 | 62 | 138 | XP_001729800.1 uncharacterized protein MGL_2786 [Malassezia globosa CBS 7966] | diamond | 1053 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 27288843 | 27288843 | PRJNA1093380_P_NODE_18063_length_206_cov_4.135338_g17957_i0 | PRJNA1093380 | 18063 | 206 | 4.135338 | 8.51879628 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 90.1 | 4.75e-19 | NR | GHJ86410.1 | 104408 | g17957 | i0 | 76.5 | 0.990291262135922 | 68 | 16 | 99 | 0 | 3 | 206 | 596 | 663 | GHJ86410.1 hypothetical protein NliqN6_2812 [Naganishia liquefaciens] | diamond | 204 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 27699751 | 27699751 | PRJNA1093380_P_NODE_10964_length_256_cov_1.683060_g10858_i0 | PRJNA1093380 | 10964 | 256 | 1.68306 | 4.3086336 | Gymnopilus dilepis | 231916 | Fungi | Fungi | 59.7 | 4.89e-8 | NR | PPQ73450.1 | 231916 | g10858 | i0 | 34.9 | 0.97265625 | 83 | 54 | 97.3 | 0 | 249 | 1 | 1955 | 2037 | PPQ73450.1 hypothetical protein CVT26_010200 [Gymnopilus dilepis] | diamond | 249 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Gymnopilus | Gymnopilus dilepis | |
| 28299261 | 28299261 | PRJNA1093380_P_NODE_5446_length_288_cov_2.018605_g5340_i0 | PRJNA1093380 | 5446 | 288 | 2.018605 | 5.8135824 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 70.9 | 7.27e-12 | NR | KWU43455.1 | 1305733 | g5340 | i0 | 92.7 | 0.833333333333333 | 41 | 3 | 42.7 | 0 | 286 | 164 | 291 | 331 | KWU43455.1 hypothetical protein RHOSPDRAFT_35059 [Rhodotorula sp. JG-1b] | diamond | 240 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 28488840 | 28488840 | PRJNA1093380_P_NODE_1467_length_458_cov_1.405195_g1362_i0 | PRJNA1093380 | 1467 | 458 | 1.405195 | 6.4357931 | Flagelloscypha sp. PMI_526 | 1485228 | Fungi | Fungi | 47.8 | 0.0057 | NR | KAH8824838.1 | 1485228 | g1362 | i0 | 28.3 | 0.347161572052402 | 53 | 38 | 34.7 | 0 | 251 | 409 | 126 | 178 | KAH8824838.1 amino acid permease/ SLC12A domain-containing protein [Flagelloscypha sp. PMI_526] | diamond | 159 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Tricholomataceae | Flagelloscypha | Flagelloscypha sp. PMI_526 | |
| 28615149 | 28615149 | PRJNA1093380_P_NODE_16967_length_241_cov_0.916667_g16861_i0 | PRJNA1093380 | 16967 | 241 | 0.916667 | 2.20916747 | Mycena galericulata | 71905 | Fungi | Fungi | 78.2 | 1.13e-14 | NR | KAJ7503612.1 | 71905 | g16861 | i0 | 61.2 | 1.21991701244813 | 49 | 19 | 61 | 0 | 3 | 149 | 450 | 498 | KAJ7503612.1 glycoside hydrolase family 54 protein [Mycena galericulata] | diamond | 294 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galericulata | |
| 28701297 | 28701297 | PRJNA1093380_P_NODE_9027_length_267_cov_2.360825_g8921_i0 | PRJNA1093380 | 9027 | 267 | 2.360825 | 6.30340275 | Agaricomycetes | 155619 | Fungi | Fungi | 76.3 | 6.79e-14 | NR | KAL0953107.1 | 104357 | g8921 | i0 | 46.1 | 5.01123595505618 | 89 | 45 | 100 | 2 | 267 | 1 | 102 | 187 | KAL0953107.1 hypothetical protein HGRIS_004378 [Hohenbuehelia grisea] | diamond | 1338 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Hohenbuehelia | Hohenbuehelia grisea | |
| 28867627 | 28867627 | PRJNA1093380_P_NODE_14088_length_247_cov_0.885057_g13982_i0 | PRJNA1093380 | 14088 | 247 | 0.885057 | 2.18609079 | Lyophyllum shimeji | 47721 | Fungi | Fungi | 95.9 | 7.930000000000001e-21 | NR | GLB33818.1 | 47721 | g13982 | i0 | 63.1 | 1.02024291497976 | 84 | 29 | 99.6 | 1 | 246 | 1 | 324 | 407 | GLB33818.1 putative RFX DNA-binding domain containing protein [Lyophyllum shimeji] | diamond | 252 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Lyophyllum | Lyophyllum shimeji | |
| 29017238 | 29017238 | PRJNA1093380_P_NODE_8708_length_269_cov_1.744898_g8602_i0 | PRJNA1093380 | 8708 | 269 | 1.744898 | 4.69377562 | Agaricomycetes | 155619 | Fungi | Fungi | 133 | 2.33e-34 | NR | XP_041312180.1 | 48563 | g8602 | i0 | 78.8 | 18.9033457249071 | 85 | 16 | 92.6 | 1 | 261 | 13 | 201 | 285 | XP_041312180.1 uncharacterized protein EDB93DRAFT_1238188 [Suillus bovinus] | diamond | 5085 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus bovinus | |
| 29206554 | 29206554 | PRJNA1093380_P_NODE_6489_length_282_cov_1.784689_g6383_i0 | PRJNA1093380 | 6489 | 282 | 1.784689 | 5.03282298 | Agaricales | 5338 | Fungi | Fungi | 81.6 | 9.27e-16 | NR | KAF9464059.1 | 64659 | g6383 | i0 | 52.5 | 8.32978723404255 | 99 | 24 | 97.9 | 3 | 278 | 3 | 283 | 365 | KAF9464059.1 hypothetical protein BDZ94DRAFT_1257446 [Collybia nuda] | diamond | 2349 | 82 | 0.995121951219512 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Clitocybaceae | Collybia | Collybia nuda | |
| 30225522 | 30225522 | PRJNA1093380_P_NODE_10232_length_260_cov_2.294118_g10126_i0 | PRJNA1093380 | 10232 | 260 | 2.294118 | 5.9647068 | Volvariella volvacea WC 439 | 1457512 | Fungi | Fungi | 42.7 | 0.0431 | NR | KAF8659887.1 | 1457512 | g10126 | i0 | 32.2 | 0.680769230769231 | 59 | 39 | 68.1 | 1 | 241 | 65 | 58 | 115 | KAF8659887.1 hypothetical protein AX16_001771 [Volvariella volvacea WC 439] | diamond | 177 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Volvariella | Volvariella volvacea | |
| 31006827 | 31006827 | PRJNA1093380_P_NODE_13814_length_247_cov_2.568966_g13708_i0 | PRJNA1093380 | 13814 | 247 | 2.568966 | 6.34534602 | Agaricomycetes | 155619 | Fungi | Fungi | 59.7 | 3.62e-8 | NR | KAL0959460.1 | 104357 | g13708 | i0 | 38 | 6.40080971659919 | 79 | 47 | 96 | 1 | 8 | 244 | 28 | 104 | KAL0959460.1 hypothetical protein HGRIS_011173 [Hohenbuehelia grisea] | diamond | 1581 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Hohenbuehelia | Hohenbuehelia grisea | |
| 31299896 | 31299896 | PRJNA1093380_P_NODE_4215_length_310_cov_1.886076_g4109_i0 | PRJNA1093380 | 4215 | 310 | 1.886076 | 5.8468356 | Gloeopeniophorella convolvens | 205761 | Fungi | Fungi | 46.6 | 0.00335 | NR | KAI0274881.1 | 205761 | g4109 | i0 | 42 | 1.40322580645161 | 69 | 28 | 55.2 | 1 | 301 | 131 | 269 | 337 | KAI0274881.1 TPR-like protein [Gloeopeniophorella convolvens] | diamond | 435 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Gloeopeniophorella | Gloeopeniophorella convolvens | ||
| 31363344 | 31363344 | PRJNA1093380_P_NODE_2676_length_361_cov_1.604167_g2570_i0 | PRJNA1093380 | 2676 | 361 | 1.604167 | 5.79104287 | Dentipellis fragilis | 205917 | Fungi | Fungi | 48.1 | 0.0019 | NR | TFY57172.1 | 205917 | g2570 | i0 | 31.1 | 5.03601108033241 | 119 | 71 | 94.7 | 4 | 348 | 7 | 287 | 399 | TFY57172.1 hypothetical protein EVG20_g8648 [Dentipellis fragilis] | diamond | 1818 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Dentipellis | Dentipellis fragilis | |
| 31449528 | 31449528 | PRJNA1093380_P_NODE_17516_length_234_cov_3.515528_g17410_i0 | PRJNA1093380 | 17516 | 234 | 3.515528 | 8.22633552 | Vanrija | 1851468 | Fungi | Fungi | 107 | 2.18e-28 | NR | XP_062631724.1 | 143232 | g17410 | i0 | 80.3 | 1.56410256410256 | 61 | 12 | 78.2 | 0 | 234 | 52 | 39 | 99 | XP_062631724.1 putative 60S ribosomal protein L37-A [Vanrija pseudolonga] | diamond | 366 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 32059055 | 32059055 | PRJNA1093380_P_NODE_17318_length_238_cov_2.248485_g17212_i0 | PRJNA1093380 | 17318 | 238 | 2.248485 | 5.3513943 | Trichosporon asahii var. asahii CBS 2479 | 1186058 | Fungi | Fungi | 72.4 | 1.1e-12 | NR | XP_014184471.1 | 1186058 | g17212 | i0 | 53.2 | 0.781512605042017 | 62 | 25 | 73.1 | 1 | 63 | 236 | 3 | 64 | XP_014184471.1 aspartate aminotransferase, precursor [Trichosporon asahii var. asahii CBS 2479] | diamond | 186 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 32185760 | 32185760 | PRJNA1093380_P_NODE_11218_length_254_cov_3.171271_g11112_i0 | PRJNA1093380 | 11218 | 254 | 3.171271 | 8.05502834 | Sistotremastrum niveocremeum HHB97 | 2834505 | Fungi | Fungi | 81.3 | 5.08e-16 | NR | KZS94755.1 | 1314777 | g11112 | i0 | 70.9 | 1.90157480314961 | 55 | 16 | 65 | 0 | 88 | 252 | 109 | 163 | KZS94755.1 FabD/lysophospholipase-like protein [Sistotremastrum niveocremeum HHB9708] | diamond | 483 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sistotremastrales | Sistotremastraceae | Sertulicium | Sertulicium niveocremeum | |
| 32493605 | 32493605 | PRJNA1093380_P_NODE_10099_length_261_cov_1.638298_g9993_i0 | PRJNA1093380 | 10099 | 261 | 1.638298 | 4.27595778 | Agaricomycetes | 155619 | Fungi | Fungi | 108 | 1.59e-25 | NR | KAI0766648.1 | 526244 | g9993 | i0 | 58.6 | 4.96551724137931 | 87 | 35 | 98.9 | 1 | 3 | 260 | 318 | 404 | KAI0766648.1 acid protease [Trametes elegans] | diamond | 1296 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes elegans |
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);;