metadata: contig_metadata: 7 rows where bioproject = "PRJNA1095825" and tax

7 rows where bioproject = "PRJNA1095825" 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
2750515	2750515	PRJNA1095825_P_NODE_142963_length_325_cov_0.861111_g139900_i0	PRJNA1095825	142963	325	0.861111	2.79861075	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	126	8.639999999999998e-32	NR	XP_011134380.1	110365	g139900	i0	58.3	1.94769230769231	103	42	94.2	1	325	20	51	153	XP_011134380.1 DEAD-box ATP-dependent RNA helicase [Gregarina niphandrodes]	diamond	633	126	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
18051844	18051844	PRJNA1095825_P_NODE_187555_length_285_cov_2.066038_g184492_i0	PRJNA1095825	187555	285	2.066038	5.8882083	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.026	NTclustered	gi\|1620111922\|ref\|XM_028670266.1\|	5849	g184492	i0	100	0.0982456140350877	28	0	10	0	179	206	392	419	Plasmodium gallinaceum glutamate dehydrogenase, putative (GDH3), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
21878246	21878246	PRJNA1095825_P_NODE_50618_length_537_cov_1.327586_g47561_i0	PRJNA1095825	50618	537	1.327586	7.12913682	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	115	6.6300000000000006e-21	NTclustered	gi\|160358922\|gb\|EU252544.1\|	88456	g47561	i0	79.191	16.9478584729981	173	31	32	4	60	232	1507	1674	Cyclospora cayetanensis 28S large subunit ribosomal RNA gene, partial sequence	blastn	9101	115	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
28480185	28480185	PRJNA1095825_P_NODE_202786_length_274_cov_2.154229_g199723_i0	PRJNA1095825	202786	274	2.154229	5.90258746	Theileria	5873	SAR_Eukaryotes	SAR_Eukaryotes	119	2.31e-29	NR	PVC53715.1	68886	g199723	i0	58.9	1.93795620437956	90	37	98.5	0	3	272	340	429	PVC53715.1 S-adenosylmethionine synthetase [Theileria orientalis]	diamond	531	119	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
29332675	29332675	PRJNA1095825_P_NODE_269509_length_245_cov_1.656977_g266446_i0	PRJNA1095825	269509	245	1.656977	4.05959365	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	62.4	3.26e-9	NR	EWC86765.1	5843	g266446	i0	44.6	5.43673469387755	74	38	89.4	2	243	25	217	288	EWC86765.1 hypothetical protein PFNF54_04318 [Plasmodium falciparum NF54]	diamond	1332	62.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
29964252	29964252	PRJNA1095825_P_NODE_219551_length_262_cov_2.428571_g216488_i0	PRJNA1095825	219551	262	2.428571	6.36285602	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	103	3.3200000000000004e-26	NR	GFE54039.1	5869	g216488	i0	61.9	4.54580152671756	84	31	96.2	1	253	2	1	83	GFE54039.1 60S ribosomal protein L31 [Babesia ovis]	diamond	1191	103	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
30636151	30636151	PRJNA1095825_P_NODE_46173_length_564_cov_3.433809_g43120_i0	PRJNA1095825	46173	564	3.433809	19.36668276	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	205	1.32e-63	NR	OEH76901.1	88456	g43120	i0	62.1	4.61702127659574	177	67	94.1	0	562	32	29	205	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	2604	205	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis

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