contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1082072" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7394947 | 7394947 | PRJNA1082072_P_NODE_106_length_888_cov_1.218405_g102_i0 | PRJNA1082072 | 106 | 888 | 1.218405 | 10.8194364 | Fungi | 4751 | Fungi | Fungi | 378 | 6.819999999999999e-118 | NR | XP_058330436.1 | 63820 | g102 | i0 | 63.3 | 81.3108108108108 | 297 | 96 | 100 | 4 | 888 | 1 | 989 | 1273 | XP_058330436.1 Translation elongation/initiation factor/Ribosomal beta-barrel [Penicillium chermesinum] | diamond | 72204 | 379 | 0.997361477572559 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chermesinum | |
| 13770555 | 13770555 | PRJNA1082072_P_NODE_291_length_560_cov_1.342916_g284_i0 | PRJNA1082072 | 291 | 560 | 1.342916 | 7.5203296 | Eukaryota | 2759 | Fungi | Fungi | 122 | 2.6199999999999996e-31 | NR | KGK38667.1 | 4909 | g284 | i0 | 42 | 10.9928571428571 | 174 | 81 | 93.2 | 3 | 5 | 526 | 40 | 193 | KGK38667.1 hypothetical protein JL09_g2231 [Pichia kudriavzevii] | diamond | 6156 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 14221932 | 14221932 | PRJNA1082072_P_NODE_692_length_387_cov_2.044586_g685_i0 | PRJNA1082072 | 692 | 387 | 2.044586 | 7.91254782 | Pyronema omphalodes CBS 1 | 337075 | Fungi | Fungi | 173 | 4.91e-50 | NR | CCX32792.1 | 1076935 | g685 | i0 | 68.2 | 5.07751937984496 | 132 | 35 | 99.2 | 2 | 386 | 3 | 100 | 228 | CCX32792.1 Similar to 60S ribosomal protein L3; acc. no. Q8NKF4 [Pyronema omphalodes CBS 100304] | diamond | 1965 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Pyronema | Pyronema omphalodes | |
| 20594227 | 20594227 | PRJNA1082072_P_NODE_2737_length_244_cov_0.900585_g2730_i0 | PRJNA1082072 | 2737 | 244 | 0.900585 | 2.1974274 | Fungi | 4751 | Fungi | Fungi | 92 | 1.44e-21 | NR | KAF5092528.1 | 27317 | g2730 | i0 | 56.3 | 16.0204918032787 | 80 | 34 | 97.1 | 1 | 241 | 5 | 57 | 136 | KAF5092528.1 hypothetical protein D0Z00_004542 [Geotrichum galactomycetum] | diamond | 3909 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum galactomycetum | |
| 26624272 | 26624272 | PRJNA1082072_P_NODE_2721_length_244_cov_0.900585_g2714_i0 | PRJNA1082072 | 2721 | 244 | 0.900585 | 2.1974274 | Pseudovirgaria hyperparasitica | 470096 | Fungi | Fungi | 49.3 | 1.85e-4 | NR | XP_033600942.1 | 470096 | g2714 | i0 | 54 | 0.614754098360656 | 50 | 23 | 61.5 | 0 | 95 | 244 | 61 | 110 | XP_033600942.1 methylcrotonoyl-CoA carboxylase-like protein subunit beta [Pseudovirgaria hyperparasitica] | diamond | 150 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Acrospermales | Acrospermaceae | Pseudovirgaria | Pseudovirgaria hyperparasitica | |
| 26782843 | 26782843 | PRJNA1082072_P_NODE_2861_length_242_cov_0.911243_g2854_i0 | PRJNA1082072 | 2861 | 242 | 0.911243 | 2.20520806 | Xylariaceae sp. FL | 1881983 | Fungi | Fungi | 99.4 | 4.36e-24 | NR | KAI1338001.1 | 2614588 | g2854 | i0 | 58.4 | 1.92148760330579 | 77 | 32 | 95.5 | 0 | 235 | 5 | 6 | 82 | KAI1338001.1 flagellar calcium-binding protein-like protein TB-44A [Xylariaceae sp. FL0016] | diamond | 465 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylariaceae sp. FL0016 | ||
| 27099058 | 27099058 | PRJNA1082072_P_NODE_2742_length_244_cov_0.900585_g2735_i0 | PRJNA1082072 | 2742 | 244 | 0.900585 | 2.1974274 | Cryomyces minteri | 331657 | Fungi | Fungi | 73.9 | 3.86e-13 | NR | TKA71849.1 | 331657 | g2735 | i0 | 51.3 | 0.959016393442623 | 78 | 32 | 93.4 | 2 | 244 | 17 | 120 | 193 | TKA71849.1 hypothetical protein B0A49_04069 [Cryomyces minteri] | diamond | 234 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cryomyces | Cryomyces minteri | |||
| 27343667 | 27343667 | PRJNA1082072_P_NODE_603_length_406_cov_1.849850_g596_i0 | PRJNA1082072 | 603 | 406 | 1.84985 | 7.510391 | Fungi | 4751 | Fungi | Fungi | 135 | 1.66e-36 | NR | ONH69752.1 | 36022 | g596 | i0 | 50 | 14.4532019704434 | 128 | 63 | 94.6 | 1 | 384 | 1 | 10 | 136 | ONH69752.1 hypothetical protein BON22_0035 [Cyberlindnera fabianii] | diamond | 5868 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera fabianii | |
| 27636307 | 27636307 | PRJNA1082072_P_NODE_1004_length_340_cov_1.636704_g997_i0 | PRJNA1082072 | 1004 | 340 | 1.636704 | 5.5647936 | Drechslerella stenobrocha 248 | 1043628 | Fungi | Fungi | 99.8 | 3.559999999999999e-23 | NR | EWC48931.1 | 1043628 | g997 | i0 | 47.7 | 2.23235294117647 | 128 | 52 | 99.7 | 2 | 340 | 2 | 54 | 181 | EWC48931.1 elongation factor 1-beta [Drechslerella stenobrocha 248] | diamond | 759 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Drechslerella | Drechslerella stenobrocha | |
| 28795652 | 28795652 | PRJNA1082072_P_NODE_1447_length_289_cov_1.106481_g1440_i0 | PRJNA1082072 | 1447 | 289 | 1.106481 | 3.19773009 | Aspergillaceae | 1131492 | Fungi | Fungi | 43.9 | 0.025 | NR | TQB67946.1 | 5098 | g1440 | i0 | 42.6 | 4.0795847750865 | 47 | 27 | 48.8 | 0 | 63 | 203 | 791 | 837 | TQB67946.1 hypothetical protein MPDQ_004307 [Monascus purpureus] | diamond | 1179 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Monascus | Monascus purpureus | |
| 28898952 | 28898952 | PRJNA1082072_P_NODE_1448_length_289_cov_1.069444_g1441_i0 | PRJNA1082072 | 1448 | 289 | 1.069444 | 3.09069316 | Emydomyces testavorans | 2070801 | Fungi | Fungi | 52.8 | 2.01e-5 | NR | WEW60200.1 | 2070801 | g1441 | i0 | 43.1 | 1.20415224913495 | 58 | 33 | 60.2 | 0 | 271 | 98 | 1002 | 1059 | WEW60200.1 Splicing factor [Emydomyces testavorans] | diamond | 348 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Nannizziopsiaceae | Emydomyces | Emydomyces testavorans | |
| 30121979 | 30121979 | PRJNA1082072_P_NODE_2232_length_250_cov_0.870056_g2225_i0 | PRJNA1082072 | 2232 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 116 | 4.05e-28 | NR | CEP24677.1 | 4903 | g2225 | i0 | 70.7 | 61.032 | 82 | 23 | 98.4 | 1 | 248 | 3 | 324 | 404 | CEP24677.1 unnamed protein product [Cyberlindnera jadinii] | diamond | 15258 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera jadinii | |
| 30541388 | 30541388 | PRJNA1082072_P_NODE_2853_length_242_cov_0.911243_g2846_i0 | PRJNA1082072 | 2853 | 242 | 0.911243 | 2.20520806 | Diaporthe sp. PMI_573 | 2614600 | Fungi | Fungi | 42.4 | 0.0497 | NR | KAH8753541.1 | 2614600 | g2846 | i0 | 38.9 | 0.892561983471074 | 72 | 34 | 89.3 | 1 | 4 | 219 | 317 | 378 | KAH8753541.1 kinase-like domain-containing protein [Diaporthe sp. PMI_573] | diamond | 216 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe sp. PMI_573 | |
| 30667789 | 30667789 | PRJNA1082072_P_NODE_853_length_362_cov_1.065744_g846_i0 | PRJNA1082072 | 853 | 362 | 1.065744 | 3.85799328 | Tortispora caseinolytica NRRL Y-17796 | 767744 | Fungi | Fungi | 133 | 5.6899999999999995e-37 | NR | ODV89225.1 | 767744 | g846 | i0 | 52.6 | 4.79005524861878 | 114 | 54 | 94.5 | 0 | 4 | 345 | 6 | 119 | ODV89225.1 hypothetical protein CANCADRAFT_58210 [Tortispora caseinolytica NRRL Y-17796] | diamond | 1734 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Trigonopsidomycetes | Trigonopsidales | Trigonopsidaceae | Tortispora | Tortispora caseinolytica | |
| 31322805 | 31322805 | PRJNA1082072_P_NODE_375_length_493_cov_1.664286_g368_i0 | PRJNA1082072 | 375 | 493 | 1.664286 | 8.20492998 | Ascomycota | 4890 | Fungi | Fungi | 89 | 1.01e-18 | NR | KAI2732586.1 | 5082 | g368 | i0 | 33.3 | 10.0892494929006 | 150 | 91 | 85.8 | 1 | 486 | 64 | 30 | 179 | KAI2732586.1 hypothetical protein CBS147332_1725 [Penicillium roqueforti] | diamond | 4974 | 89.7 | 0.992196209587514 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 31354592 | 31354592 | PRJNA1082072_P_NODE_1176_length_319_cov_1.605691_g1169_i0 | PRJNA1082072 | 1176 | 319 | 1.605691 | 5.12215429 | Fungi | 4751 | Fungi | Fungi | 169 | 7.82e-51 | NR | KAJ3522460.1 | 57161 | g1169 | i0 | 73.8 | 36.9216300940439 | 103 | 27 | 96.9 | 0 | 309 | 1 | 52 | 154 | KAJ3522460.1 hypothetical protein NM208_g12851 [Fusarium decemcellulare] | diamond | 11778 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium decemcellulare |
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);;