metadata: contig_metadata: 26 rows where bioproject = "PRJNA316313", tax_clade = "Sar" and tax

26 rows where bioproject = "PRJNA316313", 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
385983	385983	PRJNA316313_P_NODE_109141_length_198_cov_34.465839_g107755_i0	PRJNA316313	109141	198	34.465839	68.24236122	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	315	1.98e-81	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g107755	i0	95.455	53.9292929292929	198	8	100	1	1	198	300515	300319	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10678	315	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
1662383	1662383	PRJNA316313_P_NODE_395282_length_153_cov_2.422414_g393896_i0	PRJNA316313	395282	153	2.422414	3.70629342	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	250	4.14e-62	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g393896	i0	96.078	3.00653594771242	153	6	100	0	1	153	157790	157942	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	460	250	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
1663467	1663467	PRJNA316313_P_NODE_99802_length_205_cov_6.827381_g98416_i0	PRJNA316313	99802	205	6.827381	13.99613105	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	296	7.49e-76	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g98416	i0	92.683	4.57560975609756	205	15	100	0	1	205	158112	157908	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	938	296	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
1663469	1663469	PRJNA316313_P_NODE_99862_length_205_cov_6.160714_g98476_i0	PRJNA316313	99862	205	6.160714	12.6294637	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	296	7.49e-76	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g98476	i0	92.683	2.57560975609756	205	15	100	0	1	205	158112	157908	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	528	296	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2937823	2937823	PRJNA316313_P_NODE_32303_length_305_cov_4.190299_g30922_i0	PRJNA316313	32303	305	4.190299	12.78041195	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	135	2.74e-27	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g30922	i0	90.385	0.675409836065574	104	8	34	2	1	103	80490	80592	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	206	135	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
4213557	4213557	PRJNA316313_P_NODE_150424_length_187_cov_4.666667_g149038_i0	PRJNA316313	150424	187	4.666667	8.72666729	Plasmodium inui	52288	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.016	NTclustered	gi\|290965431\|dbj\|AB444054.1\|	52288	g149038	i0	100	0.598930481283422	28	0	15	0	114	141	2751	2724	Plasmodium inui msp1 gene for merozoite surface protein 1, complete cds, strain: ATCC 30156	blastn	112	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium inui
5491141	5491141	PRJNA316313_P_NODE_378625_length_161_cov_3.548387_g377239_i0	PRJNA316313	378625	161	3.548387	5.71290307	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	206	9.7e-49	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g377239	i0	91.892	17.7329192546584	148	10	100	2	2	148	117410	117264	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2855	206	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
5492220	5492220	PRJNA316313_P_NODE_88545_length_214_cov_6.231638_g87159_i0	PRJNA316313	88545	214	6.231638	13.33570532	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	248	2.24e-61	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g87159	i0	94.41	24.4672897196262	161	9	100	0	1	161	302217	302377	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5236	248	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
8040514	8040514	PRJNA316313_P_NODE_324027_length_187_cov_2.160000_g322641_i0	PRJNA316313	324027	187	2.16	4.0392	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	141	3.32e-29	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g322641	i0	100	1.20855614973262	76	0	81	0	112	187	80902	80827	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	226	141	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9315824	9315824	PRJNA316313_P_NODE_41868_length_277_cov_5.025000_g40485_i0	PRJNA316313	41868	277	5.025	13.91925	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	189	1.86e-43	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g40485	i0	98.148	13.2671480144404	108	2	80	0	1	108	299703	299596	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3675	189	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10590488	10590488	PRJNA316313_P_NODE_238309_length_187_cov_2.960000_g236923_i0	PRJNA316313	238309	187	2.96	5.5352	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	73.1	1.23e-8	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g236923	i0	89.474	0.834224598930481	57	6	33	0	20	76	299847	299791	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	156	73.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10591350	10591350	PRJNA316313_P_NODE_38389_length_286_cov_4.658635_g37008_i0	PRJNA316313	38389	286	4.658635	13.3236961	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	294	3.98e-75	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g37008	i0	88.235	0.891608391608392	255	19	85	11	1	244	80914	81168	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	255	294	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13140576	13140576	PRJNA316313_P_NODE_26791_length_329_cov_8.363014_g25414_i0	PRJNA316313	26791	329	8.363014	27.51431606	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	442	1.5699999999999994e-119	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g25414	i0	91.185	22.629179331307	329	23	100	5	1	329	433	111	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	7445	442	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
13142141	13142141	PRJNA316313_P_NODE_75371_length_226_cov_8.529101_g73985_i0	PRJNA316313	75371	226	8.529101	19.27576826	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	255	1.43e-63	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g73985	i0	89.95	9.29203539823009	199	18	94	2	12	209	96440	96637	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2100	255	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13142271	13142271	PRJNA316313_P_NODE_92091_length_211_cov_7.189655_g90705_i0	PRJNA316313	92091	211	7.189655	15.17017205	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	174	3.79e-39	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g90705	i0	80.365	1.5781990521327	219	32	99	8	3	211	80124	80341	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	333	174	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14416084	14416084	PRJNA316313_P_NODE_31472_length_308_cov_5.014760_g30091_i0	PRJNA316313	31472	308	5.01476	15.4454608	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	407	5.33e-109	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g30091	i0	90.82	5.23051948051948	305	27	99	1	4	308	157144	156841	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1611	407	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14417227	14417227	PRJNA316313_P_NODE_5332_length_766_cov_17.139918_g3791_i1	PRJNA316313	5332	766	17.139918	131.29177188	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	525	3.769999999999999e-144	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3791	i1	80.08	50.8107049608355	753	113	99	17	11	761	301972	301255	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	38921	525	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
15689622	15689622	PRJNA316313_P_NODE_28173_length_322_cov_7.221053_g26794_i0	PRJNA316313	28173	322	7.221053	23.25179066	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	525	1.4799999999999995e-144	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g26794	i0	96.25	5.82608695652174	320	12	100	0	3	322	117839	117520	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1876	525	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
15690810	15690810	PRJNA316313_P_NODE_46853_length_267_cov_5.765217_g45468_i0	PRJNA316313	46853	267	5.765217	15.39312939	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	207	4.93e-49	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g45468	i0	89.571	2.2059925093633	163	17	61	0	105	267	157284	157446	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	589	207	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18239550	18239550	PRJNA316313_P_NODE_435935_length_151_cov_4.105263_g434549_i0	PRJNA316313	435935	151	4.105263	6.19894713	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	110	7.21e-20	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g434549	i0	93.333	0.496688741721854	75	3	49	2	1	74	301583	301510	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	75	110	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19512416	19512416	PRJNA316313_P_NODE_18716_length_389_cov_5.860795_g17356_i0	PRJNA316313	18716	389	5.860795	22.79849255	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	207	7.5e-49	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g17356	i0	88.439	0.444730077120823	173	19	44	1	1	172	80190	80362	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	173	207	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
22062986	22062986	PRJNA316313_P_NODE_20358_length_373_cov_21.520833_g18990_i0	PRJNA316313	20358	373	21.520833	80.27270709	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	640	5.949999999999999e-179	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g18990	i0	97.587	65.5415549597855	373	9	100	0	1	373	116147	116519	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	24447	640	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
22065114	22065114	PRJNA316313_P_NODE_90798_length_212_cov_36.480000_g89412_i0	PRJNA316313	90798	212	36.48	77.3376	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	368	1.63e-97	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g89412	i0	98.113	53.0849056603774	212	3	100	1	1	212	96437	96647	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	11254	368	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
23338094	23338094	PRJNA316313_P_NODE_12959_length_466_cov_6.421911_g11659_i0	PRJNA316313	12959	466	6.421911	29.92610526	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	351	3.9899999999999996e-92	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g11659	i0	79.812	10.3454935622318	426	81	92	3	1	426	300726	300306	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4821	351	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
24612702	24612702	PRJNA316313_P_NODE_19620_length_380_cov_7.099125_g18255_i0	PRJNA316313	19620	380	7.099125	26.976675	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	429	1.43e-115	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g18255	i0	93.728	18.0868421052632	287	17	100	1	94	379	95717	96003	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	6873	429	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
28969354	28969354	PRJNA316313_P_NODE_156968_length_187_cov_4.413333_g155582_i0	PRJNA316313	156968	187	4.413333	8.25293271	Plasmodium vivax	5855	SAR_Eukaryotes	SAR_Eukaryotes	48.1	1.5e-4	NR	CAA63219.1	5855	g155582	i0	59.3	0.946524064171123	59	20	94.7	2	2	178	11	65	CAA63219.1 pva1 [Plasmodium vivax]	diamond	177	48.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vivax

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