contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA738523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11401406 | 11401406 | PRJNA738523_P_NODE_7689_length_277_cov_1.406863_g7618_i0 | PRJNA738523 | 7689 | 277 | 1.406863 | 3.89701051 | Mixia osmundae IAM 14324 | 764103 | Fungi | Fungi | 123 | 1.34e-33 | NR | XP_014566532.1 | 764103 | g7618 | i0 | 74.1 | 0.877256317689531 | 81 | 19 | 87.7 | 1 | 272 | 30 | 85 | 163 | XP_014566532.1 uncharacterized protein L969DRAFT_89178 [Mixia osmundae IAM 14324] | diamond | 243 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Mixiomycetes | Mixiales | Mixiaceae | Mixia | Mixia osmundae | |
| 21122157 | 21122157 | PRJNA738523_P_NODE_7757_length_276_cov_1.896552_g7686_i0 | PRJNA738523 | 7757 | 276 | 1.896552 | 5.23448352 | Eukaryota | 2759 | Fungi | Fungi | 91.7 | 4.850000000000001e-21 | NR | KAJ4470551.1 | 5353 | g7686 | i0 | 57.1 | 11.3804347826087 | 84 | 36 | 91.3 | 0 | 4 | 255 | 76 | 159 | KAJ4470551.1 histone-fold-containing protein [Lentinula edodes] | diamond | 3141 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 26682669 | 26682669 | PRJNA738523_P_NODE_16081_length_241_cov_0.916667_g16010_i0 | PRJNA738523 | 16081 | 241 | 0.916667 | 2.20916747 | Basidiomycota | 5204 | Fungi | Fungi | 47 | 9.37e-4 | NR | GAA5933423.1 | 29898 | g16010 | i0 | 38.4 | 1.76763485477178 | 86 | 44 | 95.9 | 3 | 8 | 238 | 138 | 223 | GAA5933423.1 hypothetical protein JCM3775_000686 [Rhodotorula graminis] | diamond | 426 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 26704079 | 26704079 | PRJNA738523_P_NODE_9041_length_264_cov_1.528796_g8970_i0 | PRJNA738523 | 9041 | 264 | 1.528796 | 4.03602144 | Tremellales sp. Tagirdzhanova- | 1920939 | Fungi | Fungi | 54.7 | 3.05e-6 | NR | CAD6563608.1 | 2778382 | g8970 | i0 | 44.3 | 0.693181818181818 | 61 | 32 | 69.3 | 1 | 261 | 79 | 364 | 422 | CAD6563608.1 MAG: hypothetical protein TREMPRED_000010 [Tremellales sp. Tagirdzhanova-0007] | diamond | 183 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Tagirdzhanova-0007 | |||
| 27337088 | 27337088 | PRJNA738523_P_NODE_6023_length_297_cov_0.794643_g5952_i0 | PRJNA738523 | 6023 | 297 | 0.794643 | 2.36008971 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 73.9 | 5.32e-14 | NR | KIY74369.1 | 1314674 | g5952 | i0 | 44.7 | 0.858585858585859 | 85 | 42 | 83.8 | 2 | 47 | 295 | 28 | 109 | KIY74369.1 hypothetical protein CYLTODRAFT_484685 [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 255 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 27810788 | 27810788 | PRJNA738523_P_NODE_12024_length_248_cov_1.645714_g11953_i0 | PRJNA738523 | 12024 | 248 | 1.645714 | 4.08137072 | Mycena leptocephala | 230808 | Fungi | Fungi | 55.1 | 1.81e-6 | NR | KAJ7848204.1 | 230808 | g11953 | i0 | 37.1 | 2.15322580645161 | 89 | 40 | 98 | 4 | 5 | 247 | 949 | 1029 | KAJ7848204.1 hypothetical protein B0H13DRAFT_2361998 [Mycena leptocephala] | diamond | 534 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena leptocephala | |
| 28094774 | 28094774 | PRJNA738523_P_NODE_13185_length_246_cov_0.890173_g13114_i0 | PRJNA738523 | 13185 | 246 | 0.890173 | 2.18982558 | Coprinopsis cinerea okayama7#13 | 5346 | Fungi | Fungi | 44.3 | 0.0115 | NR | XP_022234934.1 | 240176 | g13114 | i0 | 32.1 | 1.02439024390244 | 84 | 39 | 93.9 | 2 | 1 | 231 | 817 | 889 | XP_022234934.1 RNA polymerase [Coprinopsis cinerea okayama7#130] | diamond | 252 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 28262635 | 28262635 | PRJNA738523_P_NODE_8606_length_268_cov_1.579487_g8535_i0 | PRJNA738523 | 8606 | 268 | 1.579487 | 4.23302516 | Wallemia | 148959 | Fungi | Fungi | 104 | 5.01e-25 | NR | TIB35218.1 | 245174 | g8535 | i0 | 62.5 | 8.17164179104478 | 80 | 30 | 89.6 | 0 | 27 | 266 | 203 | 282 | TIB35218.1 hypothetical protein E3P86_02694 [Wallemia ichthyophaga] | diamond | 2190 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia ichthyophaga | |
| 28631741 | 28631741 | PRJNA738523_P_NODE_11127_length_250_cov_0.870056_g11056_i0 | PRJNA738523 | 11127 | 250 | 0.870056 | 2.17514 | Asterophora parasitica | 117018 | Fungi | Fungi | 69.7 | 1.33e-11 | NR | KAG5647562.1 | 117018 | g11056 | i0 | 33.7 | 0.996 | 83 | 51 | 94.8 | 1 | 241 | 5 | 260 | 342 | KAG5647562.1 hypothetical protein DXG03_008915 [Asterophora parasitica] | diamond | 249 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Asterophora | Asterophora parasitica | |
| 29326052 | 29326052 | PRJNA738523_P_NODE_14849_length_243_cov_0.905882_g14778_i0 | PRJNA738523 | 14849 | 243 | 0.905882 | 2.20129326 | Thelephora ganbajun | 370292 | Fungi | Fungi | 43.5 | 0.0191 | NR | KAF9648843.1 | 370292 | g14778 | i0 | 40.4 | 0.580246913580247 | 47 | 28 | 58 | 0 | 153 | 13 | 252 | 298 | KAF9648843.1 hypothetical protein BDM02DRAFT_3269203 [Thelephora ganbajun] | diamond | 141 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Thelephora | Thelephora ganbajun | |
| 29452138 | 29452138 | PRJNA738523_P_NODE_5510_length_308_cov_0.825532_g5439_i0 | PRJNA738523 | 5510 | 308 | 0.825532 | 2.54263856 | Puccinia striiformis | 27350 | Fungi | Fungi | 102 | 1.06e-24 | NR | POW16268.1 | 27350 | g5439 | i0 | 65.3 | 44.7467532467532 | 101 | 35 | 98.4 | 0 | 1 | 303 | 49 | 149 | POW16268.1 hypothetical protein PSTT_01417 [Puccinia striiformis] | diamond | 13782 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 29609962 | 29609962 | PRJNA738523_P_NODE_13730_length_245_cov_1.418605_g13659_i0 | PRJNA738523 | 13730 | 245 | 1.418605 | 3.47558225 | Malassezia cuniculi | 948313 | Fungi | Fungi | 104 | 1.28e-26 | NR | WFD33451.1 | 948313 | g13659 | i0 | 62.5 | 4.91020408163265 | 80 | 30 | 98 | 0 | 241 | 2 | 8 | 87 | WFD33451.1 60S ribosomal protein L32 [Malassezia cuniculi] | diamond | 1203 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 29620037 | 29620037 | PRJNA738523_P_NODE_11910_length_249_cov_0.875000_g11839_i0 | PRJNA738523 | 11910 | 249 | 0.875 | 2.17875 | Basidiomycota | 5204 | Fungi | Fungi | 106 | 3.05e-25 | NR | KAH7909816.1 | 72124 | g11839 | i0 | 60 | 3.80722891566265 | 80 | 32 | 96.4 | 0 | 3 | 242 | 4 | 83 | KAH7909816.1 hypothetical protein BJ138DRAFT_1066365 [Hygrophoropsis aurantiaca] | diamond | 948 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Hygrophoropsidaceae | Hygrophoropsis | Hygrophoropsis aurantiaca | |
| 30305742 | 30305742 | PRJNA738523_P_NODE_14152_length_245_cov_0.895349_g14081_i0 | PRJNA738523 | 14152 | 245 | 0.895349 | 2.19360505 | Phlebia brevispora | 194682 | Fungi | Fungi | 73.2 | 7.02e-14 | NR | KAJ3544745.1 | 194682 | g14081 | i0 | 44.3 | 7.57959183673469 | 88 | 40 | 98 | 2 | 240 | 1 | 19 | 105 | KAJ3544745.1 hypothetical protein NM688_g5706 [Phlebia brevispora] | diamond | 1857 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meruliaceae | Phlebia | Phlebia brevispora | |
| 30715898 | 30715898 | PRJNA738523_P_NODE_9074_length_264_cov_1.209424_g9003_i0 | PRJNA738523 | 9074 | 264 | 1.209424 | 3.19287936 | Amanita brunnescens Koide BX | 87326 | Fungi | Fungi | 68.6 | 9.34e-12 | NR | KAF8723464.1 | 1457509 | g9003 | i0 | 39.3 | 0.954545454545455 | 84 | 50 | 94.3 | 1 | 251 | 3 | 108 | 191 | KAF8723464.1 hypothetical protein AX14_009247 [Amanita brunnescens Koide BX004] | diamond | 252 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita brunnescens | |
| 30873940 | 30873940 | PRJNA738523_P_NODE_10294_length_252_cov_1.720670_g10223_i0 | PRJNA738523 | 10294 | 252 | 1.72067 | 4.3360884 | Lentinula edodes | 5353 | Fungi | Fungi | 43.5 | 0.00967 | NR | XP_046082075.1 | 5353 | g10223 | i0 | 40.5 | 1.73809523809524 | 42 | 25 | 50 | 0 | 144 | 19 | 54 | 95 | XP_046082075.1 uncharacterized protein C8R40DRAFT_605529 [Lentinula edodes] | diamond | 438 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 31253143 | 31253143 | PRJNA738523_P_NODE_13895_length_245_cov_0.895349_g13824_i0 | PRJNA738523 | 13895 | 245 | 0.895349 | 2.19360505 | Tilletia walkeri | 117179 | Fungi | Fungi | 47.8 | 6.64e-4 | NR | KAE8211335.1 | 117179 | g13824 | i0 | 36.7 | 0.73469387755102 | 60 | 38 | 73.5 | 0 | 201 | 22 | 618 | 677 | KAE8211335.1 hypothetical protein CF327_g4903 [Tilletia walkeri] | diamond | 180 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia walkeri | |
| 32107199 | 32107199 | PRJNA738523_P_NODE_15998_length_241_cov_0.916667_g15927_i0 | PRJNA738523 | 15998 | 241 | 0.916667 | 2.20916747 | Astraeus odoratus | 265491 | Fungi | Fungi | 42.7 | 0.038 | NR | KAG6330667.1 | 265491 | g15927 | i0 | 46.9 | 0.609958506224066 | 49 | 26 | 61 | 0 | 153 | 7 | 147 | 195 | KAG6330667.1 hypothetical protein ID866_8422 [Astraeus odoratus] | diamond | 147 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Astraeaceae | Astraeus | Astraeus odoratus | |
| 32170753 | 32170753 | PRJNA738523_P_NODE_16078_length_241_cov_0.916667_g16007_i0 | PRJNA738523 | 16078 | 241 | 0.916667 | 2.20916747 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 73.6 | 1.72e-13 | NR | XP_018276075.1 | 879819 | g16007 | i0 | 53.8 | 0.970954356846473 | 78 | 33 | 97.1 | 2 | 235 | 2 | 51 | 125 | XP_018276075.1 uncharacterized protein COLE_01681 [Cutaneotrichosporon oleaginosum] | diamond | 234 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum |
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);;