metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA478247" 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
2998498	2998498	PRJNA478247_P_NODE_3203_length_167_cov_1.717391_g3097_i0	PRJNA478247	3203	167	1.717391	2.86804297	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	93.6	8.59e-21	NR	XP_067924082.1	483139	g3097	i0	76.5	17.4071856287425	51	12	91.6	0	166	14	185	235	XP_067924082.1 histone arginine methyltransferase prmt1 [Cystoisospora suis]	diamond	2907	93.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
19573566	19573566	PRJNA478247_P_NODE_996_length_407_cov_2.957672_g890_i0	PRJNA478247	996	407	2.957672	12.03772504	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	137	1.54e-38	NR	XP_067920284.1	483139	g890	i0	63.2	9.72972972972973	114	26	84	1	1	342	39	136	XP_067920284.1 histone h2a [Cystoisospora suis]	diamond	3960	138	0.992753623188406	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
27092373	27092373	PRJNA478247_P_NODE_2102_length_237_cov_3.230769_g1996_i0	PRJNA478247	2102	237	3.230769	7.65692253	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.62e-8	NR	XP_012767211.1	5866	g1996	i0	45	6.82278481012658	60	33	75.9	0	53	232	17	76	XP_012767211.1 60S ribosomal L22e protein, putative [Babesia bigemina]	diamond	1617	57.8	0.993079584775087	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
30044567	30044567	PRJNA478247_P_NODE_31_length_2338_cov_31.958424_g19_i0	PRJNA478247	31	2338	31.958424	747.18795312	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	105	5.09e-19	NR	XP_011133828.1	110365	g19	i0	31.3	2.63815226689478	211	136	26.8	6	917	1543	155	358	XP_011133828.1 putative retrotransposon protein, partial [Gregarina niphandrodes]	diamond	6168	105	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
32463725	32463725	PRJNA478247_P_NODE_3639_length_150_cov_1.140496_g3533_i0	PRJNA478247	3639	150	1.140496	1.710744	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	88.2	1.61e-19	NR	XP_013230532.1	5802	g3533	i0	84	60	50	8	100	0	1	150	131	180	XP_013230532.1 40S ribosomal protein S2, putative [Eimeria tenella]	diamond	9000	88.6	0.99548532731377	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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