metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA550047" 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
27773241	27773241	PRJNA550047_P_NODE_476264_length_238_cov_11.460606_g474291_i0	PRJNA550047	476264	238	11.460606	27.27624228	Peronospora farinosa	134698	SAR_Eukaryotes	SAR_Eukaryotes	49.3	1.26e-4	NR	CAI5704132.1	134698	g474291	i0	48.9	0.592436974789916	47	24	59.2	0	1	141	145	191	CAI5704132.1 unnamed protein product [Peronospora farinosa]	diamond	141	49.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora farinosa
28846463	28846463	PRJNA550047_P_NODE_571208_length_207_cov_4.171642_g569235_i0	PRJNA550047	571208	207	4.171642	8.63529894	Peronospora farinosa	134698	SAR_Eukaryotes	SAR_Eukaryotes	102	2.99e-25	NR	CAH0493560.1	134698	g569235	i0	80.3	2.73913043478261	61	12	88.4	0	2	184	144	204	CAH0493560.1 unnamed protein product, partial [Peronospora farinosa]	diamond	567	102	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora farinosa
29730423	29730423	PRJNA550047_P_NODE_515850_length_225_cov_9.322368_g513877_i0	PRJNA550047	515850	225	9.322368	20.975328	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	69.3	1.13e-11	NR	KAF1317267.1	82926	g513877	i0	45.5	1.72	66	36	88	0	202	5	297	362	KAF1317267.1 Integrase catalytic core protein, partial [Globisporangium splendens]	diamond	387	69.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
30204296	30204296	PRJNA550047_P_NODE_74472_length_345_cov_11.566176_g72512_i0	PRJNA550047	74472	345	11.566176	39.9033072	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	93.2	4.19e-20	NR	CAH0517399.1	622444	g72512	i0	86	0.434782608695652	50	7	43.5	0	2	151	20	69	CAH0517399.1 unnamed protein product [Peronospora belbahrii]	diamond	150	93.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
30598172	30598172	PRJNA550047_P_NODE_404653_length_263_cov_7.515789_g402681_i0	PRJNA550047	404653	263	7.515789	19.76652507	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0134	NR	KAG7398242.1	109152	g402681	i0	55.9	1.16349809885932	34	15	38.8	0	249	148	13	46	KAG7398242.1 putative 28S rRNA (cytosine-C(5))-methyltransferase [Phytophthora boehmeriae]	diamond	306	44.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
31419977	31419977	PRJNA550047_P_NODE_494516_length_232_cov_9.163522_g492543_i0	PRJNA550047	494516	232	9.163522	21.25937104	root	1	Root_unresolved	Root_unresolved	57.4	2.24e-7	NR	KAF0700610.1	120398	g492543	i0	44.8	1.61637931034483	58	31	75	1	175	2	352	408	KAF0700610.1 hypothetical protein As57867_008842 [Aphanomyces stellatus]	diamond	375	57.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
31784584	31784584	PRJNA550047_P_NODE_146017_length_345_cov_4.970588_g144057_i0	PRJNA550047	146017	345	4.970588	17.1485286	Phytophthora nicotianae P1	4792	SAR_Eukaryotes	SAR_Eukaryotes	67.8	1.95e-10	NR	ETP52203.1	1317064	g144057	i0	63.8	0.817391304347826	47	17	40.9	0	198	338	131	177	ETP52203.1 hypothetical protein F442_02743 [Phytophthora nicotianae P10297]	diamond	282	67.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
32037880	32037880	PRJNA550047_P_NODE_117358_length_345_cov_6.977941_g115398_i0	PRJNA550047	117358	345	6.977941	24.07389645	Phytophthora cactorum	29920	SAR_Eukaryotes	SAR_Eukaryotes	99	2.1e-22	NR	KAG2915053.1	29920	g115398	i0	49.1	0.956521739130435	110	53	95.7	1	16	345	151	257	KAG2915053.1 hypothetical protein PC114_g7962 [Phytophthora cactorum]	diamond	330	99	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
32037995	32037995	PRJNA550047_P_NODE_343778_length_287_cov_14.925234_g341808_i0	PRJNA550047	343778	287	14.925234	42.83542158	Phytophthora kernoviae	325452	SAR_Eukaryotes	SAR_Eukaryotes	63.5	2.96e-9	NR	KAF4322330.1	1284355	g341808	i0	66.7	2.46689895470383	48	15	49.1	1	3	143	364	411	KAF4322330.1 hypothetical protein G195_004463 [Phytophthora kernoviae 00238/432]	diamond	708	63.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora kernoviae

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