contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA931595" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26936968 | 26936968 | PRJNA931595_P_NODE_12402_length_251_cov_0.865169_g12293_i0 | PRJNA931595 | 12402 | 251 | 0.865169 | 2.17157419 | Malassezia | 55193 | Fungi | Fungi | 136 | 5.529999999999998e-35 | NR | XP_018741521.1 | 1230383 | g12293 | i0 | 94.3 | 3.35856573705179 | 70 | 3 | 83.7 | 1 | 249 | 40 | 1494 | 1562 | XP_018741521.1 uncharacterized protein MSY001_3022 [Malassezia sympodialis ATCC 42132] | diamond | 843 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 28983167 | 28983167 | PRJNA931595_P_NODE_8568_length_285_cov_1.155660_g8459_i0 | PRJNA931595 | 8568 | 285 | 1.15566 | 3.293631 | Roridomyces roridus | 1738132 | Fungi | Fungi | 45.1 | 0.00922 | NR | KAJ7620048.1 | 1738132 | g8459 | i0 | 40 | 0.578947368421053 | 55 | 28 | 52.6 | 1 | 275 | 126 | 300 | 354 | KAJ7620048.1 acyl-CoA dehydrogenase NM domain-like protein [Roridomyces roridus] | diamond | 165 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Roridomyces | Roridomyces roridus | |
| 29519626 | 29519626 | PRJNA931595_P_NODE_11930_length_254_cov_1.475138_g11821_i0 | PRJNA931595 | 11930 | 254 | 1.475138 | 3.74685052 | Macrolepiota fuliginosa MF-IS2 | 1400762 | Fungi | Fungi | 42.7 | 0.041 | NR | KAF9448581.1 | 1400762 | g11821 | i0 | 40 | 0.767716535433071 | 65 | 31 | 74.4 | 3 | 2 | 190 | 286 | 344 | KAF9448581.1 iron permease FTR1 [Macrolepiota fuliginosa MF-IS2] | diamond | 195 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Macrolepiota | Macrolepiota fuliginosa | |
| 31700072 | 31700072 | PRJNA931595_P_NODE_8377_length_287_cov_0.948598_g8268_i0 | PRJNA931595 | 8377 | 287 | 0.948598 | 2.72247626 | Auricularia subglabra TFB-1 | 1331295 | Fungi | Fungi | 60.1 | 5.07e-8 | NR | EJD53658.1 | 717982 | g8268 | i0 | 33.3 | 1.34843205574913 | 129 | 52 | 99.3 | 3 | 285 | 1 | 437 | 565 | EJD53658.1 hypothetical protein AURDEDRAFT_180088 [Auricularia subglabra TFB-10046 SS5] | diamond | 387 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra | |
| 31984687 | 31984687 | PRJNA931595_P_NODE_11598_length_257_cov_2.086957_g11489_i0 | PRJNA931595 | 11598 | 257 | 2.086957 | 5.36347949 | Amylocystis lapponica | 202700 | Fungi | Fungi | 42.7 | 0.0421 | NR | KAH9948595.1 | 202700 | g11489 | i0 | 37.7 | 0.898832684824903 | 77 | 40 | 80.5 | 2 | 9 | 215 | 146 | 222 | KAH9948595.1 hypothetical protein B0H21DRAFT_733212 [Amylocystis lapponica] | diamond | 231 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Postiaceae | Amylocystis | Amylocystis lapponica | |
| 32743406 | 32743406 | PRJNA931595_P_NODE_10160_length_271_cov_1.323232_g10051_i0 | PRJNA931595 | 10160 | 271 | 1.323232 | 3.58595872 | Rhizoctonia solani | 456999 | Fungi | Fungi | 65.9 | 2.03e-11 | NR | CAE6478117.1 | 456999 | g10051 | i0 | 48.3 | 0.985239852398524 | 89 | 46 | 98.5 | 0 | 3 | 269 | 9 | 97 | CAE6478117.1 unnamed protein product [Rhizoctonia solani] | diamond | 267 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani |
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);;