contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA506002" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3661803 | 3661803 | PRJNA506002_S_NODE_58703_length_248_cov_1.897143_g58457_i0 | PRJNA506002 | 58703 | 248 | 1.897143 | 4.70491464 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 113 | 3.2900000000000004e-27 | NR | KAH8171824.1 | 1610689 | g58457 | i0 | 87.3 | 0.762096774193548 | 63 | 8 | 76.2 | 0 | 3 | 191 | 480 | 542 | KAH8171824.1 malate synthase domain-containing protein [Sarocladium implicatum] | diamond | 189 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 10687730 | 10687730 | PRJNA506002_S_NODE_39489_length_283_cov_1.833333_g39243_i0 | PRJNA506002 | 39489 | 283 | 1.833333 | 5.18833239 | Sarocladium strictum | 5046 | Fungi | Fungi | 83.2 | 3.96e-18 | NR | KAL2212624.1 | 5046 | g39243 | i0 | 88.4 | 0.45583038869258 | 43 | 5 | 45.6 | 0 | 2 | 130 | 62 | 104 | KAL2212624.1 UPF0041-domain-containing protein [Sarocladium strictum] | diamond | 129 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 11962762 | 11962762 | PRJNA506002_S_NODE_45630_length_270_cov_1.172589_g45384_i0 | PRJNA506002 | 45630 | 270 | 1.172589 | 3.1659903 | Sarocladium strictum | 5046 | Fungi | Fungi | 133 | 1.51e-35 | NR | KAL2204586.1 | 5046 | g45384 | i0 | 76.4 | 0.8 | 72 | 17 | 80 | 0 | 216 | 1 | 85 | 156 | KAL2204586.1 hypothetical protein CC79DRAFT_1350969 [Sarocladium strictum] | diamond | 216 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 27203285 | 27203285 | PRJNA506002_S_NODE_64002_length_243_cov_1.811765_g63756_i0 | PRJNA506002 | 64002 | 243 | 1.811765 | 4.40258895 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 78.6 | 8.32e-15 | NR | KAH8174025.1 | 1610689 | g63756 | i0 | 94.7 | 0.469135802469136 | 38 | 2 | 46.9 | 0 | 243 | 130 | 403 | 440 | KAH8174025.1 aminomethyltransferase folate-binding domain-containing protein [Sarocladium implicatum] | diamond | 114 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 27424976 | 27424976 | PRJNA506002_S_NODE_14443_length_375_cov_2.728477_g14197_i0 | PRJNA506002 | 14443 | 375 | 2.728477 | 10.23178875 | Rhinocladiella mackenziei CBS 65 | 86056 | Fungi | Fungi | 64.7 | 3.41e-10 | NR | XP_013277619.1 | 1442369 | g14197 | i0 | 75 | 0.96 | 40 | 10 | 32 | 0 | 365 | 246 | 88 | 127 | XP_013277619.1 uncharacterized protein Z518_01566 [Rhinocladiella mackenziei CBS 650.93] | diamond | 360 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Rhinocladiella | Rhinocladiella mackenziei | |
| 27582532 | 27582532 | PRJNA506002_S_NODE_52124_length_257_cov_2.951087_g51878_i0 | PRJNA506002 | 52124 | 257 | 2.951087 | 7.58429359 | Sarocladium strictum | 5046 | Fungi | Fungi | 45.1 | 0.0064 | NR | KAK0385706.1 | 5046 | g51878 | i0 | 73.2 | 0.478599221789883 | 41 | 7 | 44.4 | 2 | 2 | 115 | 299 | 338 | KAK0385706.1 hypothetical protein NLU13_6883 [Sarocladium strictum] | diamond | 123 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 28213840 | 28213840 | PRJNA506002_S_NODE_44746_length_272_cov_1.070352_g44500_i0 | PRJNA506002 | 44746 | 272 | 1.070352 | 2.91135744 | Sarocladium strictum | 5046 | Fungi | Fungi | 89 | 5.22e-20 | NR | KAK0386860.1 | 5046 | g44500 | i0 | 84.7 | 0.650735294117647 | 59 | 9 | 65.1 | 0 | 267 | 91 | 107 | 165 | KAK0386860.1 hypothetical protein NLU13_5173 [Sarocladium strictum] | diamond | 177 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 28245432 | 28245432 | PRJNA506002_S_NODE_49906_length_261_cov_3.191489_g49660_i0 | PRJNA506002 | 49906 | 261 | 3.191489 | 8.32978629 | Sarocladium strictum | 5046 | Fungi | Fungi | 94.4 | 3.27e-20 | NR | KAK0387532.1 | 5046 | g49660 | i0 | 92.2 | 1.18390804597701 | 51 | 4 | 58.6 | 0 | 1 | 153 | 553 | 603 | KAK0387532.1 hypothetical protein NLU13_3778 [Sarocladium strictum] | diamond | 309 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 28813723 | 28813723 | PRJNA506002_S_NODE_20028_length_345_cov_1.801471_g19782_i0 | PRJNA506002 | 20028 | 345 | 1.801471 | 6.21507495 | Xanthoria steineri | 2905939 | Fungi | Fungi | 86.7 | 4.89e-17 | NR | KAI4222665.1 | 2905939 | g19782 | i0 | 88 | 0.434782608695652 | 50 | 6 | 43.5 | 0 | 280 | 131 | 406 | 455 | KAI4222665.1 MAG: hypothetical protein L6R36_005973 [Xanthoria steineri] | diamond | 150 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Teloschistales | Teloschistaceae | Xanthoria | Xanthoria steineri | |
| 28971948 | 28971948 | PRJNA506002_S_NODE_26748_length_318_cov_1.885714_g26502_i0 | PRJNA506002 | 26748 | 318 | 1.885714 | 5.99657052 | Aspergillus cristatus | 573508 | Fungi | Fungi | 43.9 | 0.0311 | NR | ODM23100.1 | 573508 | g26502 | i0 | 48.8 | 0.405660377358491 | 43 | 22 | 40.6 | 0 | 311 | 183 | 274 | 316 | ODM23100.1 hypothetical protein SI65_00689 [Aspergillus cristatus] | diamond | 129 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 30993433 | 30993433 | PRJNA506002_S_NODE_59414_length_248_cov_0.880000_g59168_i0 | PRJNA506002 | 59414 | 248 | 0.88 | 2.1824 | Phialemonium thermophilum | 223376 | Fungi | Fungi | 78.2 | 2.77e-16 | NR | KAL1864071.1 | 223376 | g59168 | i0 | 56.9 | 0.701612903225806 | 58 | 17 | 70.2 | 1 | 247 | 74 | 82 | 131 | KAL1864071.1 hypothetical protein VTK73DRAFT_6161 [Phialemonium thermophilum] | diamond | 174 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Cephalothecales | Cephalothecaceae | Phialemonium | Phialemonium thermophilum | |
| 31815466 | 31815466 | PRJNA506002_S_NODE_53317_length_255_cov_2.401099_g53071_i0 | PRJNA506002 | 53317 | 255 | 2.401099 | 6.12280245 | Sarocladium strictum | 5046 | Fungi | Fungi | 159 | 2.97e-44 | NR | KAK0389832.1 | 5046 | g53071 | i0 | 94.1 | 1 | 85 | 5 | 100 | 0 | 1 | 255 | 97 | 181 | KAK0389832.1 hypothetical protein NLU13_3405 [Sarocladium strictum] | diamond | 255 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum |
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);;