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

5 rows where analysis = "diamond", bioproject = "PRJDB14274" 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
28447930	28447930	PRJDB14274_S_NODE_2226_length_410_cov_2.042980_g2148_i0	PRJDB14274	2226	410	2.04298	8.376218	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	94.7	8.97e-22	NR	KAE8911393.1	53985	g2148	i0	53.2	2.68536585365854	94	33	62.2	3	409	155	48	139	KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae]	diamond	1101	95.5	0.991623036649215	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
29237189	29237189	PRJDB14274_S_NODE_1529_length_493_cov_2.893519_g1452_i0	PRJDB14274	1529	493	2.893519	14.26504867	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	161	4.62e-43	NR	XP_024573476.1	4781	g1452	i0	64.7	8.3184584178499	116	41	70.6	0	7	354	533	648	XP_024573476.1 dead deah box helicase [Plasmopara halstedii]	diamond	4101	162	0.993827160493827	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
32681604	32681604	PRJDB14274_S_NODE_7020_length_239_cov_1.393258_g6942_i0	PRJDB14274	7020	239	1.393258	3.32988662	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.1	7.97e-4	NR	OQR86152.1	1202772	g6942	i0	61.3	0.803347280334728	31	12	38.9	0	15	107	55	85	OQR86152.1 hypothetical protein ACHHYP_10924 [Achlya hypogyna]	diamond	192	45.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya hypogyna
32750736	32750736	PRJDB14274_S_NODE_8780_length_214_cov_1.535948_g8702_i0	PRJDB14274	8780	214	1.535948	3.28692872	Phytophthora infestans T3	4787	SAR_Eukaryotes	SAR_Eukaryotes	115	6.1499999999999986e-28	NR	XP_002997683.1	403677	g8702	i0	79.7	3.86915887850467	69	14	96.7	0	6	212	146	214	XP_002997683.1 aconitate hydratase, mitochondrial precursor [Phytophthora infestans T30-4]	diamond	828	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
32782025	32782025	PRJDB14274_S_NODE_5920_length_258_cov_1.203046_g5842_i0	PRJDB14274	5920	258	1.203046	3.10385868	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	75.1	5.91e-14	NR	OQS02109.1	74557	g5842	i0	56.4	3.77906976744186	78	16	90.7	2	24	257	20	79	OQS02109.1 60S ribosomal protein L7a-2 [Thraustotheca clavata]	diamond	975	75.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata

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