metadata: contig_metadata: 8 rows where bioproject = "PRJNA949785", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA949785", tax_clade = "Sar" 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
3814090	3814090	PRJNA949785_P_NODE_8543_length_361_cov_0.725694_g8346_i0	PRJNA949785	8543	361	0.725694	2.61975534	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	640	5.739999999999999e-179	NTclustered	gi\|14495562\|gb\|L21708.2\|PFA34K	5821	g8346	i0	98.615	100	361	5	100	0	1	361	908	1268	Plasmodium berghei p23-like protein mRNA, partial cds	blastn	36100	645	0.992248062015504	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
12741340	12741340	PRJNA949785_P_NODE_7050_length_407_cov_1.934132_g6853_i0	PRJNA949785	7050	407	1.934132	7.87191724	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.039	NTclustered	gi\|915128644\|ref\|XM_013479421.1\|	5804	g6853	i0	88.636	0.245700245700246	44	3	11	2	287	329	3256	3214	Eimeria maxima hypothetical protein partial mRNA	blastn	100	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
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
17511291	17511291	PRJNA949785_P_NODE_11134_length_308_cov_1.421277_g10937_i0	PRJNA949785	11134	308	1.421277	4.37753316	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	130	1.29e-25	NTclustered	gi\|1624735278\|ref\|XM_029020408.1\|	857276	g10937	i0	75.824	1.77597402597403	273	57	87	8	41	308	394	662	Cryptosporidium ubiquitum vacuolar ATP synthase subunit B (cubi_03395), partial mRNA	blastn	547	130	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
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);;