metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA724039" 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
14740082	14740082	PRJNA724039_S_NODE_10272_length_202_cov_3.472727_g10065_i0	PRJNA724039	10272	202	3.472727	7.01490854	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	102	1.97e-26	NR	DBA04875.1	4803	g10065	i0	71.2	8.82178217821782	66	19	98	0	198	1	17	82	DBA04875.1 TPA: hypothetical protein N0F65_006877 [Lagenidium giganteum]	diamond	1782	102	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
29672910	29672910	PRJNA724039_S_NODE_16170_length_158_cov_3.487603_g15963_i0	PRJNA724039	16170	158	3.487603	5.51041274	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	90.5	1.8e-21	NR	TYZ63444.1	1485010	g15963	i0	74.5	2.67721518987342	47	12	89.2	0	3	143	101	147	TYZ63444.1 hypothetical protein PybrP1_007303 [[Pythium] brassicae (nom. inval.)]	diamond	423	90.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
31073708	31073708	PRJNA724039_S_NODE_15935_length_160_cov_1.178862_g15728_i0	PRJNA724039	15935	160	1.178862	1.8861792	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	62	5.49e-10	NR	KAI9917785.1	230839	g15728	i0	61.8	2.0625	55	18	97.5	2	5	160	17	71	KAI9917785.1 hypothetical protein PsorP6_012390 [Peronosclerospora sorghi]	diamond	330	62.4	0.993589743589744	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronosclerospora	Peronosclerospora sorghi
32275762	32275762	PRJNA724039_S_NODE_2098_length_529_cov_2.292683_g1902_i0	PRJNA724039	2098	529	2.292683	12.12829307	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	160	1.22e-45	NR	KAH9082828.1	100861	g1902	i0	64.5	12.6238185255198	124	44	70.3	0	529	158	139	262	KAH9082828.1 hypothetical protein LEN26_021124 [Aphanomyces euteiches]	diamond	6678	160	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
32560606	32560606	PRJNA724039_S_NODE_4339_length_340_cov_2.577558_g4132_i0	PRJNA724039	4339	340	2.577558	8.7636972	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	111	3.51e-28	NR	DBA01302.1	4803	g4132	i0	53.5	8.82352941176471	101	41	84.7	2	340	53	83	182	DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum]	diamond	3000	112	0.991071428571429	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);;