metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA758088" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA758088" 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
8857270	8857270	PRJNA758088_P_NODE_94767_length_432_cov_1.186630_g87797_i0	PRJNA758088	94767	432	1.18663	5.1262416	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	132	2.92e-33	NR	KAF8822145.1	476202	g87797	i0	58.1	9.10416666666667	105	44	72.9	0	3	317	251	355	KAF8822145.1 aldehyde dehydrogenase [Cardiosporidium cionae]	diamond	3933	132	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
19865410	19865410	PRJNA758088_P_NODE_52376_length_611_cov_4.912639_g45620_i0	PRJNA758088	52376	611	4.912639	30.01622429	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	200	3.17e-61	NR	OEH76901.1	88456	g45620	i0	61.4	5.90671031096563	176	68	86.4	0	546	19	32	207	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	3609	200	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
22413393	22413393	PRJNA758088_P_NODE_233978_length_278_cov_1.780488_g227007_i0	PRJNA758088	233978	278	1.780488	4.94975664	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	127	3.4599999999999995e-35	NR	XP_028869867.1	462227	g227007	i0	64.8	11.7841726618705	91	32	98.2	0	275	3	16	106	XP_028869867.1 Eukaryotic translation initiation factor 5A [Babesia sp. Xinjiang]	diamond	3276	127	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia sp. Xinjiang
27274266	27274266	PRJNA758088_P_NODE_212703_length_292_cov_1.178082_g205732_i0	PRJNA758088	212703	292	1.178082	3.43999944	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	79.3	8.78e-17	NR	XP_013229778.1	5802	g205732	i0	64.6	2.64041095890411	65	23	66.8	0	85	279	35	99	XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella]	diamond	771	79.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
27315808	27315808	PRJNA758088_P_NODE_181363_length_315_cov_1.272727_g174392_i0	PRJNA758088	181363	315	1.272727	4.00909005	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	96.7	7.44e-22	NR	XP_003882293.1	572307	g174392	i0	56.4	3.52380952380952	78	34	74.3	0	315	82	123	200	XP_003882293.1 hypothetical protein NCLIV_020480 [Neospora caninum Liverpool]	diamond	1110	97.1	0.995880535530381	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
29042643	29042643	PRJNA758088_P_NODE_104688_length_410_cov_1.130564_g97718_i0	PRJNA758088	104688	410	1.130564	4.6353124	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	139	2.31e-37	NR	CAL7858373.1	1344799	g97718	i0	55.6	14.9853658536585	126	53	90	1	381	13	134	259	CAL7858373.1 unnamed protein product [Sarcocystis calchasi]	diamond	6144	139	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
29074264	29074264	PRJNA758088_P_NODE_180308_length_316_cov_1.267490_g173337_i0	PRJNA758088	180308	316	1.26749	4.0052684	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	104	1.07e-24	NR	KAF8821041.1	476202	g173337	i0	48.6	0.996835443037975	105	52	99.7	1	315	1	123	225	KAF8821041.1 putative Mitochondrial uncoupling protein 3 [Cardiosporidium cionae]	diamond	315	104	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae

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