contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA448207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26823048 | 26823048 | PRJNA448207_S_NODE_2961_length_268_cov_1.107692_g2950_i0 | PRJNA448207 | 2961 | 268 | 1.107692 | 2.96861456 | Wilcoxina mikolae CBS 423.85 | 1314677 | Fungi | Fungi | 68.9 | 2.95e-11 | NR | KAF8249225.1 | 1314677 | g2950 | i0 | 38.6 | 1.97014925373134 | 88 | 54 | 98.5 | 0 | 267 | 4 | 192 | 279 | KAF8249225.1 DEAD-domain-containing protein [Wilcoxina mikolae CBS 423.85] | diamond | 528 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Wilcoxina | Wilcoxina mikolae | |
| 26854805 | 26854805 | PRJNA448207_P_NODE_16181_length_318_cov_1.012245_g16018_i0 | PRJNA448207 | 16181 | 318 | 1.012245 | 3.2189391 | Lasiosphaeris hirsuta | 260670 | Fungi | Fungi | 70.9 | 9.72e-13 | NR | KAK0730756.1 | 260670 | g16018 | i0 | 35.7 | 0.924528301886792 | 98 | 61 | 90.6 | 1 | 303 | 16 | 3 | 100 | KAK0730756.1 Prefoldin [Lasiosphaeris hirsuta] | diamond | 294 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Lasiosphaeris | Lasiosphaeris hirsuta | |
| 27423947 | 27423947 | PRJNA448207_P_NODE_25023_length_253_cov_0.938889_g24860_i0 | PRJNA448207 | 25023 | 253 | 0.938889 | 2.37538917 | Xylaria sp. FL1777 | 2614573 | Fungi | Fungi | 45.8 | 0.00356 | NR | KAI1426039.1 | 2614573 | g24860 | i0 | 55.9 | 1.4703557312253 | 34 | 15 | 40.3 | 0 | 253 | 152 | 947 | 980 | KAI1426039.1 hypothetical protein F5Y12DRAFT_713695 [Xylaria sp. FL1777] | diamond | 372 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria sp. FL1777 | |
| 29034233 | 29034233 | PRJNA448207_P_NODE_29768_length_245_cov_1.779070_g29605_i0 | PRJNA448207 | 29768 | 245 | 1.77907 | 4.3587215 | Alyxoria varia | 91480 | Fungi | Fungi | 134 | 8.26e-35 | NR | KAI9669991.1 | 91480 | g29605 | i0 | 79 | 12.8938775510204 | 81 | 17 | 99.2 | 0 | 1 | 243 | 227 | 307 | KAI9669991.1 MAG: cysteine desulfurase [Alyxoria varia] | diamond | 3159 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Arthoniomycetes | Arthoniales | Lecanographaceae | Alyxoria | Alyxoria varia | |
| 29191974 | 29191974 | PRJNA448207_P_NODE_4549_length_561_cov_1.209016_g4391_i0 | PRJNA448207 | 4549 | 561 | 1.209016 | 6.78257976 | Cladophialophora chaetospira | 386627 | Fungi | Fungi | 46.6 | 0.0321 | NR | KAJ9603346.1 | 386627 | g4391 | i0 | 44.6 | 0.299465240641711 | 56 | 31 | 29.9 | 0 | 520 | 353 | 792 | 847 | KAJ9603346.1 translocon subunit [Cladophialophora chaetospira] | diamond | 168 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora chaetospira | |
| 29286458 | 29286458 | PRJNA448207_P_NODE_9249_length_405_cov_1.478916_g9087_i0 | PRJNA448207 | 9249 | 405 | 1.478916 | 5.9896098 | Tuber magnatum | 42249 | Fungi | Fungi | 46.6 | 0.0053 | NR | PWW75267.1 | 42249 | g9087 | i0 | 46 | 0.37037037037037 | 50 | 21 | 32.6 | 1 | 169 | 38 | 147 | 196 | PWW75267.1 hypothetical protein C7212DRAFT_280944 [Tuber magnatum] | diamond | 150 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Tuber | Tuber magnatum | |
| 29412734 | 29412734 | PRJNA448207_P_NODE_26389_length_250_cov_0.870056_g26226_i0 | PRJNA448207 | 26389 | 250 | 0.870056 | 2.17514 | Cladonia borealis | 184061 | Fungi | Fungi | 60.8 | 1.66e-8 | NR | KAK0506970.1 | 184061 | g26226 | i0 | 39.7 | 1.8 | 73 | 43 | 86.4 | 1 | 233 | 18 | 177 | 249 | KAK0506970.1 hypothetical protein JMJ35_010670 [Cladonia borealis] | diamond | 450 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Lecanorales | Cladoniaceae | Cladonia | Cladonia borealis | |
| 29934543 | 29934543 | PRJNA448207_S_NODE_3271_length_255_cov_1.686813_g3260_i0 | PRJNA448207 | 3271 | 255 | 1.686813 | 4.30137315 | Pezizales | 5185 | Fungi | Fungi | 42.7 | 0.0402 | NR | KAF8539182.1 | 47213 | g3260 | i0 | 38.8 | 1.82352941176471 | 85 | 44 | 95.3 | 4 | 247 | 5 | 1 | 81 | KAF8539182.1 hypothetical protein BDD12DRAFT_805557 [Trichophaea hybrida] | diamond | 465 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Trichophaea | Trichophaea hybrida | |
| 30392470 | 30392470 | PRJNA448207_P_NODE_33733_length_226_cov_2.248366_g33570_i0 | PRJNA448207 | 33733 | 226 | 2.248366 | 5.08130716 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 84.3 | 1.77e-17 | NR | KAK0296463.1 | 329885 | g33570 | i0 | 60.3 | 5.86725663716814 | 73 | 27 | 94.2 | 2 | 219 | 7 | 5 | 77 | KAK0296463.1 Thymidylate kinase [Friedmanniomyces endolithicus] | diamond | 1326 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 30644601 | 30644601 | PRJNA448207_P_NODE_10393_length_384_cov_1.395498_g10231_i0 | PRJNA448207 | 10393 | 384 | 1.395498 | 5.35871232 | Lophiostoma macrostomum CBS 122681 | 1314788 | Fungi | Fungi | 44.3 | 0.0461 | NR | KAF2659101.1 | 1314788 | g10231 | i0 | 50 | 0.4375 | 56 | 25 | 43 | 2 | 42 | 206 | 337 | 390 | KAF2659101.1 hypothetical protein K491DRAFT_675808 [Lophiostoma macrostomum CBS 122681] | diamond | 168 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lophiostomataceae | Lophiostoma | Lophiostoma macrostomum | |
| 30834363 | 30834363 | PRJNA448207_S_NODE_3474_length_250_cov_0.870056_g3463_i0 | PRJNA448207 | 3474 | 250 | 0.870056 | 2.17514 | Akanthomyces lecanii RCEF 1 | 2714763 | Fungi | Fungi | 57 | 3.47e-7 | NR | OAA71059.1 | 1081108 | g3463 | i0 | 43.6 | 1.452 | 55 | 31 | 66 | 0 | 176 | 12 | 10 | 64 | OAA71059.1 histone acetylase complex subunit [Akanthomyces lecanii RCEF 1005] | diamond | 363 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Akanthomyces | Akanthomyces lecanii | |
| 30960844 | 30960844 | PRJNA448207_S_NODE_1474_length_357_cov_1.260563_g1463_i0 | PRJNA448207 | 1474 | 357 | 1.260563 | 4.50020991 | Candidozyma haemuli var. vulneris | 1231523 | Fungi | Fungi | 48.1 | 1.11e-4 | NR | KAF3991661.1 | 1231523 | g1463 | i0 | 47.5 | 1.08403361344538 | 59 | 30 | 49.6 | 1 | 42 | 218 | 9 | 66 | KAF3991661.1 hypothetical protein FT663_02638 [Candidozyma haemuli var. vulneris] | diamond | 387 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Candidozyma | Candidozyma haemuli | |
| 31609381 | 31609381 | PRJNA448207_S_NODE_1316_length_376_cov_1.039604_g1305_i0 | PRJNA448207 | 1316 | 376 | 1.039604 | 3.90891104 | Ascomycota | 4890 | Fungi | Fungi | 80.1 | 1.19e-14 | NR | XP_058329390.1 | 63820 | g1305 | i0 | 71.7 | 12.8457446808511 | 46 | 13 | 36.7 | 0 | 3 | 140 | 322 | 367 | XP_058329390.1 WD domain-containing protein [Penicillium chermesinum] | diamond | 4830 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chermesinum | |
| 32210456 | 32210456 | PRJNA448207_P_NODE_29978_length_245_cov_0.895349_g29815_i0 | PRJNA448207 | 29978 | 245 | 0.895349 | 2.19360505 | Fungi | 4751 | Fungi | Fungi | 61.6 | 6.83e-10 | NR | KAF5099955.1 | 27317 | g29815 | i0 | 65.9 | 8.97551020408163 | 41 | 14 | 50.2 | 0 | 2 | 124 | 83 | 123 | KAF5099955.1 hypothetical protein D0Z00_001435 [Geotrichum galactomycetum] | diamond | 2199 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum galactomycetum | |
| 32352594 | 32352594 | PRJNA448207_P_NODE_16259_length_317_cov_1.262295_g16096_i0 | PRJNA448207 | 16259 | 317 | 1.262295 | 4.00147515 | Stictis urceolata | 2704026 | Fungi | Fungi | 60.1 | 6.5e-8 | NR | MCJ1444535.1 | 2704026 | g16096 | i0 | 45 | 0.757097791798107 | 80 | 43 | 75.7 | 1 | 315 | 76 | 208 | 286 | MCJ1444535.1 hypothetical protein [Stictis urceolata] | diamond | 240 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Stictidaceae | Stictis | Stictis urceolata | |
| 32542434 | 32542434 | PRJNA448207_P_NODE_31159_length_244_cov_0.900585_g30996_i0 | PRJNA448207 | 31159 | 244 | 0.900585 | 2.1974274 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 105 | 2.2799999999999998e-24 | NR | XP_069232431.1 | 1052096 | g30996 | i0 | 73.7 | 0.934426229508197 | 76 | 19 | 93.4 | 1 | 16 | 243 | 320 | 394 | XP_069232431.1 uncharacterized protein WHR41_01920 [Cladosporium halotolerans] | diamond | 228 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32684302 | 32684302 | PRJNA448207_P_NODE_6580_length_471_cov_2.108040_g6418_i0 | PRJNA448207 | 6580 | 471 | 2.10804 | 9.9288684 | Ascomycota | 4890 | Fungi | Fungi | 47.8 | 7.16e-4 | NR | KAJ6259137.1 | 74499 | g6418 | i0 | 43.5 | 1.36305732484076 | 85 | 43 | 52.2 | 2 | 124 | 369 | 2 | 84 | KAJ6259137.1 putative 26S proteasome complex subunit sem-1 [Drechslerella dactyloides] | diamond | 642 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Drechslerella | Drechslerella dactyloides |
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);;