contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27157422 | 27157422 | PRJNA792582_P_NODE_54502_length_246_cov_0.890173_g53688_i0 | PRJNA792582 | 54502 | 246 | 0.890173 | 2.18982558 | Ascomycota | 4890 | Fungi | Fungi | 53.1 | 8.4e-6 | NR | RPA79061.1 | 1160509 | g53688 | i0 | 41.8 | 4.08536585365854 | 67 | 20 | 81.7 | 1 | 245 | 45 | 1629 | 1676 | RPA79061.1 beta and beta-prime subunits of DNA dependent RNA-polymerase [Ascobolus immersus RN42] | diamond | 1005 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascobolaceae | Ascobolus | Ascobolus immersus | |
| 27464731 | 27464731 | PRJNA792582_P_NODE_46343_length_260_cov_1.770053_g45529_i0 | PRJNA792582 | 46343 | 260 | 1.770053 | 4.6021378 | Trichocladium antarcticum | 1450529 | Fungi | Fungi | 42.7 | 0.0426 | NR | KAK4136691.1 | 1450529 | g45529 | i0 | 49 | 0.565384615384615 | 49 | 15 | 56.5 | 1 | 98 | 244 | 257 | 295 | KAK4136691.1 hypothetical protein BT67DRAFT_188219 [Trichocladium antarcticum] | diamond | 147 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Trichocladium | Trichocladium antarcticum | |
| 27852568 | 27852568 | PRJNA792582_P_NODE_21224_length_374_cov_1.023256_g20410_i0 | PRJNA792582 | 21224 | 374 | 1.023256 | 3.82697744 | Eukaryota | 2759 | Fungi | Fungi | 133 | 1.43e-35 | NR | KAK0296463.1 | 329885 | g20410 | i0 | 57.1 | 3.03208556149733 | 126 | 49 | 97.1 | 3 | 363 | 1 | 5 | 130 | KAK0296463.1 Thymidylate kinase [Friedmanniomyces endolithicus] | diamond | 1134 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 28357664 | 28357664 | PRJNA792582_P_NODE_52266_length_248_cov_2.194286_g51452_i0 | PRJNA792582 | 52266 | 248 | 2.194286 | 5.44182928 | Opisthokonta | 33154 | Fungi | Fungi | 47.8 | 6.73e-4 | NR | XP_069214629.1 | 85995 | g51452 | i0 | 36.4 | 1.45161290322581 | 77 | 45 | 88.3 | 2 | 30 | 248 | 117 | 193 | XP_069214629.1 uncharacterized protein VTJ04DRAFT_9894 [Mycothermus thermophilus] | diamond | 360 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Mycothermus | Mycothermus thermophilus | |
| 28578955 | 28578955 | PRJNA792582_P_NODE_23467_length_356_cov_1.088339_g22653_i0 | PRJNA792582 | 23467 | 356 | 1.088339 | 3.87448684 | Fungi | 4751 | Fungi | Fungi | 63.2 | 8.86e-9 | NR | KAI1003562.1 | 79252 | g22653 | i0 | 53.4 | 4.25561797752809 | 58 | 26 | 48 | 1 | 64 | 234 | 297 | 354 | KAI1003562.1 hypothetical protein K3495_g4652 [Podosphaera aphanis] | diamond | 1515 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera aphanis | |
| 28727593 | 28727593 | PRJNA792582_P_NODE_54987_length_246_cov_0.890173_g54173_i0 | PRJNA792582 | 54987 | 246 | 0.890173 | 2.18982558 | Venturia nashicola | 86259 | Fungi | Fungi | 149 | 1.3e-39 | NR | TLD08007.1 | 86259 | g54173 | i0 | 84 | 0.98780487804878 | 81 | 13 | 98.8 | 0 | 3 | 245 | 229 | 309 | TLD08007.1 hypothetical protein E2P81_ATG10132 [Venturia nashicola] | diamond | 243 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Venturiaceae | Venturia | Venturia nashicola | |
| 29295874 | 29295874 | PRJNA792582_P_NODE_8189_length_589_cov_1.488372_g7395_i0 | PRJNA792582 | 8189 | 589 | 1.488372 | 8.76651108 | Saitoella complicata NRRL Y-178 | 5606 | Fungi | Fungi | 78.2 | 8.96e-14 | NR | XP_019023484.1 | 698492 | g7395 | i0 | 47.6 | 0.835314091680815 | 82 | 40 | 40.7 | 2 | 27 | 266 | 3 | 83 | XP_019023484.1 uncharacterized protein SAICODRAFT_133906 [Saitoella complicata NRRL Y-17804] | diamond | 492 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 29800944 | 29800944 | PRJNA792582_P_NODE_41071_length_275_cov_1.202970_g40257_i0 | PRJNA792582 | 41071 | 275 | 1.20297 | 3.3081675 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 66.6 | 2.26e-10 | NR | XP_461077.2 | 284592 | g40257 | i0 | 40.7 | 0.992727272727273 | 91 | 54 | 99.3 | 0 | 275 | 3 | 1667 | 1757 | XP_461077.2 DEHA2F16522p [Debaryomyces hansenii CBS767] | diamond | 273 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 29990655 | 29990655 | PRJNA792582_P_NODE_56731_length_244_cov_0.900585_g55917_i0 | PRJNA792582 | 56731 | 244 | 0.900585 | 2.1974274 | Trichophyton soudanense CBS 452.61 | 1215331 | Fungi | Fungi | 42.7 | 0.0394 | NR | EZF76159.1 | 1215331 | g55917 | i0 | 39.7 | 0.713114754098361 | 58 | 25 | 59 | 2 | 229 | 86 | 803 | 860 | EZF76159.1 hypothetical protein H105_02445 [Trichophyton soudanense CBS 452.61] | diamond | 174 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton soudanense | |
| 30157494 | 30157494 | PRJNA792582_P_NODE_57932_length_242_cov_2.325444_g57118_i0 | PRJNA792582 | 57932 | 242 | 2.325444 | 5.62757448 | Fungi | 4751 | Fungi | Fungi | 44.3 | 0.0108 | NR | XP_014084808.1 | 5016 | g57118 | i0 | 32.9 | 4.62396694214876 | 76 | 46 | 88 | 2 | 28 | 240 | 367 | 442 | XP_014084808.1 P-loop containing nucleoside triphosphate hydrolase protein [Bipolaris maydis] | diamond | 1119 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris maydis | |
| 30307064 | 30307064 | PRJNA792582_P_NODE_54452_length_246_cov_0.890173_g53638_i0 | PRJNA792582 | 54452 | 246 | 0.890173 | 2.18982558 | Clavispora lusitaniae | 36911 | Fungi | Fungi | 132 | 1.24e-34 | NR | XP_002618853.2 | 36911 | g53638 | i0 | 88.1 | 1.02439024390244 | 84 | 7 | 98.8 | 1 | 245 | 3 | 133 | 216 | XP_002618853.2 DNA replication and checkpoint family protein [Clavispora lusitaniae] | diamond | 252 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 30527668 | 30527668 | PRJNA792582_P_NODE_58853_length_241_cov_2.214286_g58039_i0 | PRJNA792582 | 58853 | 241 | 2.214286 | 5.33642926 | Botrytis porri | 87229 | Fungi | Fungi | 43.1 | 0.0149 | NR | XP_038771599.1 | 87229 | g58039 | i0 | 42.1 | 0.473029045643154 | 38 | 22 | 47.3 | 0 | 179 | 66 | 93 | 130 | XP_038771599.1 uncharacterized protein EAF01_005258 [Botrytis porri] | diamond | 114 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis porri | |
| 30653959 | 30653959 | PRJNA792582_P_NODE_53493_length_247_cov_0.885057_g52679_i0 | PRJNA792582 | 53493 | 247 | 0.885057 | 2.18609079 | Hanseniaspora guilliermondii | 56406 | Fungi | Fungi | 99.8 | 3.56e-22 | NR | SGZ39324.1 | 56406 | g52679 | i0 | 64.6 | 0.995951417004049 | 82 | 29 | 99.6 | 0 | 1 | 246 | 757 | 838 | SGZ39324.1 uncharacterized protein HGUI_01524 [Hanseniaspora guilliermondii] | diamond | 246 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora guilliermondii | |
| 31864406 | 31864406 | PRJNA792582_P_NODE_58417_length_242_cov_0.911243_g57603_i0 | PRJNA792582 | 58417 | 242 | 0.911243 | 2.20520806 | Helotiales | 5178 | Fungi | Fungi | 102 | 1.68e-23 | NR | CZR68178.1 | 576137 | g57603 | i0 | 67.7 | 3.07438016528926 | 62 | 20 | 76.9 | 0 | 27 | 212 | 363 | 424 | CZR68178.1 uncharacterized protein PAC_18077 [Phialocephala subalpina] | diamond | 744 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Mollisiaceae | Phialocephala | Phialocephala subalpina | |
| 31887006 | 31887006 | PRJNA792582_P_NODE_59457_length_241_cov_0.916667_g58643_i0 | PRJNA792582 | 59457 | 241 | 0.916667 | 2.20916747 | Lecanosticta acicola | 111012 | Fungi | Fungi | 79 | 6.42e-15 | NR | CAK4033863.1 | 111012 | g58643 | i0 | 52.5 | 0.995850622406639 | 80 | 34 | 99.6 | 2 | 2 | 241 | 278 | 353 | CAK4033863.1 cysteine ase [Lecanosticta acicola] | diamond | 240 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Lecanosticta | Lecanosticta acicola | |
| 32045344 | 32045344 | PRJNA792582_P_NODE_55958_length_245_cov_0.895349_g55144_i0 | PRJNA792582 | 55958 | 245 | 0.895349 | 2.19360505 | Alternaria alternata | 5599 | Fungi | Fungi | 47.4 | 8.67e-4 | NR | XP_018380026.1 | 5599 | g55144 | i0 | 41.7 | 1.17551020408163 | 48 | 28 | 58.8 | 0 | 185 | 42 | 380 | 427 | XP_018380026.1 acid protease, partial [Alternaria alternata] | diamond | 288 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 32172039 | 32172039 | PRJNA792582_P_NODE_44598_length_265_cov_1.859375_g43784_i0 | PRJNA792582 | 44598 | 265 | 1.859375 | 4.92734375 | Zasmidium cellare | 395010 | Fungi | Fungi | 144 | 5.9e-40 | NR | KAK4494753.1 | 395010 | g43784 | i0 | 82.8 | 1.95849056603774 | 87 | 13 | 98.5 | 1 | 3 | 263 | 2 | 86 | KAK4494753.1 hypothetical protein PRZ48_014109 [Zasmidium cellare] | diamond | 519 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 32298767 | 32298767 | PRJNA792582_P_NODE_59159_length_241_cov_0.916667_g58345_i0 | PRJNA792582 | 59159 | 241 | 0.916667 | 2.20916747 | Cercophora scortea | 314031 | Fungi | Fungi | 42 | 0.0363 | NR | KAK3323979.1 | 314031 | g58345 | i0 | 31.4 | 0.871369294605809 | 70 | 42 | 87.1 | 1 | 30 | 239 | 4 | 67 | KAK3323979.1 hypothetical protein B0T19DRAFT_218952 [Cercophora scortea] | diamond | 210 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Cercophora | Cercophora scortea | |
| 32361941 | 32361941 | PRJNA792582_P_NODE_52279_length_248_cov_2.057143_g51465_i0 | PRJNA792582 | 52279 | 248 | 2.057143 | 5.10171464 | Coniosporium apollinis CBS 1 | 61459 | Fungi | Fungi | 68.2 | 7.45e-13 | NR | XP_007778305.1 | 1168221 | g51465 | i0 | 67.4 | 0.520161290322581 | 43 | 14 | 52 | 0 | 130 | 2 | 1 | 43 | XP_007778305.1 uncharacterized protein W97_02214 [Coniosporium apollinis CBS 100218] | diamond | 129 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Coniosporium | Coniosporium apollinis | |||
| 32393354 | 32393354 | PRJNA792582_P_NODE_59219_length_241_cov_0.916667_g58405_i0 | PRJNA792582 | 59219 | 241 | 0.916667 | 2.20916747 | Stagonosporopsis vannaccii | 2606854 | Fungi | Fungi | 139 | 4.61e-36 | NR | KAJ4993100.1 | 2606854 | g58405 | i0 | 92.5 | 0.995850622406639 | 80 | 5 | 99.6 | 1 | 1 | 240 | 478 | 556 | KAJ4993100.1 hypothetical protein SVAN01_01452 [Stagonosporopsis vannaccii] | diamond | 240 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Stagonosporopsis | Stagonosporopsis vannaccii | |
| 32740677 | 32740677 | PRJNA792582_P_NODE_56740_length_244_cov_0.900585_g55926_i0 | PRJNA792582 | 56740 | 244 | 0.900585 | 2.1974274 | Aspergillus nanangensis | 2582783 | Fungi | Fungi | 90.9 | 7.46e-20 | NR | KAF9888572.1 | 2582783 | g55926 | i0 | 57.8 | 1.02049180327869 | 83 | 32 | 98.4 | 1 | 5 | 244 | 73 | 155 | KAF9888572.1 hypothetical protein FE257_008504 [Aspergillus nanangensis] | diamond | 249 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nanangensis |
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);;