metadata: contig_metadata: 6 rows where bioproject = "PRJNA951388", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA951388", 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
29583142	29583142	PRJNA951388_S_NODE_10850_length_249_cov_2.142045_g10723_i0	PRJNA951388	10850	249	2.142045	5.33369205	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	90.5	3.07e-19	NR	CCA23064.1	890382	g10723	i0	54.3	0.975903614457831	81	34	97.6	1	5	247	45	122	CCA23064.1 conserved hypothetical protein [Albugo laibachii Nc14]	diamond	243	90.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
29747602	29747602	PRJNA951388_S_NODE_9870_length_263_cov_4.052632_g9743_i0	PRJNA951388	9870	263	4.052632	10.65842216	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	92.8	5.25e-20	NR	KAF1330494.1	82926	g9743	i0	53.2	4.58555133079848	79	37	90.1	0	2	238	297	375	KAF1330494.1 Adenosine kinase, partial [Globisporangium splendens]	diamond	1206	93.6	0.991452991452991	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
30126698	30126698	PRJNA951388_S_NODE_10632_length_252_cov_2.418994_g10505_i0	PRJNA951388	10632	252	2.418994	6.09586488	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	152	2.669999999999999e-43	NR	OQS02930.1	74557	g10505	i0	76.8	56.6428571428571	82	19	97.6	0	247	2	27	108	OQS02930.1 ubiquitin-conjugating enzyme E2 [Thraustotheca clavata]	diamond	14274	153	0.993464052287582	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
30885228	30885228	PRJNA951388_S_NODE_8794_length_283_cov_2.380952_g8667_i0	PRJNA951388	8794	283	2.380952	6.73809416	root	1	Root_unresolved	Root_unresolved	68.9	1.84e-12	NR	XP_008618707.1	1156394	g8667	i0	37.8	1.54770318021201	74	46	78.4	0	279	58	59	132	XP_008618707.1 hypothetical protein SDRG_14361 [Saprolegnia diclina VS20]	diamond	438	68.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
31580871	31580871	PRJNA951388_S_NODE_2436_length_482_cov_6.002445_g2310_i0	PRJNA951388	2436	482	6.002445	28.9317849	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	56.6	5.01e-6	NR	KAF1326903.1	82926	g2310	i0	27.7	3.26141078838174	141	93	84.6	3	475	68	184	320	KAF1326903.1 Prostaglandin e synthase, partial [Globisporangium splendens]	diamond	1572	57	0.992982456140351	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
32333766	32333766	PRJNA951388_S_NODE_6219_length_340_cov_4.662921_g6092_i0	PRJNA951388	6219	340	4.662921	15.8539314	Phytophthora fragariae	53985	SAR_Eukaryotes	SAR_Eukaryotes	80.5	1.44e-16	NR	KAE8911393.1	53985	g6092	i0	64.9	7.72941176470588	57	20	50.3	0	3	173	47	103	KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae]	diamond	2628	80.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae

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