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

9 rows where bioproject = "PRJEB81171", 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
139309	139309	PRJEB81171_P_NODE_2161_length_451_cov_2.626984_g2036_i0	PRJEB81171	2161	451	2.626984	11.84769784	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	220	3.89e-71	NR	KAF0743747.1	100861	g2036	i0	71.8	6.65853658536585	142	40	94.5	0	445	20	7	148	KAF0743747.1 hypothetical protein Ae201684_001401 [Aphanomyces euteiches]	diamond	3003	220	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
2689554	2689554	PRJEB81171_P_NODE_9223_length_245_cov_1.494186_g9096_i0	PRJEB81171	9223	245	1.494186	3.6607557	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	82.4	2.82e-11	NTclustered	gi\|669149879\|ref\|XM_008612280.1\|	1156394	g9096	i0	80.952	1.33061224489796	105	18	42	2	140	243	3144	3041	Saprolegnia diclina VS20 hypothetical protein mRNA	blastn	326	82.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
12892808	12892808	PRJEB81171_P_NODE_1331_length_569_cov_3.344758_g1209_i0	PRJEB81171	1331	569	3.344758	19.03167302	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.016	NTclustered	gi\|170285697\|emb\|CU672270.3\|	123356	g1209	i0	100	0.0509666080843585	29	0	5	0	454	482	1789	1761	H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence	blastn	29	54.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
19264947	19264947	PRJEB81171_P_NODE_5096_length_294_cov_2.171946_g4969_i0	PRJEB81171	5096	294	2.171946	6.38552124	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	87.9	7.48e-13	NTclustered	gi\|2794921614\|ref\|XM_067881037.1\|	164328	g4969	i0	87.838	1.38775510204082	74	9	25	0	173	246	119	192	Phytophthora ramorum 40S ribosomal protein S2 (KRP23_10570), partial mRNA	blastn	408	87.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
29647584	29647584	PRJEB81171_P_NODE_6550_length_270_cov_1.939086_g6423_i0	PRJEB81171	6550	270	1.939086	5.2355322	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	109	7.38e-26	NR	KAF1328421.1	82926	g6423	i0	58.1	4.71111111111111	86	36	95.6	0	10	267	25	110	KAF1328421.1 Mitochondrial-processing peptidase subunit beta, partial [Globisporangium splendens]	diamond	1272	109	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
29679234	29679234	PRJEB81171_P_NODE_6010_length_279_cov_1.033981_g5883_i0	PRJEB81171	6010	279	1.033981	2.88480699	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	81.6	1.8e-16	NR	RHZ41357.1	112090	g5883	i0	44.4	3.87096774193548	90	48	96.8	1	6	275	139	226	RHZ41357.1 hypothetical protein DYB31_011106 [Aphanomyces astaci]	diamond	1080	81.6	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
29813044	29813044	PRJEB81171_P_NODE_2071_length_461_cov_1.528351_g1946_i0	PRJEB81171	2071	461	1.528351	7.04569811	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	67	1.44e-9	NR	GLD93027.1	114742	g1946	i0	35.5	1.77006507592191	121	68	78.1	2	363	4	532	643	GLD93027.1 hypothetical protein PINS_up001619 [Pythium insidiosum]	diamond	816	67	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
31709385	31709385	PRJEB81171_P_NODE_1897_length_478_cov_2.167901_g1773_i0	PRJEB81171	1897	478	2.167901	10.36256678	Phytophthora boehmeriae	109152	SAR_Eukaryotes	SAR_Eukaryotes	150	3.569999999999999e-42	NR	KAG7399116.1	109152	g1773	i0	60.4	1.68200836820084	134	51	82.8	1	399	4	17	150	KAG7399116.1 Nucleoside diphosphate kinase III, chloroplastic/mitochondrial [Phytophthora boehmeriae]	diamond	804	150	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
32500541	32500541	PRJEB81171_P_NODE_4839_length_303_cov_0.921739_g4712_i0	PRJEB81171	4839	303	0.921739	2.79286917	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	67.4	1.61e-10	NR	TMW56328.1	41045	g4712	i0	40.7	2.41584158415842	81	43	75.2	2	229	2	11	91	TMW56328.1 hypothetical protein Poli38472_006338 [Pythium oligandrum]	diamond	732	67.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum

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