metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA352850" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA352850" 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
4899217	4899217	PRJNA352850_P_NODE_48264_length_350_cov_1.830565_g45431_i0	PRJNA352850	48264	350	1.830565	6.4069775	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	134	2.2999999999999998e-38	NR	CCI49799.1	65357	g45431	i0	63.8	1.80857142857143	105	36	90	1	343	29	2	104	CCI49799.1 unnamed protein product [Albugo candida]	diamond	633	134	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
16373506	16373506	PRJNA352850_P_NODE_24453_length_563_cov_2.342412_g21639_i0	PRJNA352850	24453	563	2.342412	13.18777956	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	214	7.18e-64	NR	GLE04299.1	114742	g21639	i0	70	7.33747779751332	150	45	79.9	0	1	450	296	445	GLE04299.1 hypothetical protein PINS_up013214 [Pythium insidiosum]	diamond	4131	216	0.990740740740741	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28291958	28291958	PRJNA352850_P_NODE_5006_length_1815_cov_7.656285_g3381_i0	PRJNA352850	5006	1815	7.656285	138.96157275	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	239	6.84e-69	NR	KAE9043783.1	129364	g3381	i0	41.6	3.29752066115702	317	164	49.8	5	7	909	62	373	KAE9043783.1 DnaJ [Phytophthora rubi]	diamond	5985	239	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora rubi
28765623	28765623	PRJNA352850_P_NODE_82747_length_245_cov_1.040816_g79914_i0	PRJNA352850	82747	245	1.040816	2.5499992	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.1	3.24e-13	NR	XP_067815434.1	4779	g79914	i0	59	26.0204081632653	61	25	74.7	0	63	245	9	69	XP_067815434.1 hypothetical protein CCR75_008431 [Bremia lactucae]	diamond	6375	70.5	0.994326241134752	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
28797075	28797075	PRJNA352850_P_NODE_36287_length_427_cov_3.531746_g33456_i0	PRJNA352850	36287	427	3.531746	15.08055542	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	154	2.19e-41	NR	XP_024578867.1	4781	g33456	i0	57	7.70023419203747	121	52	85	0	5	367	55	175	XP_024578867.1 adp-ribosylation factor family [Plasmopara halstedii]	diamond	3288	155	0.993548387096774	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
30896456	30896456	PRJNA352850_P_NODE_16874_length_735_cov_2.928571_g14203_i0	PRJNA352850	16874	735	2.928571	21.52499685	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	90.9	9.83e-17	NR	KAF1330673.1	82926	g14203	i0	34.3	1.84489795918367	137	87	55.1	3	229	633	1072	1207	KAF1330673.1 Potassium/sodium efflux p-type atpase, fungal-type, partial [Globisporangium splendens]	diamond	1356	90.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
31165911	31165911	PRJNA352850_P_NODE_25895_length_541_cov_2.085366_g23073_i0	PRJNA352850	25895	541	2.085366	11.28183006	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	145	1.27e-39	NR	OQS05870.1	74557	g23073	i0	49	7.17005545286507	143	69	78.2	3	10	432	103	243	OQS05870.1 soluble calcium-activated nucleotidase [Thraustotheca clavata]	diamond	3879	146	0.993150684931507	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
31370647	31370647	PRJNA352850_P_NODE_39456_length_403_cov_2.562147_g36624_i0	PRJNA352850	39456	403	2.562147	10.32545241	Peronospora destructor	86335	SAR_Eukaryotes	SAR_Eukaryotes	94.4	4.82e-22	NR	CAI5730667.1	86335	g36624	i0	47.8	0.856079404466501	115	55	84.9	2	25	366	1	111	CAI5730667.1 unnamed protein product [Peronospora destructor]	diamond	345	94.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
31450941	31450941	PRJNA352850_P_NODE_15376_length_788_cov_6.259811_g12749_i0	PRJNA352850	15376	788	6.259811	49.32731068	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	169	2.42e-47	NR	CAI5726580.1	162125	g12749	i0	33.8	7.05456852791878	266	167	97.8	3	788	18	14	279	CAI5726580.1 unnamed protein product [Hyaloperonospora brassicae]	diamond	5559	170	0.994117647058824	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora brassicae
31844749	31844749	PRJNA352850_P_NODE_52977_length_328_cov_1.096774_g50144_i0	PRJNA352850	52977	328	1.096774	3.59741872	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	146	3.4599999999999993e-40	NR	KAF1336544.1	82926	g50144	i0	72.3	0.859756097560976	94	25	86	1	42	323	30	122	KAF1336544.1 hypothetical protein FI667_g389, partial [Globisporangium splendens]	diamond	282	146	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
32083467	32083467	PRJNA352850_P_NODE_20358_length_641_cov_4.648649_g17589_i0	PRJNA352850	20358	641	4.648649	29.79784009	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	216	1.56e-65	NR	KAI9989725.1	4787	g17589	i0	70.2	9.89391575663027	141	42	66	0	8	430	208	348	KAI9989725.1 hypothetical protein PInf_020011 [Phytophthora infestans]	diamond	6342	218	0.990825688073395	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
32604045	32604045	PRJNA352850_P_NODE_24080_length_569_cov_2.809615_g21268_i0	PRJNA352850	24080	569	2.809615	15.98670935	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	134	3.7299999999999997e-34	NR	KAF0718187.1	120398	g21268	i0	52.5	0.64323374340949	122	57	63.8	1	4	366	224	345	KAF0718187.1 hypothetical protein As57867_001852 [Aphanomyces stellatus]	diamond	366	134	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
32841433	32841433	PRJNA352850_P_NODE_19040_length_673_cov_5.596154_g16301_i0	PRJNA352850	19040	673	5.596154	37.66211642	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	87.4	9.22e-17	NR	XP_067781709.1	4785	g16301	i0	30.5	5.34026745913819	187	113	77.6	6	610	89	33	215	XP_067781709.1 MtN3-like protein [Phytophthora cinnamomi]	diamond	3594	87.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
32855837	32855837	PRJNA352850_P_NODE_40800_length_394_cov_2.263768_g37968_i0	PRJNA352850	40800	394	2.263768	8.91924592	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	187	4.919999999999999e-55	NR	TMW59276.1	41045	g37968	i0	85.3	1.65989847715736	109	16	83	0	3	329	297	405	TMW59276.1 hypothetical protein Poli38472_004345 [Pythium oligandrum]	diamond	654	187	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum

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