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

7 rows where bioproject = "PRJNA1041773", 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
1444889	1444889	PRJNA1041773_P_NODE_36822_length_347_cov_2.678832_g36489_i0	PRJNA1041773	36822	347	2.678832	9.29554704	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	503	7.55e-138	NTclustered	gi\|166044524\|emb\|CU367433.1\|	100861	g36489	i0	92.795	98.6167146974063	347	25	100	0	1	347	783	437	Aphanomyces euteiches cDNA	blastn	34220	503	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
9936249	9936249	PRJNA1041773_P_NODE_100048_length_241_cov_1.583333_g99715_i0	PRJNA1041773	100048	241	1.583333	3.8158325299999998	Hyaloperonospora	184462	SAR_Eukaryotes	SAR_Eukaryotes	115	2.73e-21	NTclustered	gi\|33520231\|gb\|AY273976.1\|	240413	g99715	i0	93.506	31.3734439834025	77	5	32	0	1	77	446	522	Peronospora aff. dentariae MG 18-6 large subunit ribosomal RNA gene, partial sequence	blastn	7561	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora aff. dentariae MG 18-6
29466395	29466395	PRJNA1041773_P_NODE_19630_length_469_cov_1.770202_g19300_i0	PRJNA1041773	19630	469	1.770202	8.30224738	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	55.5	1.37e-5	NR	TMW55819.1	41045	g19300	i0	32.3	0.633262260127932	99	67	63.3	0	14	310	405	503	TMW55819.1 hypothetical protein Poli38472_008467 [Pythium oligandrum]	diamond	297	55.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
30288368	30288368	PRJNA1041773_P_NODE_79892_length_250_cov_0.870056_g79559_i0	PRJNA1041773	79892	250	0.870056	2.17514	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	67.8	6.14e-11	NR	KAF0743794.1	100861	g79559	i0	42.7	2.028	89	44	98.4	3	247	2	17	105	KAF0743794.1 hypothetical protein Ae201684_001444 [Aphanomyces euteiches]	diamond	507	67.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
30880223	30880223	PRJNA1041773_P_NODE_89734_length_246_cov_0.890173_g89401_i0	PRJNA1041773	89734	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	50.4	7.46e-5	NR	KAH9051731.1	100861	g89401	i0	45.5	4.14634146341463	55	30	67.1	0	15	179	1037	1091	KAH9051731.1 hypothetical protein Ae201684P_015569 [Aphanomyces euteiches]	diamond	1020	50.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
31489159	31489159	PRJNA1041773_P_NODE_90176_length_245_cov_3.238372_g89843_i0	PRJNA1041773	90176	245	3.238372	7.9340114	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	123	4.04e-31	NR	GLD91866.1	114742	g89843	i0	74.7	1.93469387755102	79	20	96.7	0	9	245	150	228	GLD91866.1 hypothetical protein PINS_up000399 [Pythium insidiosum]	diamond	474	123	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
32058276	32058276	PRJNA1041773_P_NODE_60938_length_278_cov_1.365854_g60605_i0	PRJNA1041773	60938	278	1.365854	3.79707412	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	54.3	4.15e-6	NR	KAJ0410583.1	114742	g60605	i0	41.2	1.43525179856115	68	39	72.3	1	278	78	199	266	KAJ0410583.1 hypothetical protein ATCC90586_007416 [Pythium insidiosum]	diamond	399	54.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum

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