metadata: contig_metadata: 17 rows where bioproject = "PRJEB75017", tax_clade = "Sar" and tax

17 rows where bioproject = "PRJEB75017", 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
5237859	5237859	PRJEB75017_P_NODE_10825_length_281_cov_1.125000_g10696_i0	PRJEB75017	10825	281	1.125	3.16125	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.026	NTclustered	gi\|1084986293\|ref\|XM_018780700.1\|	508771	g10696	i0	100	0.099644128113879	28	0	10	0	7	34	7593	7620	Toxoplasma gondii ME49 hypothetical protein mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
6513415	6513415	PRJEB75017_P_NODE_11486_length_274_cov_2.263682_g11357_i0	PRJEB75017	11486	274	2.263682	6.20248868	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	58.4	5.41e-4	NTclustered	gi\|916502880\|ref\|XM_013496737.1\|	44415	g11357	i0	89.13	0.372262773722628	46	5	17	0	132	177	201	246	Eimeria mitis uncharacterized protein (EMH_0004320), partial mRNA	blastn	102	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
6513431	6513431	PRJEB75017_P_NODE_13226_length_257_cov_2.233696_g13097_i0	PRJEB75017	13226	257	2.233696	5.74059872	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|921132467\|ref\|XM_013585315.1\|	51315	g13097	i0	100	0.108949416342412	28	0	11	0	57	84	627	654	Eimeria necatrix hypothetical protein, conserved partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
11613816	11613816	PRJEB75017_P_NODE_13510_length_255_cov_1.285714_g13381_i0	PRJEB75017	13510	255	1.285714	3.2785707	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1843423058\|dbj\|LC541869.1\|	5823	g13381	i0	100	0.117647058823529	30	0	12	0	28	57	51179	51150	Plasmodium berghei ANKA chromosome 1 telomere region, partial sequence	blastn	30	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
11613818	11613818	PRJEB75017_P_NODE_13750_length_253_cov_1.138889_g13621_i0	PRJEB75017	13750	253	1.138889	2.88138917	Theileria orientalis strain Shintoku	869250	SAR_Eukaryotes	SAR_Eukaryotes	129	1.7900000000000002e-33	NR	XP_009690376.1	869250	g13621	i0	67.5	46.9920948616601	80	26	94.9	0	3	242	128	207	XP_009690376.1 serine/threonine protein phosphatase 1, PP1-gamma catalytic subunit [Theileria orientalis strain Shintoku]	diamond	11889	129	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
11613840	11613840	PRJEB75017_P_NODE_16530_length_246_cov_1.352601_g16401_i0	PRJEB75017	16530	246	1.352601	3.32739846	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	159	1.27e-34	NTclustered	gi\|82914870\|ref\|XM_723786.1\|	5861	g16401	i0	80.383	9.24390243902439	209	41	85	0	37	245	983	775	Plasmodium yoelii tubulin subunit alpha (PY17X_0420500), partial mRNA	blastn	2274	159	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
12888864	12888864	PRJEB75017_P_NODE_10251_length_286_cov_1.784038_g10122_i0	PRJEB75017	10251	286	1.784038	5.10234868	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	169	2.52e-37	NTclustered	gi\|1673125678\|ref\|XM_029365676.1\|	94643	g10122	i0	85.714	28.3671328671329	161	21	56	2	48	207	1255	1096	Besnoitia besnoiti chaperonin protein BiP (BESB_073030), partial mRNA	blastn	8113	169	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
12888874	12888874	PRJEB75017_P_NODE_11051_length_279_cov_1.111650_g10922_i0	PRJEB75017	11051	279	1.11165	3.1015035	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	62.1	4.27e-5	NTclustered	gi\|916505532\|ref\|XM_013497862.1\|	44415	g10922	i0	77.273	11.0609318996416	132	13	46	14	45	172	323	205	Eimeria mitis uncharacterized protein (EMH_0061120), partial mRNA	blastn	3086	62.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
12888921	12888921	PRJEB75017_P_NODE_18271_length_242_cov_1.384615_g18142_i0	PRJEB75017	18271	242	1.384615	3.3507683	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	148	2.6999999999999997e-31	NTclustered	gi\|1624466873\|ref\|XM_029007108.1\|	5858	g18142	i0	91.667	1.58677685950413	108	7	44	2	42	148	109	215	Plasmodium malariae eukaryotic translation initiation factor 5A, putative (EIF5A), partial mRNA	blastn	384	148	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
15437800	15437800	PRJEB75017_P_NODE_11453_length_275_cov_1.158416_g11324_i0	PRJEB75017	11453	275	1.158416	3.185644	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	178	4e-40	NTclustered	gi\|1084839774\|ref\|XM_018785426.1\|	647221	g11324	i0	78.571	16.2436363636364	280	53	100	6	1	275	698	975	Plasmodium gaboni heat shock protein 70 partial mRNA	blastn	4467	178	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
15437914	15437914	PRJEB75017_P_NODE_9793_length_291_cov_1.279817_g9664_i0	PRJEB75017	9793	291	1.279817	3.72426747	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|915013849\|ref\|XM_013396674.1\|	5801	g9664	i0	100	0.484536082474227	29	0	10	0	70	98	2146	2174	Eimeria acervulina hypothetical protein, conserved partial mRNA	blastn	141	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
16712003	16712003	PRJEB75017_P_NODE_12974_length_260_cov_1.251337_g12845_i0	PRJEB75017	12974	260	1.251337	3.2534762	Babesia caballi	5871	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|2794943783\|ref\|XM_067859786.1\|	5871	g12845	i0	96.97	0.773076923076923	33	1	13	0	133	165	1719	1687	Babesia caballi phage tail protein (BcabD6B2_32530), partial mRNA	blastn	201	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia caballi
17986903	17986903	PRJEB75017_P_NODE_13555_length_254_cov_2.011050_g13426_i0	PRJEB75017	13555	254	2.01105	5.108067	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	292	1.25e-74	NTclustered	gi\|1620122260\|ref\|XM_028671860.1\|	5849	g13426	i0	90.222	76.9330708661417	225	20	88	2	1	224	671	894	Plasmodium gallinaceum serine/threonine protein phosphatase PP1, putative (PGAL8A_00286000), partial mRNA	blastn	19541	292	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
27311636	27311636	PRJEB75017_P_NODE_14083_length_252_cov_1.692737_g13954_i0	PRJEB75017	14083	252	1.692737	4.26569724	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	47	0.00143	NR	XP_067713627.1	5871	g13954	i0	32.6	3.83333333333333	89	55	100	2	252	1	4495	4583	XP_067713627.1 non-specific serine/threonine protein kinase [Babesia caballi]	diamond	966	47	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia caballi
30287345	30287345	PRJEB75017_P_NODE_14092_length_252_cov_1.547486_g13963_i0	PRJEB75017	14092	252	1.547486	3.89966472	Neospora caninum Liverpool	572307	SAR_Eukaryotes	SAR_Eukaryotes	56.6	5.22e-7	NR	XP_003879701.1	572307	g13963	i0	53.5	2.79761904761905	43	20	51.2	0	15	143	109	151	XP_003879701.1 putative PH domain-containing protein [Neospora caninum Liverpool]	diamond	705	56.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
30595492	30595492	PRJEB75017_P_NODE_8413_length_311_cov_0.878151_g8284_i0	PRJEB75017	8413	311	0.878151	2.73104961	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	63.5	7.9e-10	NR	SCQ16373.1	36330	g8284	i0	37.1	4.53376205787781	97	51	93.6	3	296	6	1	87	SCQ16373.1 cell cycle regulator protein, putative [Plasmodium ovale]	diamond	1410	63.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
31645864	31645864	PRJEB75017_P_NODE_8737_length_305_cov_1.530172_g8608_i0	PRJEB75017	8737	305	1.530172	4.6670246	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0269	NR	XP_029221749.1	94643	g8608	i0	34.9	0.845901639344262	86	44	80.7	4	289	44	4	81	XP_029221749.1 eukaryotic porin protein [Besnoitia besnoiti]	diamond	258	43.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti

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