metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA597223" 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
26618352	26618352	PRJNA597223_P_NODE_64601_length_180_cov_1.517241_g62755_i0	PRJNA597223	64601	180	1.517241	2.7310338	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	70.5	2.64e-12	NR	KAG1693005.1	4784	g62755	i0	51.7	14.4666666666667	58	28	96.7	0	4	177	286	343	KAG1693005.1 hypothetical protein DVH05_024041 [Phytophthora capsici]	diamond	2604	70.9	0.994358251057828	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
26649841	26649841	PRJNA597223_P_NODE_53161_length_191_cov_1.692308_g51315_i0	PRJNA597223	53161	191	1.692308	3.23230828	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	78.6	8.96e-16	NR	KAG1703520.1	4784	g51315	i0	57.4	19.8848167539267	61	26	95.8	0	189	7	183	243	KAG1703520.1 hypothetical protein DVH05_007467 [Phytophthora capsici]	diamond	3798	78.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
27680414	27680414	PRJNA597223_P_NODE_76404_length_162_cov_1.480315_g74558_i0	PRJNA597223	76404	162	1.480315	2.3981103	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	47.8	2.11e-4	NR	CAH0522587.1	622444	g74558	i0	69	1.07407407407407	29	9	53.7	0	162	76	271	299	CAH0522587.1 unnamed protein product [Peronospora belbahrii]	diamond	174	47.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
30427839	30427839	PRJNA597223_P_NODE_87113_length_151_cov_1.793103_g85267_i0	PRJNA597223	87113	151	1.793103	2.70758553	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	100	3.5399999999999995e-23	NR	DBA03530.1	4803	g85267	i0	98	0.993377483443709	50	1	99.3	0	2	151	2042	2091	DBA03530.1 TPA: hypothetical protein N0F65_011431 [Lagenidium giganteum]	diamond	150	100	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
30648298	30648298	PRJNA597223_P_NODE_49853_length_198_cov_1.079755_g48007_i0	PRJNA597223	49853	198	1.079755	2.1379149	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	99.4	2.37e-22	NR	KAG9414189.1	112091	g48007	i0	87.3	0.833333333333333	55	7	83.3	0	5	169	1097	1151	KAG9414189.1 pre-rRNA processing protein [Aphanomyces cochlioides]	diamond	165	99.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
31072738	31072738	PRJNA597223_P_NODE_49155_length_199_cov_2.585366_g47309_i0	PRJNA597223	49155	199	2.585366	5.14487834	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.027	NR	XP_067819804.1	4779	g47309	i0	32.7	1.80904522613065	55	37	82.9	0	3	167	35	89	XP_067819804.1 hypothetical protein CCR75_001652 [Bremia lactucae]	diamond	360	42.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
31122121	31122121	PRJNA597223_P_NODE_77355_length_161_cov_1.269841_g75509_i0	PRJNA597223	77355	161	1.269841	2.04444401	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	66.2	6.16e-11	NR	DAZ99479.1	4803	g75509	i0	79.1	0.801242236024845	43	9	80.1	0	2	130	397	439	DAZ99479.1 TPA: hypothetical protein N0F65_001664 [Lagenidium giganteum]	diamond	129	66.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
31312105	31312105	PRJNA597223_P_NODE_24015_length_321_cov_2.000000_g22171_i0	PRJNA597223	24015	321	2	6.42	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	165	1.0800000000000001e-44	NR	OQR95803.1	74557	g22171	i0	79.2	2.97196261682243	106	22	99.1	0	319	2	488	593	OQR95803.1 hypothetical protein THRCLA_07560, partial [Thraustotheca clavata]	diamond	954	165	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
32546181	32546181	PRJNA597223_P_NODE_87419_length_151_cov_1.284483_g85573_i0	PRJNA597223	87419	151	1.284483	1.93956933	Phytophthora megakarya	4795	SAR_Eukaryotes	SAR_Eukaryotes	53.9	1.2e-6	NR	OWZ01275.1	4795	g85573	i0	53.1	0.973509933774834	49	23	97.4	0	4	150	177	225	OWZ01275.1 hypothetical protein PHMEG_00027372, partial [Phytophthora megakarya]	diamond	147	53.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megakarya
32905631	32905631	PRJNA597223_P_NODE_34820_length_248_cov_1.849765_g32974_i0	PRJNA597223	34820	248	1.849765	4.5874172	Globisporangium	1448052	SAR_Eukaryotes	SAR_Eukaryotes	72.4	7.04e-14	NR	KAF1333119.1	82926	g32974	i0	56.2	5.02016129032258	73	30	85.9	1	247	35	37	109	KAF1333119.1 Transcriptional coactivator, multiprotein bridging factor mbf1, partial [Globisporangium splendens]	diamond	1245	72.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens

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