metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA380660" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA380660" and tax_phylum = "Basidiomycota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
8055521	8055521	PRJNA380660_P_NODE_7947_length_249_cov_2.940909_g7547_i0	PRJNA380660	7947	249	2.940909	7.32286341	Papiliotrema laurentii	5418	Fungi	Fungi	154	1.85e-41	NR	KAK1922076.1	5418	g7547	i0	90.4	1	83	8	100	0	1	249	111	193	KAK1922076.1 putative ATP-binding cassette transporter [Papiliotrema laurentii]	diamond	249	154	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Rhynchogastremaceae	Papiliotrema	Papiliotrema laurentii
26916833	26916833	PRJNA380660_P_NODE_5162_length_346_cov_2.589905_g4764_i0	PRJNA380660	5162	346	2.589905	8.9610713	Malassezia restricta	76775	Fungi	Fungi	105	1.14e-25	NR	XP_027486111.1	76775	g4764	i0	53	0.997109826589595	115	49	99.7	1	2	346	83	192	XP_027486111.1 uncharacterized protein MRET_3769 [Malassezia restricta]	diamond	345	105	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27074998	27074998	PRJNA380660_P_NODE_5622_length_327_cov_2.406040_g5223_i0	PRJNA380660	5622	327	2.40604	7.8677508	Vanrija humicola	5417	Fungi	Fungi	44.7	0.0196	NR	TXT10897.1	5417	g5223	i0	36.2	1.28440366972477	69	40	61.5	3	216	16	86	152	TXT10897.1 hypothetical protein VHUM_01648 [Vanrija humicola]	diamond	420	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija humicola
29001779	29001779	PRJNA380660_P_NODE_6268_length_303_cov_2.967153_g5868_i0	PRJNA380660	6268	303	2.967153	8.99047359	Taiwanofungus camphoratus	2696576	Fungi	Fungi	63.2	5.15e-9	NR	KAI0920573.1	2696576	g5868	i0	59.3	2.79207920792079	54	17	53.5	1	103	264	282	330	KAI0920573.1 hypothetical protein AcV5_010272 [Taiwanofungus camphoratus]	diamond	846	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Taiwanofungaceae	Taiwanofungus	Taiwanofungus camphoratus
29285402	29285402	PRJNA380660_P_NODE_489_length_1234_cov_5.786722_g349_i0	PRJNA380660	489	1234	5.786722	71.40814948	Tulasnella sp. JGI-2	1905295	Fungi	Fungi	101	9.9700000000000009e-22	NR	KAG8998061.1	2600232	g349	i0	37.8	0.359805510534846	148	87	34.8	3	681	1109	1	148	KAG8998061.1 hypothetical protein FRB94_007224 [Tulasnella sp. JGI-2019a]	diamond	444	101	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae		Tulasnella sp. JGI-2019a
30011988	30011988	PRJNA380660_P_NODE_5391_length_336_cov_3.576547_g4992_i0	PRJNA380660	5391	336	3.576547	12.01719792	Laccaria bicolor S238N-H82	486041	Fungi	Fungi	83.6	5.2e-16	NR	XP_001877012.1	486041	g4992	i0	51	0.928571428571429	104	47	89.3	3	320	21	689	792	XP_001877012.1 uncharacterized protein LACBIDRAFT_292769 [Laccaria bicolor S238N-H82]	diamond	312	83.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hydnangiaceae	Laccaria	Laccaria bicolor
30250252	30250252	PRJNA380660_P_NODE_11072_length_188_cov_1.937107_g10672_i0	PRJNA380660	11072	188	1.937107	3.64176116	Russula	5402	Fungi	Fungi	61.6	7.55e-10	NR	KAH9967509.1	258981	g10672	i0	41.7	2.80851063829787	60	35	95.7	0	8	187	64	123	KAH9967509.1 protein-tyrosine phosphatase-like protein, partial [Russula dissimulans]	diamond	528	62	0.993548387096774	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula dissimulans
30706854	30706854	PRJNA380660_P_NODE_7554_length_261_cov_2.155172_g7154_i0	PRJNA380660	7554	261	2.155172	5.62499892	Cryptococcus sp. DSM 1	2770025	Fungi	Fungi	82.8	1.11e-17	NR	WVQ83618.1	2770025	g7154	i0	48.8	0.988505747126437	86	44	98.9	0	3	260	29	114	WVQ83618.1 hypothetical protein IAT38_005759 [Cryptococcus sp. DSM 104549]	diamond	258	82.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus sp. DSM 104549
30801628	30801628	PRJNA380660_P_NODE_5494_length_332_cov_3.874587_g5095_i0	PRJNA380660	5494	332	3.874587	12.86362884	Cerrena zonata	2478898	Fungi	Fungi	45.8	0.00837	NR	KAK7683021.1	2478898	g5095	i0	27.6	0.948795180722892	105	71	92.2	2	21	326	221	323	KAK7683021.1 hypothetical protein QCA50_013693 [Cerrena zonata]	diamond	315	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Cerrenaceae	Cerrena	Cerrena zonata
30864834	30864834	PRJNA380660_P_NODE_5674_length_325_cov_2.581081_g5275_i0	PRJNA380660	5674	325	2.581081	8.38851325	Trametes cingulata	575983	Fungi	Fungi	55.1	4.61e-6	NR	KAI0361037.1	575983	g5275	i0	55.3	2.12307692307692	47	15	43.4	1	158	18	543	583	KAI0361037.1 hypothetical protein OH77DRAFT_1417236 [Trametes cingulata]	diamond	690	55.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes cingulata
31781619	31781619	PRJNA380660_P_NODE_7977_length_248_cov_3.520548_g7577_i0	PRJNA380660	7977	248	3.520548	8.73095904	Microbotryum silenes-dioicae	796604	Fungi	Fungi	45.1	0.00626	NR	SGY12556.1	796604	g7577	i0	36.4	1.83870967741935	77	37	78.6	2	195	1	1207	1283	SGY12556.1 BQ5605_C011g06540 [Microbotryum silenes-dioicae]	diamond	456	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Microbotryales	Microbotryaceae	Microbotryum	Microbotryum silenes-dioicae
32351504	32351504	PRJNA380660_P_NODE_6299_length_302_cov_1.534799_g5899_i0	PRJNA380660	6299	302	1.534799	4.63509298	Collybia nuda	64659	Fungi	Fungi	110	1.21e-25	NR	KAF9459792.1	64659	g5899	i0	76.4	0.884105960264901	89	16	83.4	1	253	2	60	148	KAF9459792.1 hypothetical protein BDZ94DRAFT_987108 [Collybia nuda]	diamond	267	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Clitocybaceae	Collybia	Collybia nuda

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);;