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

7 rows where analysis = "diamond", bioproject = "PRJNA340009" 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
26662923	26662923	PRJNA340009_P_NODE_9821_length_365_cov_2.044304_g9514_i0	PRJNA340009	9821	365	2.044304	7.4617096	Porospora cf. gigantea B	2853592	SAR_Eukaryotes	SAR_Eukaryotes	56.6	2.06e-6	NR	XP_068376260.1	2853592	g9514	i0	38.4	1.2	73	44	59.2	1	148	363	717	789	XP_068376260.1 MAG: uncharacterized protein KVP17_002002 [Porospora cf. gigantea B]	diamond	438	56.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Porosporidae	Porospora	Porospora cf. gigantea B
26807152	26807152	PRJNA340009_P_NODE_20661_length_266_cov_3.129032_g20354_i0	PRJNA340009	20661	266	3.129032	8.32322512	root	1	Root_unresolved	Root_unresolved	46.2	0.00285	NR	GFE55414.1	5869	g20354	i0	65.6	4.38721804511278	32	11	36.1	0	265	170	276	307	GFE55414.1 ethanolamine-phosphate cytidylyltransferase [Babesia ovis]	diamond	1167	46.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
26996869	26996869	PRJNA340009_P_NODE_44842_length_191_cov_7.126761_g44535_i0	PRJNA340009	44842	191	7.126761	13.61211351	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	47.8	3.08e-4	NR	XP_028860367.1	5858	g44535	i0	45.8	2.26178010471204	48	26	75.4	0	145	2	199	246	XP_028860367.1 dicarboxylate/tricarboxylate carrier, putative [Plasmodium malariae]	diamond	432	47.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
27376710	27376710	PRJNA340009_P_NODE_50143_length_183_cov_2.097015_g49836_i0	PRJNA340009	50143	183	2.097015	3.83753745	Piroplasmida	5863	SAR_Eukaryotes	SAR_Eukaryotes	84.3	1.51e-18	NR	XP_067803689.1	323732	g49836	i0	64.4	3.83606557377049	59	21	96.7	0	182	6	15	73	XP_067803689.1 bifunctional RNA recognition motif domain/RNA-binding domain superfamily/Nucleotide-binding alpha-beta plait domain superfamily [Babesia duncani]	diamond	702	85.1	0.990599294947121	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
29600644	29600644	PRJNA340009_P_NODE_20590_length_266_cov_9.285714_g20283_i0	PRJNA340009	20590	266	9.285714	24.69999924	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.00756	NR	XP_004832617.1	1537102	g20283	i0	95	0.225563909774436	20	1	22.6	0	205	264	106	125	XP_004832617.1 hypothetical protein BEWA_052190 [Theileria equi strain WA]	diamond	60	43.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
31813134	31813134	PRJNA340009_P_NODE_67357_length_165_cov_0.879310_g67050_i0	PRJNA340009	67357	165	0.87931	1.4508615	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.00164	NR	XP_013234134.1	5802	g67050	i0	68	0.963636363636364	25	8	45.5	0	49	123	6	30	XP_013234134.1 cytochrome c, putative [Eimeria tenella]	diamond	159	43.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
32572677	32572677	PRJNA340009_P_NODE_32519_length_219_cov_25.876471_g32212_i0	PRJNA340009	32519	219	25.876471	56.66947149	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.028	NR	OEH79025.1	88456	g32212	i0	44.7	0.643835616438356	47	26	64.4	0	43	183	491	537	OEH79025.1 endomembrane protein 70 subfamily protein [Cyclospora cayetanensis]	diamond	141	42.7	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);;