metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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
26774237	26774237	PRJNA1086823_P_NODE_15001_length_248_cov_1.908571_g14884_i0	PRJNA1086823	15001	248	1.908571	4.73325608	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	79.7	2.99e-17	NR	XP_024586470.1	4781	g14884	i0	45.7	83.1290322580645	81	44	98	0	247	5	19	99	XP_024586470.1 histone h2b [Plasmopara halstedii]	diamond	20616	80.1	0.995006242197254	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
28109650	28109650	PRJNA1086823_P_NODE_7005_length_310_cov_2.198312_g6888_i0	PRJNA1086823	7005	310	2.198312	6.8147672	Phytophthora rubi	129364	SAR_Eukaryotes	SAR_Eukaryotes	60.5	5.96e-9	NR	KAE8979265.1	129364	g6888	i0	36.1	2.40967741935484	83	49	80.3	1	8	256	19	97	KAE8979265.1 hypothetical protein PR001_g24603 [Phytophthora rubi]	diamond	747	60.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora rubi
31141374	31141374	PRJNA1086823_P_NODE_18795_length_242_cov_2.023669_g18678_i0	PRJNA1086823	18795	242	2.023669	4.89727898	Phytophthora kernoviae	325452	SAR_Eukaryotes	SAR_Eukaryotes	70.9	4.17e-13	NR	KAF4322590.1	1284355	g18678	i0	53.8	4.02892561983471	65	29	80.6	1	47	241	13	76	KAF4322590.1 hypothetical protein G195_004363 [Phytophthora kernoviae 00238/432]	diamond	975	70.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora kernoviae
31299794	31299794	PRJNA1086823_P_NODE_15475_length_248_cov_0.891429_g15358_i0	PRJNA1086823	15475	248	0.891429	2.21074392	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	57.4	1.25e-8	NR	KAF4141556.1	4787	g15358	i0	90.3	0.375	31	3	37.5	0	113	205	1	31	KAF4141556.1 hypothetical protein GN958_ATG09261 [Phytophthora infestans]	diamond	93	57.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
31932356	31932356	PRJNA1086823_P_NODE_8517_length_287_cov_1.457944_g8400_i0	PRJNA1086823	8517	287	1.457944	4.18429928	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	89	3.16e-18	NR	CCA25018.1	890382	g8400	i0	42.4	1.95470383275261	92	51	94.1	1	286	17	381	472	CCA25018.1 Rab7 family GTPase putative [Albugo laibachii Nc14]	diamond	561	89	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
32177178	32177178	PRJNA1086823_P_NODE_7298_length_305_cov_1.344828_g7181_i0	PRJNA1086823	7298	305	1.344828	4.1017254	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	87	2.21e-17	NR	KAL0583594.1	65357	g7181	i0	50	6.91475409836066	100	48	98.4	2	2	301	1017	1114	KAL0583594.1 hypothetical protein ABG067_006513 [Albugo candida]	diamond	2109	87	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida

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