metadata: contig_metadata: 19 rows where bioproject = "PRJNA1073183", tax_clade = "Sar" and tax

19 rows where bioproject = "PRJNA1073183", 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
187086	187086	PRJNA1073183_P_NODE_14921_length_337_cov_1.159091_g14826_i0	PRJNA1073183	14921	337	1.159091	3.90613667	root	1	Root_unresolved	Root_unresolved	155	1.4099999999999999e-42	NR	XP_013332868.1	5804	g14826	i0	66.4	41.3056379821958	110	37	97.9	0	3	332	165	274	XP_013332868.1 enolase 2, putative [Eimeria maxima]	diamond	13920	155	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
6119225	6119225	PRJNA1073183_P_NODE_25705_length_255_cov_1.269231_g25610_i0	PRJNA1073183	25705	255	1.269231	3.23653905	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	138	5.269999999999999e-37	NR	XP_013227965.1	5802	g25610	i0	81.9	45.8705882352941	83	15	97.6	0	7	255	192	274	XP_013227965.1 26S proteasome regulatory ATPase subunit, putative [Eimeria tenella]	diamond	11697	138	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
21864331	21864331	PRJNA1073183_P_NODE_8858_length_429_cov_1.676966_g8764_i0	PRJNA1073183	8858	429	1.676966	7.19418414	Plasmodium cynomolgi	5827	SAR_Eukaryotes	SAR_Eukaryotes	58.4	8.89e-4	NTclustered	gi\|457868707\|ref\|XM_004221228.1\|	1120755	g8764	i0	84.483	0.135198135198135	58	9	14	0	286	343	931	988	Plasmodium cynomolgi strain B transcription factor with AP2 domain(s) (PCYB_053470) mRNA, complete cds	blastn	58	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi
26782743	26782743	PRJNA1073183_P_NODE_30441_length_246_cov_0.890173_g30346_i0	PRJNA1073183	30441	246	0.890173	2.18982558	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	97.8	4.52e-23	NR	OEH76901.1	88456	g30346	i0	65.4	8.87804878048781	81	28	98.8	0	246	4	111	191	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	2184	97.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
26932388	26932388	PRJNA1073183_P_NODE_33462_length_242_cov_0.911243_g33367_i0	PRJNA1073183	33462	242	0.911243	2.20520806	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	82.4	2.56e-16	NR	XP_001351251.1	36329	g33367	i0	56.2	3.6198347107438	73	32	90.5	0	232	14	202	274	XP_001351251.1 stomatin-like protein, putative [Plasmodium falciparum 3D7]	diamond	876	82.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
27438411	27438411	PRJNA1073183_P_NODE_13603_length_352_cov_1.100358_g13508_i0	PRJNA1073183	13603	352	1.100358	3.87326016	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	115	1.52e-28	NR	KAF7459052.1	83540	g13508	i0	47.7	5.33522727272727	107	55	91.2	1	26	346	132	237	KAF7459052.1 putative translation initiation factor eIF-5A [Cryptosporidium felis]	diamond	1878	116	0.991379310344828	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium felis
28827181	28827181	PRJNA1073183_P_NODE_24648_length_262_cov_1.333333_g24553_i0	PRJNA1073183	24648	262	1.333333	3.49333246	root	1	Root_unresolved	Root_unresolved	83.6	2.03e-16	NR	XP_067926781.1	483139	g24553	i0	50	4.64885496183206	84	41	96.2	1	252	1	112	194	XP_067926781.1 mitochondrial p5cdh [Cystoisospora suis]	diamond	1218	84.3	0.991696322657177	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
29490331	29490331	PRJNA1073183_P_NODE_26670_length_251_cov_0.865169_g26575_i0	PRJNA1073183	26670	251	0.865169	2.17157419	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	79.3	5.45e-15	NR	GFE53308.1	5869	g26575	i0	55.4	4.81673306772908	65	29	77.7	0	198	4	138	202	GFE53308.1 leucyl-tRNA synthetase [Babesia ovis]	diamond	1209	79.7	0.994981179422836	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
29624751	29624751	PRJNA1073183_P_NODE_32050_length_244_cov_0.900585_g31955_i0	PRJNA1073183	32050	244	0.900585	2.1974274	Plasmodium coatneyi	208452	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00813	NR	XP_019914520.1	208452	g31955	i0	54.1	0.454918032786885	37	16	45.5	1	240	130	900	935	XP_019914520.1 Uncharacterized protein PCOAH_00021770 [Plasmodium coatneyi]	diamond	111	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium coatneyi
29901062	29901062	PRJNA1073183_P_NODE_32011_length_244_cov_0.900585_g31916_i0	PRJNA1073183	32011	244	0.900585	2.1974274	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	147	1.62e-41	NR	XP_013248875.1	5801	g31916	i0	88.6	67.155737704918	79	9	97.1	0	239	3	230	308	XP_013248875.1 ATP-dependent helicase, putaive, putative [Eimeria acervulina]	diamond	16386	147	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
30375320	30375320	PRJNA1073183_P_NODE_19952_length_293_cov_1.050000_g19857_i0	PRJNA1073183	19952	293	1.05	3.0765	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	149	1.5999999999999996e-41	NR	XP_013338036.1	5804	g19857	i0	74.2	6.95221843003413	97	25	99.3	0	3	293	116	212	XP_013338036.1 developmentally regulated GTP-binding protein 1, putative [Eimeria maxima]	diamond	2037	149	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
30469872	30469872	PRJNA1073183_P_NODE_28073_length_249_cov_0.875000_g27978_i0	PRJNA1073183	28073	249	0.875	2.17875	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	100	1.29e-22	NR	PVC52725.1	68886	g27978	i0	65	7.80722891566265	80	28	96.4	0	241	2	423	502	PVC52725.1 vacuolar H+-ATPase, a subunit [Theileria orientalis]	diamond	1944	101	0.99009900990099	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
32177146	32177146	PRJNA1073183_P_NODE_24618_length_262_cov_1.629630_g24523_i0	PRJNA1073183	24618	262	1.62963	4.2696306	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	112	2.12e-26	NR	XP_013251045.1	5801	g24523	i0	60.3	7.54580152671756	78	31	89.3	0	26	259	897	974	XP_013251045.1 thrombospondin type 1 domain-containing protein, putative [Eimeria acervulina]	diamond	1977	113	0.991150442477876	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
32335438	32335438	PRJNA1073183_P_NODE_34359_length_241_cov_0.916667_g34264_i0	PRJNA1073183	34359	241	0.916667	2.20916747	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	86.3	1.72e-17	NR	KAF7458533.1	83540	g34264	i0	48.8	7.96680497925311	80	37	99.6	1	240	1	295	370	KAF7458533.1 cysteine-tRNA synthetase (CysRS) [Cryptosporidium felis]	diamond	1920	87	0.991954022988506	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium felis
32375434	32375434	PRJNA1073183_P_NODE_5019_length_566_cov_14.450304_g4926_i0	PRJNA1073183	5019	566	14.450304	81.78872064	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	206	9.64e-64	NR	OEH76901.1	88456	g4926	i0	62.1	4.60070671378092	177	67	93.8	0	4	534	29	205	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	2604	206	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
32533719	32533719	PRJNA1073183_P_NODE_34819_length_230_cov_4.267516_g34724_i0	PRJNA1073183	34819	230	4.267516	9.8152868	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	49.7	1.04e-4	NR	CAL7864417.1	1344799	g34724	i0	40	1.87826086956522	70	34	87.4	3	202	2	42	106	CAL7864417.1 unnamed protein product [Sarcocystis calchasi]	diamond	432	49.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
32565454	32565454	PRJNA1073183_P_NODE_6739_length_489_cov_4.656250_g6645_i0	PRJNA1073183	6739	489	4.65625	22.7690625	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	93.2	1.85e-20	NR	XP_028865997.1	189622	g6645	i0	36.2	3.03680981595092	163	85	91.4	4	8	454	1	158	XP_028865997.1 translationally-controlled tumor protein [Babesia ovata]	diamond	1485	93.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
32690938	32690938	PRJNA1073183_P_NODE_25140_length_259_cov_1.241935_g25045_i0	PRJNA1073183	25140	259	1.241935	3.21661165	Babesia bovis T2Bo	484906	SAR_Eukaryotes	SAR_Eukaryotes	79	2.05e-15	NR	XP_051623346.1	484906	g25045	i0	39	0.94980694980695	82	50	95	0	250	5	125	206	XP_051623346.1 putative integral membrane protein [Babesia bovis T2Bo]	diamond	246	79	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
32785438	32785438	PRJNA1073183_P_NODE_34320_length_241_cov_0.916667_g34225_i0	PRJNA1073183	34320	241	0.916667	2.20916747	Babesia caballi	5871	SAR_Eukaryotes	SAR_Eukaryotes	126	2.08e-32	NR	XP_067718097.1	5871	g34225	i0	75.9	0.983402489626556	79	19	98.3	0	239	3	18	96	XP_067718097.1 serine hydroxymethyltransferase 2, putative [Babesia caballi]	diamond	237	126	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia caballi

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