metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA900028" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA900028" 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
875519	875519	PRJNA900028_P_NODE_3561_length_571_cov_1.482759_g2842_i0	PRJNA900028	3561	571	1.482759	8.46655389	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	259	3.09e-64	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g2842	i0	76.97	12.7565674255692	495	89	86	14	57	546	300321	300795	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	7284	259	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2150259	2150259	PRJNA900028_P_NODE_17362_length_285_cov_0.957627_g16613_i0	PRJNA900028	17362	285	0.957627	2.72923695	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	331	3.02e-86	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g16613	i0	90.196	1.89122807017544	255	23	99	2	31	284	80167	80420	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	539	331	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2151375	2151375	PRJNA900028_P_NODE_882_length_1410_cov_6.349008_g346_i2	PRJNA900028	882	1410	6.349008	89.5210128	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	2374	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g346	i2	97.155	1125.74964539007	1406	39	99	1	6	1410	1750	345	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	1587307	2374	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
3426669	3426669	PRJNA900028_P_NODE_73503_length_188_cov_1.100719_g72754_i0	PRJNA900028	73503	188	1.100719	2.06935172	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	215	1.94e-51	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g72754	i0	87.234	1.97340425531915	188	24	100	0	1	188	157422	157609	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	371	215	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
3426749	3426749	PRJNA900028_P_NODE_7963_length_385_cov_5.550595_g7217_i0	PRJNA900028	7963	385	5.550595	21.36979075	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	673	0	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g7217	i0	98.182	5.15324675324675	385	7	100	0	1	385	117547	117163	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1984	673	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
3426868	3426868	PRJNA900028_P_NODE_90543_length_180_cov_1.557252_g89794_i0	PRJNA900028	90543	180	1.557252	2.8030536	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	198	1.85e-46	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g89794	i0	88.095	18.8111111111111	168	18	99	2	1	167	96598	96432	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3386	198	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
5979144	5979144	PRJNA900028_P_NODE_705_length_1660_cov_7.038485_g346_i0	PRJNA900028	705	1660	7.038485	116.838851	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	2708	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g346	i0	98.441	1138.1156626506	1539	23	93	1	123	1660	1883	345	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	1889272	2708	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
7252366	7252366	PRJNA900028_P_NODE_10006_length_351_cov_1.043046_g9258_i0	PRJNA900028	10006	351	1.043046	3.66109146	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	326	1.77e-84	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g9258	i0	84.593	20.6210826210826	344	36	100	6	25	351	302561	302218	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	7238	326	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
8528778	8528778	PRJNA900028_P_NODE_77347_length_186_cov_1.467153_g76598_i0	PRJNA900028	77347	186	1.467153	2.72890458	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	135	1.53e-27	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g76598	i0	90.291	15.0268817204301	103	10	100	0	35	137	96631	96529	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2795	135	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
11077911	11077911	PRJNA900028_P_NODE_120469_length_167_cov_0.864407_g119720_i0	PRJNA900028	120469	167	0.864407	1.44355969	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	128	2.26e-25	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g119720	i0	82.209	19.9880239520958	163	15	100	4	5	167	96457	96309	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3338	128	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
11079522	11079522	PRJNA900028_P_NODE_789_length_1520_cov_6.651258_g346_i1	PRJNA900028	789	1520	6.651258	101.0991216	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	2564	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g346	i1	96.946	1183.02697368421	1539	28	100	7	1	1520	345	1883	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	1798201	2564	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
12353437	12353437	PRJNA900028_P_NODE_126770_length_167_cov_0.864407_g126021_i0	PRJNA900028	126770	167	0.864407	1.44355969	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	147	6.25e-31	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g126021	i0	83.03	1.98802395209581	165	25	99	3	2	166	80598	80437	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	332	147	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
12354428	12354428	PRJNA900028_P_NODE_38290_length_223_cov_3.666667_g37541_i0	PRJNA900028	38290	223	3.666667	8.17666741	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	368	1.73e-97	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g37541	i0	97.235	11.1210762331839	217	6	99	0	1	217	157063	157279	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2480	368	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13630023	13630023	PRJNA900028_P_NODE_99711_length_176_cov_1.204724_g98962_i0	PRJNA900028	99711	176	1.204724	2.12031424	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	318	1.3299999999999995e-82	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g98962	i0	99.429	5.89772727272727	175	1	100	0	1	175	96879	96705	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1038	318	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
16178324	16178324	PRJNA900028_P_NODE_47413_length_211_cov_0.962963_g46664_i0	PRJNA900028	47413	211	0.962963	2.03185193	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	278	2.81e-70	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g46664	i0	90.865	1.98578199052133	208	18	100	1	4	211	80261	80467	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	419	278	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
17453513	17453513	PRJNA900028_P_NODE_22294_length_262_cov_1.830986_g21545_i0	PRJNA900028	22294	262	1.830986	4.79718332	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	462	9.319999999999999e-126	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g21545	i0	98.479	29.0763358778626	263	3	100	1	1	262	301464	301726	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	7618	462	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
17453554	17453554	PRJNA900028_P_NODE_2514_length_695_cov_3.886997_g1838_i0	PRJNA900028	2514	695	3.886997	27.01462915	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	1134	0	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g1838	i0	96.121	76.8719424460432	696	26	100	1	1	695	116837	116142	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	53426	1134	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18726037	18726037	PRJNA900028_P_NODE_133715_length_166_cov_0.871795_g132966_i0	PRJNA900028	133715	166	0.871795	1.4471797	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	235	1.2899999999999998e-57	NTclustered	gi\|1624698154\|ref\|XM_029013945.1\|	189622	g132966	i0	92.683	20.5240963855422	164	10	99	1	3	166	232	71	Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA	blastn	3407	235	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
20000854	20000854	PRJNA900028_P_NODE_1016_length_1280_cov_6.900081_g346_i3	PRJNA900028	1016	1280	6.900081	88.3210368	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	2182	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g346	i3	97.424	999.646875	1281	32	100	1	1	1280	345	1625	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	1279548	2182	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
20001289	20001289	PRJNA900028_P_NODE_14376_length_305_cov_1.140625_g13628_i0	PRJNA900028	14376	305	1.140625	3.47890625	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	388	1.91e-103	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g13628	i0	89.49	3.02295081967213	314	23	100	10	1	305	80843	81155	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	922	388	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20001617	20001617	PRJNA900028_P_NODE_176956_length_162_cov_1.274336_g176207_i0	PRJNA900028	176956	162	1.274336	2.06442432	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	228	2.0899999999999995e-55	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g176207	i0	91.975	35.7716049382716	162	13	100	0	1	162	116256	116095	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5795	228	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20002699	20002699	PRJNA900028_P_NODE_8776_length_370_cov_1.704050_g8030_i0	PRJNA900028	8776	370	1.70405	6.304985	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.035	NTclustered	gi\|915001980\|ref\|XM_013393193.1\|	5801	g8030	i0	100	0.0756756756756757	28	0	8	0	8	35	106	133	Eimeria acervulina hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
23826486	23826486	PRJNA900028_P_NODE_106499_length_173_cov_1.048387_g105750_i0	PRJNA900028	106499	173	1.048387	1.81370951	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	259	7.98e-65	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g105750	i0	94.611	23.485549132948	167	9	99	0	7	173	299780	299946	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4063	259	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
23828150	23828150	PRJNA900028_P_NODE_76099_length_187_cov_0.971014_g75350_i0	PRJNA900028	76099	187	0.971014	1.81579618	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	278	2.43e-70	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g75350	i0	94.505	25.3048128342246	182	6	100	4	1	182	192	15	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	4732	278	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
24196983	24196983	PRJNA900028_P_NODE_58579_length_198_cov_1.986577_g57830_i0	PRJNA900028	58579	198	1.986577	3.93342246	Conoidasida	1280412	SAR_Eukaryotes	SAR_Eukaryotes	97.1	7.82e-16	NTclustered	gi\|157366229\|gb\|EF666482.1\|	158379	g57830	i0	98.182	27.2777777777778	55	1	28	0	1	55	4008	4062	Ascogregarina taiwanensis 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 26S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	5401	97.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Lecudinidae	Ascogregarina	Ascogregarina taiwanensis
25100917	25100917	PRJNA900028_P_NODE_166200_length_163_cov_0.894737_g165451_i0	PRJNA900028	166200	163	0.894737	1.45842131	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	122	1.0199999999999999e-23	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g165451	i0	80.503	1.95092024539877	159	31	98	0	5	163	117432	117274	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	318	122	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);;