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

10 rows where analysis = "diamond", bioproject = "PRJNA1105232" 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
10416001	10416001	PRJNA1105232_S_NODE_14309_length_173_cov_2.088710_g14093_i0	PRJNA1105232	14309	173	2.08871	3.6134683	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	69.3	6.06e-12	NR	KAF8819103.1	476202	g14093	i0	53.4	6.8150289017341	58	26	98.8	1	173	3	500	557	KAF8819103.1 putative Methylenetetrahydrofolate reductase 1 [Cardiosporidium cionae]	diamond	1179	69.7	0.994261119081779	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
12966418	12966418	PRJNA1105232_S_NODE_1531_length_414_cov_6.084932_g1316_i0	PRJNA1105232	1531	414	6.084932	25.19161848	Sarcocystis aucheniae	65407	SAR_Eukaryotes	SAR_Eukaryotes	194	2.579999999999999e-55	NR	WXH59476.1	65407	g1316	i0	73.6	20.5652173913043	129	34	93.5	0	403	17	567	695	WXH59476.1 heat shock protein 90 [Sarcocystis aucheniae]	diamond	8514	194	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis aucheniae
27825928	27825928	PRJNA1105232_S_NODE_6304_length_242_cov_1.787565_g6088_i0	PRJNA1105232	6304	242	1.787565	4.3259073	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	80.1	2.57e-15	NR	CAL7866155.1	1344799	g6088	i0	56	5.13223140495868	84	32	99.2	3	2	241	771	853	CAL7866155.1 unnamed protein product [Sarcocystis calchasi]	diamond	1242	80.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
30027536	30027536	PRJNA1105232_S_NODE_311_length_850_cov_8.556804_g130_i0	PRJNA1105232	311	850	8.556804	72.732834	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	200	5.39e-59	NR	UKJ90114.1	68886	g130	i0	57.5	2.53058823529412	174	66	59.6	2	849	343	95	265	UKJ90114.1 60S ribosomal protein L5 [Theileria orientalis]	diamond	2151	202	0.99009900990099	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
30478536	30478536	PRJNA1105232_S_NODE_15073_length_169_cov_3.575000_g14857_i0	PRJNA1105232	15073	169	3.575	6.04175	Porospora cf. gigantea B	2853592	SAR_Eukaryotes	SAR_Eukaryotes	71.6	7.61e-13	NR	XP_068379002.1	2853592	g14857	i0	57.1	0.994082840236686	56	24	99.4	0	169	2	138	193	XP_068379002.1 MAG: uncharacterized protein KVP17_005105 [Porospora cf. gigantea B]	diamond	168	71.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Porosporidae	Porospora	Porospora cf. gigantea B
30690826	30690826	PRJNA1105232_S_NODE_16033_length_166_cov_1.777778_g15817_i0	PRJNA1105232	16033	166	1.777778	2.95111148	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.3	2.02e-14	NR	XP_013248971.1	5801	g15817	i0	61.8	5.6566265060241	55	21	99.4	0	166	2	465	519	XP_013248971.1 endonuclease III-like protein 1, putative [Eimeria acervulina]	diamond	939	76.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
31015556	31015556	PRJNA1105232_S_NODE_895_length_506_cov_20.096280_g683_i0	PRJNA1105232	895	506	20.09628	101.6871768	Porospora cf. gigantea A	2853593	SAR_Eukaryotes	SAR_Eukaryotes	223	2.21e-71	NR	XP_067813754.1	2853593	g683	i0	68	6.3498023715415	153	49	90.7	0	505	47	19	171	XP_067813754.1 MAG: uncharacterized protein KVP18_001803 [Porospora cf. gigantea A]	diamond	3213	223	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Porosporidae	Porospora	Porospora cf. gigantea A
31038755	31038755	PRJNA1105232_S_NODE_16035_length_166_cov_1.777778_g15819_i0	PRJNA1105232	16035	166	1.777778	2.95111148	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	51.6	1.41e-6	NR	TRY53264.1	756076	g15819	i0	49	7.33734939759036	49	25	88.6	0	19	165	7	55	TRY53264.1 60S ribosomal protein L36 [Cryptosporidium tyzzeri]	diamond	1218	52	0.992307692307692	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium tyzzeri
32650970	32650970	PRJNA1105232_S_NODE_3520_length_305_cov_1.464844_g3304_i0	PRJNA1105232	3520	305	1.464844	4.4677742	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	47	0.00102	NR	XP_013230120.1	5802	g3304	i0	42.4	1.16065573770492	59	32	58	2	224	48	12	68	XP_013230120.1 AN1-like Zinc finger-containing protein, putative [Eimeria tenella]	diamond	354	47	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
32817332	32817332	PRJNA1105232_S_NODE_11960_length_187_cov_1.507246_g11744_i0	PRJNA1105232	11960	187	1.507246	2.81855002	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	47.8	2.94e-4	NR	XP_067918059.1	483139	g11744	i0	46.2	0.834224598930481	52	26	83.4	1	30	185	573	622	XP_067918059.1 nucleolar phosphoprotein [Cystoisospora suis]	diamond	156	47.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis

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