metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA637219" 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
608836	608836	PRJNA637219_S_NODE_6161_length_204_cov_1.232258_g6116_i0	PRJNA637219	6161	204	1.232258	2.51380632	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	115	3.29e-29	NR	KAH9103229.1	100861	g6116	i0	83.6	16.75	67	11	98.5	0	3	203	146	212	KAH9103229.1 hypothetical protein AeMF1_020367 [Aphanomyces euteiches]	diamond	3417	115	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
1884872	1884872	PRJNA637219_S_NODE_10362_length_168_cov_1.226891_g10317_i0	PRJNA637219	10362	168	1.226891	2.06117688	root	1	Root_unresolved	Root_unresolved	97.8	4.49e-22	NR	GLE04626.1	114742	g10317	i0	88	2.67857142857143	50	6	89.3	0	168	19	353	402	GLE04626.1 hypothetical protein PINS_up013596 [Pythium insidiosum]	diamond	450	98.6	0.991886409736308	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
1884879	1884879	PRJNA637219_S_NODE_1082_length_413_cov_8.181319_g1037_i0	PRJNA637219	1082	413	8.181319	33.78884747	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	149	9.799999999999999e-44	NR	TMW58359.1	41045	g1037	i0	63.2	1.70702179176755	117	43	85	0	24	374	2	118	TMW58359.1 hypothetical protein Poli38472_009918 [Pythium oligandrum]	diamond	705	149	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
6987259	6987259	PRJNA637219_S_NODE_13406_length_164_cov_1.173913_g13361_i0	PRJNA637219	13406	164	1.173913	1.92521732	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	107	4.44e-28	NR	CCI42937.1	65357	g13361	i0	94.3	0.969512195121951	53	3	97	0	163	5	79	131	CCI42937.1 unnamed protein product [Albugo candida]	diamond	159	107	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
28849276	28849276	PRJNA637219_S_NODE_7128_length_193_cov_1.416667_g7083_i0	PRJNA637219	7128	193	1.416667	2.73416731	Phytophthora boehmeriae	109152	SAR_Eukaryotes	SAR_Eukaryotes	55.5	6.19e-7	NR	KAG7399871.1	109152	g7083	i0	46	6.85492227979275	63	33	97.9	1	193	5	249	310	KAG7399871.1 Protein yif1b [Phytophthora boehmeriae]	diamond	1323	55.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
28924945	28924945	PRJNA637219_S_NODE_11068_length_167_cov_0.864407_g11023_i0	PRJNA637219	11068	167	0.864407	1.44355969	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	66.2	6.83e-11	NR	KAK1937051.1	4793	g11023	i0	63.3	20.2095808383234	49	18	88	0	149	3	1024	1072	KAK1937051.1 Multidrug resistance protein 1A [Phytophthora citrophthora]	diamond	3375	66.6	0.993993993993994	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora citrophthora
29493423	29493423	PRJNA637219_S_NODE_6670_length_198_cov_1.617450_g6625_i0	PRJNA637219	6670	198	1.61745	3.202551	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	72	9.65e-15	NR	DBA04642.1	4803	g6625	i0	63.8	9.74242424242424	47	17	71.2	0	145	5	14	60	DBA04642.1 TPA: hypothetical protein N0F65_012225 [Lagenidium giganteum]	diamond	1929	72.4	0.994475138121547	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
29714070	29714070	PRJNA637219_S_NODE_16910_length_161_cov_0.910714_g16865_i0	PRJNA637219	16910	161	0.910714	1.46624954	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	41.2	0.0435	NR	XP_024584594.1	4781	g16865	i0	47.1	3.24223602484472	34	18	63.4	0	6	107	383	416	XP_024584594.1 poly polymerase catalytic domain containing protein [Plasmopara halstedii]	diamond	522	41.6	0.990384615384615	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
29923144	29923144	PRJNA637219_S_NODE_6131_length_204_cov_2.019355_g6086_i0	PRJNA637219	6131	204	2.019355	4.1194842	Phytophthora fragariae	53985	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.00609	NR	KAE8894613.1	53985	g6086	i0	32.9	1.07352941176471	73	37	92.6	3	203	15	83	153	KAE8894613.1 hypothetical protein PF003_g21468 [Phytophthora fragariae]	diamond	219	44.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
30598857	30598857	PRJNA637219_S_NODE_7773_length_187_cov_1.115942_g7728_i0	PRJNA637219	7773	187	1.115942	2.08681154	root	1	Root_unresolved	Root_unresolved	76.6	2e-14	NR	TYZ51933.1	1485010	g7728	i0	64.5	12.6898395721925	62	16	99.5	1	187	2	209	264	TYZ51933.1 hypothetical protein PybrP1_006673 [[Pythium] brassicae (nom. inval.)]	diamond	2373	76.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
30870854	30870854	PRJNA637219_S_NODE_15094_length_163_cov_0.894737_g15049_i0	PRJNA637219	15094	163	0.894737	1.45842131	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	65.5	1.21e-10	NR	KAF0689980.1	120398	g15049	i0	63.8	0.865030674846626	47	17	86.5	0	142	2	364	410	KAF0689980.1 hypothetical protein As57867_018562 [Aphanomyces stellatus]	diamond	141	65.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
30997328	30997328	PRJNA637219_S_NODE_16054_length_162_cov_0.902655_g16009_i0	PRJNA637219	16054	162	0.902655	1.4623011	Phytophthora citrophthora	4793	SAR_Eukaryotes	SAR_Eukaryotes	57	4.74e-8	NR	KAK1929870.1	4793	g16009	i0	52.9	0.944444444444444	51	24	94.4	0	10	162	1	51	KAK1929870.1 hypothetical protein P3T76_014716 [Phytophthora citrophthora]	diamond	153	57	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora citrophthora
31958368	31958368	PRJNA637219_S_NODE_3157_length_264_cov_1.190698_g3112_i0	PRJNA637219	3157	264	1.190698	3.14344272	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	47.4	1.02e-4	NR	XP_008873562.1	157072	g3112	i0	42.6	1.56818181818182	47	27	53.4	0	257	117	18	64	XP_008873562.1 hypothetical protein H310_09302 [Aphanomyces invadans]	diamond	414	47.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
32610211	32610211	PRJNA637219_S_NODE_11220_length_167_cov_0.864407_g11175_i0	PRJNA637219	11220	167	0.864407	1.44355969	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	46.6	8.65e-5	NR	TMW68050.1	41045	g11175	i0	57.5	1.40119760479042	40	13	70.1	2	120	4	22	58	TMW68050.1 hypothetical protein Poli38472_007722 [Pythium oligandrum]	diamond	234	46.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
32862069	32862069	PRJNA637219_S_NODE_8480_length_181_cov_1.143939_g8435_i0	PRJNA637219	8480	181	1.143939	2.07052959	Bremia lactucae	4779	SAR_Eukaryotes	SAR_Eukaryotes	73.9	2.2e-14	NR	XP_067816087.1	4779	g8435	i0	58.3	0.994475138121547	60	25	99.4	0	180	1	90	149	XP_067816087.1 uncharacterized protein CCR75_005623 [Bremia lactucae]	diamond	180	73.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae

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