metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA949785" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA949785" 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
13686816	13686816	PRJNA949785_P_NODE_14651_length_260_cov_2.016043_g14454_i0	PRJNA949785	14651	260	2.016043	5.2417118	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	124	5.66e-31	NR	XP_725288.1	5861	g14454	i0	73.1	19.0038461538462	78	21	90	0	235	2	377	454	XP_725288.1 uncharacterized protein PY17X_1143800 [Plasmodium yoelii]	diamond	4941	125	0.992	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
28225480	28225480	PRJNA949785_P_NODE_4126_length_566_cov_2.977688_g3935_i0	PRJNA949785	4126	566	2.977688	16.85371408	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	64.3	3.03e-8	NR	XP_029216214.1	94643	g3935	i0	25	1.01766784452297	192	127	94.3	5	556	23	271	459	XP_029216214.1 LETM1 family protein [Besnoitia besnoiti]	diamond	576	64.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
28825376	28825376	PRJNA949785_P_NODE_4308_length_551_cov_1.487448_g4113_i0	PRJNA949785	4308	551	1.487448	8.19583848	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	67.8	1.08e-9	NR	XP_028865435.1	189622	g4113	i0	46.3	0.73502722323049	67	35	35.9	1	294	97	2	68	XP_028865435.1 PP-loop family protein [Babesia ovata]	diamond	405	67.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
29937449	29937449	PRJNA949785_P_NODE_15151_length_254_cov_2.546961_g14954_i0	PRJNA949785	15151	254	2.546961	6.46928094	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	55.1	1.9e-6	NR	QOY41774.1	5807	g14954	i0	38.6	4.55905511811024	83	49	98	1	6	254	315	395	QOY41774.1 Sec1-like protein [Cryptosporidium parvum]	diamond	1158	55.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
31264444	31264444	PRJNA949785_P_NODE_1675_length_919_cov_2.875887_g1531_i0	PRJNA949785	1675	919	2.875887	26.42940153	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	248	8.64e-76	NR	XP_028536015.1	85471	g1531	i0	44.1	7.41675734494015	270	151	88.1	0	825	16	144	413	XP_028536015.1 glycylpeptide N-tetradecanoyltransferase, putative [Plasmodium relictum]	diamond	6816	248	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum

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