metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax_phylum = "Oomycota"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11155273	11155273	PRJNA977246_S_NODE_6229_length_641_cov_4.212418_g5482_i0	PRJNA977246	6229	641	4.212418	27.00159938	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	193	4.38e-59	NR	RHY03263.1	112090	g5482	i0	59.6	2.1201248049922	151	61	70.7	0	34	486	22	172	RHY03263.1 hypothetical protein DYB36_008331, partial [Aphanomyces astaci]	diamond	1359	193	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
12748226	12748226	PRJNA977246_S_NODE_46270_length_163_cov_1.641791_g45278_i0	PRJNA977246	46270	163	1.641791	2.67611933	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	117	1.74e-29	NR	XP_024574992.1	4781	g45278	i0	100	51.680981595092	54	0	99.4	0	163	2	172	225	XP_024574992.1 ck1 ck1 ck1-d protein kinase [Plasmopara halstedii]	diamond	8424	117	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
29047353	29047353	PRJNA977246_S_NODE_16508_length_353_cov_3.734568_g15517_i0	PRJNA977246	16508	353	3.734568	13.18302504	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	79.7	1.97e-15	NR	GLD97161.1	114742	g15517	i0	45.8	1.86118980169972	107	51	90.9	4	22	342	112	211	GLD97161.1 hypothetical protein PINS_up005844 [Pythium insidiosum]	diamond	657	79.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
29425935	29425935	PRJNA977246_S_NODE_35449_length_199_cov_4.200000_g34457_i0	PRJNA977246	35449	199	4.2	8.358	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	62.4	2.45e-9	NR	KAJ0402321.1	114742	g34457	i0	57.7	0.78391959798995	52	19	73.9	2	189	43	160	211	KAJ0402321.1 hypothetical protein P43SY_008562 [Pythium insidiosum]	diamond	156	62.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
31137847	31137847	PRJNA977246_S_NODE_5675_length_676_cov_28.777434_g4975_i0	PRJNA977246	5675	676	28.777434	194.53545384	Pythiaceae	4782	SAR_Eukaryotes	SAR_Eukaryotes	128	6.5e-34	NR	DAZ93102.1	4803	g4975	i0	54.3	5.27218934911243	127	57	56.4	1	60	440	4	129	DAZ93102.1 TPA: hypothetical protein N0F65_006854 [Lagenidium giganteum]	diamond	3564	129	0.992248062015504	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum

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