metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1068513" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1068513" 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
12935624	12935624	PRJNA1068513_S_NODE_3851_length_455_cov_2.824607_g3806_i0	PRJNA1068513	3851	455	2.824607	12.85196185	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	172	2.9499999999999995e-48	NR	XP_067922542.1	483139	g3806	i0	67.5	2.28791208791209	123	40	81.1	0	2	370	385	507	XP_067922542.1 vacuolar atp synthase subunit [Cystoisospora suis]	diamond	1041	172	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
14210547	14210547	PRJNA1068513_S_NODE_3072_length_494_cov_4.156770_g3027_i0	PRJNA1068513	3072	494	4.15677	20.5344438	Theileria orientalis	68886	SAR_Eukaryotes	SAR_Eukaryotes	197	4.78e-58	NR	PVC53715.1	68886	g3027	i0	66.9	4.09311740890688	136	45	82.6	0	1	408	294	429	PVC53715.1 S-adenosylmethionine synthetase [Theileria orientalis]	diamond	2022	197	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
26741989	26741989	PRJNA1068513_S_NODE_9521_length_291_cov_2.733945_g9475_i0	PRJNA1068513	9521	291	2.733945	7.95577995	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	105	3.55e-26	NR	XP_016655351.1	31271	g9475	i0	62.3	9.16494845360825	77	29	79.4	0	289	59	75	151	XP_016655351.1 AP-1 complex subunit sigma, putative [Plasmodium chabaudi chabaudi]	diamond	2667	106	0.990566037735849	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
26900813	26900813	PRJNA1068513_S_NODE_11141_length_265_cov_2.416667_g11095_i0	PRJNA1068513	11141	265	2.416667	6.40416755	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	57.8	9.57e-8	NR	KAK1937600.1	32595	g11095	i0	38.5	1.76603773584906	78	47	88.3	1	4	237	96	172	KAK1937600.1 ubiquitin family protein [Babesia divergens]	diamond	468	58.2	0.993127147766323	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia divergens
29048538	29048538	PRJNA1068513_S_NODE_5288_length_395_cov_1.543478_g5243_i0	PRJNA1068513	5288	395	1.543478	6.0967381	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.9	2.68e-11	NR	XP_028546196.1	77519	g5243	i0	55.7	4.57974683544304	61	27	46.3	0	386	204	375	435	XP_028546196.1 CAMP-dependent protein kinase regulatory subunit [Plasmodium gonderi]	diamond	1809	71.6	0.990223463687151	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gonderi
29080050	29080050	PRJNA1068513_S_NODE_6828_length_349_cov_2.449275_g6782_i0	PRJNA1068513	6828	349	2.449275	8.54796975	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	82.8	4e-16	NR	XP_067924033.1	483139	g6782	i0	58.3	2.63037249283668	60	25	51.6	0	347	168	244	303	XP_067924033.1 proteasome subunit beta type [Cystoisospora suis]	diamond	918	83.2	0.995192307692308	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
30501234	30501234	PRJNA1068513_S_NODE_10133_length_281_cov_1.014423_g10087_i0	PRJNA1068513	10133	281	1.014423	2.85052863	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	65.1	8.31e-10	NR	XP_028862187.1	5858	g10087	i0	35.6	27.202846975089	90	52	89.7	1	17	268	1087	1176	XP_028862187.1 pre-mRNA-splicing factor ATP-dependent RNA helicase PRP22, putative [Plasmodium malariae]	diamond	7644	65.5	0.993893129770992	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
30912129	30912129	PRJNA1068513_S_NODE_14014_length_209_cov_17.095588_g13968_i0	PRJNA1068513	14014	209	17.095588	35.72977892	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	61.6	1.09e-9	NR	XP_029219880.1	94643	g13968	i0	73.2	7.00478468899522	41	11	58.9	0	208	86	120	160	XP_029219880.1 vacuolar ATP synthetase [Besnoitia besnoiti]	diamond	1464	62	0.993548387096774	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
31078510	31078510	PRJNA1068513_S_NODE_1275_length_644_cov_31.248687_g1235_i0	PRJNA1068513	1275	644	31.248687	201.24154428	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	207	6.26e-64	NR	OEH76901.1	88456	g1235	i0	60.7	3.34472049689441	183	72	85.2	0	641	93	29	211	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	2154	207	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
31837142	31837142	PRJNA1068513_S_NODE_6517_length_358_cov_1.705263_g6471_i0	PRJNA1068513	6517	358	1.705263	6.10484154	Toxoplasma gondii ME49	508771	SAR_Eukaryotes	SAR_Eukaryotes	88.6	5.93e-18	NR	XP_018635900.1	508771	g6471	i0	41.7	7.07262569832402	103	59	86.3	1	358	50	265	366	XP_018635900.1 proteasome subunit [Toxoplasma gondii ME49]	diamond	2532	88.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii

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