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

5 rows where analysis = "diamond", bioproject = "PRJNA290839" 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
18224559	18224559	PRJNA290839_P_NODE_295_length_492_cov_1.288783_g274_i0	PRJNA290839	295	492	1.288783	6.34081236	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	167	1.19e-49	NR	XP_067742027.1	164328	g274	i0	56.1	11.3231707317073	157	66	94.5	3	5	469	24	179	XP_067742027.1 Ubiquitin-40S ribosomal protein S27a [Phytophthora ramorum]	diamond	5571	167	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
28779377	28779377	PRJNA290839_P_NODE_1087_length_251_cov_1.556180_g1066_i0	PRJNA290839	1087	251	1.55618	3.9060118	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	99	3.1e-23	NR	CCA18322.1	890382	g1066	i0	64.1	0.932270916334661	78	26	93.2	1	251	18	150	225	CCA18322.1 40S ribosomal protein S33 putative [Albugo laibachii Nc14]	diamond	234	99	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
30359048	30359048	PRJNA290839_P_NODE_892_length_271_cov_1.565657_g871_i0	PRJNA290839	892	271	1.565657	4.24293047	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	155	1.33e-45	NR	RHY63180.1	112090	g871	i0	82.2	5.87822878228782	90	14	99.6	1	271	2	111	198	RHY63180.1 hypothetical protein DYB34_003832 [Aphanomyces astaci]	diamond	1593	155	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
31306444	31306444	PRJNA290839_P_NODE_1015_length_253_cov_0.866667_g994_i0	PRJNA290839	1015	253	0.866667	2.19266751	Peronosclerospora sorghi	230839	SAR_Eukaryotes	SAR_Eukaryotes	87.4	5.03e-18	NR	KAI9906506.1	230839	g994	i0	55	3.79446640316206	80	36	94.9	0	1	240	66	145	KAI9906506.1 hypothetical protein PsorP6_016583 [Peronosclerospora sorghi]	diamond	960	87.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronosclerospora	Peronosclerospora sorghi
31798349	31798349	PRJNA290839_P_NODE_717_length_303_cov_1.013043_g696_i0	PRJNA290839	717	303	1.013043	3.06952029	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	157	2.7899999999999998e-46	NR	XP_024577953.1	4781	g696	i0	78.2	9	101	22	100	0	1	303	27	127	XP_024577953.1 ribosomal protein s4 [Plasmopara halstedii]	diamond	2727	158	0.993670886075949	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii

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