contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA609258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5691180 | 5691180 | PRJNA609258_P_NODE_45305_length_268_cov_2.051282_g44920_i0 | PRJNA609258 | 45305 | 268 | 2.051282 | 5.49743576 | Penicillium cinerascens | 70096 | Fungi | Fungi | 171 | 2.78e-47 | NR | XP_058307134.1 | 70096 | g44920 | i0 | 94.4 | 6.97388059701493 | 89 | 5 | 99.6 | 0 | 1 | 267 | 427 | 515 | XP_058307134.1 uncharacterized protein N7498_007823 [Penicillium cinerascens] | diamond | 1869 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium cinerascens | |
| 20990305 | 20990305 | PRJNA609258_P_NODE_56237_length_246_cov_0.901734_g55852_i0 | PRJNA609258 | 56237 | 246 | 0.901734 | 2.21826564 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 154 | 1.8e-41 | NR | XP_069225257.1 | 1052096 | g55852 | i0 | 93.8 | 3.90243902439024 | 80 | 5 | 97.6 | 0 | 244 | 5 | 150 | 229 | XP_069225257.1 uncharacterized protein WHR41_09031 [Cladosporium halotolerans] | diamond | 960 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 22264872 | 22264872 | PRJNA609258_P_NODE_50858_length_252_cov_0.871508_g50473_i0 | PRJNA609258 | 50858 | 252 | 0.871508 | 2.19620016 | Meyerozyma sp. JA9 | 2028340 | Fungi | Fungi | 171 | 4.41e-49 | NR | RLV86257.1 | 2028340 | g50473 | i0 | 100 | 1.97619047619048 | 83 | 0 | 98.8 | 0 | 251 | 3 | 125 | 207 | RLV86257.1 Fumarate hydratase mitochondrial [Meyerozyma sp. JA9] | diamond | 498 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma sp. JA9 | |
| 27617369 | 27617369 | PRJNA609258_P_NODE_52244_length_250_cov_0.881356_g51859_i0 | PRJNA609258 | 52244 | 250 | 0.881356 | 2.20339 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 150 | 1.0399999999999997e-42 | NR | XP_069227621.1 | 1052096 | g51859 | i0 | 85.4 | 0.984 | 82 | 12 | 98.4 | 0 | 3 | 248 | 184 | 265 | XP_069227621.1 uncharacterized protein WHR41_07069 [Cladosporium halotolerans] | diamond | 246 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28311923 | 28311923 | PRJNA609258_P_NODE_50546_length_252_cov_0.871508_g50161_i0 | PRJNA609258 | 50546 | 252 | 0.871508 | 2.19620016 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 47.8 | 6.95e-4 | NR | XP_064699104.1 | 574656 | g50161 | i0 | 34.6 | 0.964285714285714 | 81 | 50 | 96.4 | 2 | 245 | 3 | 11 | 88 | XP_064699104.1 uncharacterized protein LTS14_000121 [Recurvomyces mirabilis] | diamond | 243 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 28564486 | 28564486 | PRJNA609258_P_NODE_59907_length_242_cov_0.923077_g59522_i0 | PRJNA609258 | 59907 | 242 | 0.923077 | 2.23384634 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 124 | 1e-30 | NR | XP_069230624.1 | 1052096 | g59522 | i0 | 78.5 | 0.979338842975207 | 79 | 11 | 97.9 | 1 | 238 | 2 | 15 | 87 | XP_069230624.1 uncharacterized protein WHR41_03922 [Cladosporium halotolerans] | diamond | 237 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28785284 | 28785284 | PRJNA609258_P_NODE_22467_length_400_cov_1.021407_g22083_i0 | PRJNA609258 | 22467 | 400 | 1.021407 | 4.085628 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 154 | 3.88e-45 | NR | XP_069234340.1 | 1052096 | g22083 | i0 | 78.6 | 0.84 | 112 | 23 | 84 | 1 | 339 | 4 | 1 | 111 | XP_069234340.1 uncharacterized protein WHR41_00260 [Cladosporium halotolerans] | diamond | 336 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29038320 | 29038320 | PRJNA609258_P_NODE_58948_length_243_cov_0.917647_g58563_i0 | PRJNA609258 | 58948 | 243 | 0.917647 | 2.22988221 | Sarocladium strictum | 5046 | Fungi | Fungi | 93.6 | 4.47e-20 | NR | KAK0385525.1 | 5046 | g58563 | i0 | 59 | 1.02469135802469 | 83 | 31 | 98.8 | 1 | 240 | 1 | 73 | 155 | KAK0385525.1 hypothetical protein NLU13_6705 [Sarocladium strictum] | diamond | 249 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30030179 | 30030179 | PRJNA609258_P_NODE_46491_length_263_cov_2.278947_g46106_i0 | PRJNA609258 | 46491 | 263 | 2.278947 | 5.99363061 | Eukaryota | 2759 | Fungi | Fungi | 59.3 | 6.85e-8 | NR | KAF5093929.1 | 27317 | g46106 | i0 | 36.6 | 2.89733840304183 | 82 | 51 | 93.5 | 1 | 8 | 253 | 291 | 371 | KAF5093929.1 hypothetical protein D0Z00_003777 [Geotrichum galactomycetum] | diamond | 762 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum galactomycetum | |
| 30553899 | 30553899 | PRJNA609258_P_NODE_42093_length_281_cov_1.875000_g41708_i0 | PRJNA609258 | 42093 | 281 | 1.875 | 5.26875 | Microsporum canis CBS 11348 | 63405 | Fungi | Fungi | 47.4 | 0.00135 | NR | XP_002843532.1 | 554155 | g41708 | i0 | 32.5 | 0.822064056939502 | 77 | 50 | 82.2 | 1 | 9 | 239 | 396 | 470 | XP_002843532.1 ankyrin repeat domain-containing protein 44 [Microsporum canis CBS 113480] | diamond | 231 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Microsporum | Microsporum canis | |
| 30598655 | 30598655 | PRJNA609258_P_NODE_54593_length_248_cov_0.891429_g54208_i0 | PRJNA609258 | 54593 | 248 | 0.891429 | 2.21074392 | Herpotrichiellaceae | 43219 | Fungi | Fungi | 130 | 3.68e-35 | NR | OCT52748.1 | 86049 | g54208 | i0 | 72 | 9.91935483870968 | 82 | 23 | 99.2 | 0 | 3 | 248 | 105 | 186 | OCT52748.1 MFS monocarboxylate transporter [Cladophialophora carrionii] | diamond | 2460 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora carrionii | |
| 31926511 | 31926511 | PRJNA609258_P_NODE_51277_length_251_cov_0.876404_g50892_i0 | PRJNA609258 | 51277 | 251 | 0.876404 | 2.19977404 | Phaeosphaeriaceae | 5020 | Fungi | Fungi | 149 | 1.43e-39 | NR | KAF2031233.1 | 210430 | g50892 | i0 | 89.2 | 15.8725099601594 | 83 | 9 | 99.2 | 0 | 250 | 2 | 1164 | 1246 | KAF2031233.1 hypothetical protein EK21DRAFT_63579 [Setomelanomma holmii] | diamond | 3984 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Setomelanomma | Setomelanomma holmii | |
| 32053107 | 32053107 | PRJNA609258_P_NODE_23998_length_385_cov_6.141026_g23614_i0 | PRJNA609258 | 23998 | 385 | 6.141026 | 23.6429501 | Teloschistaceae | 88646 | Fungi | Fungi | 164 | 1.47e-44 | NR | KAI4229015.1 | 262315 | g23614 | i0 | 60.9 | 25.8233766233766 | 128 | 50 | 99.7 | 0 | 385 | 2 | 54 | 181 | KAI4229015.1 MAG: hypothetical protein LQ349_006456 [Xanthoria aureola] | diamond | 9942 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Teloschistales | Teloschistaceae | Xanthoria | Xanthoria aureola |
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);;