contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27182106 | 27182106 | PRJNA902848_P_NODE_19362_length_243_cov_0.917647_g19312_i0 | PRJNA902848 | 19362 | 243 | 0.917647 | 2.22988221 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 43.1 | 0.0289 | NR | KAK4333672.1 | 5286 | g19312 | i0 | 69.4 | 0.444444444444444 | 36 | 9 | 44.4 | 1 | 237 | 130 | 957 | 990 | KAK4333672.1 LOW QUALITY PROTEIN: Acetyl-coenzyme A synthetase 1, partial [Rhodotorula toruloides] | diamond | 108 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 27790119 | 27790119 | PRJNA902848_P_NODE_14304_length_251_cov_0.876404_g14254_i0 | PRJNA902848 | 14304 | 251 | 0.876404 | 2.19977404 | Agaricus | 5340 | Fungi | Fungi | 119 | 1.8e-29 | NR | KAF7761936.1 | 192524 | g14254 | i0 | 67.5 | 8.92828685258964 | 83 | 27 | 99.2 | 0 | 249 | 1 | 245 | 327 | KAF7761936.1 hypothetical protein Agabi119p4_9928 [Agaricus bisporus var. burnettii] | diamond | 2241 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 28066549 | 28066549 | PRJNA902848_P_NODE_17525_length_246_cov_0.901734_g17475_i0 | PRJNA902848 | 17525 | 246 | 0.901734 | 2.21826564 | Malassezia cuniculi | 948313 | Fungi | Fungi | 83.6 | 1.34e-16 | NR | WFD35389.1 | 948313 | g17475 | i0 | 54.9 | 0.865853658536585 | 71 | 30 | 84.1 | 1 | 225 | 19 | 39 | 109 | WFD35389.1 aspartate transaminase [Malassezia cuniculi] | diamond | 213 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 28421654 | 28421654 | PRJNA902848_P_NODE_1226_length_618_cov_2.689908_g1177_i0 | PRJNA902848 | 1226 | 618 | 2.689908 | 16.62363144 | Fungi | 4751 | Fungi | Fungi | 142 | 2.08e-38 | NR | XP_001833989.1 | 240176 | g1177 | i0 | 61.4 | 7.08252427184466 | 132 | 48 | 64.1 | 3 | 63 | 458 | 88 | 216 | XP_001833989.1 elongation factor 1 beta/delta chain [Coprinopsis cinerea okayama7#130] | diamond | 4377 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 28603428 | 28603428 | PRJNA902848_P_NODE_7367_length_322_cov_1.232932_g7317_i0 | PRJNA902848 | 7367 | 322 | 1.232932 | 3.97004104 | Agaricus bisporus var. bisporus H97 | 936046 | Fungi | Fungi | 132 | 1.76e-35 | NR | XP_006456618.1 | 936046 | g7317 | i0 | 75 | 0.819875776397516 | 88 | 22 | 82 | 0 | 59 | 322 | 1 | 88 | XP_006456618.1 hypothetical protein AGABI2DRAFT_122501 [Agaricus bisporus var. bisporus H97] | diamond | 264 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 29140317 | 29140317 | PRJNA902848_P_NODE_19309_length_243_cov_0.917647_g19259_i0 | PRJNA902848 | 19309 | 243 | 0.917647 | 2.22988221 | Kwoniella dejecticola CBS 1 | 324770 | Fungi | Fungi | 79 | 6.6e-15 | NR | XP_065824241.1 | 1296121 | g19259 | i0 | 78.7 | 1.18518518518519 | 47 | 10 | 58 | 0 | 84 | 224 | 252 | 298 | XP_065824241.1 uncharacterized protein I303_100685 [Kwoniella dejecticola CBS 10117] | diamond | 288 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dejecticola | |
| 30403845 | 30403845 | PRJNA902848_P_NODE_14473_length_251_cov_0.876404_g14423_i0 | PRJNA902848 | 14473 | 251 | 0.876404 | 2.19977404 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 58.2 | 1.48e-7 | NR | XP_018741108.1 | 1230383 | g14423 | i0 | 41.5 | 1.41035856573705 | 65 | 38 | 77.7 | 0 | 238 | 44 | 299 | 363 | XP_018741108.1 uncharacterized protein MSY001_2588 [Malassezia sympodialis ATCC 42132] | diamond | 354 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 30695284 | 30695284 | PRJNA902848_P_NODE_16653_length_247_cov_1.344828_g16603_i0 | PRJNA902848 | 16653 | 247 | 1.344828 | 3.32172516 | Fungi | 4751 | Fungi | Fungi | 106 | 7.300000000000001e-27 | NR | KAI8462047.1 | 170000 | g16603 | i0 | 60.3 | 2.84210526315789 | 78 | 31 | 94.7 | 0 | 238 | 5 | 1 | 78 | KAI8462047.1 actin-related protein 2/3 complex subunit 3 [Phakopsora pachyrhizi] | diamond | 702 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 30814108 | 30814108 | PRJNA902848_P_NODE_13874_length_252_cov_0.871508_g13824_i0 | PRJNA902848 | 13874 | 252 | 0.871508 | 2.19620016 | Agaricus bisporus var. burnettii JB137-S8 | 597362 | Fungi | Fungi | 56.2 | 4.8e-7 | NR | XP_007333098.1 | 597362 | g13824 | i0 | 92 | 0.297619047619048 | 25 | 2 | 29.8 | 0 | 250 | 176 | 222 | 246 | XP_007333098.1 uncharacterized protein AGABI1DRAFT_115923 [Agaricus bisporus var. burnettii JB137-S8] | diamond | 75 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 30853296 | 30853296 | PRJNA902848_P_NODE_17094_length_247_cov_0.896552_g17044_i0 | PRJNA902848 | 17094 | 247 | 0.896552 | 2.21448344 | Agaricus | 5340 | Fungi | Fungi | 80.1 | 2.71e-15 | NR | KAF7762716.1 | 192524 | g17044 | i0 | 49.4 | 4.79757085020243 | 79 | 40 | 96 | 0 | 9 | 245 | 74 | 152 | KAF7762716.1 transcriptional regulator family: Zinc finger, CCHC-type [Agaricus bisporus var. burnettii] | diamond | 1185 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 31129760 | 31129760 | PRJNA902848_P_NODE_14275_length_251_cov_0.876404_g14225_i0 | PRJNA902848 | 14275 | 251 | 0.876404 | 2.19977404 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 153 | 6.42e-41 | NR | SHO80068.1 | 1230383 | g14225 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 427 | 509 | SHO80068.1 Similar to S.cerevisiae protein BLM10 (Proteasome activator) [Malassezia sympodialis ATCC 42132] | diamond | 249 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 31161363 | 31161363 | PRJNA902848_P_NODE_17075_length_247_cov_0.896552_g17025_i0 | PRJNA902848 | 17075 | 247 | 0.896552 | 2.21448344 | Blastosporella zonata | 530045 | Fungi | Fungi | 70.1 | 3.45e-12 | NR | YP_009517165.1 | 530045 | g17025 | i0 | 76.7 | 1.62753036437247 | 43 | 10 | 52.2 | 0 | 3 | 131 | 211 | 253 | YP_009517165.1 LAGLIDADG homing endonuclease [Blastosporella zonata] | diamond | 402 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Blastosporella | Blastosporella zonata | |
| 31857398 | 31857398 | PRJNA902848_P_NODE_9057_length_297_cov_1.388393_g9007_i0 | PRJNA902848 | 9057 | 297 | 1.388393 | 4.12352721 | Psilocybe cf. subviscida | 2480587 | Fungi | Fungi | 50.4 | 1.35e-4 | NR | KAF5313249.1 | 2480587 | g9007 | i0 | 38.9 | 0.727272727272727 | 72 | 39 | 67.7 | 1 | 211 | 11 | 159 | 230 | KAF5313249.1 hypothetical protein D9619_002469 [Psilocybe cf. subviscida] | diamond | 216 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cf. subviscida | |
| 31889050 | 31889050 | PRJNA902848_P_NODE_19377_length_243_cov_0.917647_g19327_i0 | PRJNA902848 | 19377 | 243 | 0.917647 | 2.22988221 | Malassezia cuniculi | 948313 | Fungi | Fungi | 107 | 6.5e-25 | NR | WFD34367.1 | 948313 | g19327 | i0 | 84.7 | 0.728395061728395 | 59 | 9 | 72.8 | 0 | 66 | 242 | 511 | 569 | WFD34367.1 ubiquitinyl hydrolase 1 [Malassezia cuniculi] | diamond | 177 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 31983972 | 31983972 | PRJNA902848_P_NODE_6458_length_339_cov_0.849624_g6408_i0 | PRJNA902848 | 6458 | 339 | 0.849624 | 2.88022536 | Agaricus bisporus var. burnettii | 192524 | Fungi | Fungi | 101 | 3.47e-22 | NR | KAF7782688.1 | 192524 | g6408 | i0 | 79.5 | 0.646017699115044 | 73 | 14 | 63.7 | 1 | 218 | 3 | 822 | 894 | KAF7782688.1 hypothetical protein Agabi119p4_2064 [Agaricus bisporus var. burnettii] | diamond | 219 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 32300838 | 32300838 | PRJNA902848_P_NODE_8599_length_303_cov_1.356522_g8549_i0 | PRJNA902848 | 8599 | 303 | 1.356522 | 4.11026166 | Mycena kentingensis (nom. inval.) | 1325293 | Fungi | Fungi | 46.6 | 0.00333 | NR | KAF7323850.1 | 1325293 | g8549 | i0 | 53.1 | 0.98019801980198 | 49 | 19 | 46.5 | 3 | 8 | 148 | 428 | 474 | KAF7323850.1 Growth factor receptor domain-containing protein [Mycena kentingensis (nom. inval.)] | diamond | 297 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena kentingensis (nom. inval.) | |
| 32427063 | 32427063 | PRJNA902848_P_NODE_11259_length_271_cov_1.146465_g11209_i0 | PRJNA902848 | 11259 | 271 | 1.146465 | 3.10692015 | Hypsizygus marmoreus | 39966 | Fungi | Fungi | 95.9 | 2.3400000000000003e-21 | NR | YP_009630858.1 | 39966 | g11209 | i0 | 53.6 | 1.8929889298893 | 84 | 38 | 93 | 1 | 253 | 2 | 182 | 264 | YP_009630858.1 hypothetical protein HM01MITGene32 [Hypsizygus marmoreus] | diamond | 513 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 32529796 | 32529796 | PRJNA902848_P_NODE_18939_length_244_cov_0.912281_g18889_i0 | PRJNA902848 | 18939 | 244 | 0.912281 | 2.22596564 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 97.4 | 1.84e-22 | NR | CEQ41105.1 | 5005 | g18889 | i0 | 55.8 | 11.3729508196721 | 77 | 31 | 94.7 | 1 | 233 | 3 | 134 | 207 | CEQ41105.1 SPOSA6832_02794, partial [Sporobolomyces salmonicolor] | diamond | 2775 | 97.8 | 0.995910020449898 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 32647793 | 32647793 | PRJNA902848_P_NODE_5900_length_350_cov_1.039711_g5850_i0 | PRJNA902848 | 5900 | 350 | 1.039711 | 3.6389885 | Agaricus bisporus var. burnettii | 192524 | Fungi | Fungi | 188 | 9.95e-53 | NR | KAF7761196.1 | 192524 | g5850 | i0 | 78.4 | 15.9085714285714 | 116 | 25 | 99.4 | 0 | 3 | 350 | 563 | 678 | KAF7761196.1 hypothetical protein Agabi119p4_10605 [Agaricus bisporus var. burnettii] | diamond | 5568 | 188 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus |
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);;