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

24 rows where analysis = "blastn", bioproject = "PRJNA781427" 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
2037294	2037294	PRJNA781427_P_NODE_65262_length_273_cov_7.340000_g64378_i0	PRJNA781427	65262	273	7.34	20.0382	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	279	1.06e-70	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g64378	i0	87.097	27.5897435897436	248	30	95	2	21	268	300057	299812	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	7532	279	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
7138521	7138521	PRJNA781427_P_NODE_12786_length_723_cov_2.995385_g11998_i0	PRJNA781427	12786	723	2.995385	21.65663355	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	484	6.019999999999998e-132	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g11998	i0	80.323	39.3969571230982	681	100	99	17	52	723	299851	299196	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	28484	484	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9688912	9688912	PRJNA781427_P_NODE_34768_length_390_cov_4.176656_g33887_i0	PRJNA781427	34768	390	4.176656	16.2889584	Rhytidocystis nekhoroshkovae	2719952	SAR_Eukaryotes	SAR_Eukaryotes	200	1.26e-46	NTclustered	gi\|1823682799\|gb\|MT231950.1\|	2719952	g33887	i0	85	45.7666666666667	200	27	51	3	1	198	5097	5295	Rhytidocystis nekhoroshkovae isolate 7Rit_RP3_MBS small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	17849	200	1	Eukaryota	Sar	Apicomplexa	Marosporida	Agamococcidiorida	Rhytidocystidae	Rhytidocystis	Rhytidocystis nekhoroshkovae
9689701	9689701	PRJNA781427_P_NODE_64848_length_274_cov_6.601990_g63964_i0	PRJNA781427	64848	274	6.60199	18.0894526	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	180	1.11e-40	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g63964	i0	79.457	19.0255474452555	258	49	97	4	10	265	97166	97421	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5213	180	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9689887	9689887	PRJNA781427_P_NODE_71768_length_256_cov_4.519126_g70884_i0	PRJNA781427	71768	256	4.519126	11.56896256	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	374	4.369999999999998e-99	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g70884	i0	95.339	42.88671875	236	10	97	1	17	251	97441	97206	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10979	374	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10964713	10964713	PRJNA781427_P_NODE_39489_length_363_cov_5.448276_g38607_i0	PRJNA781427	39489	363	5.448276	19.77724188	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	342	1.8199999999999998e-89	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g38607	i0	91.837	22.969696969697	245	20	99	0	11	255	299923	299679	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	8338	342	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10965550	10965550	PRJNA781427_P_NODE_71389_length_257_cov_3.570652_g70505_i0	PRJNA781427	71389	257	3.570652	9.17657564	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	364	2.6399999999999993e-96	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g70505	i0	93.145	46.0622568093385	248	17	96	0	6	253	300757	300510	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	11838	364	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
12239636	12239636	PRJNA781427_P_NODE_16910_length_605_cov_5.644068_g16063_i0	PRJNA781427	16910	605	5.644068	34.1466114	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	307	1.16e-78	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g16063	i0	86.972	33.502479338843	284	23	91	6	8	277	299640	299923	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	20269	307	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
12240794	12240794	PRJNA781427_P_NODE_61770_length_282_cov_1.956938_g60886_i0	PRJNA781427	61770	282	1.956938	5.51856516	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	248	3.09e-61	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g60886	i0	94.444	25.9893617021277	162	8	99	1	4	164	301806	301645	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	7329	248	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
12240917	12240917	PRJNA781427_P_NODE_65990_length_271_cov_12.838384_g65106_i0	PRJNA781427	65990	271	12.838384	34.79202064	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	228	3.8499999999999985e-55	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g65106	i0	82.879	20.9040590405904	257	41	99	3	7	263	302663	302410	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5665	228	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13515117	13515117	PRJNA781427_P_NODE_65991_length_271_cov_10.611111_g65107_i0	PRJNA781427	65991	271	10.611111	28.75611081	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	217	8.329999999999999e-52	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g65107	i0	82.101	2.45018450184502	257	43	95	3	8	264	302663	302410	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	664	217	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13965917	13965917	PRJNA781427_P_NODE_71031_length_258_cov_2.081081_g70147_i0	PRJNA781427	71031	258	2.081081	5.36918898	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	244	3.6099999999999996e-60	NTclustered	gi\|1673124534\|ref\|XM_029361026.1\|	94643	g70147	i0	84.127	85.4883720930233	252	40	98	0	1	252	843	592	Besnoitia besnoiti actin ACT1 (BESB_023240), partial mRNA	blastn	22056	244	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
15240621	15240621	PRJNA781427_P_NODE_9932_length_847_cov_1.361757_g9222_i0	PRJNA781427	9932	847	1.361757	11.53408179	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.024	NTclustered	gi\|915124466\|ref\|XM_013478043.1\|	5804	g9222	i0	96.875	0.0791027154663518	32	1	4	0	754	785	2179	2148	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	67	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
17338212	17338212	PRJNA781427_P_NODE_16914_length_605_cov_4.546992_g16067_i0	PRJNA781427	16914	605	4.546992	27.5093016	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	313	2.49e-80	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g16067	i0	87.324	35.3190082644628	284	22	91	7	8	277	299640	299923	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	21368	313	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
17340262	17340262	PRJNA781427_P_NODE_97314_length_238_cov_2.630303_g96430_i0	PRJNA781427	97314	238	2.630303	6.26012114	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|921128108\|ref\|XM_013583167.1\|	51315	g96430	i0	92.308	1.10504201680672	39	2	16	1	88	126	6670	6633	Eimeria necatrix hypothetical protein, conserved partial mRNA	blastn	263	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
18613072	18613072	PRJNA781427_P_NODE_72575_length_254_cov_9.745856_g71691_i0	PRJNA781427	72575	254	9.745856	24.75447424	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	448	2.5199999999999996e-121	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g71691	i0	98.805	42.2992125984252	251	3	99	0	1	251	301556	301806	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10744	448	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18613484	18613484	PRJNA781427_P_NODE_8975_length_900_cov_5.200726_g8297_i0	PRJNA781427	8975	900	5.200726	46.806534	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.025	NTclustered	gi\|124506116\|ref\|XM_001351620.1\|	36329	g8297	i0	100	0.0322222222222222	29	0	3	0	367	395	3114	3142	Plasmodium falciparum 3D7 phosphatidylinositol 4-kinase (PF3D7_0509800), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
19887848	19887848	PRJNA781427_P_NODE_54776_length_302_cov_12.786026_g53893_i0	PRJNA781427	54776	302	12.786026	38.61379852	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	196	1.23e-45	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g53893	i0	89.677	11.5430463576159	155	15	95	1	143	297	300503	300350	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3486	196	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19888464	19888464	PRJNA781427_P_NODE_79196_length_249_cov_0.875000_g78312_i0	PRJNA781427	79196	249	0.875	2.17875	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	289	1.58e-73	NTclustered	gi\|1673112969\|ref\|XM_029359708.1\|	94643	g78312	i0	87.6	86.0120481927711	250	29	100	2	1	249	1290	1042	Besnoitia besnoiti pre-mRNA processing splicing factor PRP8 (BESB_009540), partial mRNA	blastn	21417	289	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
21163353	21163353	PRJNA781427_P_NODE_47217_length_329_cov_8.507812_g46334_i0	PRJNA781427	47217	329	8.507812	27.99070148	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	167	1.06e-36	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g46334	i0	86.755	2.2370820668693	151	19	90	1	2	152	157281	157430	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	736	167	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
22439195	22439195	PRJNA781427_P_NODE_88798_length_244_cov_2.064327_g87914_i0	PRJNA781427	88798	244	2.064327	5.03695788	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	124	4.599999999999999e-24	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g87914	i0	78.723	12.422131147541	188	38	95	2	49	235	96913	97099	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3031	124	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
23714491	23714491	PRJNA781427_P_NODE_82299_length_248_cov_0.862857_g81415_i0	PRJNA781427	82299	248	0.862857	2.13988536	Plasmodium cynomolgi	5827	SAR_Eukaryotes	SAR_Eukaryotes	62.1	3.73e-5	NTclustered	gi\|457877613\|ref\|XM_004224990.1\|	1120755	g81415	i0	95	0.310483870967742	40	1	16	1	158	196	318	279	Plasmodium cynomolgi strain B hypothetical protein (PCYB_145190) mRNA, partial cds	blastn	77	62.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi
24987558	24987558	PRJNA781427_P_NODE_58020_length_292_cov_1.757991_g57136_i0	PRJNA781427	58020	292	1.757991	5.13333372	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	248	3.22e-61	NTclustered	gi\|126649276\|ref\|XM_001388273.1\|	353152	g57136	i0	82.624	11.2191780821918	282	48	96	1	2	282	147	428	Cryptosporidium parvum Iowa II ribosomal protein S23 (cgd6_1390) mRNA, partial cds	blastn	3276	248	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
24987761	24987761	PRJNA781427_P_NODE_65260_length_273_cov_13.210000_g64376_i0	PRJNA781427	65260	273	13.21	36.0633	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	451	2.11e-122	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g64376	i0	97.358	5.09157509157509	265	7	97	0	4	268	157609	157345	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1390	451	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);;