contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA474911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19573418 | 19573418 | PRJNA474911_P_NODE_8176_length_202_cov_0.907801_g8049_i0 | PRJNA474911 | 8176 | 202 | 0.907801 | 1.83375802 | Rhodotorula | 5533 | Fungi | Fungi | 112 | 4.56e-27 | NR | KAG0661067.1 | 5537 | g8049 | i0 | 82.1 | 2.3168316831683202 | 78 | 3 | 99.5 | 1 | 1 | 201 | 519 | 596 | KAG0661067.1 hypothetical protein C6P46_004174, partial [Rhodotorula mucilaginosa] | diamond | 468 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 23399879 | 23399879 | PRJNA474911_P_NODE_7859_length_204_cov_0.895105_g7732_i0 | PRJNA474911 | 7859 | 204 | 0.895105 | 1.8260142 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 124 | 1.75e-31 | NR | GHJ84354.1 | 104408 | g7732 | i0 | 100 | 0.970588235294118 | 66 | 0 | 97.1 | 0 | 7 | 204 | 1 | 66 | GHJ84354.1 hypothetical protein NliqN6_0756 [Naganishia liquefaciens] | diamond | 198 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 27313798 | 27313798 | PRJNA474911_P_NODE_7623_length_205_cov_0.888889_g7496_i0 | PRJNA474911 | 7623 | 205 | 0.888889 | 1.82222245 | Rhodotorula | 5533 | Fungi | Fungi | 147 | 1.7699999999999993e-41 | NR | KAG0653983.1 | 5537 | g7496 | i0 | 100 | 1.99024390243902 | 68 | 0 | 99.5 | 0 | 1 | 204 | 24 | 91 | KAG0653983.1 hypothetical protein C6P46_002028 [Rhodotorula mucilaginosa] | diamond | 408 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 27329263 | 27329263 | PRJNA474911_P_NODE_7643_length_205_cov_0.888889_g7516_i0 | PRJNA474911 | 7643 | 205 | 0.888889 | 1.82222245 | Cyathus striatus | 68777 | Fungi | Fungi | 64.7 | 2.77e-11 | NR | KAF9002551.1 | 68777 | g7516 | i0 | 51.5 | 1.82926829268293 | 68 | 28 | 92.2 | 2 | 189 | 1 | 1 | 68 | KAF9002551.1 profilin [Cyathus striatus] | diamond | 375 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Cyathus | Cyathus striatus | |
| 27392483 | 27392483 | PRJNA474911_P_NODE_7183_length_208_cov_0.870748_g7056_i0 | PRJNA474911 | 7183 | 208 | 0.870748 | 1.81115584 | Collybia nuda | 64659 | Fungi | Fungi | 98.2 | 7.110000000000001e-22 | NR | KAF9455744.1 | 64659 | g7056 | i0 | 81 | 0.908653846153846 | 63 | 12 | 90.9 | 0 | 208 | 20 | 272 | 334 | KAF9455744.1 hypothetical protein BDZ94DRAFT_1315875 [Collybia nuda] | diamond | 189 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Clitocybaceae | Collybia | Collybia nuda | |
| 27645141 | 27645141 | PRJNA474911_P_NODE_7044_length_209_cov_0.864865_g6917_i0 | PRJNA474911 | 7044 | 209 | 0.864865 | 1.80756785 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 139 | 4.33e-38 | NR | GHJ90132.1 | 104408 | g6917 | i0 | 97.1 | 2.97129186602871 | 69 | 2 | 99 | 0 | 208 | 2 | 188 | 256 | GHJ90132.1 hypothetical protein NliqN6_6534 [Naganishia liquefaciens] | diamond | 621 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 28339572 | 28339572 | PRJNA474911_P_NODE_7346_length_207_cov_0.876712_g7219_i0 | PRJNA474911 | 7346 | 207 | 0.876712 | 1.81479384 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 68.9 | 1.25e-11 | NR | GHJ87782.1 | 104408 | g7219 | i0 | 91.2 | 0.492753623188406 | 34 | 3 | 49.3 | 0 | 105 | 206 | 224 | 257 | GHJ87782.1 hypothetical protein NliqN6_4184 [Naganishia liquefaciens] | diamond | 102 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 28497570 | 28497570 | PRJNA474911_P_NODE_7747_length_204_cov_1.307692_g7620_i0 | PRJNA474911 | 7747 | 204 | 1.307692 | 2.66769168 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 140 | 1.15e-37 | NR | GHJ88385.1 | 104408 | g7620 | i0 | 100 | 0.985294117647059 | 67 | 0 | 98.5 | 0 | 203 | 3 | 328 | 394 | GHJ88385.1 hypothetical protein NliqN6_4787 [Naganishia liquefaciens] | diamond | 201 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 29381510 | 29381510 | PRJNA474911_P_NODE_7449_length_206_cov_0.882759_g7322_i0 | PRJNA474911 | 7449 | 206 | 0.882759 | 1.81848354 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 115 | 5.69e-28 | NR | GHJ84791.1 | 104408 | g7322 | i0 | 79.4 | 0.990291262135922 | 68 | 14 | 99 | 0 | 204 | 1 | 950 | 1017 | GHJ84791.1 hypothetical protein NliqN6_1193 [Naganishia liquefaciens] | diamond | 204 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 29507712 | 29507712 | PRJNA474911_P_NODE_7050_length_209_cov_0.864865_g6923_i0 | PRJNA474911 | 7050 | 209 | 0.864865 | 1.80756785 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 134 | 3.0199999999999996e-37 | NR | KAG0661311.1 | 5537 | g6923 | i0 | 100 | 0.976076555023923 | 68 | 0 | 97.6 | 0 | 209 | 6 | 195 | 262 | KAG0661311.1 hypothetical protein C6P46_004083 [Rhodotorula mucilaginosa] | diamond | 204 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 29696854 | 29696854 | PRJNA474911_P_NODE_6730_length_213_cov_1.684211_g6603_i0 | PRJNA474911 | 6730 | 213 | 1.684211 | 3.58736943 | Amanita brunnescens Koide BX | 87326 | Fungi | Fungi | 52 | 6.04e-7 | NR | KAF8651155.1 | 1457509 | g6603 | i0 | 47.9 | 0.676056338028169 | 48 | 24 | 66.2 | 1 | 169 | 29 | 8 | 55 | KAF8651155.1 hypothetical protein AX14_008492, partial [Amanita brunnescens Koide BX004] | diamond | 144 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita brunnescens | |
| 29949933 | 29949933 | PRJNA474911_P_NODE_3451_length_322_cov_1.655172_g3325_i0 | PRJNA474911 | 3451 | 322 | 1.655172 | 5.32965384 | Leucoagaricus sp. SymC.cos | 1714833 | Fungi | Fungi | 47.8 | 0.00153 | NR | KXN82259.1 | 1714833 | g3325 | i0 | 36.9 | 0.782608695652174 | 84 | 46 | 71.7 | 3 | 294 | 64 | 289 | 372 | KXN82259.1 hypothetical protein AN958_02809 [Leucoagaricus sp. SymC.cos] | diamond | 252 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucoagaricus | Leucoagaricus sp. SymC.cos | |
| 30377141 | 30377141 | PRJNA474911_P_NODE_7232_length_208_cov_0.870748_g7105_i0 | PRJNA474911 | 7232 | 208 | 0.870748 | 1.81115584 | Fungi | 4751 | Fungi | Fungi | 101 | 1.48e-25 | NR | KAJ8294693.1 | 5286 | g7105 | i0 | 79.1 | 17.4086538461538 | 67 | 14 | 96.6 | 0 | 4 | 204 | 69 | 135 | KAJ8294693.1 40S ribosomal protein S28-B [Rhodotorula toruloides] | diamond | 3621 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 30487101 | 30487101 | PRJNA474911_P_NODE_7693_length_205_cov_0.888889_g7566_i0 | PRJNA474911 | 7693 | 205 | 0.888889 | 1.82222245 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 124 | 3.38e-34 | NR | GHJ89223.1 | 104408 | g7566 | i0 | 83.6 | 1.9609756097561 | 67 | 11 | 98 | 0 | 3 | 203 | 73 | 139 | GHJ89223.1 hypothetical protein NliqN6_5625 [Naganishia liquefaciens] | diamond | 402 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 30613266 | 30613266 | PRJNA474911_P_NODE_7793_length_204_cov_0.895105_g7666_i0 | PRJNA474911 | 7793 | 204 | 0.895105 | 1.8260142 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 152 | 1.42e-41 | NR | KWU44114.1 | 1305733 | g7666 | i0 | 100 | 2 | 68 | 0 | 100 | 0 | 1 | 204 | 441 | 508 | KWU44114.1 glycoside hydrolase [Rhodotorula sp. JG-1b] | diamond | 408 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 30676431 | 30676431 | PRJNA474911_P_NODE_513_length_901_cov_1.396429_g421_i0 | PRJNA474911 | 513 | 901 | 1.396429 | 12.58182529 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 317 | 2.07e-105 | NR | GHJ84434.1 | 104408 | g421 | i0 | 85 | 0.822419533851276 | 247 | 22 | 81.2 | 3 | 24 | 755 | 1 | 235 | GHJ84434.1 hypothetical protein NliqN6_0836 [Naganishia liquefaciens] | diamond | 741 | 317 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens |
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);;