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

4 rows where analysis = "diamond", bioproject = "PRJEB2333" 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
27121232	27121232	PRJEB2333_P_NODE_2502_length_589_cov_1.336957_g1735_i0	PRJEB2333	2502	589	1.336957	7.87467673	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	94	1.62e-19	NR	KAJ8578052.1	4785	g1735	i0	42.2	5.25127334465195	116	64	59.1	2	588	241	133	245	KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi]	diamond	3093	94.7	0.992608236536431	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
28454577	28454577	PRJEB2333_P_NODE_3906_length_194_cov_1.719745_g3129_i0	PRJEB2333	3906	194	1.719745	3.3363053	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	70.9	2.38e-12	NR	DAZ96502.1	4803	g3129	i0	54	2.92268041237113	63	29	97.4	0	192	4	2045	2107	DAZ96502.1 TPA: hypothetical protein N0F65_008053 [Lagenidium giganteum]	diamond	567	70.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
30437754	30437754	PRJEB2333_P_NODE_2513_length_583_cov_1.879121_g1746_i0	PRJEB2333	2513	583	1.879121	10.95527543	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	202	1.15e-62	NR	KAG1694345.1	4784	g1746	i0	53.6	3.99313893653516	194	64	99.8	1	583	2	28	195	KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici]	diamond	2328	203	0.995073891625616	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
31480746	31480746	PRJEB2333_P_NODE_2396_length_650_cov_1.499184_g1636_i0	PRJEB2333	2396	650	1.499184	9.744696	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	179	2.69e-52	NR	GLD96418.1	114742	g1636	i0	59.1	3.32307692307692	149	60	68.8	1	2	448	45	192	GLD96418.1 hypothetical protein PINS_up005101 [Pythium insidiosum]	diamond	2160	179	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum

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