metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
10655889	10655889	PRJNA492406_P_NODE_10129_length_387_cov_1.471338_g9830_i0	PRJNA492406	10129	387	1.471338	5.69407806	Theileria orientalis	68886	SAR_Eukaryotes	SAR_Eukaryotes	177	8.8e-51	NR	PVC53715.1	68886	g9830	i0	65.1	3.87596899224806	126	44	97.7	0	9	386	304	429	PVC53715.1 S-adenosylmethionine synthetase [Theileria orientalis]	diamond	1500	177	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
19578407	19578407	PRJNA492406_P_NODE_26156_length_252_cov_2.575419_g25857_i0	PRJNA492406	26156	252	2.575419	6.49005588	Neospora caninum Liverpool	572307	SAR_Eukaryotes	SAR_Eukaryotes	131	4.549999999999999e-34	NR	XP_003886277.1	572307	g25857	i0	78.8	4.78571428571429	80	17	95.2	0	251	12	324	403	XP_003886277.1 putative seryl-tRNA synthetase [Neospora caninum Liverpool]	diamond	1206	131	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20854162	20854162	PRJNA492406_P_NODE_23637_length_265_cov_1.979167_g23338_i0	PRJNA492406	23637	265	1.979167	5.24479255	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	124	7.33e-33	NR	OEH74043.1	88456	g23338	i0	71.6	2.98867924528302	88	25	99.6	0	264	1	114	201	OEH74043.1 ribosomal protein rpp0 [Cyclospora cayetanensis]	diamond	792	124	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
27107816	27107816	PRJNA492406_P_NODE_10082_length_388_cov_0.974603_g9783_i0	PRJNA492406	10082	388	0.974603	3.78145964	Theileria orientalis	68886	SAR_Eukaryotes	SAR_Eukaryotes	60.1	6.45e-8	NR	UKK02333.1	68886	g9783	i0	55.1	0.378865979381443	49	18	34.8	1	386	252	166	214	UKK02333.1 60S ribosomal protein L10 [Theileria orientalis]	diamond	147	60.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
28102956	28102956	PRJNA492406_P_NODE_25505_length_256_cov_1.316940_g25206_i0	PRJNA492406	25505	256	1.31694	3.3713664	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	60.8	9.05e-9	NR	XP_013233811.1	5802	g25206	i0	49.2	2.40234375	61	30	70.3	1	66	245	8	68	XP_013233811.1 S-phase kinase-associated protein, putative [Eimeria tenella]	diamond	615	60.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
30314108	30314108	PRJNA492406_P_NODE_22472_length_271_cov_1.555556_g22173_i0	PRJNA492406	22472	271	1.555556	4.21555676	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	121	1.47e-33	NR	XP_013436144.1	51315	g22173	i0	74.7	12.719557195572	75	19	83	0	264	40	18	92	XP_013436144.1 60S ribosomal protein L37, putative [Eimeria necatrix]	diamond	3447	122	0.991803278688525	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
31024321	31024321	PRJNA492406_P_NODE_11515_length_366_cov_1.474403_g11216_i0	PRJNA492406	11515	366	1.474403	5.39631498	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	63.2	2.65e-9	NR	XP_004833657.1	1537102	g11216	i0	38.8	0.655737704918033	80	48	64.8	1	287	51	16	95	XP_004833657.1 nucleolar phosphoprotein, putative [Theileria equi strain WA]	diamond	240	63.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
32416108	32416108	PRJNA492406_P_NODE_27539_length_249_cov_1.312500_g27240_i0	PRJNA492406	27539	249	1.3125	3.268125	Cryptosporidium ryanae	515981	SAR_Eukaryotes	SAR_Eukaryotes	77	2.19e-14	NR	XP_067198293.1	515981	g27240	i0	39.7	0.939759036144578	78	47	94	0	248	15	205	282	XP_067198293.1 arginine n-methyltransferase [Cryptosporidium ryanae]	diamond	234	77	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ryanae

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