metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1249535" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1249535" 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
26820710	26820710	PRJNA1249535_S_NODE_158221_length_330_cov_2.708171_g154838_i0	PRJNA1249535	158221	330	2.708171	8.9369643	Cryptosporidium ryanae	515981	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.0114	NR	XP_067196890.1	515981	g154838	i0	34.7	0.918181818181818	101	52	86.4	4	298	14	550	642	XP_067196890.1 uncharacterized protein FG386_001689 [Cryptosporidium ryanae]	diamond	303	45.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ryanae
28147788	28147788	PRJNA1249535_S_NODE_80645_length_400_cov_4.886850_g77264_i0	PRJNA1249535	80645	400	4.88685	19.5474	Cryptosporidium bovis	310047	SAR_Eukaryotes	SAR_Eukaryotes	48.5	0.00202	NR	XP_067182957.1	310047	g77264	i0	39.6	0.3975	53	32	39.8	0	286	128	426	478	XP_067182957.1 WD40 repeat [Cryptosporidium bovis]	diamond	159	48.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium bovis
28400125	28400125	PRJNA1249535_S_NODE_126806_length_351_cov_3.625899_g123423_i0	PRJNA1249535	126806	351	3.625899	12.72690549	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0282	NR	XP_028534202.1	85471	g123423	i0	42.6	0.401709401709402	47	27	40.2	0	258	118	518	564	XP_028534202.1 histone deacetylase, putative [Plasmodium relictum]	diamond	141	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
28400166	28400166	PRJNA1249535_S_NODE_239066_length_285_cov_20.665094_g235683_i0	PRJNA1249535	239066	285	20.665094	58.8955179	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0347	NR	XP_028527875.1	5849	g235683	i0	28.9	0.8	76	54	80	0	246	19	330	405	XP_028527875.1 conserved Plasmodium protein, unknown function [Plasmodium gallinaceum]	diamond	228	43.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
29158143	29158143	PRJNA1249535_S_NODE_283749_length_261_cov_7.617021_g280366_i0	PRJNA1249535	283749	261	7.617021	19.88042481	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0412	NR	SBT01570.1	5858	g280366	i0	35.6	0.839080459770115	73	46	83.9	1	237	19	38	109	SBT01570.1 Plasmodium exported protein (Pm-fam-a like), unknown function [Plasmodium malariae]	diamond	219	42.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
30516053	30516053	PRJNA1249535_S_NODE_2673_length_1290_cov_8.191454_g1704_i0	PRJNA1249535	2673	1290	8.191454	105.6697566	Porospora cf. gigantea B	2853592	SAR_Eukaryotes	SAR_Eukaryotes	50.1	0.0168	NR	XP_068376221.1	2853592	g1704	i0	33.3	0.216279069767442	93	41	16.7	4	828	1043	53	145	XP_068376221.1 MAG: uncharacterized protein KVP17_001978 [Porospora cf. gigantea B]	diamond	279	50.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Porosporidae	Porospora	Porospora cf. gigantea B
30831921	30831921	PRJNA1249535_S_NODE_165714_length_325_cov_5.019841_g162331_i0	PRJNA1249535	165714	325	5.019841	16.31448325	Plasmodium cynomolgi strain B	1120755	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0198	NR	XP_004224718.1	1120755	g162331	i0	46.3	0.378461538461538	41	22	37.8	0	255	133	139	179	XP_004224718.1 hypothetical protein PCYB_141990, partial [Plasmodium cynomolgi strain B]	diamond	123	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi
30881512	30881512	PRJNA1249535_S_NODE_115434_length_360_cov_4.125436_g112051_i0	PRJNA1249535	115434	360	4.125436	14.8515696	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0406	NR	EUR65349.1	57266	g112051	i0	39.6	2.20833333333333	53	32	44.2	0	235	77	1187	1239	EUR65349.1 hypothetical protein PFBG_04963 [Plasmodium falciparum 7G8]	diamond	795	44.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
30927093	30927093	PRJNA1249535_S_NODE_76634_length_407_cov_3.122754_g73253_i0	PRJNA1249535	76634	407	3.122754	12.70960878	Babesia gibsoni	33632	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.0128	NR	KAK1445024.1	33632	g73253	i0	27.3	0.810810810810811	110	58	68.6	4	399	121	436	540	KAK1445024.1 hypothetical protein BgAZ_109300 [Babesia gibsoni]	diamond	330	46.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni

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