contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA492363" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25565587 | 25565587 | PRJNA492363_S_NODE_10665_length_296_cov_1.587234_g9844_i0 | PRJNA492363 | 10665 | 296 | 1.587234 | 4.69821264 | Candelaria pacifica | 460848 | Fungi | Fungi | 64.7 | 4.82e-10 | NR | KAI9706148.1 | 460848 | g9844 | i0 | 41.8 | 0.922297297297297 | 91 | 45 | 88.2 | 2 | 296 | 36 | 131 | 217 | KAI9706148.1 MAG: hypothetical protein M1812_008249 [Candelaria pacifica] | diamond | 273 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Candelariomycetes | Candelariales | Candelariaceae | Candelaria | Candelaria pacifica | |
| 25703430 | 25703430 | PRJNA492363_S_NODE_95154_length_204_cov_1.139860_g94333_i0 | PRJNA492363 | 95154 | 204 | 1.13986 | 2.3253144 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 115 | 3.98e-28 | NR | KAK5087141.1 | 1690604 | g94333 | i0 | 96.7 | 0.897058823529412 | 61 | 2 | 89.7 | 0 | 2 | 184 | 22 | 82 | KAK5087141.1 hypothetical protein LTR05_004312 [Lithohypha guttulata] | diamond | 183 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 26033533 | 26033533 | PRJNA492363_S_NODE_70300_length_223_cov_1.382716_g69479_i0 | PRJNA492363 | 70300 | 223 | 1.382716 | 3.08345668 | Knufia obscura | 1635080 | Fungi | Fungi | 114 | 1.2900000000000002e-27 | NR | XP_064733396.1 | 1635080 | g69479 | i0 | 76.5 | 0.914798206278027 | 68 | 16 | 91.5 | 0 | 221 | 18 | 325 | 392 | XP_064733396.1 uncharacterized protein PMZ80_002510 [Knufia obscura] | diamond | 204 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 26247719 | 26247719 | PRJNA492363_S_NODE_85822_length_209_cov_2.006757_g85001_i0 | PRJNA492363 | 85822 | 209 | 2.006757 | 4.19412213 | Orbilia oligospora ATCC 24927 | 756982 | Fungi | Fungi | 67.8 | 3.51e-11 | NR | XP_011125841.1 | 756982 | g85001 | i0 | 71.8 | 0.559808612440191 | 39 | 11 | 56 | 0 | 208 | 92 | 271 | 309 | XP_011125841.1 hypothetical protein AOL_s00169g182 [Orbilia oligospora ATCC 24927] | diamond | 117 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia oligospora | |
| 32917991 | 32917991 | PRJNA492363_S_NODE_105361_length_198_cov_2.116788_g104540_i0 | PRJNA492363 | 105361 | 198 | 2.116788 | 4.19124024 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 105 | 2.2999999999999994e-24 | NR | KAK5097878.1 | 1690604 | g104540 | i0 | 96.1 | 0.772727272727273 | 51 | 2 | 77.3 | 0 | 4 | 156 | 665 | 715 | KAK5097878.1 hypothetical protein LTS08_006633 [Lithohypha guttulata] | diamond | 153 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 32969641 | 32969641 | PRJNA492363_S_NODE_23514_length_245_cov_1.619565_g22693_i0 | PRJNA492363 | 23514 | 245 | 1.619565 | 3.96793425 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 91.7 | 9.47e-20 | NR | KAK5080779.1 | 1690604 | g22693 | i0 | 100 | 0.551020408163265 | 45 | 0 | 55.1 | 0 | 135 | 1 | 1 | 45 | KAK5080779.1 hypothetical protein LTR05_008484 [Lithohypha guttulata] | diamond | 135 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 32969773 | 32969773 | PRJNA492363_S_NODE_87866_length_208_cov_1.306122_g87045_i0 | PRJNA492363 | 87866 | 208 | 1.306122 | 2.71673376 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 59.7 | 2.37e-8 | NR | KAK5085269.1 | 1690604 | g87045 | i0 | 100 | 0.375 | 26 | 0 | 37.5 | 0 | 130 | 207 | 1 | 26 | KAK5085269.1 hypothetical protein LTR05_004550 [Lithohypha guttulata] | diamond | 78 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 33003681 | 33003681 | PRJNA492363_S_NODE_83891_length_210_cov_1.328859_g83070_i0 | PRJNA492363 | 83891 | 210 | 1.328859 | 2.7906039 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 75.5 | 2.57e-14 | NR | KAK5084213.1 | 1690604 | g83070 | i0 | 100 | 0.514285714285714 | 36 | 0 | 51.4 | 0 | 109 | 2 | 1 | 36 | KAK5084213.1 54S ribosomal protein L4 mitochondrial [Lithohypha guttulata] | diamond | 108 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 33009734 | 33009734 | PRJNA492363_S_NODE_9531_length_311_cov_1.536000_g8710_i0 | PRJNA492363 | 9531 | 311 | 1.536 | 4.77696 | Hyaloscypha | 47747 | Fungi | Fungi | 82.8 | 2.51e-16 | NR | XP_024742286.1 | 1095630 | g8710 | i0 | 75 | 2.19935691318328 | 56 | 14 | 54 | 0 | 7 | 174 | 116 | 171 | XP_024742286.1 uncharacterized protein K444DRAFT_607936 [Hyaloscypha bicolor E] | diamond | 684 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Hyaloscyphaceae | Hyaloscypha | Hyaloscypha bicolor | |
| 33020789 | 33020789 | PRJNA492363_S_NODE_97196_length_203_cov_0.901408_g96375_i0 | PRJNA492363 | 97196 | 203 | 0.901408 | 1.82985824 | Knufia obscura | 1635080 | Fungi | Fungi | 58.9 | 4.29e-8 | NR | XP_064726489.1 | 1635080 | g96375 | i0 | 61.4 | 0.650246305418719 | 44 | 17 | 65 | 0 | 133 | 2 | 1 | 44 | XP_064726489.1 uncharacterized protein PMZ80_009369 [Knufia obscura] | diamond | 132 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 33037697 | 33037697 | PRJNA492363_S_NODE_17364_length_251_cov_1.684211_g16543_i0 | PRJNA492363 | 17364 | 251 | 1.684211 | 4.22736961 | Xanthoria mediterranea | 408593 | Fungi | Fungi | 76.6 | 2.1e-14 | NR | KAI4097675.1 | 408593 | g16543 | i0 | 100 | 0.418326693227092 | 35 | 0 | 41.8 | 0 | 2 | 106 | 263 | 297 | KAI4097675.1 MAG: hypothetical protein LQ339_006720 [Xanthoria mediterranea] | diamond | 105 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Teloschistales | Teloschistaceae | Xanthoria | Xanthoria mediterranea | |
| 33054918 | 33054918 | PRJNA492363_S_NODE_95405_length_204_cov_0.895105_g94584_i0 | PRJNA492363 | 95405 | 204 | 0.895105 | 1.8260142 | Aspergillus taichungensis | 482145 | Fungi | Fungi | 132 | 4.48e-34 | NR | PLN76819.1 | 482145 | g94584 | i0 | 93.9 | 0.970588235294118 | 66 | 4 | 97.1 | 0 | 5 | 202 | 377 | 442 | PLN76819.1 diacylglycerol acyltransferase family [Aspergillus taichungensis] | diamond | 198 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus taichungensis | |
| 33106037 | 33106037 | PRJNA492363_S_NODE_73158_length_221_cov_2.000000_g72337_i0 | PRJNA492363 | 73158 | 221 | 2 | 4.42 | Knufia obscura | 1635080 | Fungi | Fungi | 56.2 | 4.79e-7 | NR | XP_064727209.1 | 1635080 | g72337 | i0 | 39.7 | 0.787330316742081 | 58 | 35 | 78.7 | 0 | 45 | 218 | 51 | 108 | XP_064727209.1 uncharacterized protein PMZ80_008422 [Knufia obscura] | diamond | 174 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 33174224 | 33174224 | PRJNA492363_S_NODE_11432_length_287_cov_0.849558_g10611_i0 | PRJNA492363 | 11432 | 287 | 0.849558 | 2.43823146 | Aspergillus fischeri | 36630 | Fungi | Fungi | 120 | 1.78e-30 | NR | KAG2026562.1 | 36630 | g10611 | i0 | 74.1 | 0.846689895470383 | 81 | 21 | 84.7 | 0 | 247 | 5 | 172 | 252 | KAG2026562.1 hypothetical protein GB937_001343 [Aspergillus fischeri] | diamond | 243 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fischeri |
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);;