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

10 rows where analysis = "diamond", bioproject = "PRJNA692200" 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
18524945	18524945	PRJNA692200_S_NODE_695_length_474_cov_768.402353_g657_i0	PRJNA692200	695	474	768.402353	3642.22715322	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	153	9.74e-43	NR	TYZ67175.1	1485010	g657	i0	60	9.26582278481013	130	47	80.4	2	472	92	154	281	TYZ67175.1 hypothetical protein PybrP1_001669, partial [[Pythium] brassicae (nom. inval.)]	diamond	4392	153	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
26650543	26650543	PRJNA692200_S_NODE_15121_length_187_cov_2.007246_g15064_i0	PRJNA692200	15121	187	2.007246	3.75355002	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	54.3	1.46e-6	NR	KAF1795771.1	29920	g15064	i0	50	5.67914438502674	54	22	78.6	2	2	148	170	223	KAF1795771.1 P-loop containing nucleoside triphosphate hydrolase [Phytophthora cactorum]	diamond	1062	54.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
28136328	28136328	PRJNA692200_S_NODE_7445_length_251_cov_1.282178_g7388_i0	PRJNA692200	7445	251	1.282178	3.21826678	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	58.2	4.79e-8	NR	KAF0701472.1	120398	g7388	i0	37.6	2.03187250996016	85	44	90.8	3	12	239	58	142	KAF0701472.1 hypothetical protein As57867_008018 [Aphanomyces stellatus]	diamond	510	58.5	0.994871794871795	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
28578254	28578254	PRJNA692200_S_NODE_22687_length_159_cov_2.236364_g22630_i0	PRJNA692200	22687	159	2.236364	3.55581876	Albugo	65356	SAR_Eukaryotes	SAR_Eukaryotes	41.6	0.0306	NR	CCI43855.1	65357	g22630	i0	38.8	2.66037735849057	49	25	83	1	154	23	268	316	CCI43855.1 unnamed protein product [Albugo candida]	diamond	423	42	0.990476190476191	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
29556848	29556848	PRJNA692200_S_NODE_19410_length_168_cov_2.697479_g19353_i0	PRJNA692200	19410	168	2.697479	4.53176472	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	69.7	4.12e-13	NR	XP_067815842.1	4779	g19353	i0	91.7	1.28571428571429	36	3	64.3	0	166	59	130	165	XP_067815842.1 uncharacterized protein CCR75_002732 [Bremia lactucae]	diamond	216	69.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
30651018	30651018	PRJNA692200_S_NODE_9173_length_232_cov_1.300546_g9116_i0	PRJNA692200	9173	232	1.300546	3.01726672	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	106	8.51e-26	NR	KAG9410527.1	112091	g9116	i0	94.7	2.14655172413793	57	3	73.7	0	9	179	234	290	KAG9410527.1 hypothetical protein AC1031_018567 [Aphanomyces cochlioides]	diamond	498	106	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
30714428	30714428	PRJNA692200_S_NODE_17994_length_173_cov_4.435484_g17937_i0	PRJNA692200	17994	173	4.435484	7.67338732	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	48.5	1.32e-4	NR	XP_067741692.1	164328	g17937	i0	57.1	0.728323699421965	42	17	71.1	1	173	51	624	665	XP_067741692.1 Long chain acyl-CoA synthetase 7, peroxisomal [Phytophthora ramorum]	diamond	126	48.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
30777737	30777737	PRJNA692200_S_NODE_9774_length_226_cov_1.367232_g9717_i0	PRJNA692200	9774	226	1.367232	3.08994432	Nothophytophthora sp. Chile5	2483409	SAR_Eukaryotes	SAR_Eukaryotes	62	4.8e-9	NR	RLN55150.1	2483409	g9717	i0	46.7	0.79646017699115	60	31	78.3	1	223	47	452	511	RLN55150.1 hypothetical protein BBJ28_00027179, partial [Nothophytophthora sp. Chile5]	diamond	180	62	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Nothophytophthora	Nothophytophthora sp. Chile5
31199306	31199306	PRJNA692200_S_NODE_19975_length_167_cov_1.110169_g19918_i0	PRJNA692200	19975	167	1.110169	1.85398223	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	77.8	5.7e-15	NR	KAH9192935.1	100861	g19918	i0	86.8	1.36526946107784	38	5	68.3	0	163	50	461	498	KAH9192935.1 hypothetical protein AeNC1_005084 [Aphanomyces euteiches]	diamond	228	77.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
32137430	32137430	PRJNA692200_S_NODE_17378_length_176_cov_2.377953_g17321_i0	PRJNA692200	17378	176	2.377953	4.18519728	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	49.7	2.06e-5	NR	RHY74090.1	112090	g17321	i0	54.2	0.818181818181818	48	17	73.3	1	6	134	108	155	RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci]	diamond	144	49.7	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci

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