contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB12982" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27753469 | 27753469 | PRJEB12982_P_NODE_14484_length_182_cov_1.917293_g14321_i0 | PRJEB12982 | 14484 | 182 | 1.917293 | 3.48947326 | root | 1 | Root_unresolved | Root_unresolved | 66.2 | 8.47e-11 | NR | WFC99200.1 | 253288 | g14321 | i0 | 51.9 | 7.58241758241758 | 54 | 26 | 89 | 0 | 180 | 19 | 1209 | 1262 | WFC99200.1 protein kinase C [Malassezia yamatoensis] | diamond | 1380 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia yamatoensis | |
| 27885883 | 27885883 | PRJEB12982_P_NODE_19585_length_163_cov_0.894737_g19422_i0 | PRJEB12982 | 19585 | 163 | 0.894737 | 1.45842131 | Ceratobasidium theobromae | 1582974 | Fungi | Fungi | 57.8 | 4.56e-8 | NR | KAB5590028.1 | 1582974 | g19422 | i0 | 50 | 0.920245398773006 | 50 | 25 | 92 | 0 | 14 | 163 | 202 | 251 | KAB5590028.1 Oxidoreductase DltE [Ceratobasidium theobromae] | diamond | 150 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium theobromae | |
| 28637551 | 28637551 | PRJEB12982_P_NODE_16247_length_170_cov_1.504132_g16084_i0 | PRJEB12982 | 16247 | 170 | 1.504132 | 2.5570244 | Eukaryota | 2759 | Fungi | Fungi | 47 | 2.39e-4 | NR | KAJ7132881.1 | 220801 | g16084 | i0 | 55.3 | 2.52352941176471 | 47 | 20 | 81.2 | 1 | 141 | 4 | 22 | 68 | KAJ7132881.1 hypothetical protein C8R43DRAFT_653580 [Mycena crocata] | diamond | 429 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena crocata | |
| 30286238 | 30286238 | PRJEB12982_P_NODE_19532_length_163_cov_0.894737_g19369_i0 | PRJEB12982 | 19532 | 163 | 0.894737 | 1.45842131 | Meira miltonrushii | 1280837 | Fungi | Fungi | 113 | 1.01e-27 | NR | XP_025355399.1 | 1280837 | g19369 | i0 | 98.1 | 0.993865030674847 | 54 | 1 | 99.4 | 0 | 162 | 1 | 279 | 332 | XP_025355399.1 alpha/beta-hydrolase [Meira miltonrushii] | diamond | 162 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 31227208 | 31227208 | PRJEB12982_P_NODE_13295_length_192_cov_1.069930_g13132_i0 | PRJEB12982 | 13295 | 192 | 1.06993 | 2.0542656 | Basidiomycota | 5204 | Fungi | Fungi | 67.8 | 2.5e-11 | NR | KAI0676928.1 | 259368 | g13132 | i0 | 47.5 | 6.578125 | 61 | 32 | 95.3 | 0 | 186 | 4 | 302 | 362 | KAI0676928.1 GroES-like protein [Trametes maxima] | diamond | 1263 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes maxima | |
| 32144761 | 32144761 | PRJEB12982_P_NODE_19818_length_163_cov_0.894737_g19655_i0 | PRJEB12982 | 19818 | 163 | 0.894737 | 1.45842131 | Opisthokonta | 33154 | Fungi | Fungi | 52.4 | 5.03e-6 | NR | WFD33867.1 | 948313 | g19655 | i0 | 42.6 | 6.86503067484663 | 54 | 31 | 99.4 | 0 | 162 | 1 | 262 | 315 | WFD33867.1 non-specific serine/threonine protein kinase [Malassezia cuniculi] | diamond | 1119 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 32556368 | 32556368 | PRJEB12982_P_NODE_18319_length_165_cov_0.879310_g18156_i0 | PRJEB12982 | 18319 | 165 | 0.87931 | 1.4508615 | Serendipita | 358905 | Fungi | Fungi | 41.6 | 0.0302 | NR | KAG8826147.1 | 2600213 | g18156 | i0 | 48.8 | 2.98181818181818 | 41 | 21 | 74.5 | 0 | 36 | 158 | 124 | 164 | KAG8826147.1 hypothetical protein FRC18_010124, partial [Serendipita sp. 400] | diamond | 492 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita sp. 400 | |
| 32877242 | 32877242 | PRJEB12982_P_NODE_4280_length_365_cov_1.996835_g4117_i0 | PRJEB12982 | 4280 | 365 | 1.996835 | 7.28844775 | Cantharellus anzutake | 1750568 | Fungi | Fungi | 61.2 | 4.36e-8 | NR | XP_038921413.1 | 1750568 | g4117 | i0 | 53.3 | 1.22465753424658 | 60 | 27 | 49.3 | 1 | 365 | 186 | 275 | 333 | XP_038921413.1 60S ribosomal protein L4 [Cantharellus anzutake] | diamond | 447 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Cantharellus | Cantharellus anzutake | |
| 32877243 | 32877243 | PRJEB12982_P_NODE_5380_length_321_cov_1.558824_g5217_i0 | PRJEB12982 | 5380 | 321 | 1.558824 | 5.00382504 | Fistulina hepatica ATCC 64428 | 1128425 | Fungi | Fungi | 137 | 1.35e-36 | NR | KIY43866.1 | 1128425 | g5217 | i0 | 63.8 | 1.93457943925234 | 105 | 38 | 98.1 | 0 | 317 | 3 | 113 | 217 | KIY43866.1 hypothetical protein FISHEDRAFT_52692 [Fistulina hepatica ATCC 64428] | diamond | 621 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Fistulinaceae | Fistulina | Fistulina hepatica |
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);;