contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA851399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26770158 | 26770158 | PRJNA851399_P_NODE_26941_length_167_cov_0.864407_g26488_i0 | PRJNA851399 | 26941 | 167 | 0.864407 | 1.44355969 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 54.7 | 8.1e-7 | NR | XP_066820672.1 | 1397322 | g26488 | i0 | 64.7 | 0.916167664670659 | 51 | 17 | 91.6 | 1 | 167 | 15 | 1034 | 1083 | XP_066820672.1 glycosyltransferase family 31 protein [Cystobasidium minutum MCA 4210] | diamond | 153 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 26991476 | 26991476 | PRJNA851399_P_NODE_39862_length_161_cov_0.910714_g39409_i0 | PRJNA851399 | 39862 | 161 | 0.910714 | 1.46624954 | Dioszegia hungarica | 4972 | Fungi | Fungi | 90.1 | 2.12e-20 | NR | XP_052948222.1 | 4972 | g39409 | i0 | 90.6 | 2.96273291925466 | 53 | 5 | 98.8 | 0 | 2 | 160 | 56 | 108 | XP_052948222.1 uncharacterized protein MKK02DRAFT_6664, partial [Dioszegia hungarica] | diamond | 477 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 27212848 | 27212848 | PRJNA851399_P_NODE_32842_length_164_cov_0.886957_g32389_i0 | PRJNA851399 | 32842 | 164 | 0.886957 | 1.45460948 | Sporobolomyces koalae | 500713 | Fungi | Fungi | 44.3 | 0.00367 | NR | GAA5933746.1 | 500713 | g32389 | i0 | 79.3 | 0.530487804878049 | 29 | 6 | 53 | 0 | 88 | 2 | 292 | 320 | GAA5933746.1 hypothetical protein JCM15063_001402 [Sporobolomyces koalae] | diamond | 87 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces koalae | |
| 27695331 | 27695331 | PRJNA851399_P_NODE_35644_length_163_cov_0.894737_g35191_i0 | PRJNA851399 | 35644 | 163 | 0.894737 | 1.45842131 | Tilletia | 13289 | Fungi | Fungi | 40 | 0.0208 | NR | KAK0555574.1 | 155126 | g35191 | i0 | 42 | 2.79754601226994 | 50 | 25 | 92 | 1 | 150 | 1 | 11 | 56 | KAK0555574.1 hypothetical protein OC845_000144 [Tilletia horrida] | diamond | 456 | 40.4 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida | |
| 27750197 | 27750197 | PRJNA851399_P_NODE_40804_length_161_cov_0.910714_g40351_i0 | PRJNA851399 | 40804 | 161 | 0.910714 | 1.46624954 | Ustilago sp. UG-2 | 1849495 | Fungi | Fungi | 47 | 3.87e-4 | NR | SOV09056.1 | 2043610 | g40351 | i0 | 72.4 | 0.540372670807453 | 29 | 8 | 54 | 0 | 3 | 89 | 241 | 269 | SOV09056.1 uncharacterized protein UDID_18248 [Ustilago sp. UG-2017a] | diamond | 87 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago sp. UG-2017a | |
| 28349835 | 28349835 | PRJNA851399_P_NODE_29586_length_165_cov_1.758621_g29133_i0 | PRJNA851399 | 29586 | 165 | 1.758621 | 2.90172465 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 108 | 6.41e-26 | NR | WFD16074.1 | 1514897 | g29133 | i0 | 98.1 | 0.963636363636364 | 53 | 1 | 96.4 | 0 | 159 | 1 | 189 | 241 | WFD16074.1 ERAD-associated protein [Malassezia arunalokei] | diamond | 159 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 28381436 | 28381436 | PRJNA851399_P_NODE_37026_length_162_cov_1.424779_g36573_i0 | PRJNA851399 | 37026 | 162 | 1.424779 | 2.30814198 | Crepidotus variabilis | 179855 | Fungi | Fungi | 41.2 | 0.0439 | NR | KAF9528525.1 | 179855 | g36573 | i0 | 44.4 | 0.833333333333333 | 45 | 25 | 83.3 | 0 | 160 | 26 | 1197 | 1241 | KAF9528525.1 hypothetical protein CPB83DRAFT_314750 [Crepidotus variabilis] | diamond | 135 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Crepidotaceae | Crepidotus | Crepidotus variabilis | |
| 28949996 | 28949996 | PRJNA851399_P_NODE_24408_length_168_cov_1.714286_g23955_i0 | PRJNA851399 | 24408 | 168 | 1.714286 | 2.88000048 | Mycena galericulata | 71905 | Fungi | Fungi | 67 | 1.41e-11 | NR | KAJ7511407.1 | 71905 | g23955 | i0 | 50.9 | 0.982142857142857 | 55 | 27 | 98.2 | 0 | 165 | 1 | 117 | 171 | KAJ7511407.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Mycena galericulata] | diamond | 165 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galericulata | |
| 29076238 | 29076238 | PRJNA851399_P_NODE_28548_length_166_cov_0.871795_g28095_i0 | PRJNA851399 | 28548 | 166 | 0.871795 | 1.4471797 | Sporobolomyces phaffii | 183961 | Fungi | Fungi | 68.9 | 7.61e-12 | NR | GAA6017737.1 | 183961 | g28095 | i0 | 67.9 | 1.01204819277108 | 56 | 17 | 99.4 | 1 | 165 | 1 | 599 | 654 | GAA6017737.1 hypothetical protein JCM11491_001187 [Sporobolomyces phaffii] | diamond | 168 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii | |
| 29360287 | 29360287 | PRJNA851399_P_NODE_21389_length_174_cov_1.632000_g20936_i0 | PRJNA851399 | 21389 | 174 | 1.632 | 2.83968 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 126 | 3.5700000000000004e-33 | NR | WFD17650.1 | 1514897 | g20936 | i0 | 96.6 | 1 | 58 | 2 | 100 | 0 | 174 | 1 | 150 | 207 | WFD17650.1 DNA-(apurinic or apyrimidinic site) lyase [Malassezia arunalokei] | diamond | 174 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 29644009 | 29644009 | PRJNA851399_P_NODE_26970_length_167_cov_0.864407_g26517_i0 | PRJNA851399 | 26970 | 167 | 0.864407 | 1.44355969 | Phanerochaete carnosa HHB-1 | 231932 | Fungi | Fungi | 70.5 | 4.4e-13 | NR | XP_007389787.1 | 650164 | g26517 | i0 | 70.8 | 1.72455089820359 | 48 | 13 | 84.4 | 1 | 2 | 142 | 66 | 113 | XP_007389787.1 uncharacterized protein PHACADRAFT_132799 [Phanerochaete carnosa HHB-10118-sp] | diamond | 288 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete carnosa | |
| 30244694 | 30244694 | PRJNA851399_P_NODE_31492_length_165_cov_0.879310_g31039_i0 | PRJNA851399 | 31492 | 165 | 0.87931 | 1.4508615 | Malassezia restricta | 76775 | Fungi | Fungi | 93.6 | 8.38e-22 | NR | XP_027485087.1 | 76775 | g31039 | i0 | 81.5 | 0.981818181818182 | 54 | 10 | 98.2 | 0 | 164 | 3 | 27 | 80 | XP_027485087.1 tether containing UBX domain for GLUT4 [Malassezia restricta] | diamond | 162 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30308250 | 30308250 | PRJNA851399_P_NODE_28812_length_166_cov_0.871795_g28359_i0 | PRJNA851399 | 28812 | 166 | 0.871795 | 1.4471797 | Serendipita vermifera | 109899 | Fungi | Fungi | 66.6 | 4.97e-11 | NR | PVF96461.1 | 109899 | g28359 | i0 | 61.8 | 2.98192771084337 | 55 | 21 | 99.4 | 0 | 166 | 2 | 359 | 413 | PVF96461.1 DUF1212-domain-containing protein [Serendipita vermifera] | diamond | 495 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 30560271 | 30560271 | PRJNA851399_P_NODE_37553_length_162_cov_0.902655_g37100_i0 | PRJNA851399 | 37553 | 162 | 0.902655 | 1.4623011 | Malassezia globosa CBS 7966 | 425265 | Fungi | Fungi | 102 | 5.5e-24 | NR | XP_001729784.1 | 425265 | g37100 | i0 | 78.8 | 0.962962962962963 | 52 | 11 | 96.3 | 0 | 158 | 3 | 276 | 327 | XP_001729784.1 putative aspartyl protease [Malassezia globosa CBS 7966] | diamond | 156 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 31761718 | 31761718 | PRJNA851399_P_NODE_29957_length_165_cov_0.879310_g29504_i0 | PRJNA851399 | 29957 | 165 | 0.87931 | 1.4508615 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 80.5 | 1.44e-16 | NR | KAJ3512029.1 | 752674 | g29504 | i0 | 100 | 9.23636363636364 | 39 | 0 | 70.9 | 0 | 165 | 49 | 211 | 249 | KAJ3512029.1 hypothetical protein NMY22_g15458 [Coprinellus aureogranulatus] | diamond | 1524 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus |
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);;