contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3998578 | 3998578 | PRJNA1046144_P_NODE_28344_length_314_cov_1.493878_g28049_i0 | PRJNA1046144 | 28344 | 314 | 1.493878 | 4.69077692 | Ascomycota | 4890 | Fungi | Fungi | 164 | 2.53e-44 | NR | KAG9790352.1 | 46634 | g28049 | i0 | 83.8 | 15.0095541401274 | 99 | 16 | 94.6 | 0 | 314 | 18 | 906 | 1004 | KAG9790352.1 hypothetical protein KCU88_g1234, partial [Aureobasidium melanogenum] | diamond | 4713 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 18024409 | 18024409 | PRJNA1046144_P_NODE_55875_length_235_cov_1.506024_g55580_i0 | PRJNA1046144 | 55875 | 235 | 1.506024 | 3.5391564 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 143 | 2.39e-40 | NR | XP_069227386.1 | 1052096 | g55580 | i0 | 88.9 | 1.82553191489362 | 72 | 8 | 91.9 | 0 | 216 | 1 | 1 | 72 | XP_069227386.1 uncharacterized protein WHR41_06818 [Cladosporium halotolerans] | diamond | 429 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26678739 | 26678739 | PRJNA1046144_P_NODE_61741_length_231_cov_0.888889_g61446_i0 | PRJNA1046144 | 61741 | 231 | 0.888889 | 2.05333359 | Sarocladium | 284134 | Fungi | Fungi | 84.3 | 1.28e-17 | NR | KAK0391652.1 | 5046 | g61446 | i0 | 95.2 | 1.11688311688312 | 42 | 2 | 54.5 | 0 | 225 | 100 | 21 | 62 | KAK0391652.1 hypothetical protein NLU13_1151 [Sarocladium strictum] | diamond | 258 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 26940167 | 26940167 | PRJNA1046144_P_NODE_60222_length_232_cov_0.883436_g59927_i0 | PRJNA1046144 | 60222 | 232 | 0.883436 | 2.04957152 | Podosphaera aphanis | 79252 | Fungi | Fungi | 68.2 | 1.08e-11 | NR | KAI0991384.1 | 79252 | g59927 | i0 | 44.3 | 1.90086206896552 | 70 | 39 | 90.5 | 0 | 210 | 1 | 125 | 194 | KAI0991384.1 hypothetical protein K3495_g16803, partial [Podosphaera aphanis] | diamond | 441 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera aphanis | |
| 26940169 | 26940169 | PRJNA1046144_P_NODE_61842_length_231_cov_0.888889_g61547_i0 | PRJNA1046144 | 61842 | 231 | 0.888889 | 2.05333359 | Penicillium nucicola | 1850975 | Fungi | Fungi | 42.7 | 0.0318 | NR | XP_056982059.1 | 1850975 | g61547 | i0 | 40 | 0.779220779220779 | 60 | 29 | 70.1 | 3 | 205 | 44 | 531 | 589 | XP_056982059.1 uncharacterized protein N7511_007899 [Penicillium nucicola] | diamond | 180 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium nucicola | |
| 28606235 | 28606235 | PRJNA1046144_P_NODE_63587_length_230_cov_0.894410_g63292_i0 | PRJNA1046144 | 63587 | 230 | 0.89441 | 2.057143 | Purpureocillium | 1052105 | Fungi | Fungi | 61.6 | 6.85e-9 | NR | PWI69477.1 | 33203 | g63292 | i0 | 81.6 | 3.52173913043478 | 38 | 7 | 49.6 | 0 | 10 | 123 | 503 | 540 | PWI69477.1 hypothetical protein PCL_01124 [Purpureocillium lilacinum] | diamond | 810 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 29340654 | 29340654 | PRJNA1046144_P_NODE_65189_length_229_cov_0.900000_g64894_i0 | PRJNA1046144 | 65189 | 229 | 0.9 | 2.061 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 44.7 | 9.95e-4 | NR | XP_069229215.1 | 1052096 | g64894 | i0 | 87.5 | 0.62882096069869 | 24 | 3 | 31.4 | 0 | 157 | 228 | 1 | 24 | XP_069229215.1 uncharacterized protein WHR41_04749 [Cladosporium halotolerans] | diamond | 144 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29466460 | 29466460 | PRJNA1046144_P_NODE_66550_length_228_cov_0.905660_g66255_i0 | PRJNA1046144 | 66550 | 228 | 0.90566 | 2.0649048 | Sarocladium strictum | 5046 | Fungi | Fungi | 157 | 8.73e-43 | NR | KAK0391472.1 | 5046 | g66255 | i0 | 96 | 1.97368421052632 | 75 | 3 | 98.7 | 0 | 226 | 2 | 90 | 164 | KAK0391472.1 hypothetical protein NLU13_0973 [Sarocladium strictum] | diamond | 450 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29592707 | 29592707 | PRJNA1046144_P_NODE_60390_length_232_cov_0.883436_g60095_i0 | PRJNA1046144 | 60390 | 232 | 0.883436 | 2.04957152 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 90.1 | 6.63e-19 | NR | XP_069229444.1 | 1052096 | g60095 | i0 | 81.1 | 0.956896551724138 | 74 | 12 | 95.7 | 1 | 9 | 230 | 1 | 72 | XP_069229444.1 uncharacterized protein WHR41_05413 [Cladosporium halotolerans] | diamond | 222 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30635390 | 30635390 | PRJNA1046144_P_NODE_56353_length_235_cov_0.867470_g56058_i0 | PRJNA1046144 | 56353 | 235 | 0.86747 | 2.0385545 | Golovinomyces magnicellulatus | 62714 | Fungi | Fungi | 108 | 1.58e-28 | NR | TQS38765.1 | 62714 | g56058 | i0 | 92.4 | 0.842553191489362 | 66 | 4 | 83 | 1 | 235 | 41 | 50 | 115 | TQS38765.1 hypothetical protein Golomagni_00721 [Golovinomyces magnicellulatus] | diamond | 198 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces magnicellulatus | |
| 30753918 | 30753918 | PRJNA1046144_P_NODE_46154_length_256_cov_2.064171_g45859_i0 | PRJNA1046144 | 46154 | 256 | 2.064171 | 5.28427776 | Sordariomycetes | 147550 | Fungi | Fungi | 162 | 1.41e-44 | NR | KAK0387323.1 | 5046 | g45859 | i0 | 91.7 | 3.9375 | 84 | 7 | 98.4 | 0 | 254 | 3 | 73 | 156 | KAK0387323.1 hypothetical protein NLU13_5636 [Sarocladium strictum] | diamond | 1008 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30793461 | 30793461 | PRJNA1046144_P_NODE_50074_length_247_cov_2.696629_g49779_i0 | PRJNA1046144 | 50074 | 247 | 2.696629 | 6.66067363 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 161 | 2.42e-46 | NR | KAK0360393.1 | 329885 | g49779 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 247 | 2 | 176 | 257 | KAK0360393.1 hypothetical protein LTR94_027482, partial [Friedmanniomyces endolithicus] | diamond | 246 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 30848690 | 30848690 | PRJNA1046144_P_NODE_42434_length_265_cov_1.750000_g42139_i0 | PRJNA1046144 | 42434 | 265 | 1.75 | 4.6375 | Phaeosphaeriaceae | 5020 | Fungi | Fungi | 61.6 | 1.1e-8 | NR | KAH4941100.1 | 13684 | g42139 | i0 | 87.5 | 2.53584905660377 | 32 | 4 | 36.2 | 0 | 3 | 98 | 1940 | 1971 | KAH4941100.1 hypothetical protein HBI79_032670 [Parastagonospora nodorum] | diamond | 672 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 31014699 | 31014699 | PRJNA1046144_P_NODE_40255_length_271_cov_1.123762_g39960_i0 | PRJNA1046144 | 40255 | 271 | 1.123762 | 3.04539502 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 144 | 3.75e-38 | NR | XP_069231876.1 | 1052096 | g39960 | i0 | 82.9 | 0.907749077490775 | 82 | 14 | 90.8 | 0 | 1 | 246 | 348 | 429 | XP_069231876.1 uncharacterized protein WHR41_02577 [Cladosporium halotolerans] | diamond | 246 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 31014700 | 31014700 | PRJNA1046144_P_NODE_42275_length_266_cov_1.020305_g41980_i0 | PRJNA1046144 | 42275 | 266 | 1.020305 | 2.7140113 | Podosphaera aphanis | 79252 | Fungi | Fungi | 137 | 3.3899999999999996e-37 | NR | KAI0995829.1 | 79252 | g41980 | i0 | 74.7 | 1.8609022556391 | 83 | 20 | 93.6 | 1 | 3 | 251 | 158 | 239 | KAI0995829.1 hypothetical protein K3495_g12352 [Podosphaera aphanis] | diamond | 495 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera aphanis | |
| 31267558 | 31267558 | PRJNA1046144_P_NODE_61415_length_231_cov_1.740741_g61120_i0 | PRJNA1046144 | 61415 | 231 | 1.740741 | 4.02111171 | Knufia obscura | 1635080 | Fungi | Fungi | 56.6 | 1.87e-8 | NR | XP_064729107.1 | 1635080 | g61120 | i0 | 68.8 | 0.623376623376623 | 48 | 14 | 61 | 1 | 2 | 142 | 33 | 80 | XP_064729107.1 uncharacterized protein PMZ80_006294 [Knufia obscura] | diamond | 144 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 31299146 | 31299146 | PRJNA1046144_P_NODE_54295_length_238_cov_1.704142_g54000_i0 | PRJNA1046144 | 54295 | 238 | 1.704142 | 4.05585796 | Diaporthe sp. PMI_573 | 2614600 | Fungi | Fungi | 79.7 | 3.3e-15 | NR | KAH8772585.1 | 2614600 | g54000 | i0 | 53.2 | 4.04621848739496 | 79 | 37 | 99.6 | 0 | 237 | 1 | 128 | 206 | KAH8772585.1 hypothetical protein F5883DRAFT_34304 [Diaporthe sp. PMI_573] | diamond | 963 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe sp. PMI_573 | |
| 31741860 | 31741860 | PRJNA1046144_P_NODE_59497_length_233_cov_0.878049_g59202_i0 | PRJNA1046144 | 59497 | 233 | 0.878049 | 2.04585417 | Sarocladium strictum | 5046 | Fungi | Fungi | 115 | 5.85e-28 | NR | KAK0392120.1 | 5046 | g59202 | i0 | 79.2 | 0.991416309012876 | 77 | 16 | 99.1 | 0 | 1 | 231 | 547 | 623 | KAK0392120.1 hypothetical protein NLU13_1618 [Sarocladium strictum] | diamond | 231 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 32058310 | 32058310 | PRJNA1046144_P_NODE_46798_length_255_cov_1.301075_g46503_i0 | PRJNA1046144 | 46798 | 255 | 1.301075 | 3.31774125 | Neolecta irregularis DAH-3 | 1198029 | Fungi | Fungi | 70.9 | 1.24e-13 | NR | OLL27145.1 | 1198029 | g46503 | i0 | 54.4 | 0.8 | 68 | 27 | 75.3 | 1 | 192 | 1 | 5 | 72 | OLL27145.1 60S ribosomal protein L36 [Neolecta irregularis DAH-3] | diamond | 204 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Neolectomycetes | Neolectales | Neolectaceae | Neolecta | Neolecta irregularis | |
| 32081843 | 32081843 | PRJNA1046144_P_NODE_63878_length_230_cov_0.894410_g63583_i0 | PRJNA1046144 | 63878 | 230 | 0.89441 | 2.057143 | Pleosporales | 92860 | Fungi | Fungi | 105 | 5.47e-27 | NR | KAF2035163.1 | 210430 | g63583 | i0 | 68.1 | 2.89565217391304 | 72 | 23 | 93.9 | 0 | 229 | 14 | 14 | 85 | KAF2035163.1 hypothetical protein EK21DRAFT_54834 [Setomelanomma holmii] | diamond | 666 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Setomelanomma | Setomelanomma holmii | |
| 32216640 | 32216640 | PRJNA1046144_P_NODE_51758_length_244_cov_1.308571_g51463_i0 | PRJNA1046144 | 51758 | 244 | 1.308571 | 3.19291324 | Periconia digitata | 1303443 | Fungi | Fungi | 149 | 6.769999999999999e-43 | NR | CAI6338253.1 | 1303443 | g51463 | i0 | 88.8 | 0.983606557377049 | 80 | 9 | 98.4 | 0 | 3 | 242 | 8 | 87 | CAI6338253.1 unnamed protein product [Periconia digitata] | diamond | 240 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 32501581 | 32501581 | PRJNA1046144_P_NODE_69559_length_226_cov_0.917197_g69264_i0 | PRJNA1046144 | 69559 | 226 | 0.917197 | 2.07286522 | Sarocladium strictum | 5046 | Fungi | Fungi | 127 | 4.98e-32 | NR | KAK0388221.1 | 5046 | g69264 | i0 | 90.9 | 2.6283185840708 | 66 | 6 | 87.6 | 0 | 225 | 28 | 824 | 889 | KAK0388221.1 hypothetical protein NLU13_4466 [Sarocladium strictum] | diamond | 594 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 32690418 | 32690418 | PRJNA1046144_P_NODE_60360_length_232_cov_0.883436_g60065_i0 | PRJNA1046144 | 60360 | 232 | 0.883436 | 2.04957152 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 81.3 | 6.22e-16 | NR | XP_069229386.1 | 1052096 | g60065 | i0 | 69.2 | 0.84051724137931 | 65 | 20 | 84.1 | 0 | 195 | 1 | 35 | 99 | XP_069229386.1 uncharacterized protein WHR41_05525 [Cladosporium halotolerans] | diamond | 195 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans |
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);;