metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA812715" 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
2500586	2500586	PRJNA812715_P_NODE_60902_length_335_cov_2.641221_g59103_i0	PRJNA812715	60902	335	2.641221	8.84809035	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	316	1.0099999999999999e-81	NTclustered	gi\|1015519763\|gb\|KT369006.1\|	1821735	g59103	i0	86.218	93.9671641791045	312	20	91	12	1	306	3367	3661	Lankesterella sp. Guelph2013 isolate B mitochondrion, complete genome	blastn	31479	318	0.993710691823899	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Lankesterellidae	Lankesterella	Lankesterella sp. Guelph2013
4642600	4642600	PRJNA812715_P_NODE_67404_length_313_cov_1.925000_g65604_i0	PRJNA812715	67404	313	1.925	6.02525	Goussia sp. BMR-2011c	980545	SAR_Eukaryotes	SAR_Eukaryotes	448	3.1999999999999998e-121	NTclustered	gi\|328460783\|gb\|GU479658.1\|	980545	g65604	i0	96.324	71.2651757188498	272	10	87	0	42	313	1527	1256	Goussia sp. BMR-2011c isolate CAR620-#620 18S ribosomal RNA gene, partial sequence	blastn	22306	448	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia sp. BMR-2011c
5915446	5915446	PRJNA812715_P_NODE_116705_length_243_cov_1.358824_g114904_i0	PRJNA812715	116705	243	1.358824	3.30194232	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|916501325\|ref\|XM_013496023.1\|	44415	g114904	i0	87.5	0.197530864197531	48	6	20	0	82	129	2075	2028	Eimeria mitis uncharacterized protein (EMH_0045020), partial mRNA	blastn	48	56.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
5916027	5916027	PRJNA812715_P_NODE_23325_length_674_cov_3.951747_g21637_i0	PRJNA812715	23325	674	3.951747	26.63477478	Goussia bayae	2303416	SAR_Eukaryotes	SAR_Eukaryotes	505	4.289999999999999e-138	NTclustered	gi\|1450318675\|gb\|MH758782.1\|	2303416	g21637	i0	89.409	59.6765578635015	406	36	60	7	273	674	434	32	Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence	blastn	40222	505	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia bayae
7191379	7191379	PRJNA812715_P_NODE_37406_length_469_cov_1.164141_g35617_i0	PRJNA812715	37406	469	1.164141	5.45982129	Eimeria iyoensis	3136237	SAR_Eukaryotes	SAR_Eukaryotes	538	2.8699999999999993e-148	NTclustered	gi\|2753323552\|dbj\|LC806970.1\|	3136237	g35617	i0	88.539	94.8123667377399	445	50	95	1	26	469	1102	658	Eimeria iyoensis EHM2023 mitochondrial Cytb, Cox1 genes for cytochrome b, cytochrome c oxidase subunit 1, partial and complete cds	blastn	44467	538	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria iyoensis
8465779	8465779	PRJNA812715_P_NODE_26327_length_612_cov_2.541744_g24598_i0	PRJNA812715	26327	612	2.541744	15.55547328	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	418	5.189999999999998e-112	NTclustered	gi\|296004693\|ref\|XM_961086.2\|	36329	g24598	i0	79.526	19.7467320261438	591	117	96	4	10	598	1366	778	Plasmodium falciparum 3D7 cell division cycle protein 48 homologue, putative (PF3D7_0619400), partial mRNA	blastn	12085	418	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
9740676	9740676	PRJNA812715_P_NODE_20908_length_735_cov_15.912387_g19277_i0	PRJNA812715	20908	735	15.912387	116.95604445	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	272	5.189999999999999e-68	NTclustered	gi\|126649276\|ref\|XM_001388273.1\|	353152	g19277	i0	80.27	5.27619047619048	370	66	50	5	107	472	112	478	Cryptosporidium parvum Iowa II ribosomal protein S23 (cgd6_1390) mRNA, partial cds	blastn	3878	272	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
9741073	9741073	PRJNA812715_P_NODE_3268_length_2413_cov_4.986752_g2898_i0	PRJNA812715	3268	2413	4.986752	120.33032576	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	1439	0	NTclustered	gi\|401405636\|ref\|XM_003882219.1\|	572307	g2898	i0	81.475	49.8458350600912	1776	309	73	20	2	1767	734	2499	Neospora caninum Liverpool putative elongation factor 2 (NCLIV_020220), partial mRNA	blastn	120278	1439	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9741483	9741483	PRJNA812715_P_NODE_45188_length_410_cov_0.913947_g43392_i0	PRJNA812715	45188	410	0.913947	3.7471827	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.039	NTclustered	gi\|1620122350\|ref\|XM_028671911.1\|	5849	g43392	i0	96.774	0.075609756097561	31	1	8	0	39	69	2347	2377	Plasmodium gallinaceum conserved Plasmodium membrane protein, unknown function (PGAL8A_00291200), partial mRNA	blastn	31	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
11428782	11428782	PRJNA812715_P_NODE_42609_length_427_cov_1.971751_g40814_i0	PRJNA812715	42609	427	1.971751	8.41937677	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	337	1.0099999999999999e-87	NTclustered	gi\|724471677\|gb\|KP009592.1\|	471278	g40814	i0	83.2	88.1662763466042	375	56	87	6	55	425	2272	2643	Eimeria intestinalis mitochondrion, complete genome	blastn	37647	337	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria intestinalis
12293720	12293720	PRJNA812715_P_NODE_7970_length_1491_cov_6.169252_g7108_i0	PRJNA812715	7970	1491	6.169252	91.98354732	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	1496	0	NTclustered	gi\|916427472\|ref\|XM_013379513.1\|	5802	g7108	i0	84.887	102.081824279007	1502	205	100	19	1	1491	1772	282	Eimeria tenella uncharacterized protein (ETH_00000210), partial mRNA	blastn	152204	1496	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
12704410	12704410	PRJNA812715_P_NODE_27510_length_592_cov_1.639692_g25762_i0	PRJNA812715	27510	592	1.639692	9.70697664	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.005	NTclustered	gi\|156093793\|ref\|XM_001612885.1\|	5855	g25762	i0	100	0.101351351351351	30	0	5	0	104	133	1727	1698	Plasmodium vivax hypothetical protein, conserved (PVX_003475), partial mRNA	blastn	60	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vivax
13565897	13565897	PRJNA812715_P_NODE_124271_length_227_cov_2.629870_g122470_i0	PRJNA812715	124271	227	2.62987	5.9698049	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.21e-4	NTclustered	gi\|916424421\|ref\|XM_013377988.1\|	5802	g122470	i0	100	1.71806167400881	32	0	14	0	110	141	291	260	Eimeria tenella ribosome biogenesis protein BOP1, putative (ETH_00006705), partial mRNA	blastn	390	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
13979015	13979015	PRJNA812715_P_NODE_6811_length_1647_cov_34.486023_g6048_i0	PRJNA812715	6811	1647	34.486023	567.98479881	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	881	0	NTclustered	gi\|260323703\|dbj\|AK317816.1\|	5811	g6048	i0	78.702	44.5312689738919	1371	257	82	27	163	1517	1582	231	Toxoplasma gondii cDNA, clone: XTG00910.2, full cDNA, XTG Sugano cDNA library	blastn	73343	881	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
14840733	14840733	PRJNA812715_P_NODE_21792_length_712_cov_1.679186_g20131_i0	PRJNA812715	21792	712	1.679186	11.95580432	Cryptosporidium hominis	237895	SAR_Eukaryotes	SAR_Eukaryotes	119	6.92e-22	NTclustered	gi\|67623164\|ref\|XM_662773.1\|	353151	g20131	i0	83.704	2.80056179775281	135	13	18	5	566	691	590	456	Cryptosporidium hominis TU502 hypothetical protein (Chro.40222) partial mRNA	blastn	1994	119	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
17391483	17391483	PRJNA812715_P_NODE_36474_length_477_cov_2.948020_g34686_i0	PRJNA812715	36474	477	2.94802	14.0620554	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	455	3.03e-123	NTclustered	gi\|1673117913\|ref\|XM_029364357.1\|	94643	g34686	i0	86.085	34.7966457023061	424	58	89	1	47	469	793	370	Besnoitia besnoiti histone deacetylase HDAC3 (BESB_059430), partial mRNA	blastn	16598	455	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
17802689	17802689	PRJNA812715_P_NODE_63534_length_326_cov_1.367589_g61735_i0	PRJNA812715	63534	326	1.367589	4.45834014	Isospora	56625	SAR_Eukaryotes	SAR_Eukaryotes	385	2.66e-102	NTclustered	gi\|794450809\|gb\|KP658103.1\|	1627835	g61735	i0	87.798	105.539877300613	336	31	100	4	1	326	3997	4332	Isospora sp. JRB-2015 voucher AHL_G09-038458 mitochondrion, complete genome	blastn	34406	388	0.992268041237113	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Isospora	Isospora sp. JRB-2015
18664904	18664904	PRJNA812715_P_NODE_46315_length_402_cov_6.085106_g44519_i0	PRJNA812715	46315	402	6.085106	24.46212612	Goussia carpelli	947543	SAR_Eukaryotes	SAR_Eukaryotes	676	0	NTclustered	gi\|324022099\|gb\|GU593716.1\|	947543	g44519	i0	97.03	102.18407960199	404	9	100	3	1	402	827	425	Goussia carpelli strain 23 28S ribosomal RNA gene, partial sequence	blastn	41078	676	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia carpelli
18665516	18665516	PRJNA812715_P_NODE_65655_length_319_cov_1.252033_g63855_i0	PRJNA812715	65655	319	1.252033	3.99398527	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	148	3.7099999999999996e-31	NTclustered	gi\|66358027\|ref\|XM_626192.1\|	353152	g63855	i0	82.927	55.6050156739812	164	28	53	0	144	307	488	325	Cryptosporidium parvum Iowa II polyubiquitin with 3 Ub domains (cgd5_2550) mRNA, partial cds	blastn	17738	148	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
19941223	19941223	PRJNA812715_P_NODE_8436_length_1437_cov_2.469941_g7529_i0	PRJNA812715	8436	1437	2.469941	35.49305217	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	237	3.79e-57	NTclustered	gi\|915004992\|ref\|XM_013394145.1\|	5801	g7529	i0	77.427	0.51704940848991	412	83	28	8	794	1200	407	1	Eimeria acervulina phosphatidylinositol-4-phosphate 5-kinase, putative partial mRNA	blastn	743	237	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
20351202	20351202	PRJNA812715_P_NODE_21156_length_729_cov_2.141768_g19512_i0	PRJNA812715	21156	729	2.141768	15.61348872	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	348	8.31e-91	NTclustered	gi\|1620131078\|ref\|XM_028673840.1\|	5849	g19512	i0	79.038	48.3292181069959	520	99	71	7	214	727	1131	616	Plasmodium gallinaceum 26S protease regulatory subunit 10B, putative (RPT4), partial mRNA	blastn	35232	348	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
24176744	24176744	PRJNA812715_P_NODE_55859_length_355_cov_1.092199_g54060_i0	PRJNA812715	55859	355	1.092199	3.87730645	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	99	4.25e-16	NTclustered	gi\|527100360\|dbj\|AK441444.1\|	5865	g54060	i0	91.549	0.4	71	6	20	0	285	355	58	128	Babesia bovis BBOV_III011550 mRNA for translation initiation factor eIF-1A, putative, complete cds, clone: XBBk015291, strain: Texas	blastn	142	99	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
25040059	25040059	PRJNA812715_P_NODE_53620_length_364_cov_6.484536_g51821_i0	PRJNA812715	53620	364	6.484536	23.60371104	Goussia sp. BMR-2011c	980545	SAR_Eukaryotes	SAR_Eukaryotes	645	1.2499999999999996e-180	NTclustered	gi\|328460764\|gb\|GU479639.1\|	980545	g51821	i0	98.626	101.458791208791	364	5	100	0	1	364	12	375	Goussia sp. BMR-2011c isolate GCAR812-#812 18S ribosomal RNA gene, partial sequence	blastn	36931	645	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia sp. BMR-2011c
25040169	25040169	PRJNA812715_P_NODE_5720_length_1817_cov_30.522362_g5067_i0	PRJNA812715	5720	1817	30.522362	554.59131754	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	1158	0	NTclustered	gi\|624291\|gb\|U19268.1\|ETU19268	5802	g5067	i0	82.586	67.4920198128784	1315	227	72	2	394	1707	1456	143	Eimeria tenella beta-tubulin mRNA, complete cds	blastn	122633	1158	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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