metadata: contig_metadata: 7 rows where bioproject = "PRJNA1095825", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA1095825", 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
16777433	16777433	PRJNA1095825_P_NODE_205694_length_272_cov_1.829146_g202631_i0	PRJNA1095825	205694	272	1.829146	4.97527712	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.49e-4	NTclustered	gi\|813220221\|ref\|XM_012356098.1\|	695850	g202631	i0	97.143	0.128676470588235	35	1	13	0	59	93	171	137	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	35	60.2	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
26878061	26878061	PRJNA1095825_P_NODE_273701_length_245_cov_0.895349_g270638_i0	PRJNA1095825	273701	245	0.895349	2.19360505	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	91.7	2.34e-19	NR	KAJ0398341.1	114742	g270638	i0	55.6	1.98367346938776	81	35	99.2	1	245	3	605	684	KAJ0398341.1 hypothetical protein ATCC90586_006212 [Pythium insidiosum]	diamond	486	91.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
26995442	26995442	PRJNA1095825_P_NODE_248742_length_249_cov_0.875000_g245679_i0	PRJNA1095825	248742	249	0.875	2.17875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	64.3	9.2e-10	NR	KAG1706867.1	4784	g245679	i0	72.2	9.62650602409639	36	10	43.4	0	139	246	257	292	KAG1706867.1 hypothetical protein DVH05_028706 [Phytophthora capsici]	diamond	2397	64.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
28038227	28038227	PRJNA1095825_P_NODE_166625_length_302_cov_2.008734_g163562_i0	PRJNA1095825	166625	302	2.008734	6.06637668	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	3.94e-30	NR	KAJ0412157.1	114742	g163562	i0	67.5	14.5430463576159	83	26	82.5	1	3	251	621	702	KAJ0412157.1 hypothetical protein ATCC90586_005770 [Pythium insidiosum]	diamond	4392	123	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
30825863	30825863	PRJNA1095825_P_NODE_258974_length_247_cov_0.885057_g255911_i0	PRJNA1095825	258974	247	0.885057	2.18609079	Phytophthora fragariae	53985	SAR_Eukaryotes	SAR_Eukaryotes	93.6	4.35e-20	NR	KAE9247899.1	53985	g255911	i0	67.1	4.4331983805668	73	23	88.7	1	3	221	183	254	KAE9247899.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora fragariae]	diamond	1095	93.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
30952497	30952497	PRJNA1095825_P_NODE_93674_length_392_cov_2.445141_g90611_i0	PRJNA1095825	93674	392	2.445141	9.58495272	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	93.6	2.29e-21	NR	KAJ0400315.1	114742	g90611	i0	49.2	1.89030612244898	126	57	93.4	3	368	3	2	124	KAJ0400315.1 hypothetical protein P43SY_002063 [Pythium insidiosum]	diamond	741	93.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
32691209	32691209	PRJNA1095825_P_NODE_288160_length_242_cov_0.911243_g285097_i0	PRJNA1095825	288160	242	0.911243	2.20520806	Phytophthora lilii	2077276	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0255	NR	GMF18441.1	2077276	g285097	i0	40.7	0.669421487603306	54	32	66.9	0	6	167	267	320	GMF18441.1 unnamed protein product [Phytophthora lilii]	diamond	162	43.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora lilii

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