metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA699078" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA699078" 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
10885967	10885967	PRJNA699078_S_NODE_19129_length_380_cov_1.540785_g18182_i0	PRJNA699078	19129	380	1.540785	5.854983	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	126	5.46e-35	NR	XP_013437149.1	51315	g18182	i0	60.4	5.02894736842105	91	36	71.8	0	379	107	15	105	XP_013437149.1 Serine/threonine-protein phosphatase PP-X isozyme 2, related [Eimeria necatrix]	diamond	1911	127	0.992125984251969	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
28136349	28136349	PRJNA699078_S_NODE_32865_length_301_cov_2.888889_g31916_i0	PRJNA699078	32865	301	2.888889	8.69555589	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	131	1.83e-36	NR	AET50562.1	5802	g31916	i0	66.3	6.47840531561462	92	31	91.7	0	26	301	61	152	AET50562.1 hypothetical protein [Eimeria tenella]	diamond	1950	132	0.992424242424242	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
28187901	28187901	PRJNA699078_S_NODE_103546_length_165_cov_0.896552_g102597_i0	PRJNA699078	103546	165	0.896552	1.4793108	Neospora caninum Liverpool	572307	SAR_Eukaryotes	SAR_Eukaryotes	50.8	1.79e-5	NR	XP_003880389.1	572307	g102597	i0	44.4	2.54545454545455	45	25	81.8	0	136	2	259	303	XP_003880389.1 hypothetical protein NCLIV_008245 [Neospora caninum Liverpool]	diamond	420	50.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
28503879	28503879	PRJNA699078_S_NODE_51007_length_239_cov_2.463158_g50058_i0	PRJNA699078	51007	239	2.463158	5.88694762	Cryptosporidium sp. chipmunk genotype I	1280935	SAR_Eukaryotes	SAR_Eukaryotes	61.2	1.08e-8	NR	XP_067201985.1	1280935	g50058	i0	43.3	9.64016736401674	67	36	81.6	1	232	38	807	873	XP_067201985.1 Fun12p GTpase translation initiation factor IF2 [Cryptosporidium sp. chipmunk genotype I]	diamond	2304	61.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. chipmunk genotype I
28661870	28661870	PRJNA699078_S_NODE_99647_length_167_cov_2.237288_g98698_i0	PRJNA699078	99647	167	2.237288	3.73627096	Plasmodium falciparum Dd2	57267	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0184	NR	KOB87734.1	57267	g98698	i0	53.3	0.538922155688623	30	14	53.9	0	152	63	202	231	KOB87734.1 hypothetical protein PFDG_03633 [Plasmodium falciparum Dd2]	diamond	90	42.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
30252101	30252101	PRJNA699078_S_NODE_79472_length_188_cov_2.244604_g78523_i0	PRJNA699078	79472	188	2.244604	4.21985552	root	1	Root_unresolved	Root_unresolved	50.4	3.41e-5	NR	XP_003881519.1	572307	g78523	i0	47.4	2.74468085106383	57	30	91	0	187	17	158	214	XP_003881519.1 F14N23.23, related [Neospora caninum Liverpool]	diamond	516	50.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
30789036	30789036	PRJNA699078_S_NODE_104534_length_164_cov_1.356522_g103585_i0	PRJNA699078	104534	164	1.356522	2.22469608	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	48.1	1.6e-4	NR	KAF8823037.1	476202	g103585	i0	47.7	3.14634146341463	44	16	69.5	2	51	164	333	375	KAF8823037.1 PAN domain-containing protein, partial [Cardiosporidium cionae]	diamond	516	48.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
32200869	32200869	PRJNA699078_S_NODE_90918_length_175_cov_1.650794_g89969_i0	PRJNA699078	90918	175	1.650794	2.8888895	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	57.8	1.11e-8	NR	XP_067919974.1	483139	g89969	i0	44.6	1.88571428571429	56	31	96	0	4	171	73	128	XP_067919974.1 macrophage migration inhibitory factor [Cystoisospora suis]	diamond	330	57.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
32390685	32390685	PRJNA699078_S_NODE_33659_length_298_cov_1.670683_g32710_i0	PRJNA699078	33659	298	1.670683	4.97863534	Eimeria brunetti	51314	SAR_Eukaryotes	SAR_Eukaryotes	60.5	3.65e-8	NR	CDJ51585.1	51314	g32710	i0	48.3	1.77181208053691	60	31	60.4	0	298	119	275	334	CDJ51585.1 RNA helicase, putative [Eimeria brunetti]	diamond	528	60.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria brunetti
32674713	32674713	PRJNA699078_S_NODE_33680_length_298_cov_1.449799_g32731_i0	PRJNA699078	33680	298	1.449799	4.32040102	Porospora cf. gigantea B	2853592	SAR_Eukaryotes	SAR_Eukaryotes	52.8	2.14e-5	NR	XP_068373318.1	2853592	g32731	i0	49.1	1.10738255033557	55	26	55.4	1	295	131	23	75	XP_068373318.1 MAG: uncharacterized protein KVP17_004685 [Porospora cf. gigantea B]	diamond	330	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Porosporidae	Porospora	Porospora cf. gigantea B

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