contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA663960" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26828446 | 26828446 | PRJNA663960_S_NODE_10501_length_329_cov_3.053191_g10265_i0 | PRJNA663960 | 10501 | 329 | 3.053191 | 10.04499839 | Malassezia nana | 180528 | Fungi | Fungi | 133 | 2.6000000000000002e-37 | NR | WFD28884.1 | 180528 | g10265 | i0 | 67 | 2.5258358662614 | 94 | 31 | 85.7 | 0 | 3 | 284 | 54 | 147 | WFD28884.1 hypothetical protein MNAN1_003899 [Malassezia nana] | diamond | 831 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 26828447 | 26828447 | PRJNA663960_S_NODE_11321_length_322_cov_2.636364_g11085_i0 | PRJNA663960 | 11321 | 322 | 2.636364 | 8.48909208 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 144 | 3.929999999999999e-42 | NR | XP_066819462.1 | 1397322 | g11085 | i0 | 72 | 0.866459627329193 | 93 | 26 | 86.6 | 0 | 2 | 280 | 38 | 130 | XP_066819462.1 NADH dehydrogenase, alpha subcomplex, subunit 6 [Cystobasidium minutum MCA 4210] | diamond | 279 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 28186650 | 28186650 | PRJNA663960_S_NODE_16466_length_285_cov_6.924370_g16230_i0 | PRJNA663960 | 16466 | 285 | 6.92437 | 19.7344545 | Malassezia cuniculi | 948313 | Fungi | Fungi | 78.2 | 2.05e-14 | NR | WFD35143.1 | 948313 | g16230 | i0 | 68.3 | 0.631578947368421 | 60 | 19 | 63.2 | 0 | 6 | 185 | 473 | 532 | WFD35143.1 threonine synthase [Malassezia cuniculi] | diamond | 180 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 28881431 | 28881431 | PRJNA663960_S_NODE_43028_length_185_cov_3.956522_g42792_i0 | PRJNA663960 | 43028 | 185 | 3.956522 | 7.3195657 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 73.9 | 1.5e-14 | NR | XP_017991387.1 | 77020 | g42792 | i0 | 59 | 1.97837837837838 | 61 | 25 | 98.9 | 0 | 3 | 185 | 102 | 162 | XP_017991387.1 hypothetical protein Malapachy_1963 [Malassezia pachydermatis] | diamond | 366 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 30219917 | 30219917 | PRJNA663960_S_NODE_51792_length_168_cov_1.685950_g51556_i0 | PRJNA663960 | 51792 | 168 | 1.68595 | 2.832396 | Malassezia | 55193 | Fungi | Fungi | 86.7 | 2.82e-19 | NR | WFD34732.1 | 948313 | g51556 | i0 | 76.8 | 1.98214285714286 | 56 | 13 | 100 | 0 | 168 | 1 | 130 | 185 | WFD34732.1 60S ribosomal protein L13 [Malassezia cuniculi] | diamond | 333 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 31345507 | 31345507 | PRJNA663960_S_NODE_20176_length_264_cov_2.304147_g19940_i0 | PRJNA663960 | 20176 | 264 | 2.304147 | 6.08294808 | Favolaschia claudopus | 2862362 | Fungi | Fungi | 44.3 | 0.0125 | NR | KAK7005443.1 | 2862362 | g19940 | i0 | 33.3 | 0.920454545454545 | 81 | 52 | 92 | 1 | 259 | 17 | 175 | 253 | KAK7005443.1 hypothetical protein R3P38DRAFT_3604659 [Favolaschia claudopus] | diamond | 243 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Favolaschia | Favolaschia claudopus | |
| 31567073 | 31567073 | PRJNA663960_S_NODE_41136_length_190_cov_1.160839_g40900_i0 | PRJNA663960 | 41136 | 190 | 1.160839 | 2.2055941 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 51.6 | 1.41e-5 | NR | WFD16437.1 | 1514897 | g40900 | i0 | 100 | 0.363157894736842 | 23 | 0 | 36.3 | 0 | 69 | 1 | 2841 | 2863 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 69 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 32041386 | 32041386 | PRJNA663960_S_NODE_60558_length_159_cov_1.035714_g60322_i0 | PRJNA663960 | 60558 | 159 | 1.035714 | 1.64678526 | Malassezia restricta | 76775 | Fungi | Fungi | 107 | 3.44e-28 | NR | XP_027484891.1 | 76775 | g60322 | i0 | 92.3 | 0.981132075471698 | 52 | 4 | 98.1 | 0 | 159 | 4 | 96 | 147 | XP_027484891.1 calcium sensor Efh [Malassezia restricta] | diamond | 156 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;