metadata: contig_metadata: 5 rows where bioproject = "PRJNA229468", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA229468", 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
27660586	27660586	PRJNA229468_S_NODE_1244_length_161_cov_1.267857_g1231_i0	PRJNA229468	1244	161	1.267857	2.04124977	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	101	1.98e-26	NR	KAJ0398525.1	114742	g1231	i0	86.8	10.8633540372671	53	7	98.8	0	161	3	23	75	KAJ0398525.1 hypothetical protein ATCC90586_009975 [Pythium insidiosum]	diamond	1749	101	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
27912795	27912795	PRJNA229468_S_NODE_1105_length_166_cov_0.871795_g1092_i0	PRJNA229468	1105	166	0.871795	1.4471797	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	53.9	1.47e-6	NR	KAH9182970.1	100861	g1092	i0	48.9	4.06626506024096	45	21	81.3	1	151	17	73	115	KAH9182970.1 hypothetical protein AeNC1_015056 [Aphanomyces euteiches]	diamond	675	53.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
27926824	27926824	PRJNA229468_S_NODE_1125_length_165_cov_0.879310_g1112_i0	PRJNA229468	1125	165	0.87931	1.4508615	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	57.4	8.64e-8	NR	GLD93914.1	114742	g1112	i0	55.1	0.890909090909091	49	20	85.5	1	142	2	330	378	GLD93914.1 hypothetical protein PINS_up002519 [Pythium insidiosum]	diamond	147	57.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
30091553	30091553	PRJNA229468_S_NODE_672_length_199_cov_2.353333_g659_i0	PRJNA229468	672	199	2.353333	4.68313267	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	96.3	9.35e-24	NR	CAH0519262.1	622444	g659	i0	71.4	8.56281407035176	63	18	95	0	199	11	19	81	CAH0519262.1 unnamed protein product [Peronospora belbahrii]	diamond	1704	96.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
30154684	30154684	PRJNA229468_S_NODE_732_length_191_cov_1.415493_g719_i0	PRJNA229468	732	191	1.415493	2.70359163	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	57.4	1.27e-7	NR	XP_008867870.1	157072	g719	i0	55.1	5.8586387434555	49	22	77	0	191	45	291	339	XP_008867870.1 hypothetical protein H310_05039 [Aphanomyces invadans]	diamond	1119	57.8	0.993079584775087	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);;