metadata: contig_metadata: 29 rows where bioproject = "PRJNA1174770" and tax

29 rows where bioproject = "PRJNA1174770" 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
1590956	1590956	PRJNA1174770_P_NODE_842_length_548_cov_7.228457_g755_i0	PRJNA1174770	842	548	7.228457	39.61194436	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	665	0	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g755	i0	91.075	75.036496350365	493	42	100	2	56	548	300787	300297	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	41120	665	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2867109	2867109	PRJNA1174770_P_NODE_3743_length_239_cov_2.447368_g3654_i0	PRJNA1174770	3743	239	2.447368	5.84920952	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	283	7e-72	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3654	i0	88.235	1.96652719665272	238	26	99	2	1	238	80309	80544	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	470	283	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2867119	2867119	PRJNA1174770_P_NODE_5683_length_195_cov_1.568493_g5594_i0	PRJNA1174770	5683	195	1.568493	3.05856135	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	145	2.7e-30	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g5594	i0	80.412	24.8871794871795	194	34	100	2	1	193	116603	116793	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4853	145	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
4143202	4143202	PRJNA1174770_P_NODE_6384_length_185_cov_3.051471_g6295_i0	PRJNA1174770	6384	185	3.051471	5.64522135	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	259	8.67e-65	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g6295	i0	91.892	1	185	15	100	0	1	185	157332	157516	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	185	259	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
5419331	5419331	PRJNA1174770_P_NODE_1225_length_451_cov_2.383085_g1136_i0	PRJNA1174770	1225	451	2.383085	10.74771335	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	560	5.87e-155	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g1136	i0	91.811	28.1640798226164	403	31	100	2	50	451	95563	95964	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	12702	560	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
5419339	5419339	PRJNA1174770_P_NODE_2205_length_323_cov_3.091241_g2116_i0	PRJNA1174770	2205	323	3.091241	9.98470843	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	435	2.5800000000000003e-117	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g2116	i0	91.277	3.02786377708978	321	24	99	4	3	321	80251	80569	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	978	435	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
6694199	6694199	PRJNA1174770_P_NODE_3526_length_247_cov_1.656566_g3437_i0	PRJNA1174770	3526	247	1.656566	4.09171802	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	329	9.21e-86	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3437	i0	90.763	17.7327935222672	249	20	100	3	1	247	97012	97259	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4380	329	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
6694219	6694219	PRJNA1174770_P_NODE_6006_length_190_cov_2.177305_g5917_i0	PRJNA1174770	6006	190	2.177305	4.1368795	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	211	2.54e-50	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g5917	i0	91.083	30.2157894736842	157	13	98	1	24	179	299461	299305	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5741	211	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9244206	9244206	PRJNA1174770_P_NODE_2648_length_290_cov_1.253112_g2559_i0	PRJNA1174770	2648	290	1.253112	3.6340248	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	270	6.81e-68	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g2559	i0	83.737	0.996551724137931	289	44	99	3	1	288	80523	80809	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	289	270	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9244216	9244216	PRJNA1174770_P_NODE_4788_length_211_cov_2.024691_g4699_i0	PRJNA1174770	4788	211	2.024691	4.27209801	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	209	1.04e-49	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g4699	i0	86.458	2.4739336492891	192	25	100	1	21	211	302069	302260	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	522	209	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10519904	10519904	PRJNA1174770_P_NODE_1309_length_434_cov_7.729870_g1220_i0	PRJNA1174770	1309	434	7.72987	33.5476358	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	730	0	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g1220	i0	97.005	5.84562211981567	434	13	100	0	1	434	117979	117546	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2537	730	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10519914	10519914	PRJNA1174770_P_NODE_3649_length_242_cov_4.347150_g3560_i0	PRJNA1174770	3649	242	4.34715	10.520103	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	333	6.949999999999999e-87	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3560	i0	91.667	39.3429752066116	240	20	100	0	3	242	300479	300718	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	9521	333	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10519927	10519927	PRJNA1174770_P_NODE_5789_length_193_cov_2.472222_g5700_i0	PRJNA1174770	5789	193	2.472222	4.77138846	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	331	1.91e-86	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g5700	i0	97.906	12.4300518134715	191	4	100	0	3	193	301497	301307	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2399	331	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
11794867	11794867	PRJNA1174770_P_NODE_2610_length_292_cov_4.901235_g2521_i0	PRJNA1174770	2610	292	4.901235	14.3116062	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	479	1.0499999999999996e-130	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g2521	i0	96.246	36.1541095890411	293	10	100	1	1	292	299375	299083	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10557	479	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14345257	14345257	PRJNA1174770_P_NODE_12692_length_152_cov_3.067961_g12603_i0	PRJNA1174770	12692	152	3.067961	4.66330072	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	158	2.56e-34	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g12603	i0	85.526	2.76315789473684	152	21	99	1	1	151	51615	51464	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	420	158	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14345264	14345264	PRJNA1174770_P_NODE_2432_length_305_cov_3.871094_g2343_i0	PRJNA1174770	2432	305	3.871094	11.8068367	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	320	7.06e-83	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g2343	i0	87.41	15.7377049180328	278	35	100	0	1	278	300718	300441	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4800	320	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14345268	14345268	PRJNA1174770_P_NODE_3632_length_243_cov_1.881443_g3543_i0	PRJNA1174770	3632	243	1.881443	4.57190649	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	263	9.3e-66	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3543	i0	90.148	8.5843621399177	203	19	100	1	42	243	97166	97368	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2086	263	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14345307	14345307	PRJNA1174770_P_NODE_9272_length_166_cov_1.547009_g9183_i0	PRJNA1174770	9272	166	1.547009	2.56803494	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	211	2.17e-50	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g9183	i0	89.697	9.25301204819277	165	17	99	0	1	165	157469	157305	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1536	211	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
15619027	15619027	PRJNA1174770_P_NODE_2693_length_286_cov_2.468354_g2604_i0	PRJNA1174770	2693	286	2.468354	7.05949244	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	488	1.6999999999999996e-133	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g2604	i0	97.552	38.6643356643357	286	6	100	1	1	286	96316	96032	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	11058	488	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
15619034	15619034	PRJNA1174770_P_NODE_3753_length_239_cov_1.542105_g3664_i0	PRJNA1174770	3753	239	1.542105	3.68563095	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	257	4.24e-64	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3664	i0	86.122	3.02092050209205	245	27	100	7	1	239	81081	80838	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	722	257	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19442285	19442285	PRJNA1174770_P_NODE_12556_length_157_cov_2.750000_g12467_i0	PRJNA1174770	12556	157	2.75	4.3175	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	139	9.67e-29	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g12467	i0	95.455	20.9235668789809	88	3	100	1	70	157	96910	96996	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3285	139	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19442287	19442287	PRJNA1174770_P_NODE_1396_length_418_cov_2.666667_g1307_i0	PRJNA1174770	1396	418	2.666667	11.14666806	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	584	3.2099999999999984e-162	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g1307	i0	91.885	12.6124401913876	419	32	100	2	1	418	157272	157689	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5272	584	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19442295	19442295	PRJNA1174770_P_NODE_3456_length_250_cov_1.597015_g3367_i0	PRJNA1174770	3456	250	1.597015	3.9925375	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	130	1.02e-25	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g3367	i0	82.759	1.16	145	25	58	0	105	249	299386	299530	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	290	130	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19442313	19442313	PRJNA1174770_P_NODE_6756_length_180_cov_6.641221_g6667_i0	PRJNA1174770	6756	180	6.641221	11.9541978	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	265	1.8e-66	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g6667	i0	93.333	35.2055555555556	180	11	100	1	1	180	95989	96167	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	6337	265	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20717637	20717637	PRJNA1174770_P_NODE_12697_length_152_cov_2.553398_g12608_i0	PRJNA1174770	12697	152	2.553398	3.88116496	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	267	4.08e-67	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g12608	i0	99.32	22.4210526315789	147	1	99	0	4	150	301279	301133	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3408	267	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20717668	20717668	PRJNA1174770_P_NODE_6517_length_184_cov_1.111111_g6428_i0	PRJNA1174770	6517	184	1.111111	2.04444424	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	231	1.88e-56	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g6428	i0	89.56	0.989130434782609	182	19	99	0	1	182	116174	116355	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	182	231	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20717684	20717684	PRJNA1174770_P_NODE_8717_length_167_cov_1.288136_g8628_i0	PRJNA1174770	8717	167	1.288136	2.15118712	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	226	7.799999999999999e-55	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g8628	i0	91.018	2	167	15	100	0	1	167	80750	80584	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	334	226	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
24542258	24542258	PRJNA1174770_P_NODE_540_length_698_cov_11.791988_g467_i0	PRJNA1174770	540	698	11.791988	82.30807624	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	1075	0	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g467	i0	94.429	68.4369627507163	700	37	100	2	1	698	116138	116837	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	47769	1075	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
24542267	24542267	PRJNA1174770_P_NODE_5980_length_191_cov_1.021127_g5891_i0	PRJNA1174770	5980	191	1.021127	1.95035257	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	219	1.5299999999999999e-52	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g5891	i0	89.941	0.884816753926702	169	17	88	0	1	169	300969	301137	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	169	219	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum

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