metadata: contig_metadata: 9 rows where bioproject = "PRJNA986547", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA986547", 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
22651201	22651201	PRJNA986547_P_NODE_1438_length_382_cov_0.951456_g1356_i0	PRJNA986547	1438	382	0.951456	3.63456192	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	195	1.7499999999999998e-61	NR	KAF0743747.1	100861	g1356	i0	73.2	2.88219895287958	123	33	96.6	0	13	381	1	123	KAF0743747.1 hypothetical protein Ae201684_001401 [Aphanomyces euteiches]	diamond	1101	195	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
27569442	27569442	PRJNA986547_P_NODE_12244_length_240_cov_5.071856_g12162_i0	PRJNA986547	12244	240	5.071856	12.1724544	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	89.4	1.44e-18	NR	XP_067817417.1	4779	g12162	i0	58.2	16.8125	67	28	83.8	0	240	40	539	605	XP_067817417.1 hypothetical protein CCR75_004345 [Bremia lactucae]	diamond	4035	89.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
27885193	27885193	PRJNA986547_P_NODE_8725_length_250_cov_3.372881_g8643_i0	PRJNA986547	8725	250	3.372881	8.4322025	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.1	4.49e-17	NR	XP_067789266.1	4785	g8643	i0	55.1	12.324	78	33	93.6	1	234	1	45	120	XP_067789266.1 Alanine aminotransferase 2 [Phytophthora cinnamomi]	diamond	3081	85.9	0.990686845168801	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
28958966	28958966	PRJNA986547_P_NODE_13248_length_233_cov_5.300000_g13166_i0	PRJNA986547	13248	233	5.3	12.349	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	72	9.3e-13	NR	RHY18808.1	112090	g13166	i0	69.6	2.88412017167382	56	17	72.1	0	168	1	193	248	RHY18808.1 hypothetical protein DYB25_003459 [Aphanomyces astaci]	diamond	672	72.4	0.994475138121547	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
28990628	28990628	PRJNA986547_P_NODE_4908_length_280_cov_2.265700_g4826_i0	PRJNA986547	4908	280	2.2657	6.34396	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	55.1	2.76e-6	NR	KAE8913668.1	53985	g4826	i0	39.3	2.86071428571429	89	39	83.6	3	1	234	368	452	KAE8913668.1 hypothetical protein PF003_g2265 [Phytophthora fragariae]	diamond	801	55.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
30285518	30285518	PRJNA986547_P_NODE_16032_length_209_cov_4.257353_g15950_i0	PRJNA986547	16032	209	4.257353	8.89786777	root	1	Root_unresolved	Root_unresolved	80.5	1.19e-15	NR	RLN45783.1	325452	g15950	i0	62.1	9.90430622009569	58	21	83.3	1	197	24	680	736	RLN45783.1 hypothetical protein BBJ29_004098 [Phytophthora kernoviae]	diamond	2070	81.3	0.990159901599016	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora kernoviae
31353654	31353654	PRJNA986547_P_NODE_8916_length_250_cov_0.870056_g8834_i0	PRJNA986547	8916	250	0.870056	2.17514	Phytophthora oleae	2107226	SAR_Eukaryotes	SAR_Eukaryotes	51.6	3.08e-5	NR	KAL3666721.1	2107226	g8834	i0	38.7	2.652	62	38	74.4	0	237	52	605	666	KAL3666721.1 hypothetical protein V7S43_008344 [Phytophthora oleae]	diamond	663	51.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora oleae
31707425	31707425	PRJNA986547_P_NODE_16497_length_204_cov_7.496183_g16415_i0	PRJNA986547	16497	204	7.496183	15.29221332	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	93.2	3.76e-20	NR	CCI45297.1	65357	g16415	i0	58.8	26.9558823529412	68	27	98.5	1	202	2	378	445	CCI45297.1 unnamed protein product [Albugo candida]	diamond	5499	94	0.991489361702128	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
31922935	31922935	PRJNA986547_P_NODE_15937_length_209_cov_12.992647_g15855_i0	PRJNA986547	15937	209	12.992647	27.15463223	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0179	NR	XP_008875065.1	157072	g15855	i0	45.2	0.889952153110048	62	31	86.1	2	3	182	441	501	XP_008875065.1 hypothetical protein H310_10446 [Aphanomyces invadans]	diamond	186	43.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans

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