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

6 rows where analysis = "diamond", bioproject = "PRJNA951412" 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
11138508	11138508	PRJNA951412_P_NODE_749_length_526_cov_2.317881_g664_i0	PRJNA951412	749	526	2.317881	12.19205406	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	224	1.88e-66	NR	GLD95430.1	114742	g664	i0	70	13.1692015209125	160	43	91.3	1	40	519	15	169	GLD95430.1 hypothetical protein PINS_up004074 [Pythium insidiosum]	diamond	6927	226	0.991150442477876	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
27057262	27057262	PRJNA951412_P_NODE_6502_length_246_cov_0.884393_g6417_i0	PRJNA951412	6502	246	0.884393	2.17560678	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	51.2	3.16e-5	NR	KAJ0412788.1	114742	g6417	i0	46.3	0.658536585365854	54	29	65.9	0	81	242	172	225	KAJ0412788.1 hypothetical protein ATCC90586_002418 [Pythium insidiosum]	diamond	162	51.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
27221543	27221543	PRJNA951412_P_NODE_1982_length_330_cov_0.910506_g1897_i0	PRJNA951412	1982	330	0.910506	3.0046698	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	117	6.26e-28	NR	CCI46340.1	65357	g1897	i0	59.5	8.89090909090909	111	40	98.2	2	325	2	302	410	CCI46340.1 unnamed protein product [Albugo candida]	diamond	2934	117	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
29810916	29810916	PRJNA951412_P_NODE_7831_length_242_cov_0.923077_g7746_i0	PRJNA951412	7831	242	0.923077	2.23384634	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	113	9.73e-29	NR	KAJ8525807.1	4785	g7746	i0	75.4	9.40909090909091	69	17	85.5	0	241	35	201	269	KAJ8525807.1 hypothetical protein ON010_g15307 [Phytophthora cinnamomi]	diamond	2277	114	0.991228070175439	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
30815457	30815457	PRJNA951412_P_NODE_2914_length_284_cov_2.090047_g2829_i0	PRJNA951412	2914	284	2.090047	5.93573348	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	102	8.449999999999999e-23	NR	OQR95490.1	74557	g2829	i0	66.7	0.72887323943662	69	23	72.9	0	76	282	377	445	OQR95490.1 pescadillo [Thraustotheca clavata]	diamond	207	102	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
32333769	32333769	PRJNA951412_P_NODE_3919_length_255_cov_1.681319_g3834_i0	PRJNA951412	3919	255	1.681319	4.28736345	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	62.8	3.81e-9	NR	KAH9158664.1	100861	g3834	i0	68.2	0.517647058823529	44	14	51.8	0	132	1	110	153	KAH9158664.1 hypothetical protein LEN26_002820 [Aphanomyces euteiches]	diamond	132	62.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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