metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1182301" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1182301" 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
26616516	26616516	PRJNA1182301_P_NODE_49441_length_250_cov_3.016949_g49316_i0	PRJNA1182301	49441	250	3.016949	7.5423725	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	51.2	4.25e-5	NR	TYZ69087.1	1485010	g49316	i0	52.6	1.368	38	16	45.6	1	123	10	776	811	TYZ69087.1 hypothetical protein PybrP1_010193, partial [[Pythium] brassicae (nom. inval.)]	diamond	342	51.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
32475263	32475263	PRJNA1182301_P_NODE_66839_length_229_cov_3.987179_g66714_i0	PRJNA1182301	66839	229	3.987179	9.13063991	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	75.1	9.52e-14	NR	GLE02111.1	114742	g66714	i0	40.8	1.28384279475983	98	35	98.3	1	225	1	21	118	GLE02111.1 hypothetical protein PINS_up010949 [Pythium insidiosum]	diamond	294	75.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
32695826	32695826	PRJNA1182301_P_NODE_18740_length_291_cov_1.344037_g18615_i0	PRJNA1182301	18740	291	1.344037	3.91114767	Peronospora effusa	542832	SAR_Eukaryotes	SAR_Eukaryotes	180	7.559999999999998e-54	NR	RMX62511.1	542832	g18615	i0	91.8	1	97	7	100	1	291	1	166	261	RMX62511.1 hypothetical protein DD238_007997 [Peronospora effusa]	diamond	291	180	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora effusa
32714950	32714950	PRJNA1182301_P_NODE_65420_length_235_cov_2.382716_g65295_i0	PRJNA1182301	65420	235	2.382716	5.5993826	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	59.3	4.85e-8	NR	KAH9115027.1	100861	g65295	i0	62.5	1.22553191489362	48	15	61.3	2	91	234	191	235	KAH9115027.1 hypothetical protein AeMF1_010946 [Aphanomyces euteiches]	diamond	288	59.3	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);;