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

8 rows where bioproject = "PRJNA235310", 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
367386	367386	PRJNA235310_P_NODE_5541_length_166_cov_0.888889_g5515_i0	PRJNA235310	5541	166	0.888889	1.47555574	Cryptosporidium ryanae	515981	SAR_Eukaryotes	SAR_Eukaryotes	110	8.13e-20	NTclustered	gi\|2787718610\|ref\|XM_067340940.1\|	515981	g5515	i0	86.139	5.32530120481928	101	14	61	0	18	118	329	429	Cryptosporidium ryanae 40S ribosomal protein S16 (FG386_001547), partial mRNA	blastn	884	110	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ryanae
26915769	26915769	PRJNA235310_P_NODE_2862_length_225_cov_2.329545_g2836_i0	PRJNA235310	2862	225	2.329545	5.24147625	Toxoplasma gondii ME49	508771	SAR_Eukaryotes	SAR_Eukaryotes	68.2	6.09e-12	NR	XP_018635543.1	508771	g2836	i0	63.5	0.693333333333333	52	18	68	1	154	2	83	134	XP_018635543.1 vacuolar atp synthase subunit f, putative [Toxoplasma gondii ME49]	diamond	156	68.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
27123053	27123053	PRJNA235310_P_NODE_5282_length_167_cov_0.881356_g5256_i0	PRJNA235310	5282	167	0.881356	1.47186452	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	75.5	3.79e-14	NR	XP_002258203.1	5851	g5256	i0	52.7	6.91616766467066	55	26	98.8	0	166	2	756	810	XP_002258203.1 protein kinase, putative [Plasmodium knowlesi strain H]	diamond	1155	75.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
27706198	27706198	PRJNA235310_P_NODE_5004_length_168_cov_1.739496_g4978_i0	PRJNA235310	5004	168	1.739496	2.92235328	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	68.2	4.22e-13	NR	CAL7859112.1	1344799	g4978	i0	68.6	1.82142857142857	51	16	91.1	0	3	155	55	105	CAL7859112.1 unnamed protein product [Sarcocystis calchasi]	diamond	306	68.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
28968850	28968850	PRJNA235310_P_NODE_1108_length_382_cov_1.405405_g1082_i0	PRJNA235310	1108	382	1.405405	5.3686471	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	93.6	3.9e-21	NR	XP_067804091.1	323732	g1082	i0	40.8	2.00261780104712	130	68	95	3	370	8	3	132	XP_067804091.1 bifunctional Translationally controlled tumor protein (TCTP) domain/Translationally controlled tumor protein/Mss4-like superfamily/Mss4-translationally controlled tumor-associated TCTP [Babesia duncani]	diamond	765	93.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
30610988	30610988	PRJNA235310_P_NODE_2093_length_271_cov_1.819820_g2067_i0	PRJNA235310	2093	271	1.81982	4.9317122	Neospora caninum Liverpool	572307	SAR_Eukaryotes	SAR_Eukaryotes	109	1.41e-28	NR	XP_003884403.1	572307	g2067	i0	61.4	0.918819188191882	83	32	91.9	0	254	6	11	93	XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool]	diamond	249	109	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
30642560	30642560	PRJNA235310_P_NODE_5013_length_168_cov_1.310924_g4987_i0	PRJNA235310	5013	168	1.310924	2.20235232	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	46.2	3.78e-4	NR	KAF8819440.1	476202	g4987	i0	42.2	0.803571428571429	45	26	80.4	0	168	34	73	117	KAF8819440.1 hypothetical protein IE077_001027, partial [Cardiosporidium cionae]	diamond	135	46.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
32445426	32445426	PRJNA235310_P_NODE_3959_length_190_cov_1.106383_g3933_i0	PRJNA235310	3959	190	1.106383	2.1021277	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	64.3	3.92e-11	NR	XP_028533300.1	85471	g3933	i0	54.1	0.963157894736842	61	28	96.3	0	8	190	13	73	XP_028533300.1 60S ribosomal protein L35ae, putative [Plasmodium relictum]	diamond	183	64.3	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);;