contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA675331" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12127053 | 12127053 | PRJNA675331_P_NODE_17690_length_253_cov_1.133333_g17518_i0 | PRJNA675331 | 17690 | 253 | 1.133333 | 2.86733249 | Tulasnella sp. JGI-2 | 1905295 | Fungi | Fungi | 133 | 1.16e-37 | NR | KAG9002549.1 | 2600232 | g17518 | i0 | 73.5 | 31.4584980237154 | 83 | 22 | 98.4 | 0 | 251 | 3 | 73 | 155 | KAG9002549.1 ribosomal 40S subunit protein S18B [Tulasnella sp. JGI-2019a] | diamond | 7959 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella sp. JGI-2019a | ||
| 12127122 | 12127122 | PRJNA675331_P_NODE_8910_length_330_cov_1.077821_g8738_i0 | PRJNA675331 | 8910 | 330 | 1.077821 | 3.5568093 | Fungi | 4751 | Fungi | Fungi | 191 | 1.11e-58 | NR | XP_014179854.1 | 1186058 | g8738 | i0 | 85.3 | 87.2181818181818 | 109 | 16 | 99.1 | 0 | 3 | 329 | 34 | 142 | XP_014179854.1 ribosomal protein S2 [Trichosporon asahii var. asahii CBS 2479] | diamond | 28782 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 15950545 | 15950545 | PRJNA675331_P_NODE_853_length_962_cov_1.772778_g726_i0 | PRJNA675331 | 853 | 962 | 1.772778 | 17.05412436 | Fungi | 4751 | Fungi | Fungi | 379 | 2.04e-127 | NR | KAA1064956.1 | 56615 | g726 | i0 | 61.6 | 18.6392931392931 | 315 | 117 | 98.2 | 2 | 946 | 2 | 1 | 311 | KAA1064956.1 hypothetical protein PGT21_020153 [Puccinia graminis f. sp. tritici] | diamond | 17931 | 382 | 0.992146596858639 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 26828906 | 26828906 | PRJNA675331_P_NODE_14721_length_273_cov_1.150000_g14549_i0 | PRJNA675331 | 14721 | 273 | 1.15 | 3.1395 | Marasmius sp. AFHP31 | 3065222 | Fungi | Fungi | 50.8 | 7.22e-5 | NR | KAK1222820.1 | 3065222 | g14549 | i0 | 52.3 | 0.483516483516484 | 44 | 20 | 48.4 | 1 | 273 | 142 | 89 | 131 | KAK1222820.1 hypothetical protein PQX77_014242 [Marasmius sp. AFHP31] | diamond | 132 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius sp. AFHP31 | |
| 27018638 | 27018638 | PRJNA675331_P_NODE_17762_length_252_cov_1.720670_g17590_i0 | PRJNA675331 | 17762 | 252 | 1.72067 | 4.3360884 | Tetrapyrgos nigripes | 182062 | Fungi | Fungi | 61.2 | 2.74e-9 | NR | KAF5365072.1 | 182062 | g17590 | i0 | 43.3 | 1.33333333333333 | 60 | 34 | 71.4 | 0 | 250 | 71 | 30 | 89 | KAF5365072.1 hypothetical protein D9758_011019 [Tetrapyrgos nigripes] | diamond | 336 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Tetrapyrgos | Tetrapyrgos nigripes | |
| 27650699 | 27650699 | PRJNA675331_P_NODE_10424_length_309_cov_2.567797_g10252_i0 | PRJNA675331 | 10424 | 309 | 2.567797 | 7.93449273 | Leucoagaricus sp. SymC.cos | 1714833 | Fungi | Fungi | 69.3 | 3.01e-12 | NR | KXN86585.1 | 1714833 | g10252 | i0 | 57.1 | 0.543689320388349 | 56 | 24 | 54.4 | 0 | 2 | 169 | 14 | 69 | KXN86585.1 60S acidic ribosomal protein P2 [Leucoagaricus sp. SymC.cos] | diamond | 168 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucoagaricus | Leucoagaricus sp. SymC.cos | |
| 27883342 | 27883342 | PRJNA675331_P_NODE_6325_length_383_cov_1.683871_g6153_i0 | PRJNA675331 | 6325 | 383 | 1.683871 | 6.44922593 | Naganishia | 1851509 | Fungi | Fungi | 87.8 | 3.12e-19 | NR | GHJ86214.1 | 104408 | g6153 | i0 | 45.7 | 3.15665796344648 | 81 | 44 | 63.4 | 0 | 243 | 1 | 42 | 122 | GHJ86214.1 hypothetical protein NliqN6_2616 [Naganishia liquefaciens] | diamond | 1209 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 28262113 | 28262113 | PRJNA675331_P_NODE_8286_length_340_cov_1.441948_g8114_i0 | PRJNA675331 | 8286 | 340 | 1.441948 | 4.9026232 | Russulaceae | 5401 | Fungi | Fungi | 137 | 3.909999999999999e-35 | NR | KAI9509635.1 | 71964 | g8114 | i0 | 66 | 26.9823529411765 | 97 | 31 | 85.6 | 1 | 337 | 47 | 321 | 415 | KAI9509635.1 polyadenylate binding protein [Russula earlei] | diamond | 9174 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula earlei | |
| 28325341 | 28325341 | PRJNA675331_P_NODE_12266_length_290_cov_1.073733_g12094_i0 | PRJNA675331 | 12266 | 290 | 1.073733 | 3.1138257 | Marasmius | 34448 | Fungi | Fungi | 55.5 | 1.23e-6 | NR | KAL0064858.1 | 585030 | g12094 | i0 | 56.5 | 0.951724137931034 | 46 | 19 | 47.6 | 1 | 231 | 94 | 92 | 136 | KAL0064858.1 Chitinase 2 [Marasmius tenuissimus] | diamond | 276 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius tenuissimus | |
| 28483380 | 28483380 | PRJNA675331_P_NODE_2866_length_550_cov_1.291405_g2698_i0 | PRJNA675331 | 2866 | 550 | 1.291405 | 7.1027275 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 0.0072 | NR | KAJ8295625.1 | 5286 | g2698 | i0 | 72.4 | 2.34545454545455 | 29 | 8 | 15.8 | 0 | 2 | 88 | 209 | 237 | KAJ8295625.1 ATP synthase subunit beta, mitochondrial [Rhodotorula toruloides] | diamond | 1290 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 28945398 | 28945398 | PRJNA675331_P_NODE_8408_length_338_cov_1.162264_g8236_i0 | PRJNA675331 | 8408 | 338 | 1.162264 | 3.92845232 | Peniophora sp. CONT | 1314672 | Fungi | Fungi | 120 | 9.479999999999999e-32 | NR | KZV71391.1 | 1314672 | g8236 | i0 | 61.5 | 1.95266272189349 | 109 | 40 | 96.7 | 2 | 334 | 8 | 28 | 134 | KZV71391.1 60S ribosomal protein L18 [Peniophora sp. CONT] | diamond | 660 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CONT | |
| 28976822 | 28976822 | PRJNA675331_P_NODE_16188_length_263_cov_1.894737_g16016_i0 | PRJNA675331 | 16188 | 263 | 1.894737 | 4.98315831 | Mycena sanguinolenta | 230812 | Fungi | Fungi | 52 | 2.64e-5 | NR | KAF7343507.1 | 230812 | g16016 | i0 | 59.6 | 4.71102661596958 | 47 | 18 | 53.6 | 1 | 108 | 248 | 616 | 661 | KAF7343507.1 hypothetical protein MSAN_01971000 [Mycena sanguinolenta] | diamond | 1239 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena sanguinolenta | |
| 29197862 | 29197862 | PRJNA675331_P_NODE_12709_length_286_cov_1.084507_g12537_i0 | PRJNA675331 | 12709 | 286 | 1.084507 | 3.10169002 | Trametes sanguinea | 158606 | Fungi | Fungi | 147 | 5.88e-40 | NR | KAJ3013448.1 | 158606 | g12537 | i0 | 77.9 | 27.9020979020979 | 95 | 20 | 99.7 | 1 | 1 | 285 | 122 | 215 | KAJ3013448.1 hypothetical protein NUW54_g1592 [Trametes sanguinea] | diamond | 7980 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes sanguinea | |
| 29450079 | 29450079 | PRJNA675331_P_NODE_16630_length_260_cov_1.647059_g16458_i0 | PRJNA675331 | 16630 | 260 | 1.647059 | 4.2823534 | Postia placenta MAD-698-R-SB12 | 670580 | Fungi | Fungi | 62 | 3.75e-10 | NR | XP_024343606.1 | 670580 | g16458 | i0 | 44.4 | 1.37307692307692 | 63 | 35 | 72.7 | 0 | 258 | 70 | 41 | 103 | XP_024343606.1 hypothetical protein POSPLADRAFT_1068240 [Postia placenta MAD-698-R-SB12] | diamond | 357 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Adustoporiaceae | Rhodonia | Rhodonia placenta | |
| 29809327 | 29809327 | PRJNA675331_P_NODE_1371_length_771_cov_2.206304_g1216_i0 | PRJNA675331 | 1371 | 771 | 2.206304 | 17.01060384 | Basidiomycota | 5204 | Fungi | Fungi | 308 | 2.78e-102 | NR | CEQ39685.1 | 5005 | g1216 | i0 | 61 | 15.2256809338521 | 251 | 95 | 96.9 | 2 | 15 | 761 | 19 | 268 | CEQ39685.1 SPOSA6832_01235 [Sporobolomyces salmonicolor] | diamond | 11739 | 310 | 0.993548387096774 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 29987162 | 29987162 | PRJNA675331_P_NODE_13031_length_283_cov_1.176190_g12859_i0 | PRJNA675331 | 13031 | 283 | 1.17619 | 3.3286177 | Papiliotrema laurentii | 5418 | Fungi | Fungi | 52.4 | 1.93e-5 | NR | KAK1923511.1 | 5418 | g12859 | i0 | 43.8 | 0.678445229681979 | 64 | 35 | 67.8 | 1 | 227 | 36 | 117 | 179 | KAK1923511.1 CAP domain-containing protein [Papiliotrema laurentii] | diamond | 192 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 30567327 | 30567327 | PRJNA675331_P_NODE_18313_length_251_cov_0.865169_g18141_i0 | PRJNA675331 | 18313 | 251 | 0.865169 | 2.17157419 | Polyporales | 5303 | Fungi | Fungi | 44.7 | 0.00864 | NR | XP_027613509.1 | 139825 | g18141 | i0 | 47.4 | 1.26693227091633 | 57 | 16 | 58.6 | 2 | 1 | 147 | 577 | 627 | XP_027613509.1 hypothetical protein SCP_0409800 [Sparassis crispa] | diamond | 318 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Sparassidaceae | Sparassis | Sparassis crispa | |
| 30935105 | 30935105 | PRJNA675331_P_NODE_6454_length_380_cov_0.990228_g6282_i0 | PRJNA675331 | 6454 | 380 | 0.990228 | 3.7628664 | Russula earlei | 71964 | Fungi | Fungi | 57.8 | 9.48e-7 | NR | KAI9507850.1 | 71964 | g6282 | i0 | 29.4 | 0.536842105263158 | 68 | 48 | 53.7 | 0 | 1 | 204 | 506 | 573 | KAI9507850.1 voltage-gated potassium channel [Russula earlei] | diamond | 204 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula earlei | |
| 31472565 | 31472565 | PRJNA675331_P_NODE_10836_length_305_cov_1.306034_g10664_i0 | PRJNA675331 | 10836 | 305 | 1.306034 | 3.9834037 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 87.8 | 1.12e-17 | NR | KIY73845.1 | 1314674 | g10664 | i0 | 48.9 | 5.33114754098361 | 90 | 34 | 88.5 | 3 | 303 | 34 | 499 | 576 | KIY73845.1 tripeptidyl peptidase A [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 1626 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 32831545 | 32831545 | PRJNA675331_P_NODE_8600_length_335_cov_1.175573_g8428_i0 | PRJNA675331 | 8600 | 335 | 1.175573 | 3.93816955 | Amanita thiersii Skay4 | 235537 | Fungi | Fungi | 71.6 | 6.96e-12 | NR | PFH52463.1 | 703135 | g8428 | i0 | 62.8 | 0.698507462686567 | 43 | 16 | 38.5 | 0 | 273 | 145 | 39 | 81 | PFH52463.1 glycoside hydrolase family 10 protein [Amanita thiersii Skay4041] | diamond | 234 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita thiersii |
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);;