metadata: contig_metadata: 14 rows where bioproject = "PRJNA833575", tax_clade = "Sar" and tax

14 rows where bioproject = "PRJNA833575", tax_clade = "Sar" 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
824487	824487	PRJNA833575_P_NODE_39841_length_233_cov_1.756098_g39704_i0	PRJNA833575	39841	233	1.756098	4.09170834	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	140	1.32e-36	NR	KAJ8552402.1	4785	g39704	i0	85.7	12.8240343347639	77	11	99.1	0	232	2	726	802	KAJ8552402.1 hypothetical protein ON010_g10144 [Phytophthora cinnamomi]	diamond	2988	141	0.99290780141844	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
7202757	7202757	PRJNA833575_P_NODE_41646_length_231_cov_1.333333_g41509_i0	PRJNA833575	41646	231	1.333333	3.07999923	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	122	1.02e-30	NR	KUF99980.1	4792	g41509	i0	77.6	8.88311688311688	76	17	98.7	0	2	229	202	277	KUF99980.1 hypothetical protein AM588_10009152 [Phytophthora nicotianae]	diamond	2052	123	0.991869918699187	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
7202830	7202830	PRJNA833575_P_NODE_45606_length_227_cov_0.911392_g45469_i0	PRJNA833575	45606	227	0.911392	2.06885984	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	111	1.7e-26	NR	KAH9127454.1	100861	g45469	i0	72.2	8.56387665198238	72	20	95.2	0	2	217	235	306	KAH9127454.1 hypothetical protein LEN26_009249 [Aphanomyces euteiches]	diamond	1944	111	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
16127163	16127163	PRJNA833575_P_NODE_44693_length_228_cov_0.905660_g44556_i0	PRJNA833575	44693	228	0.90566	2.0649048	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	154	5.42e-33	NTclustered	gi\|166051500\|emb\|CU351357.1\|	100861	g44556	i0	80.5	15.0789473684211	200	39	88	0	26	225	304	503	Aphanomyces euteiches cDNA	blastn	3438	154	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
16531571	16531571	PRJNA833575_P_NODE_31573_length_264_cov_1.533333_g31436_i0	PRJNA833575	31573	264	1.533333	4.04799912	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	145	1.37e-38	NR	DAZ96808.1	4803	g31436	i0	80.2	27.375	81	16	92	0	22	264	215	295	DAZ96808.1 TPA: hypothetical protein N0F65_007069 [Lagenidium giganteum]	diamond	7227	145	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
19950644	19950644	PRJNA833575_P_NODE_21616_length_318_cov_2.104418_g21479_i0	PRJNA833575	21616	318	2.104418	6.69204924	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	178	3.009999999999999e-55	NR	KAJ0402934.1	114742	g21479	i0	79.8	44.0849056603774	104	21	98.1	0	1	312	38	141	KAJ0402934.1 hypothetical protein P43SY_005919 [Pythium insidiosum]	diamond	14019	179	0.994413407821229	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
25050640	25050640	PRJNA833575_P_NODE_34780_length_250_cov_1.403315_g34643_i0	PRJNA833575	34780	250	1.403315	3.5082875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	171	7.73e-50	NR	XP_024575811.1	4781	g34643	i0	89.2	70.716	83	9	99.6	0	250	2	119	201	XP_024575811.1 serine threonine-protein phosphatase pp-x isozyme 2 [Plasmopara halstedii]	diamond	17679	172	0.994186046511628	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
27812981	27812981	PRJNA833575_P_NODE_41284_length_232_cov_0.883436_g41147_i0	PRJNA833575	41284	232	0.883436	2.04957152	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	58.5	4.24e-8	NR	CCA21993.1	890382	g41147	i0	43.8	0.943965517241379	73	38	94.4	2	231	13	1	70	CCA21993.1 vesicleassociated membrane protein putative [Albugo laibachii Nc14]	diamond	219	58.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
28137180	28137180	PRJNA833575_P_NODE_13785_length_392_cov_2.789474_g13648_i0	PRJNA833575	13785	392	2.789474	10.93473808	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	134	2.8299999999999996e-35	NR	DBA03690.1	4803	g13648	i0	68.4	12.2448979591837	98	30	75	1	299	6	226	322	DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum]	diamond	4800	135	0.992592592592593	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
28831532	28831532	PRJNA833575_P_NODE_7068_length_534_cov_2.086022_g6931_i0	PRJNA833575	7068	534	2.086022	11.13935748	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	82.8	9.79e-15	NR	XP_009828003.1	112090	g6931	i0	36.1	4.03932584269663	147	82	77.5	4	459	46	104	247	XP_009828003.1 hypothetical protein H257_04997 [Aphanomyces astaci]	diamond	2157	83.6	0.990430622009569	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
28863082	28863082	PRJNA833575_P_NODE_27828_length_282_cov_1.352113_g27691_i0	PRJNA833575	27828	282	1.352113	3.81295866	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	98.2	2.0099999999999994e-23	NR	XP_067742027.1	164328	g27691	i0	58.4	20.7553191489362	89	36	93.6	1	269	6	18	106	XP_067742027.1 Ubiquitin-40S ribosomal protein S27a [Phytophthora ramorum]	diamond	5853	98.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
30126111	30126111	PRJNA833575_P_NODE_32912_length_258_cov_1.804233_g32775_i0	PRJNA833575	32912	258	1.804233	4.65492114	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.1	3.41e-8	NR	GLE07099.1	114742	g32775	i0	48.4	4.45348837209302	64	32	73.3	1	5	193	176	239	GLE07099.1 hypothetical protein PINS_up016968 [Pythium insidiosum]	diamond	1149	60.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
30497064	30497064	PRJNA833575_P_NODE_32973_length_258_cov_1.412698_g32836_i0	PRJNA833575	32973	258	1.412698	3.64476084	Phytophthora megakarya	4795	SAR_Eukaryotes	SAR_Eukaryotes	62.4	5.26e-9	NR	OWY95929.1	4795	g32836	i0	41.5	0.953488372093023	82	47	94.2	1	1	243	7	88	OWY95929.1 Glycoside hydrolase [Phytophthora megakarya]	diamond	246	62.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megakarya
31327023	31327023	PRJNA833575_P_NODE_39335_length_234_cov_0.872727_g39198_i0	PRJNA833575	39335	234	0.872727	2.04218118	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00129	NR	KAH9073826.1	100861	g39198	i0	50.9	2.11538461538462	55	21	70.5	2	167	3	2	50	KAH9073826.1 hypothetical protein Ae201684P_003328 [Aphanomyces euteiches]	diamond	495	45.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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