metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA853194" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA853194" 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
27379535	27379535	PRJNA853194_S_NODE_343_length_1966_cov_12.753830_g225_i0	PRJNA853194	343	1966	12.75383	250.7402978	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	57	3.77e-4	NR	ETW55751.1	57270	g225	i0	23.3	8.35757884028484	580	337	79.3	28	1822	263	1347	1878	ETW55751.1 hypothetical protein PFUGPA_02256, partial [Plasmodium falciparum Palo Alto/Uganda]	diamond	16431	57	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
27907563	27907563	PRJNA853194_S_NODE_13105_length_531_cov_54.844978_g12030_i0	PRJNA853194	13105	531	54.844978	291.22683318	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	160	4.38e-44	NR	XP_028536015.1	85471	g12030	i0	47.4	1.74011299435028	154	81	87	0	530	69	260	413	XP_028536015.1 glycylpeptide N-tetradecanoyltransferase, putative [Plasmodium relictum]	diamond	924	160	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
28191772	28191772	PRJNA853194_S_NODE_76426_length_251_cov_1.337079_g75335_i0	PRJNA853194	76426	251	1.337079	3.35606829	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0225	NR	XP_026193722.1	88456	g75335	i0	39.3	0.669322709163347	56	33	65.7	1	199	35	884	939	XP_026193722.1 uncharacterized protein LOC34623461 [Cyclospora cayetanensis]	diamond	168	43.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
29044684	29044684	PRJNA853194_S_NODE_25088_length_409_cov_6.181548_g23997_i0	PRJNA853194	25088	409	6.181548	25.28253132	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	64.7	4.35e-9	NR	XP_002140823.1	441375	g23997	i0	36.1	2.30317848410758	108	53	69.7	5	5	289	284	388	XP_002140823.1 uncharacterized protein CMU_009660 [Cryptosporidium muris RN66]	diamond	942	64.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
29139534	29139534	PRJNA853194_S_NODE_4569_length_833_cov_45.030263_g3769_i0	PRJNA853194	4569	833	45.030263	375.10209079	Toxoplasma gondii GT1	507601	SAR_Eukaryotes	SAR_Eukaryotes	111	1.7599999999999998e-24	NR	EPR61646.1	507601	g3769	i0	30.3	1.57022809123649	218	150	77.8	1	62	709	125	342	EPR61646.1 N-methyl-D-aspartate receptor-associated protein [Toxoplasma gondii GT1]	diamond	1308	111	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
30979658	30979658	PRJNA853194_S_NODE_12454_length_543_cov_6.980851_g11384_i0	PRJNA853194	12454	543	6.980851	37.90602093	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	134	1.0799999999999999e-32	NR	SCP05393.1	36330	g11384	i0	53	13.2099447513812	134	60	74	3	3	404	560	690	SCP05393.1 exoribonuclease, putative [Plasmodium ovale]	diamond	7173	135	0.992592592592593	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
31011021	31011021	PRJNA853194_S_NODE_3574_length_921_cov_20.770047_g2866_i0	PRJNA853194	3574	921	20.770047	191.29213287	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	172	2.4799999999999994e-48	NR	ETW54969.1	57270	g2866	i0	54.3	2.15960912052117	164	75	53.4	0	811	320	26	189	ETW54969.1 hypothetical protein PFUGPA_02792 [Plasmodium falciparum Palo Alto/Uganda]	diamond	1989	172	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
32141473	32141473	PRJNA853194_S_NODE_36098_length_353_cov_3.292857_g35007_i0	PRJNA853194	36098	353	3.292857	11.62378521	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	47.8	0.00212	NR	XP_028860370.1	5858	g35007	i0	39.7	1.24079320113314	73	42	60.3	2	18	230	244	316	XP_028860370.1 lipoate-protein ligase B, putative [Plasmodium malariae]	diamond	438	47.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae

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