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

8 rows where analysis = "diamond", bioproject = "PRJEB10320" 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
7665767	7665767	PRJEB10320_P_NODE_20107_length_192_cov_1.496815_g19849_i0	PRJEB10320	20107	192	1.496815	2.8738848	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	90.1	2.66e-19	NR	SBS81362.1	5858	g19849	i0	73.8	8.640625	61	15	95.3	1	5	187	134	193	SBS81362.1 heat shock protein 90, putative (HSP90), partial [Plasmodium malariae]	diamond	1659	90.5	0.995580110497237	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
9910643	9910643	PRJEB10320_P_NODE_8868_length_335_cov_2.170000_g8610_i0	PRJEB10320	8868	335	2.17	7.2695	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	153	3.8e-45	NR	EUD71171.1	138298	g8610	i0	66.7	9.45671641791045	105	35	94	0	21	335	7	111	EUD71171.1 eukaryotic translation initiation factor 5A-2 [Plasmodium vinckei petteri]	diamond	3168	153	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
26994729	26994729	PRJEB10320_P_NODE_8182_length_353_cov_1.575472_g7924_i0	PRJEB10320	8182	353	1.575472	5.56141616	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.4	7.3e-6	NR	XP_953348.1	5874	g7924	i0	38.9	2.99150141643059	72	40	61.2	2	14	229	9	76	XP_953348.1 60S ribosomal protein P1, putative [Theileria annulata]	diamond	1056	52.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria annulata
30222233	30222233	PRJEB10320_P_NODE_17912_length_208_cov_1.485549_g17654_i0	PRJEB10320	17912	208	1.485549	3.08994192	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	67.4	2.32e-11	NR	OEH77243.1	88456	g17654	i0	53.6	3.98076923076923	69	31	99.5	1	207	1	99	166	OEH77243.1 DNA-directed RNA polymerase II rpb5 [Cyclospora cayetanensis]	diamond	828	67.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
30311497	30311497	PRJEB10320_P_NODE_17632_length_211_cov_0.943182_g17374_i0	PRJEB10320	17632	211	0.943182	1.99011402	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	116	2.9e-28	NR	AAZ06362.1	5811	g17374	i0	72.5	26.7867298578199	69	19	98.1	0	210	4	22	90	AAZ06362.1 ATP-binding cassette sub-family E member 1 [Toxoplasma gondii]	diamond	5652	116	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
30349250	30349250	PRJEB10320_P_NODE_21172_length_185_cov_1.140000_g20914_i0	PRJEB10320	21172	185	1.14	2.109	Cryptosporidium andersoni	117008	SAR_Eukaryotes	SAR_Eukaryotes	58.9	1.34e-8	NR	XP_067069864.1	117008	g20914	i0	54.4	2.77297297297297	57	26	92.4	0	185	15	26	82	XP_067069864.1 60s ribosomal protein L13A [Cryptosporidium andersoni]	diamond	513	58.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium andersoni
32150817	32150817	PRJEB10320_P_NODE_18818_length_201_cov_1.445783_g18560_i0	PRJEB10320	18818	201	1.445783	2.90602383	Theileria orientalis	68886	SAR_Eukaryotes	SAR_Eukaryotes	58.5	2.97e-8	NR	UKK02333.1	68886	g18560	i0	61.5	0.582089552238806	39	15	58.2	0	1	117	168	206	UKK02333.1 60S ribosomal protein L10 [Theileria orientalis]	diamond	117	58.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
32246006	32246006	PRJEB10320_P_NODE_26318_length_158_cov_1.609756_g26060_i0	PRJEB10320	26318	158	1.609756	2.54341448	Cryptosporidium parvum Iowa II	353152	SAR_Eukaryotes	SAR_Eukaryotes	72	3.63e-14	NR	XP_626159.1	353152	g26060	i0	66	8.44936708860759	50	17	94.9	0	158	9	100	149	XP_626159.1 40S ribosomal protein S13, partial [Cryptosporidium parvum Iowa II]	diamond	1335	72	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum

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