metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA169559" 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
364811	364811	PRJNA169559_P_NODE_12801_length_469_cov_3.479545_g10919_i0	PRJNA169559	12801	469	3.479545	16.31906605	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	182	1.4e-55	NR	AET50562.1	5802	g10919	i0	54.3	14.2452025586354	162	64	97.2	1	467	12	5	166	AET50562.1 hypothetical protein [Eimeria tenella]	diamond	6681	183	0.994535519125683	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
364979	364979	PRJNA169559_P_NODE_2781_length_992_cov_3.049844_g1810_i0	PRJNA169559	2781	992	3.0498440000000002	30.25445248	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	376	1.7799999999999994e-126	NR	XP_013338036.1	5804	g1810	i0	70.4	6.13306451612903	253	75	76.5	0	121	879	86	338	XP_013338036.1 developmentally regulated GTP-binding protein 1, putative [Eimeria maxima]	diamond	6084	376	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
9293304	9293304	PRJNA169559_P_NODE_8268_length_590_cov_34.333333_g6639_i0	PRJNA169559	8268	590	34.333333	202.5666647	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	202	2.13e-62	NR	OEH76901.1	88456	g6639	i0	61.5	1.78474576271186	179	69	91	0	585	49	29	207	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	1053	202	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
12533426	12533426	PRJNA169559_P_NODE_24050_length_314_cov_1.733333_g21974_i0	PRJNA169559	24050	314	1.733333	5.44266562	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	107	1.58e-24	NR	AAZ06362.1	5811	g21974	i0	56.6	3.78343949044586	99	43	94.6	0	298	2	490	588	AAZ06362.1 ATP-binding cassette sub-family E member 1 [Toxoplasma gondii]	diamond	1188	108	0.990740740740741	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
28512871	28512871	PRJNA169559_P_NODE_49027_length_150_cov_1.909091_g46950_i0	PRJNA169559	49027	150	1.909091	2.8636365	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	92	2.41e-22	NR	OEH74291.1	88456	g46950	i0	84	8	50	8	100	0	1	150	76	125	OEH74291.1 vacuolar atp synthase subunit [Cyclospora cayetanensis]	diamond	1200	92.8	0.991379310344828	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
29095113	29095113	PRJNA169559_P_NODE_1408_length_1380_cov_2.772761_g803_i0	PRJNA169559	1408	1380	2.772761	38.2641018	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	56.2	3.66e-4	NR	CAL7859820.1	1344799	g803	i0	41.4	0.126086956521739	58	29	11.5	1	1372	1214	1049	1106	CAL7859820.1 unnamed protein product [Sarcocystis calchasi]	diamond	174	56.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
29491618	29491618	PRJNA169559_P_NODE_44750_length_218_cov_2.105820_g42673_i0	PRJNA169559	44750	218	2.10582	4.5906876	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0145	NR	XP_028525879.1	5849	g42673	i0	35.2	3.61926605504587	54	35	74.3	0	56	217	552	605	XP_028525879.1 conserved Plasmodium protein, unknown function [Plasmodium gallinaceum]	diamond	789	43.9	0.990888382687927	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
29537004	29537004	PRJNA169559_P_NODE_12710_length_471_cov_1.950226_g10833_i0	PRJNA169559	12710	471	1.950226	9.18556446	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	104	5.509999999999999e-24	NR	XP_011130643.1	110365	g10833	i0	67.1	0.89171974522293	70	23	44.6	0	456	247	16	85	XP_011130643.1 putative peptidyl-prolyl cis-trans isomerase [Gregarina niphandrodes]	diamond	420	104	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
29789490	29789490	PRJNA169559_P_NODE_45731_length_205_cov_2.386364_g43654_i0	PRJNA169559	45731	205	2.386364	4.8920462	Cryptosporidium meleagridis	93969	SAR_Eukaryotes	SAR_Eukaryotes	53.1	3.08e-7	NR	KAK9171662.1	93969	g43654	i0	59	1.14146341463415	39	16	57.1	0	9	125	5	43	KAK9171662.1 Small nuclear ribonucleoprotein G [Cryptosporidium meleagridis]	diamond	234	53.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium meleagridis
30800501	30800501	PRJNA169559_P_NODE_26414_length_288_cov_1.247104_g24338_i0	PRJNA169559	26414	288	1.247104	3.59165952	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	50.4	9.79e-5	NR	KAF8821440.1	476202	g24338	i0	64.9	0.385416666666667	37	13	38.5	0	286	176	156	192	KAF8821440.1 Rna-directed Rna polymerase, partial [Cardiosporidium cionae]	diamond	111	50.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
31798270	31798270	PRJNA169559_P_NODE_30457_length_263_cov_1.418803_g28381_i0	PRJNA169559	30457	263	1.418803	3.73145189	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	64.3	1.21e-9	NR	XP_067926952.1	483139	g28381	i0	45	3.1254752851711	60	33	68.4	0	82	261	680	739	XP_067926952.1 zinc zz type domain-containing protein [Cystoisospora suis]	diamond	822	64.7	0.993817619783617	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
32033830	32033830	PRJNA169559_P_NODE_5298_length_737_cov_5.494350_g3940_i0	PRJNA169559	5298	737	5.49435	40.4933595	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	55.8	1.01e-5	NR	XP_002141421.1	441375	g3940	i0	26.4	0.508819538670285	125	82	50.9	3	402	28	40	154	XP_002141421.1 suppressor of kinetochore protein 1, putative [Cryptosporidium muris RN66]	diamond	375	55.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
32192095	32192095	PRJNA169559_P_NODE_32558_length_255_cov_0.986726_g30482_i0	PRJNA169559	32558	255	0.986726	2.5161513	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	50.4	8.02e-5	NR	KAF8819189.1	476202	g30482	i0	64.9	0.435294117647059	37	13	43.5	0	112	2	45	81	KAF8819189.1 putative nucleolar gtp-binding protein 2 [Cardiosporidium cionae]	diamond	111	50.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
32791866	32791866	PRJNA169559_P_NODE_25760_length_294_cov_2.218868_g23684_i0	PRJNA169559	25760	294	2.218868	6.52347192	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	53.9	4.78e-6	NR	XP_029218987.1	94643	g23684	i0	44	1.94897959183673	84	44	85.7	1	291	40	94	174	XP_029218987.1 CCDC25 protein [Besnoitia besnoiti]	diamond	573	53.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti

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