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

7 rows where bioproject = "PRJNA557895", 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
14565193	14565193	PRJNA557895_P_NODE_3152_length_552_cov_37.298211_g2810_i0	PRJNA557895	3152	552	37.298211	205.88612472	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	987	0	NTclustered	gi\|325194495\|emb\|FR825318.1\|	890382	g2810	i0	98.913	240.791666666667	552	6	100	0	1	552	582	31	Albugo laibachii Nc14, genomic contig CONTIG_2072_NC14_v4_1125_53	blastn	132917	987	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
22212799	22212799	PRJNA557895_P_NODE_11698_length_269_cov_2.436364_g11343_i0	PRJNA557895	11698	269	2.436364	6.55381916	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	144	1.46e-41	NR	KAE8946087.1	53985	g11343	i0	71.6	16.7509293680297	88	25	98.1	0	1	264	58	145	KAE8946087.1 Ras-related protein [Phytophthora fragariae]	diamond	4506	145	0.993103448275862	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
27236860	27236860	PRJNA557895_P_NODE_34923_length_164_cov_0.886957_g34568_i0	PRJNA557895	34923	164	0.886957	1.45460948	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	83.2	7.09e-17	NR	GLE07309.1	114742	g34568	i0	78.8	1.90243902439024	52	11	95.1	0	159	4	2491	2542	GLE07309.1 hypothetical protein PINS_up017439 [Pythium insidiosum]	diamond	312	83.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
29335055	29335055	PRJNA557895_P_NODE_37269_length_162_cov_0.902655_g36914_i0	PRJNA557895	37269	162	0.902655	1.4623011	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00678	NR	XP_067819810.1	4779	g36914	i0	42	2.83333333333333	50	29	92.6	0	1	150	216	265	XP_067819810.1 hypothetical protein CCR75_001658 [Bremia lactucae]	diamond	459	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
30300457	30300457	PRJNA557895_P_NODE_27792_length_174_cov_1.224000_g27437_i0	PRJNA557895	27792	174	1.224	2.12976	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	53.1	3e-6	NR	DAZ99648.1	4803	g27437	i0	40.7	1.86206896551724	54	32	93.1	0	9	170	203	256	DAZ99648.1 TPA: hypothetical protein N0F65_001885 [Lagenidium giganteum]	diamond	324	53.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
30584203	30584203	PRJNA557895_P_NODE_31353_length_166_cov_0.871795_g30998_i0	PRJNA557895	31353	166	0.871795	1.4471797	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	75.9	4.49e-15	NR	TMW55611.1	41045	g30998	i0	85.1	0.849397590361446	47	6	84.9	1	24	164	1	46	TMW55611.1 hypothetical protein Poli38472_010493 [Pythium oligandrum]	diamond	141	75.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
32369451	32369451	PRJNA557895_P_NODE_22179_length_197_cov_1.378378_g21824_i0	PRJNA557895	22179	197	1.378378	2.71540466	root	1	Root_unresolved	Root_unresolved	79	1.98e-15	NR	KAF0740755.1	100861	g21824	i0	63.5	5.49746192893401	63	23	95.9	0	2	190	253	315	KAF0740755.1 hypothetical protein Ae201684_003886 [Aphanomyces euteiches]	diamond	1083	79.7	0.991217063989962	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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