metadata: contig_metadata: 11 rows where bioproject = "PRJNA1156092", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA1156092", 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
4129922	4129922	PRJNA1156092_P_NODE_6684_length_412_cov_1.451327_g6554_i0	PRJNA1156092	6684	412	1.451327	5.97946724	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	215	4.7700000000000003e-51	NTclustered	gi\|698791735\|ref\|XM_009830598.1\|	112090	g6554	i0	80.333	18.3859223300971	300	46	71	11	1	292	462	168	Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA	blastn	7575	215	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
17614835	17614835	PRJNA1156092_P_NODE_12214_length_325_cov_1.928571_g12084_i0	PRJNA1156092	12214	325	1.928571	6.26785575	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	99	3.87e-16	NTclustered	gi\|325195237\|emb\|FR826032.1\|	890382	g12084	i0	96.61	46.9753846153846	59	2	18	0	266	324	207	265	Albugo laibachii Nc14, genomic contig CONTIG_3119_NC14_v4_456_35141	blastn	15267	99	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
22714130	22714130	PRJNA1156092_P_NODE_21278_length_254_cov_2.546961_g21148_i0	PRJNA1156092	21278	254	2.546961	6.46928094	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	180	1.01e-40	NTclustered	gi\|50261276\|ref\|NC_005984.1\|	4770	g21148	i0	83.5	79.7874015748032	200	25	77	6	59	253	10445	10249	Saprolegnia ferax mitochondrion, complete genome	blastn	20266	180	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia ferax
27166555	27166555	PRJNA1156092_P_NODE_14922_length_300_cov_2.030837_g14792_i0	PRJNA1156092	14922	300	2.030837	6.092511	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	60.1	8.42e-9	NR	KAJ0400315.1	114742	g14792	i0	45.3	3.56	95	45	91	3	278	6	2	93	KAJ0400315.1 hypothetical protein P43SY_002063 [Pythium insidiosum]	diamond	1068	60.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28828046	28828046	PRJNA1156092_P_NODE_26148_length_247_cov_0.885057_g26018_i0	PRJNA1156092	26148	247	0.885057	2.18609079	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	84.7	2.15e-17	NR	OQR83458.1	74557	g26018	i0	54.5	4.70040485829959	77	34	92.3	1	2	229	218	294	OQR83458.1 hypothetical protein THRCLA_10936, partial [Thraustotheca clavata]	diamond	1161	85.1	0.995299647473561	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
29660902	29660902	PRJNA1156092_P_NODE_30970_length_242_cov_1.254438_g30840_i0	PRJNA1156092	30970	242	1.254438	3.03573996	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	52.8	1.12e-6	NR	TMW61868.1	41045	g30840	i0	68.8	1.16528925619835	32	10	39.7	0	10	105	68	99	TMW61868.1 hypothetical protein Poli38472_010931 [Pythium oligandrum]	diamond	282	52.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
29711911	29711911	PRJNA1156092_P_NODE_28710_length_245_cov_0.895349_g28580_i0	PRJNA1156092	28710	245	0.895349	2.19360505	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	88.2	4.81e-20	NR	KAK1929143.1	4793	g28580	i0	59.3	3.97959183673469	81	31	96.7	2	241	5	40	120	KAK1929143.1 40S ribosomal protein S7-2 [Phytophthora citrophthora]	diamond	975	89	0.991011235955056	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora citrophthora
30198060	30198060	PRJNA1156092_P_NODE_24772_length_248_cov_1.617143_g24642_i0	PRJNA1156092	24772	248	1.617143	4.01051464	Peronospora effusa	542832	SAR_Eukaryotes	SAR_Eukaryotes	78.2	1.32e-14	NR	RMX70274.1	542832	g24642	i0	72.3	6.06048387096774	47	13	56.9	0	144	4	340	386	RMX70274.1 hypothetical protein DD238_000070 [Peronospora effusa]	diamond	1503	78.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora effusa
30988299	30988299	PRJNA1156092_P_NODE_29214_length_244_cov_0.900585_g29084_i0	PRJNA1156092	29214	244	0.900585	2.1974274	Peronosclerospora sorghi	230839	SAR_Eukaryotes	SAR_Eukaryotes	121	9.239999999999999e-30	NR	KAI9915200.1	230839	g29084	i0	79	11.9508196721311	81	17	99.6	0	244	2	265	345	KAI9915200.1 hypothetical protein PsorP6_007066 [Peronosclerospora sorghi]	diamond	2916	121	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronosclerospora	Peronosclerospora sorghi
31418475	31418475	PRJNA1156092_P_NODE_25396_length_248_cov_0.880000_g25266_i0	PRJNA1156092	25396	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	62.8	3.38e-9	NR	GMF10484.1	2077276	g25266	i0	40.8	2.80645161290323	76	45	91.9	0	20	247	329	404	GMF10484.1 unnamed protein product [Phytophthora lilii]	diamond	696	63.2	0.993670886075949	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora lilii
32082749	32082749	PRJNA1156092_P_NODE_16798_length_286_cov_1.037559_g16668_i0	PRJNA1156092	16798	286	1.037559	2.96741874	root	1	Root_unresolved	Root_unresolved	93.2	2.86e-20	NR	TMW65989.1	41045	g16668	i0	53.1	6.96503496503496	96	39	96.5	2	285	10	50	143	TMW65989.1 hypothetical protein Poli38472_003754 [Pythium oligandrum]	diamond	1992	93.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum

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