metadata: contig_metadata: 8 rows where bioproject = "PRJNA1197996", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA1197996", 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
1043713	1043713	PRJNA1197996_S_NODE_27101_length_244_cov_0.900585_g27047_i0	PRJNA1197996	27101	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	92.8	1.85e-22	NR	RHY30188.1	157072	g27047	i0	65.2	1.61065573770492	66	23	81.1	0	244	47	19	84	RHY30188.1 hypothetical protein DYB32_004557, partial [Aphanomyces invadans]	diamond	393	93.6	0.991452991452991	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
4871784	4871784	PRJNA1197996_S_NODE_364_length_1026_cov_1.997901_g335_i0	PRJNA1197996	364	1026	1.997901	20.49846426	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	1677	0	NTclustered	gi\|2248512796\|ref\|NC_063789.1\|	272952	g335	i0	96.819	98.0672514619883	1006	28	98	2	1	1002	1028	23	Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome	blastn	100617	1681	0.997620464009518	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora arabidopsidis
7421453	7421453	PRJNA1197996_S_NODE_10246_length_332_cov_1.509653_g10192_i0	PRJNA1197996	10246	332	1.509653	5.01204796	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	67.6	1.12e-6	NTclustered	gi\|2795039260\|ref\|XM_067938436.1\|	4785	g10192	i0	88.889	0.487951807228916	54	6	16	0	277	330	1719	1666	Phytophthora cinnamomi Translocation protein SEC63 (IUM83_13740), partial mRNA	blastn	162	67.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
11802490	11802490	PRJNA1197996_S_NODE_19190_length_270_cov_3.111675_g19136_i0	PRJNA1197996	19190	270	3.111675	8.4015225	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	285	2.24e-72	NTclustered	gi\|2795032738\|ref\|XM_067933181.1\|	4785	g19136	i0	87.967	93.1518518518518	241	29	89	0	1	241	751	991	Phytophthora cinnamomi Electron transfer flavoprotein subunit alpha, mitochondrial precursor (IUM83_08787), partial mRNA	blastn	25151	285	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
22000618	22000618	PRJNA1197996_S_NODE_15258_length_292_cov_2.310502_g15204_i0	PRJNA1197996	15258	292	2.310502	6.74666584	Peronospora aff. claytoniae	2028483	SAR_Eukaryotes	SAR_Eukaryotes	464	2.93e-126	NTclustered	gi\|1235732001\|gb\|MF693904.1\|	2028483	g15204	i0	98.846	88.8664383561644	260	3	89	0	32	291	1	260	Peronospora aff. claytoniae isolate RC16DM3 large subunit ribosomal RNA gene, partial sequence	blastn	25949	464	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora aff. claytoniae
28398967	28398967	PRJNA1197996_S_NODE_2586_length_513_cov_6.104545_g2535_i0	PRJNA1197996	2586	513	6.104545	31.31631585	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	84.3	1.62e-15	NR	TMW68720.1	41045	g2535	i0	37.8	0.573099415204678	98	61	57.3	0	3	296	57	154	TMW68720.1 hypothetical protein Poli38472_006188 [Pythium oligandrum]	diamond	294	84.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
29282874	29282874	PRJNA1197996_S_NODE_8809_length_348_cov_1.676364_g8755_i0	PRJNA1197996	8809	348	1.676364	5.83374672	Saprolegnia parasitica CBS 223.65	695850	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00743	NR	XP_012194493.1	695850	g8755	i0	51.2	0.706896551724138	41	20	35.3	0	3	125	803	843	XP_012194493.1 CMGC/MAPK protein kinase [Saprolegnia parasitica CBS 223.65]	diamond	246	46.2	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
31652576	31652576	PRJNA1197996_S_NODE_20657_length_263_cov_2.915789_g20603_i0	PRJNA1197996	20657	263	2.915789	7.66852507	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	60.5	2.8e-8	NR	DAZ94709.1	4803	g20603	i0	42	5.85171102661597	69	39	77.6	1	206	3	672	740	DAZ94709.1 TPA: hypothetical protein N0F65_012662 [Lagenidium giganteum]	diamond	1539	60.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum

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