contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27972863 | 27972863 | PRJNA942359_P_NODE_13065_length_253_cov_0.866667_g12950_i0 | PRJNA942359 | 13065 | 253 | 0.866667 | 2.19266751 | Phlebiopsis gigantea 11 | 82310 | Fungi | Fungi | 94 | 4.11e-20 | NR | KIP11724.1 | 745531 | g12950 | i0 | 63.5 | 2.00395256916996 | 85 | 28 | 99.6 | 2 | 253 | 2 | 714 | 796 | KIP11724.1 hypothetical protein PHLGIDRAFT_124624 [Phlebiopsis gigantea 11061_1 CR5-6] | diamond | 507 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis gigantea | |
| 28446623 | 28446623 | PRJNA942359_P_NODE_13586_length_252_cov_0.871508_g13471_i0 | PRJNA942359 | 13586 | 252 | 0.871508 | 2.19620016 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 139 | 6.33e-36 | NR | XP_017990898.1 | 77020 | g13471 | i0 | 79.5 | 1.97619047619048 | 83 | 17 | 98.8 | 0 | 250 | 2 | 2715 | 2797 | XP_017990898.1 hypothetical protein Malapachy_1648 [Malassezia pachydermatis] | diamond | 498 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 29684345 | 29684345 | PRJNA942359_P_NODE_13670_length_252_cov_0.871508_g13555_i0 | PRJNA942359 | 13670 | 252 | 0.871508 | 2.19620016 | Agaricomycetes | 155619 | Fungi | Fungi | 60.8 | 1.21e-8 | NR | TDL21692.1 | 50990 | g13555 | i0 | 47.4 | 4.47619047619048 | 76 | 37 | 88.1 | 3 | 251 | 30 | 139 | 213 | TDL21692.1 alpha/beta-hydrolase [Rickenella mellea] | diamond | 1128 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Rickenellaceae | Rickenella | Rickenella mellea | |
| 30056706 | 30056706 | PRJNA942359_P_NODE_14871_length_250_cov_0.881356_g14756_i0 | PRJNA942359 | 14871 | 250 | 0.881356 | 2.20339 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 114 | 3.69e-27 | NR | AYO43534.1 | 425264 | g14756 | i0 | 67.1 | 2.952 | 82 | 27 | 98.4 | 0 | 2 | 247 | 105 | 186 | AYO43534.1 putative copper-transporting ATPase HMA5 [Malassezia restricta CBS 7877] | diamond | 738 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31320742 | 31320742 | PRJNA942359_P_NODE_16715_length_247_cov_0.896552_g16600_i0 | PRJNA942359 | 16715 | 247 | 0.896552 | 2.21448344 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 66.6 | 1.15e-11 | NR | XP_017991903.1 | 77020 | g16600 | i0 | 61.4 | 0.534412955465587 | 44 | 17 | 53.4 | 0 | 232 | 101 | 96 | 139 | XP_017991903.1 hypothetical protein Malapachy_4255 [Malassezia pachydermatis] | diamond | 132 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 31574010 | 31574010 | PRJNA942359_P_NODE_14956_length_250_cov_0.881356_g14841_i0 | PRJNA942359 | 14956 | 250 | 0.881356 | 2.20339 | Kwoniella sp. DSM 27419 | 2770024 | Fungi | Fungi | 51.6 | 3.09e-5 | NR | WVR09670.1 | 2770024 | g14841 | i0 | 62.5 | 0.768 | 32 | 12 | 38.4 | 0 | 77 | 172 | 352 | 383 | WVR09670.1 hypothetical protein IAU60_006745 [Kwoniella sp. DSM 27419] | diamond | 192 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella sp. DSM 27419 | |
| 32648789 | 32648789 | PRJNA942359_P_NODE_13360_length_253_cov_0.866667_g13245_i0 | PRJNA942359 | 13360 | 253 | 0.866667 | 2.19266751 | Apiotrichum porosum | 105984 | Fungi | Fungi | 53.9 | 4.63e-6 | NR | XP_028477162.1 | 105984 | g13245 | i0 | 46.4 | 0.818181818181818 | 69 | 35 | 80.6 | 2 | 48 | 251 | 241 | 308 | XP_028477162.1 uncharacterized protein EHS24_006874 [Apiotrichum porosum] | diamond | 207 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 32774969 | 32774969 | PRJNA942359_P_NODE_20280_length_242_cov_0.923077_g20165_i0 | PRJNA942359 | 20280 | 242 | 0.923077 | 2.23384634 | Apiotrichum porosum | 105984 | Fungi | Fungi | 127 | 8.419999999999998e-32 | NR | XP_028480263.1 | 105984 | g20165 | i0 | 79.5 | 6.22314049586777 | 73 | 13 | 90.5 | 1 | 219 | 1 | 351 | 421 | XP_028480263.1 uncharacterized protein EHS24_000582 [Apiotrichum porosum] | diamond | 1506 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum |
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);;