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

6 rows where analysis = "diamond", bioproject = "PRJNA1242190" 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
27281443	27281443	PRJNA1242190_S_NODE_5683_length_347_cov_1.923358_g5676_i0	PRJNA1242190	5683	347	1.923358	6.67405226	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	160	4.38e-48	NR	XP_067788423.1	4785	g5676	i0	67	11.3948126801153	112	37	96.8	0	346	11	30	141	XP_067788423.1 60S ribosomal protein L35a-4 [Phytophthora cinnamomi]	diamond	3954	161	0.993788819875776	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
30199722	30199722	PRJNA1242190_S_NODE_10272_length_270_cov_0.949239_g10265_i0	PRJNA1242190	10272	270	0.949239	2.5629453	Phytophthora boehmeriae	109152	SAR_Eukaryotes	SAR_Eukaryotes	78.2	1.93e-16	NR	KAG7401950.1	109152	g10265	i0	47.7	3.93333333333333	86	44	94.4	1	255	1	17	102	KAG7401950.1 hypothetical protein PHYBOEH_008471 [Phytophthora boehmeriae]	diamond	1062	78.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
31355772	31355772	PRJNA1242190_S_NODE_6476_length_329_cov_7.937500_g6469_i0	PRJNA1242190	6476	329	7.9375	26.114375	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	133	4.97e-38	NR	KAG7390926.1	109152	g6469	i0	67	10.3677811550152	88	28	80.2	1	23	286	3	89	KAG7390926.1 60S ribosomal protein L37 [Phytophthora boehmeriae]	diamond	3411	133	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
31829887	31829887	PRJNA1242190_S_NODE_11597_length_255_cov_0.989011_g11590_i0	PRJNA1242190	11597	255	0.989011	2.52197805	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.66e-14	NR	XP_024584861.1	4781	g11590	i0	96.9	6.01176470588235	32	1	37.6	0	96	1	138	169	XP_024584861.1 adp-ribosylation factor [Plasmopara halstedii]	diamond	1533	75.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
32399750	32399750	PRJNA1242190_S_NODE_2399_length_479_cov_4.039409_g2392_i0	PRJNA1242190	2399	479	4.039409	19.34876911	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	85.9	1.34e-17	NR	DBA01302.1	4803	g2392	i0	41.3	4.55323590814196	121	56	75.8	2	477	115	77	182	DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum]	diamond	2181	86.3	0.995365005793743	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
32809713	32809713	PRJNA1242190_S_NODE_14100_length_225_cov_10.605263_g14093_i0	PRJNA1242190	14100	225	10.605263	23.86184175	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	69.3	8.83e-14	NR	XP_008610509.1	1156394	g14093	i0	59.3	2.92	54	21	72	1	11	172	1	53	XP_008610509.1 40S ribosomal protein S29 [Saprolegnia diclina VS20]	diamond	657	69.7	0.994261119081779	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina

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