metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA738523" 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
27599913	27599913	PRJNA738523_P_NODE_8744_length_267_cov_1.304124_g8673_i0	PRJNA738523	8744	267	1.304124	3.48201108	Pythiaceae	4782	SAR_Eukaryotes	SAR_Eukaryotes	65.1	6.41e-10	NR	KAJ0410772.1	114742	g8673	i0	50	4.12359550561798	100	38	98.9	4	3	266	132	231	KAJ0410772.1 hypothetical protein ATCC90586_001401 [Pythium insidiosum]	diamond	1101	65.5	0.993893129770992	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
27905064	27905064	PRJNA738523_P_NODE_10825_length_251_cov_0.865169_g10754_i0	PRJNA738523	10825	251	0.865169	2.17157419	Phytophthora kernoviae	325452	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.68e-8	NR	KAG2519636.1	325452	g10754	i0	41.9	4.47011952191235	74	40	88.4	2	26	247	55	125	KAG2519636.1 hypothetical protein JM18_006761 [Phytophthora kernoviae]	diamond	1122	60.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora kernoviae
28262626	28262626	PRJNA738523_P_NODE_13526_length_246_cov_0.890173_g13455_i0	PRJNA738523	13526	246	0.890173	2.18982558	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	87	8.75e-18	NR	RHY06105.1	112090	g13455	i0	58	4.9390243902439	81	33	98.8	1	244	2	339	418	RHY06105.1 hypothetical protein DYB36_008297, partial [Aphanomyces astaci]	diamond	1215	87	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
28473745	28473745	PRJNA738523_P_NODE_14446_length_244_cov_0.900585_g14375_i0	PRJNA738523	14446	244	0.900585	2.1974274	Nothophytophthora sp. Chile5	2483409	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00416	NR	RLN92552.1	2483409	g14375	i0	40.7	1.65983606557377	54	31	65.2	1	159	1	206	259	RLN92552.1 hypothetical protein BBJ28_00007100 [Nothophytophthora sp. Chile5]	diamond	405	45.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Nothophytophthora	Nothophytophthora sp. Chile5
28547214	28547214	PRJNA738523_P_NODE_15887_length_241_cov_1.398810_g15816_i0	PRJNA738523	15887	241	1.39881	3.3711321	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	48.1	3.98e-4	NR	KAH9197853.1	100861	g15816	i0	41.8	1.50622406639004	67	31	77.2	2	210	25	26	89	KAH9197853.1 hypothetical protein AeNC1_000130 [Aphanomyces euteiches]	diamond	363	48.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
29020888	29020888	PRJNA738523_P_NODE_14368_length_244_cov_0.900585_g14297_i0	PRJNA738523	14368	244	0.900585	2.1974274	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	91.3	5.41e-20	NR	KAE9210719.1	53985	g14297	i0	54.3	5.7172131147541	81	37	99.6	0	1	243	185	265	KAE9210719.1 hypothetical protein PF005_g11305 [Phytophthora fragariae]	diamond	1395	91.7	0.995637949836423	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
31126351	31126351	PRJNA738523_P_NODE_11755_length_249_cov_0.875000_g11684_i0	PRJNA738523	11755	249	0.875	2.17875	Hyaloperonospora brassicae	162125	SAR_Eukaryotes	SAR_Eukaryotes	61.2	1.18e-8	NR	CAI5722649.1	162125	g11684	i0	48.6	0.867469879518072	72	30	86.7	3	26	241	204	268	CAI5722649.1 unnamed protein product [Hyaloperonospora brassicae]	diamond	216	61.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora brassicae
32528941	32528941	PRJNA738523_P_NODE_11679_length_249_cov_0.875000_g11608_i0	PRJNA738523	11679	249	0.875	2.17875	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	87.4	7.45e-18	NR	XP_024585157.1	4781	g11608	i0	66.7	2.02409638554217	54	18	65.1	0	231	70	489	542	XP_024585157.1 propionyl-carboxylase beta mitochondrial [Plasmopara halstedii]	diamond	504	87.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
32749314	32749314	PRJNA738523_P_NODE_11500_length_249_cov_1.698864_g11429_i0	PRJNA738523	11500	249	1.698864	4.23017136	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00174	NR	OQR81620.1	74557	g11429	i0	42	3.49397590361446	50	29	60.2	0	21	170	130	179	OQR81620.1 wu:fk36e11 [Thraustotheca clavata]	diamond	870	47	0.991489361702128	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
32770599	32770599	PRJNA738523_P_NODE_13360_length_246_cov_0.890173_g13289_i0	PRJNA738523	13360	246	0.890173	2.18982558	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	85.9	2.47e-17	NR	TYZ68759.1	1485010	g13289	i0	55.6	0.98780487804878	81	36	98.8	0	3	245	281	361	TYZ68759.1 hypothetical protein PybrP1_007006 [[Pythium] brassicae (nom. inval.)]	diamond	243	85.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)

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