contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19633545 | 19633545 | PRJNA534016_P_NODE_13796_length_251_cov_0.865169_g13706_i0 | PRJNA534016 | 13796 | 251 | 0.865169 | 2.17157419 | Wallemia | 148959 | Fungi | Fungi | 72.4 | 1.45e-12 | NR | TIA92543.1 | 1540922 | g13706 | i0 | 77.3 | 3.14342629482072 | 44 | 10 | 52.6 | 0 | 120 | 251 | 278 | 321 | TIA92543.1 hypothetical protein E3P99_00572 [Wallemia hederae] | diamond | 789 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia hederae | |
| 28025426 | 28025426 | PRJNA534016_P_NODE_8885_length_288_cov_1.293023_g8795_i0 | PRJNA534016 | 8885 | 288 | 1.293023 | 3.72390624 | Coprinopsis sp. MPI-PUGE-AT- | 1859955 | Fungi | Fungi | 67.8 | 6.74e-11 | NR | KAH6897529.1 | 2826081 | g8795 | i0 | 38.9 | 1.91666666666667 | 95 | 57 | 97.9 | 1 | 6 | 287 | 139 | 233 | KAH6897529.1 metalloprotease, partial [Coprinopsis sp. MPI-PUGE-AT-0042] | diamond | 552 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis sp. MPI-PUGE-AT-0042 | |
| 28513892 | 28513892 | PRJNA534016_P_NODE_18067_length_241_cov_2.071429_g17977_i0 | PRJNA534016 | 18067 | 241 | 2.071429 | 4.99214389 | Ceratobasidium | 5251 | Fungi | Fungi | 133 | 2.45e-34 | NR | QRV75876.1 | 170446 | g17977 | i0 | 77.2 | 13.7676348547718 | 79 | 18 | 98.3 | 0 | 239 | 3 | 360 | 438 | QRV75876.1 mucoidy inhibitor A [Ceratobasidium sp. AG-Ba] | diamond | 3318 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-Ba | |
| 29414511 | 29414511 | PRJNA534016_P_NODE_15289_length_248_cov_0.880000_g15199_i0 | PRJNA534016 | 15289 | 248 | 0.88 | 2.1824 | Malassezia restricta | 76775 | Fungi | Fungi | 93.6 | 4.64e-21 | NR | XP_027484041.1 | 76775 | g15199 | i0 | 73.6 | 0.641129032258065 | 53 | 14 | 64.1 | 0 | 3 | 161 | 62 | 114 | XP_027484041.1 cysteine-rich secretory protein [Malassezia restricta] | diamond | 159 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30520107 | 30520107 | PRJNA534016_P_NODE_11593_length_266_cov_2.336788_g11503_i0 | PRJNA534016 | 11593 | 266 | 2.336788 | 6.21585608 | Meira miltonrushii | 1280837 | Fungi | Fungi | 152 | 3.999999999999999e-42 | NR | XP_025358680.1 | 1280837 | g11503 | i0 | 79.1 | 10.6917293233083 | 86 | 18 | 97 | 0 | 266 | 9 | 148 | 233 | XP_025358680.1 histone deacetylase, partial [Meira miltonrushii] | diamond | 2844 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 30724595 | 30724595 | PRJNA534016_P_NODE_2774_length_490_cov_2.268585_g2684_i0 | PRJNA534016 | 2774 | 490 | 2.268585 | 11.1160665 | Eukaryota | 2759 | Fungi | Fungi | 73.2 | 8.61e-12 | NR | KAJ1308859.1 | 456999 | g2684 | i0 | 36.2 | 2.36938775510204 | 105 | 60 | 60.6 | 2 | 314 | 18 | 141 | 244 | KAJ1308859.1 hypothetical protein OPQ81_004547 [Rhizoctonia solani] | diamond | 1161 | 73.6 | 0.994565217391304 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 31563430 | 31563430 | PRJNA534016_P_NODE_18896_length_232_cov_2.522013_g18806_i0 | PRJNA534016 | 18896 | 232 | 2.522013 | 5.85107016 | Ceratobasidium sp. 395 | 2600204 | Fungi | Fungi | 97.1 | 1.3099999999999999e-23 | NR | KAG8707497.1 | 2600204 | g18806 | i0 | 58.7 | 0.969827586206897 | 75 | 31 | 97 | 0 | 6 | 230 | 1 | 75 | KAG8707497.1 hypothetical protein FRC09_001786 [Ceratobasidium sp. 395] | diamond | 225 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 395 | |
| 32195908 | 32195908 | PRJNA534016_P_NODE_13158_length_254_cov_1.701657_g13068_i0 | PRJNA534016 | 13158 | 254 | 1.701657 | 4.32220878 | Leucosporidium creatinivorum | 106004 | Fungi | Fungi | 146 | 1.36e-40 | NR | ORY77273.1 | 106004 | g13068 | i0 | 89.3 | 0.992125984251969 | 84 | 9 | 99.2 | 0 | 3 | 254 | 204 | 287 | ORY77273.1 hypothetical protein BCR35DRAFT_305580 [Leucosporidium creatinivorum] | diamond | 252 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium creatinivorum |
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);;