metadata: contig_metadata: 18 rows where bioproject = "PRJNA473201", tax_clade = "Sar" and tax

18 rows where bioproject = "PRJNA473201", 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
1718598	1718598	PRJNA473201_P_NODE_35302_length_335_cov_0.988550_g34560_i0	PRJNA473201	35302	335	0.98855	3.3116425	Theileria orientalis strain Shintoku	869250	SAR_Eukaryotes	SAR_Eukaryotes	145	1.76e-41	NR	XP_009690710.1	869250	g34560	i0	65.1	9.77910447761194	109	38	97.6	0	7	333	4	112	XP_009690710.1 60S ribosomal protein L17 [Theileria orientalis strain Shintoku]	diamond	3276	145	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
4271071	4271071	PRJNA473201_P_NODE_56504_length_275_cov_2.757426_g55762_i0	PRJNA473201	56504	275	2.757426	7.5829215	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|916498813\|ref\|XM_013494772.1\|	44415	g55762	i0	100	0.105454545454545	29	0	11	0	96	124	2511	2483	Eimeria mitis elongation factor Tu GTP-binding domain-containing protein, putative (EMH_0090800), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
5547418	5547418	PRJNA473201_P_NODE_37665_length_325_cov_1.607143_g36923_i0	PRJNA473201	37665	325	1.607143	5.22321475	Eimeriidae	5799	SAR_Eukaryotes	SAR_Eukaryotes	140	1.9e-37	NR	XP_013232628.1	5802	g36923	i0	73	3.42461538461538	89	24	82.2	0	289	23	292	380	XP_013232628.1 60S ribosomal protein L3, putative [Eimeria tenella]	diamond	1113	140	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
6198558	6198558	PRJNA473201_P_NODE_87505_length_220_cov_23.795918_g86763_i0	PRJNA473201	87505	220	23.795918	52.3510196	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	84.2	6.91e-12	NTclustered	gi\|573016600\|gb\|KF018657.1\|	36330	g86763	i0	77.778	20.9636363636364	135	30	61	0	3	137	1116	982	Plasmodium ovale isolate ZBP-HN clone RH4 18S ribosomal RNA gene, complete sequence	blastn	4612	84.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
7472991	7472991	PRJNA473201_P_NODE_54446_length_281_cov_1.110577_g53704_i0	PRJNA473201	54446	281	1.110577	3.12072137	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.026	NTclustered	gi\|915122992\|ref\|XM_013477306.1\|	5804	g53704	i0	100	0.199288256227758	28	0	10	0	94	121	1481	1454	Eimeria maxima ribosomal RNA methyltransferase, putative partial mRNA	blastn	56	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
8097420	8097420	PRJNA473201_P_NODE_67347_length_250_cov_1.790960_g66605_i0	PRJNA473201	67347	250	1.79096	4.4774	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	268	2.07e-67	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g66605	i0	86.345	2.616	249	30	99	4	1	247	157195	156949	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	654	268	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
8747954	8747954	PRJNA473201_P_NODE_49327_length_293_cov_10.518182_g48585_i0	PRJNA473201	49327	293	10.518182	30.81827326	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.027	NTclustered	gi\|1620127633\|ref\|XM_028673323.1\|	5849	g48585	i0	100	0.286689419795222	28	0	10	0	112	139	10629	10602	Plasmodium gallinaceum hypothetical protein (PGAL8A_00456300), partial mRNA	blastn	84	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
9371821	9371821	PRJNA473201_P_NODE_53768_length_282_cov_26.224880_g53026_i0	PRJNA473201	53768	282	26.22488	73.9541616	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.026	NTclustered	gi\|1084895398\|ref\|XM_018787168.1\|	647221	g53026	i0	100	0.099290780141844	28	0	10	0	195	222	253	226	Plasmodium gaboni hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
9372035	9372035	PRJNA473201_P_NODE_64388_length_254_cov_31.635359_g63646_i0	PRJNA473201	64388	254	31.635359	80.35381186	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	76.8	1.37e-9	NTclustered	gi\|1084825779\|ref\|XM_018785154.1\|	647221	g63646	i0	82.796	3.73228346456693	93	8	35	6	16	103	2044	1955	Plasmodium gaboni putative sentrin-specific protease 2 partial mRNA	blastn	948	76.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
10647682	10647682	PRJNA473201_P_NODE_41229_length_312_cov_9.246862_g40487_i0	PRJNA473201	41229	312	9.246862	28.85020944	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.008	NTclustered	gi\|1084825779\|ref\|XM_018785154.1\|	647221	g40487	i0	100	0.272435897435897	29	0	9	0	1	29	2034	2006	Plasmodium gaboni putative sentrin-specific protease 2 partial mRNA	blastn	85	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
14472892	14472892	PRJNA473201_P_NODE_65532_length_251_cov_29.280899_g64790_i0	PRJNA473201	65532	251	29.280899	73.49505649	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|1084825779\|ref\|XM_018785154.1\|	647221	g64790	i0	100	0.115537848605578	29	0	12	0	1	29	2032	2004	Plasmodium gaboni putative sentrin-specific protease 2 partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
18295682	18295682	PRJNA473201_P_NODE_55775_length_277_cov_2.480392_g55033_i0	PRJNA473201	55775	277	2.480392	6.87068584	Cryptosporidium sp. chipmunk genotype I	1280935	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|2787699113\|ref\|XM_067345761.1\|	1280935	g55033	i0	100	0.306859205776173	29	0	10	0	101	129	514	486	Cryptosporidium sp. chipmunk genotype I uncharacterized protein (ELE39_002657), partial mRNA	blastn	85	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. chipmunk genotype I
26743787	26743787	PRJNA473201_P_NODE_40641_length_314_cov_1.278008_g39899_i0	PRJNA473201	40641	314	1.278008	4.01294512	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	95.1	1.07e-22	NR	XP_013251421.1	5801	g39899	i0	47.1	10.5668789808917	85	45	81.2	0	60	314	8	92	XP_013251421.1 60s ribosomal protein L33-A, putative [Eimeria acervulina]	diamond	3318	95.5	0.995811518324607	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
28039970	28039970	PRJNA473201_P_NODE_71225_length_248_cov_1.320000_g70483_i0	PRJNA473201	71225	248	1.32	3.2736	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	79	1.25e-16	NR	CDJ52943.1	51314	g70483	i0	53.3	1.62096774193548	75	29	83.5	1	207	1	1	75	CDJ52943.1 60s ribosomal protein L33-A, putative [Eimeria brunetti]	diamond	402	79.7	0.991217063989962	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria brunetti
30361008	30361008	PRJNA473201_P_NODE_66052_length_251_cov_0.865169_g65310_i0	PRJNA473201	66052	251	0.865169	2.17157419	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	78.6	9.96e-15	NR	KAF8817981.1	476202	g65310	i0	61.7	0.717131474103586	60	20	71.7	1	249	70	589	645	KAF8817981.1 pre-mRna processing splicing factor PRP8 [Cardiosporidium cionae]	diamond	180	78.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
31451329	31451329	PRJNA473201_P_NODE_59816_length_267_cov_0.953608_g59074_i0	PRJNA473201	59816	267	0.953608	2.54613336	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	91.3	4.76e-20	NR	XP_625504.1	353152	g59074	i0	60.5	1.70786516853933	76	30	85.4	0	266	39	183	258	XP_625504.1 60S ribosomal protein L7A, partial [Cryptosporidium parvum Iowa II]	diamond	456	92	0.992391304347826	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
32574199	32574199	PRJNA473201_P_NODE_85779_length_241_cov_0.916667_g85037_i0	PRJNA473201	85779	241	0.916667	2.20916747	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.03e-13	NR	VWU50489.1	2600580	g85037	i0	44.2	0.95850622406639	77	43	95.9	0	232	2	333	409	VWU50489.1 AP-1 complex subunit mu-1, putative [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	231	75.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
32590218	32590218	PRJNA473201_P_NODE_83859_length_242_cov_0.911243_g83117_i0	PRJNA473201	83859	242	0.911243	2.20520806	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	113	4.4600000000000006e-27	NR	XP_029220075.1	94643	g83117	i0	67.9	5.80165289256198	78	25	96.7	0	3	236	415	492	XP_029220075.1 signal recognition particle receptor alpha subunit [Besnoitia besnoiti]	diamond	1404	114	0.991228070175439	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);;