metadata: contig_metadata: 3 rows where bioproject = "PRJNA789095", tax_clade = "Sar" and tax

3 rows where bioproject = "PRJNA789095", 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
27780407	27780407	PRJNA789095_P_NODE_57344_length_269_cov_2.408163_g56010_i0	PRJNA789095	57344	269	2.408163	6.47795847	Phytophthora fragariaefolia	1490495	SAR_Eukaryotes	SAR_Eukaryotes	69.7	1.2e-11	NR	GMF19770.1	1490495	g56010	i0	50.8	0.680297397769517	61	30	68	0	183	1	266	326	GMF19770.1 unnamed protein product [Phytophthora fragariaefolia]	diamond	183	69.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariaefolia
31105451	31105451	PRJNA789095_P_NODE_49655_length_286_cov_3.431925_g48321_i0	PRJNA789095	49655	286	3.431925	9.8153055	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	133	5.28e-34	NR	KAJ0397719.1	114742	g48321	i0	69.9	4.8986013986014	93	28	97.6	0	279	1	1	93	KAJ0397719.1 hypothetical protein P43SY_007187 [Pythium insidiosum]	diamond	1401	134	0.992537313432836	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
31444151	31444151	PRJNA789095_P_NODE_63376_length_256_cov_1.535519_g62042_i0	PRJNA789095	63376	256	1.535519	3.93092864	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	67.8	6.69e-11	NR	XP_008863654.1	157072	g62042	i0	43.9	0.9609375	82	35	85.5	2	252	34	597	676	XP_008863654.1 hypothetical protein H310_02048 [Aphanomyces invadans]	diamond	246	67.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans

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