contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB2925" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3852226 | 3852226 | PRJEB2925_P_NODE_14104_length_273_cov_4.415966_g12826_i0 | PRJEB2925 | 14104 | 273 | 4.415966 | 12.05558718 | Fungi | 4751 | Fungi | Fungi | 95.1 | 4.14e-23 | NR | XP_020071439.1 | 983966 | g12826 | i0 | 52.7 | 6.18681318681319 | 93 | 37 | 94.5 | 1 | 14 | 271 | 6 | 98 | XP_020071439.1 60S ribosomal protein eL30 [Cyberlindnera jadinii NRRL Y-1542] | diamond | 1689 | 95.9 | 0.991657977059437 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera jadinii | |
| 5128542 | 5128542 | PRJEB2925_P_NODE_8305_length_428_cov_2.620865_g7070_i0 | PRJEB2925 | 8305 | 428 | 2.6208649999999998 | 11.2173022 | Thermothelomyces thermophilus ATCC 42464 | 573729 | Fungi | Fungi | 181 | 1.3199999999999998e-55 | NR | XP_003660671.1 | 573729 | g7070 | i0 | 65.6 | 0.918224299065421 | 131 | 44 | 91.1 | 1 | 392 | 3 | 1 | 131 | XP_003660671.1 uncharacterized protein MYCTH_59591 [Thermothelomyces thermophilus ATCC 42464] | diamond | 393 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothelomyces | Thermothelomyces thermophilus | |
| 7678400 | 7678400 | PRJEB2925_P_NODE_6607_length_504_cov_4.153518_g5467_i0 | PRJEB2925 | 6607 | 504 | 4.153518 | 20.93373072 | Eukaryota | 2759 | Fungi | Fungi | 207 | 8.86e-66 | NR | KAF5092142.1 | 43985 | g5467 | i0 | 66.9 | 26.0654761904762 | 151 | 48 | 88.7 | 1 | 497 | 51 | 1 | 151 | KAF5092142.1 hypothetical protein D0Z03_003024 [Geotrichum reessii] | diamond | 13137 | 209 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum reessii | |
| 8953072 | 8953072 | PRJEB2925_P_NODE_12928_length_294_cov_1.494208_g11651_i0 | PRJEB2925 | 12928 | 294 | 1.494208 | 4.39297152 | Schizosaccharomyces cryophilus OY26 | 653667 | Fungi | Fungi | 150 | 1.15e-43 | NR | XP_013025045.1 | 653667 | g11651 | i0 | 68.4 | 13.765306122449 | 98 | 31 | 100 | 0 | 294 | 1 | 59 | 156 | XP_013025045.1 elongation factor-1 alpha [Schizosaccharomyces cryophilus OY26] | diamond | 4047 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces cryophilus | |
| 10228862 | 10228862 | PRJEB2925_P_NODE_14629_length_266_cov_1.701299_g13351_i0 | PRJEB2925 | 14629 | 266 | 1.701299 | 4.52545534 | Candida dubliniensis CD36 | 573826 | Fungi | Fungi | 77.8 | 6.28e-17 | NR | XP_002417266.1 | 573826 | g13351 | i0 | 75.5 | 13.0375939849624 | 49 | 12 | 55.3 | 0 | 3 | 149 | 3 | 51 | XP_002417266.1 60S ribosomal protein L39 [Candida dubliniensis CD36] | diamond | 3468 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida dubliniensis | |
| 21702869 | 21702869 | PRJEB2925_P_NODE_4818_length_621_cov_7.172355_g3834_i0 | PRJEB2925 | 4818 | 621 | 7.172355 | 44.54032455 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 202 | 3.9799999999999995e-62 | NR | XP_069228100.1 | 1052096 | g3834 | i0 | 52 | 2.8792270531401 | 198 | 95 | 95.7 | 0 | 1 | 594 | 5 | 202 | XP_069228100.1 60S ribosomal protein uL13 [Cladosporium halotolerans] | diamond | 1788 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26773607 | 26773607 | PRJEB2925_P_NODE_10821_length_342_cov_3.133550_g9548_i0 | PRJEB2925 | 10821 | 342 | 3.13355 | 10.716741 | Ascomycota | 4890 | Fungi | Fungi | 83.2 | 1.51e-17 | NR | KAF5848676.1 | 45130 | g9548 | i0 | 48 | 3.50877192982456 | 75 | 39 | 65.8 | 0 | 282 | 58 | 64 | 138 | KAF5848676.1 hypothetical protein GGP41_009781 [Bipolaris sorokiniana] | diamond | 1200 | 84 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris sorokiniana | |
| 27349572 | 27349572 | PRJEB2925_P_NODE_9063_length_398_cov_2.349862_g7797_i0 | PRJEB2925 | 9063 | 398 | 2.349862 | 9.35245076 | Lindgomyces ingoldianus | 673940 | Fungi | Fungi | 52.4 | 8.16e-5 | NR | XP_033554535.1 | 673940 | g7797 | i0 | 33.7 | 2.5929648241206 | 101 | 60 | 70.9 | 2 | 79 | 360 | 378 | 478 | XP_033554535.1 WSC-domain-containing protein [Lindgomyces ingoldianus] | diamond | 1032 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lindgomycetaceae | Lindgomyces | Lindgomyces ingoldianus | |
| 27475657 | 27475657 | PRJEB2925_P_NODE_13703_length_280_cov_1.632653_g12425_i0 | PRJEB2925 | 13703 | 280 | 1.632653 | 4.5714284 | Amniculicola lignicola CBS 123 | 455074 | Fungi | Fungi | 46.6 | 0.00225 | NR | KAF1996879.1 | 1392246 | g12425 | i0 | 30 | 1.97142857142857 | 90 | 57 | 93.2 | 2 | 280 | 20 | 62 | 148 | KAF1996879.1 replication protein A, subunit RPA32 [Amniculicola lignicola CBS 123094] | diamond | 552 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Amniculicolaceae | Amniculicola | Amniculicola lignicola | |
| 27595614 | 27595614 | PRJEB2925_P_NODE_4044_length_696_cov_7.829047_g3145_i0 | PRJEB2925 | 4044 | 696 | 7.829047 | 54.49016712 | Eukaryota | 2759 | Fungi | Fungi | 105 | 5.11e-24 | NR | KGK38667.1 | 4909 | g3145 | i0 | 40.7 | 6.53448275862069 | 150 | 70 | 64.7 | 2 | 694 | 245 | 64 | 194 | KGK38667.1 hypothetical protein JL09_g2231 [Pichia kudriavzevii] | diamond | 4548 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 27753532 | 27753532 | PRJEB2925_P_NODE_13444_length_284_cov_2.570281_g12167_i0 | PRJEB2925 | 13444 | 284 | 2.570281 | 7.29959804 | Taphrinales | 5008 | Fungi | Fungi | 52 | 1.93e-5 | NR | CCG83374.1 | 1097556 | g12167 | i0 | 47.8 | 3.38028169014085 | 46 | 23 | 47.5 | 1 | 142 | 8 | 110 | 155 | CCG83374.1 Protein gar2 [Taphrina deformans PYCC 5710] | diamond | 960 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Taphrinomycetes | Taphrinales | Taphrinaceae | Taphrina | Taphrina deformans | |
| 28037596 | 28037596 | PRJEB2925_P_NODE_9805_length_373_cov_2.142012_g8534_i0 | PRJEB2925 | 9805 | 373 | 2.142012 | 7.98970476 | Eukaryota | 2759 | Fungi | Fungi | 104 | 1.26e-25 | NR | XP_003680017.1 | 4950 | g8534 | i0 | 63.5 | 8.91152815013405 | 74 | 27 | 59.5 | 0 | 6 | 227 | 66 | 139 | XP_003680017.1 uncharacterized protein TDEL_0B06770 [Torulaspora delbrueckii] | diamond | 3324 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Torulaspora | Torulaspora delbrueckii | |
| 28069027 | 28069027 | PRJEB2925_P_NODE_9285_length_390_cov_1.777465_g8017_i0 | PRJEB2925 | 9285 | 390 | 1.777465 | 6.9321135 | Orbilia | 47022 | Fungi | Fungi | 100 | 3.55e-22 | NR | XP_011119936.1 | 756982 | g8017 | i0 | 47.4 | 5.7 | 116 | 55 | 84.6 | 1 | 61 | 390 | 249 | 364 | XP_011119936.1 hypothetical protein AOL_s00054g318 [Orbilia oligospora ATCC 24927] | diamond | 2223 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia oligospora | |
| 28770127 | 28770127 | PRJEB2925_P_NODE_4587_length_641_cov_7.622112_g3630_i0 | PRJEB2925 | 4587 | 641 | 7.6221120000000004 | 48.85773792 | Phialemonium thermophilum | 223376 | Fungi | Fungi | 181 | 3.99e-54 | NR | KAL1880002.1 | 223376 | g3630 | i0 | 60.7 | 4.02964118564743 | 178 | 64 | 83.3 | 4 | 635 | 102 | 1 | 172 | KAL1880002.1 hypothetical protein VTK73DRAFT_6392 [Phialemonium thermophilum] | diamond | 2583 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Cephalothecales | Cephalothecaceae | Phialemonium | Phialemonium thermophilum | |
| 29275230 | 29275230 | PRJEB2925_P_NODE_14289_length_271_cov_0.974576_g13011_i0 | PRJEB2925 | 14289 | 271 | 0.974576 | 2.64110096 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 60.5 | 3e-8 | NR | OAQ79673.1 | 33203 | g13011 | i0 | 52.5 | 1.23985239852399 | 59 | 27 | 64.2 | 1 | 271 | 98 | 494 | 552 | OAQ79673.1 MFS monocarboxylate [Purpureocillium lilacinum] | diamond | 336 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 29843727 | 29843727 | PRJEB2925_P_NODE_8171_length_434_cov_2.105263_g6942_i0 | PRJEB2925 | 8171 | 434 | 2.105263 | 9.13684142 | Golovinomyces magnicellulatus | 62714 | Fungi | Fungi | 45.1 | 0.0288 | NR | TQS32420.1 | 62714 | g6942 | i0 | 39.1 | 2.03917050691244 | 64 | 37 | 42.9 | 1 | 432 | 247 | 103 | 166 | TQS32420.1 hypothetical protein Golomagni_07261, partial [Golovinomyces magnicellulatus] | diamond | 885 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces magnicellulatus | |
| 30437766 | 30437766 | PRJEB2925_P_NODE_14613_length_266_cov_2.220779_g13335_i0 | PRJEB2925 | 14613 | 266 | 2.220779 | 5.90727214 | Eukaryota | 2759 | Fungi | Fungi | 55.8 | 3.53e-7 | NR | XP_069223042.1 | 85995 | g13335 | i0 | 37.9 | 2.16541353383459 | 103 | 44 | 98.1 | 5 | 1 | 261 | 1 | 99 | XP_069223042.1 uncharacterized protein VTJ04DRAFT_432 [Mycothermus thermophilus] | diamond | 576 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Mycothermus | Mycothermus thermophilus | |
| 30469361 | 30469361 | PRJEB2925_P_NODE_8133_length_435_cov_4.405000_g6906_i0 | PRJEB2925 | 8133 | 435 | 4.405 | 19.16175 | Trichomeriaceae | 1233474 | Fungi | Fungi | 53.1 | 1.48e-5 | NR | XP_064730136.1 | 1635080 | g6906 | i0 | 34.4 | 4.08275862068966 | 61 | 40 | 42.1 | 0 | 2 | 184 | 7 | 67 | XP_064730136.1 uncharacterized protein PMZ80_005999 [Knufia obscura] | diamond | 1776 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 31227260 | 31227260 | PRJEB2925_P_NODE_4975_length_609_cov_5.390244_g3970_i0 | PRJEB2925 | 4975 | 609 | 5.390244 | 32.82658596 | Fungi | 4751 | Fungi | Fungi | 90.9 | 7.09e-19 | NR | XP_016594331.1 | 27334 | g3970 | i0 | 31 | 10 | 155 | 98 | 71.9 | 1 | 36 | 473 | 37 | 191 | XP_016594331.1 Ribosomal protein S27a [Penicillium expansum] | diamond | 6090 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium expansum | |
| 31392250 | 31392250 | PRJEB2925_P_NODE_2396_length_1017_cov_8.091650_g1782_i0 | PRJEB2925 | 2396 | 1017 | 8.09165 | 82.2920805 | Penicillium psychrosexuale | 1002107 | Fungi | Fungi | 47.8 | 0.00858 | NR | XP_057043115.1 | 1002107 | g1782 | i0 | 39.4 | 0.194690265486726 | 66 | 35 | 19.5 | 1 | 385 | 188 | 35 | 95 | XP_057043115.1 uncharacterized protein N7518_005418 [Penicillium psychrosexuale] | diamond | 198 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium psychrosexuale | |
| 31954833 | 31954833 | PRJEB2925_P_NODE_12017_length_312_cov_3.436823_g10741_i0 | PRJEB2925 | 12017 | 312 | 3.436823 | 10.72288776 | Saccharomycetaceae | 4893 | Fungi | Fungi | 63.2 | 6.9e-10 | NR | KAF4001137.1 | 4932 | g10741 | i0 | 54.5 | 3.15384615384615 | 66 | 20 | 63.5 | 1 | 2 | 199 | 51 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 984 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 31993053 | 31993053 | PRJEB2925_P_NODE_12218_length_308_cov_1.340659_g10942_i0 | PRJEB2925 | 12218 | 308 | 1.340659 | 4.12922972 | Valsa sordida | 252740 | Fungi | Fungi | 77.4 | 1.77e-15 | NR | ROV91428.1 | 252740 | g10942 | i0 | 47.9 | 0.691558441558442 | 71 | 37 | 69.2 | 0 | 4 | 216 | 77 | 147 | ROV91428.1 hypothetical protein VSDG_07212 [Cytospora chrysosperma] | diamond | 213 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora chrysosperma | |
| 32246541 | 32246541 | PRJEB2925_P_NODE_10518_length_351_cov_1.892405_g9246_i0 | PRJEB2925 | 10518 | 351 | 1.892405 | 6.64234155 | Elasticomyces elasticus | 574655 | Fungi | Fungi | 82.8 | 2.43e-16 | NR | KAK3627784.1 | 574655 | g9246 | i0 | 53.7 | 2.1025641025641 | 82 | 38 | 70.1 | 0 | 350 | 105 | 135 | 216 | KAK3627784.1 hypothetical protein LTR56_019017 [Elasticomyces elasticus] | diamond | 738 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus | |
| 32587819 | 32587819 | PRJEB2925_P_NODE_9739_length_375_cov_2.350000_g8468_i0 | PRJEB2925 | 9739 | 375 | 2.35 | 8.8125 | Opisthokonta | 33154 | Fungi | Fungi | 107 | 3.4e-25 | NR | KAG6997482.1 | 116821 | g8468 | i0 | 66.7 | 12.672 | 72 | 24 | 57.6 | 0 | 216 | 1 | 172 | 243 | KAG6997482.1 60S ribosomal protein L7 [Physcia stellaris] | diamond | 4752 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Physcia | Physcia stellaris | |
| 32814473 | 32814473 | PRJEB2925_P_NODE_14400_length_269_cov_1.854701_g13122_i0 | PRJEB2925 | 14400 | 269 | 1.854701 | 4.98914569 | Xylona heveae TC161 | 1328760 | Fungi | Fungi | 58.9 | 5.19e-9 | NR | XP_018186027.1 | 1328760 | g13122 | i0 | 49.2 | 0.680297397769517 | 61 | 31 | 68 | 0 | 252 | 70 | 1 | 61 | XP_018186027.1 60S ribosomal protein L37 [Xylona heveae TC161] | diamond | 183 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Xylonomycetes | Xylonales | Xylonaceae | Xylona | Xylona heveae |
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);;