contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA772154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14776270 | 14776270 | PRJNA772154_P_NODE_20332_length_247_cov_0.896552_g20147_i0 | PRJNA772154 | 20332 | 247 | 0.896552 | 2.21448344 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 141 | 2.09e-38 | NR | XP_069231889.1 | 1052096 | g20147 | i0 | 93.9 | 0.995951417004049 | 82 | 5 | 99.6 | 0 | 246 | 1 | 166 | 247 | XP_069231889.1 uncharacterized protein WHR41_02538 [Cladosporium halotolerans] | diamond | 246 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27663245 | 27663245 | PRJNA772154_P_NODE_16204_length_267_cov_0.984536_g16019_i0 | PRJNA772154 | 16204 | 267 | 0.984536 | 2.62871112 | Hypocreales | 5125 | Fungi | Fungi | 45.8 | 0.00425 | NR | PNY28660.1 | 45235 | g16019 | i0 | 35.8 | 5.15730337078652 | 81 | 33 | 69.7 | 2 | 186 | 1 | 712 | 792 | PNY28660.1 Uncharacterized protein TCAP_01416 [Tolypocladium capitatum] | diamond | 1377 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Tolypocladium | Tolypocladium capitatum | |
| 27779970 | 27779970 | PRJNA772154_P_NODE_16044_length_268_cov_1.600000_g15859_i0 | PRJNA772154 | 16044 | 268 | 1.6 | 4.288 | Blumeria graminis f. sp. tritici 96224 | 1268274 | Fungi | Fungi | 124 | 3.909999999999999e-35 | NR | EPQ66094.1 | 1268274 | g15859 | i0 | 98.6 | 0.794776119402985 | 71 | 1 | 79.5 | 0 | 25 | 237 | 1 | 71 | EPQ66094.1 hypothetical protein BGT96224_331 [Blumeria graminis f. sp. tritici 96224] | diamond | 213 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 28190052 | 28190052 | PRJNA772154_P_NODE_19846_length_248_cov_0.891429_g19661_i0 | PRJNA772154 | 19846 | 248 | 0.891429 | 2.21074392 | Penicillium italicum | 40296 | Fungi | Fungi | 83.6 | 1.62e-16 | NR | KGO65600.1 | 40296 | g19661 | i0 | 100 | 0.495967741935484 | 41 | 0 | 49.6 | 0 | 1 | 123 | 492 | 532 | KGO65600.1 Major facilitator superfamily domain, general substrate transporter [Penicillium italicum] | diamond | 123 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium italicum | |
| 29484561 | 29484561 | PRJNA772154_P_NODE_22690_length_242_cov_0.923077_g22505_i0 | PRJNA772154 | 22690 | 242 | 0.923077 | 2.23384634 | Lambiella insularis | 1397036 | Fungi | Fungi | 54.3 | 2.99e-6 | NR | MCJ1476718.1 | 1397036 | g22505 | i0 | 72.2 | 0.446280991735537 | 36 | 10 | 44.6 | 0 | 3 | 110 | 385 | 420 | MCJ1476718.1 hypothetical protein [Lambiella insularis] | diamond | 108 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Lambiella | Lambiella insularis | |
| 30211066 | 30211066 | PRJNA772154_P_NODE_17572_length_253_cov_0.866667_g17387_i0 | PRJNA772154 | 17572 | 253 | 0.866667 | 2.19266751 | Hortaea werneckii | 91943 | Fungi | Fungi | 43.9 | 0.0136 | NR | KAI7231445.1 | 91943 | g17387 | i0 | 50 | 0.49802371541502 | 42 | 18 | 49.8 | 1 | 195 | 70 | 185 | 223 | KAI7231445.1 ubiquitin carboxyl-terminal hydrolase 2, partial [Hortaea werneckii] | diamond | 126 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 30379178 | 30379178 | PRJNA772154_P_NODE_19312_length_249_cov_0.886364_g19127_i0 | PRJNA772154 | 19312 | 249 | 0.886364 | 2.20704636 | Cladophialophora | 82105 | Fungi | Fungi | 128 | 2.43e-32 | NR | KAJ9604603.1 | 386627 | g19127 | i0 | 76.8 | 3.95180722891566 | 82 | 19 | 98.8 | 0 | 2 | 247 | 299 | 380 | KAJ9604603.1 hypothetical protein H2200_010717 [Cladophialophora chaetospira] | diamond | 984 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora chaetospira | |
| 30821173 | 30821173 | PRJNA772154_P_NODE_19674_length_249_cov_0.886364_g19489_i0 | PRJNA772154 | 19674 | 249 | 0.886364 | 2.20704636 | Histoplasma | 5036 | Fungi | Fungi | 42.7 | 0.0269 | NR | KAG5304146.1 | 5037 | g19489 | i0 | 28.9 | 1.83132530120482 | 76 | 45 | 85.5 | 2 | 25 | 237 | 52 | 123 | KAG5304146.1 hypothetical protein I7I52_02384 [Histoplasma capsulatum] | diamond | 456 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Histoplasma | Histoplasma capsulatum | |
| 31642931 | 31642931 | PRJNA772154_P_NODE_18536_length_251_cov_0.876404_g18351_i0 | PRJNA772154 | 18536 | 251 | 0.876404 | 2.19977404 | Penicillium | 5073 | Fungi | Fungi | 65.5 | 3.22e-10 | NR | XP_057128578.1 | 69791 | g18351 | i0 | 42.4 | 2.00796812749004 | 85 | 45 | 99.2 | 2 | 1 | 249 | 95 | 177 | XP_057128578.1 uncharacterized protein N7481_001527 [Penicillium waksmanii] | diamond | 504 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium waksmanii |
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);;