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

4 rows where analysis = "diamond", bioproject = "PRJNA1199330" and tax_phylum = "Apicomplexa"

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
26901781	26901781	PRJNA1199330_P_NODE_77681_length_275_cov_1.321782_g76982_i0	PRJNA1199330	77681	275	1.321782	3.6349005	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	56.2	9.83e-7	NR	XP_067714729.1	5871	g76982	i0	50	2.19272727272727	50	24	54.5	1	9	158	235	283	XP_067714729.1 apical complex lysine methyltransferase [Babesia caballi]	diamond	603	56.6	0.992932862190813	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia caballi
27357205	27357205	PRJNA1199330_P_NODE_90223_length_263_cov_1.642105_g89524_i0	PRJNA1199330	90223	263	1.642105	4.31873615	Babesia divergens	32595	SAR_Eukaryotes	SAR_Eukaryotes	54.3	4.05e-6	NR	KAK1937509.1	32595	g89524	i0	44.3	0.798479087452472	70	32	79.8	1	254	45	109	171	KAK1937509.1 putative DNA topoisomerase [Babesia divergens]	diamond	210	54.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia divergens
28196727	28196727	PRJNA1199330_P_NODE_28986_length_383_cov_2.977419_g28290_i0	PRJNA1199330	28986	383	2.977419	11.40351477	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00793	NR	KAF4638293.1	5811	g28290	i0	42.4	4.15926892950392	66	33	51.7	2	382	185	153	213	KAF4638293.1 zinc finger protein ZFP1 [Toxoplasma gondii]	diamond	1593	46.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
32570600	32570600	PRJNA1199330_P_NODE_8839_length_707_cov_31.630915_g8204_i0	PRJNA1199330	8839	707	31.630915	223.63056905	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	47.4	0.0295	NR	OEH78494.1	88456	g8204	i0	52.4	0.356435643564356	42	19	17.8	1	371	496	290	330	OEH78494.1 microneme protein [Cyclospora cayetanensis]	diamond	252	47.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis

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