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

5 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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
13776325	13776325	PRJNA1111448_S_NODE_96791_length_275_cov_1.618812_g95968_i0	PRJNA1111448	96791	275	1.618812	4.451733	Albugo	65356	SAR_Eukaryotes	SAR_Eukaryotes	127	1.03e-32	NR	CCI42781.1	65357	g95968	i0	69.4	4.63636363636364	85	26	92.7	0	273	19	330	414	CCI42781.1 unnamed protein product [Albugo candida]	diamond	1275	127	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
21894818	21894818	PRJNA1111448_S_NODE_51118_length_345_cov_2.830882_g50295_i0	PRJNA1111448	51118	345	2.830882	9.7665429	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	126	1.96e-33	NR	OQS05478.1	74557	g50295	i0	61.5	6.99130434782609	109	41	94.8	1	345	19	125	232	OQS05478.1 40S ribosomal protein S3-3 [Thraustotheca clavata]	diamond	2412	126	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
27564325	27564325	PRJNA1111448_S_NODE_94304_length_278_cov_1.502439_g93481_i0	PRJNA1111448	94304	278	1.502439	4.17678042	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	111	3.68e-29	NR	KAF0694959.1	120398	g93481	i0	100	1.23021582733813	57	0	61.5	0	3	173	74	130	KAF0694959.1 hypothetical protein As57867_014131 [Aphanomyces stellatus]	diamond	342	111	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
28994474	28994474	PRJNA1111448_S_NODE_81548_length_294_cov_1.045249_g80725_i0	PRJNA1111448	81548	294	1.045249	3.07303206	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	165	2.01e-50	NR	KAF0708390.1	120398	g80725	i0	82.5	1.97959183673469	97	17	99	0	293	3	40	136	KAF0708390.1 hypothetical protein As57867_006351, partial [Aphanomyces stellatus]	diamond	582	165	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
29531009	29531009	PRJNA1111448_S_NODE_109830_length_261_cov_1.468085_g109007_i0	PRJNA1111448	109830	261	1.468085	3.83170185	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	121	5.54e-32	NR	CAH0482684.1	622444	g109007	i0	70	1.75862068965517	80	24	92	0	258	19	140	219	CAH0482684.1 unnamed protein product [Peronospora belbahrii]	diamond	459	121	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii

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