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

11 rows where bioproject = "PRJNA1111448", 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
6596212	6596212	PRJNA1111448_S_NODE_55986_length_335_cov_2.114504_g55163_i0	PRJNA1111448	55986	335	2.114504	7.0835884	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	272	2.2299999999999997e-68	NTclustered	gi\|325194347\|emb\|FR825188.1\|	890382	g55163	i0	83	71.3014925373134	300	51	90	0	1	300	978	1277	Albugo laibachii Nc14, genomic contig CONTIG_1829_NC14_v4_1468_6528	blastn	23886	272	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
8676202	8676202	PRJNA1111448_S_NODE_72327_length_307_cov_1.243590_g71504_i0	PRJNA1111448	72327	307	1.24359	3.8178213	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	531	3.0199999999999998e-146	NTclustered	gi\|50261276\|ref\|NC_005984.1\|	4770	g71504	i0	97.735	106.260586319218	309	5	100	2	1	307	9177	9485	Saprolegnia ferax mitochondrion, complete genome	blastn	32622	531	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia ferax
13776325	13776325	PRJNA1111448_S_NODE_96791_length_275_cov_1.618812_g95968_i0	PRJNA1111448	96791	275	1.618812	4.451733	Albugo	65356	SAR_Eukaryotes	SAR_Eukaryotes	127	1.03e-32	NR	CCI42781.1	65357	g95968	i0	69.4	4.63636363636364	85	26	92.7	0	273	19	330	414	CCI42781.1 unnamed protein product [Albugo candida]	diamond	1275	127	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
15050267	15050267	PRJNA1111448_S_NODE_144412_length_200_cov_4.850394_g143589_i0	PRJNA1111448	144412	200	4.850394	9.700788	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	359	9.14e-95	NTclustered	gi\|166051677\|emb\|CU353805.1\|	100861	g143589	i0	99	94.985	200	2	100	0	1	200	85	284	Aphanomyces euteiches cDNA	blastn	18997	359	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
18069411	18069411	PRJNA1111448_S_NODE_23755_length_441_cov_5.437500_g22933_i0	PRJNA1111448	23755	441	5.4375	23.979375	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	809	0	NTclustered	gi\|698793876\|ref\|XR_717098.1\|	112090	g22933	i0	99.773	101.24716553288	441	1	100	0	1	441	2124	2564	Aphanomyces astaci 28S ribosomal RNA rRNA	blastn	44650	809	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
21894818	21894818	PRJNA1111448_S_NODE_51118_length_345_cov_2.830882_g50295_i0	PRJNA1111448	51118	345	2.830882	9.7665429	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	126	1.96e-33	NR	OQS05478.1	74557	g50295	i0	61.5	6.99130434782609	109	41	94.8	1	345	19	125	232	OQS05478.1 40S ribosomal protein S3-3 [Thraustotheca clavata]	diamond	2412	126	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
21895147	21895147	PRJNA1111448_S_NODE_83158_length_291_cov_13.646789_g82335_i0	PRJNA1111448	83158	291	13.646789	39.71215599	Geolegnia helicoides	1432543	SAR_Eukaryotes	SAR_Eukaryotes	496	1.04e-135	NTclustered	gi\|563440377\|gb\|KF656776.1\|	1432543	g82335	i0	97.27	100.216494845361	293	6	100	1	1	291	905	613	Geolegnia helicoides internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence	blastn	29163	496	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Geolegnia	Geolegnia helicoides
23975012	23975012	PRJNA1111448_S_NODE_33039_length_397_cov_26.990741_g32216_i0	PRJNA1111448	33039	397	26.990741	107.15324177	Verrucalvaceae	120409	SAR_Eukaryotes	SAR_Eukaryotes	701	0	NTclustered	gi\|698793877\|ref\|XR_717099.1\|	112090	g32216	i0	98.492	99.8463476070529	398	5	100	1	1	397	598	995	Aphanomyces astaci 18S ribosomal RNA rRNA	blastn	39639	701	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
27564325	27564325	PRJNA1111448_S_NODE_94304_length_278_cov_1.502439_g93481_i0	PRJNA1111448	94304	278	1.502439	4.17678042	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	111	3.68e-29	NR	KAF0694959.1	120398	g93481	i0	100	1.23021582733813	57	0	61.5	0	3	173	74	130	KAF0694959.1 hypothetical protein As57867_014131 [Aphanomyces stellatus]	diamond	342	111	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
28994474	28994474	PRJNA1111448_S_NODE_81548_length_294_cov_1.045249_g80725_i0	PRJNA1111448	81548	294	1.045249	3.07303206	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	165	2.01e-50	NR	KAF0708390.1	120398	g80725	i0	82.5	1.97959183673469	97	17	99	0	293	3	40	136	KAF0708390.1 hypothetical protein As57867_006351, partial [Aphanomyces stellatus]	diamond	582	165	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
29531009	29531009	PRJNA1111448_S_NODE_109830_length_261_cov_1.468085_g109007_i0	PRJNA1111448	109830	261	1.468085	3.83170185	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	121	5.54e-32	NR	CAH0482684.1	622444	g109007	i0	70	1.75862068965517	80	24	92	0	258	19	140	219	CAH0482684.1 unnamed protein product [Peronospora belbahrii]	diamond	459	121	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii

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