metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA788929" 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
9697517	9697517	PRJNA788929_P_NODE_20108_length_364_cov_40.539519_g19448_i0	PRJNA788929	20108	364	40.539519	147.56384916	root	1	Root_unresolved	Root_unresolved	140	1.08e-36	NR	KFH09002.1	933077	g19448	i0	63.8	6.17307692307692	105	38	86.5	0	329	15	176	280	KFH09002.1 glyceraldehyde-3-phosphate dehydrogenase GAPDH1 [Toxoplasma gondii VAND]	diamond	2247	140	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
19896575	19896575	PRJNA788929_P_NODE_8496_length_630_cov_19.976661_g7848_i0	PRJNA788929	8496	630	19.976661	125.8529643	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	202	5.05e-62	NR	OEH76901.1	88456	g7848	i0	60.8	5.05238095238095	181	71	86.2	0	597	55	27	207	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	3183	202	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
27559076	27559076	PRJNA788929_P_NODE_4424_length_962_cov_28.160855_g3901_i0	PRJNA788929	4424	962	28.160855	270.9074251	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	108	2.5299999999999994e-23	NR	XP_029221749.1	94643	g3901	i0	30.5	0.960498960498961	308	192	94.8	10	918	7	1	290	XP_029221749.1 eukaryotic porin protein [Besnoitia besnoiti]	diamond	924	108	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
27821224	27821224	PRJNA788929_P_NODE_4384_length_968_cov_34.581006_g3871_i0	PRJNA788929	4384	968	34.581006	334.74413808	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	525	2.15e-186	NR	KAF4639249.1	5811	g3871	i0	79	164.129132231405	300	63	93	0	903	4	3	302	KAF4639249.1 serine/threonine phosophatase PP1 [Toxoplasma gondii]	diamond	158877	528	0.994318181818182	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
28601279	28601279	PRJNA788929_P_NODE_1027_length_1989_cov_41.608038_g888_i0	PRJNA788929	1027	1989	41.608038	827.58387582	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	58.9	8.31e-6	NR	2FBN_A	5833	g888	i0	30.2	0.419306184012066	139	85	19.5	4	811	425	32	168	2FBN_A Chain A, kDa peptidylprolyl isomerase, putative [Plasmodium falciparum]	diamond	834	58.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
28853576	28853576	PRJNA788929_P_NODE_3068_length_1190_cov_25.179051_g2677_i0	PRJNA788929	3068	1190	25.179051	299.6307069	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	68.2	3.21e-8	NR	KAF8822999.1	476202	g2677	i0	41.9	0.708403361344538	74	42	18.7	1	272	493	76	148	KAF8822999.1 hypothetical protein IE077_001474 [Cardiosporidium cionae]	diamond	843	68.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
30653871	30653871	PRJNA788929_P_NODE_10213_length_558_cov_153.478351_g9560_i0	PRJNA788929	10213	558	153.478351	856.40919858	Babesia bovis T2Bo	484906	SAR_Eukaryotes	SAR_Eukaryotes	89	2.53e-19	NR	XP_001610942.1	484906	g9560	i0	53.5	0.532258064516129	99	41	52.2	3	90	380	7	102	XP_001610942.1 putative ribosomal protein S25 [Babesia bovis T2Bo]	diamond	297	89	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
30906986	30906986	PRJNA788929_P_NODE_18894_length_378_cov_29.304918_g18234_i0	PRJNA788929	18894	378	29.304918	110.77259004	Babesia gibsoni	33632	SAR_Eukaryotes	SAR_Eukaryotes	68.6	1.38e-10	NR	KAK1443921.1	33632	g18234	i0	48.6	1.24603174603175	70	33	53.2	1	355	155	103	172	KAK1443921.1 tRNA-aminoacylation cofactor arc1 family member like protein [Babesia gibsoni]	diamond	471	68.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
31127579	31127579	PRJNA788929_P_NODE_23395_length_333_cov_28.726923_g22734_i0	PRJNA788929	23395	333	28.726923	95.66065359	Babesia bigemina	5866	SAR_Eukaryotes	SAR_Eukaryotes	54.7	1.86e-6	NR	XP_012768717.1	5866	g22734	i0	42.6	0.486486486486487	54	31	48.6	0	279	118	1	54	XP_012768717.1 Zinc finger A20 and AN1 domain-containing stress-associated protein 9 [Babesia bigemina]	diamond	162	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
31886918	31886918	PRJNA788929_P_NODE_10457_length_549_cov_56.279412_g9804_i0	PRJNA788929	10457	549	56.279412	308.97397188	Babesia bovis T2Bo	484906	SAR_Eukaryotes	SAR_Eukaryotes	92	1.47e-20	NR	XP_001610942.1	484906	g9804	i0	54	0.546448087431694	100	41	53.6	3	464	171	7	103	XP_001610942.1 putative ribosomal protein S25 [Babesia bovis T2Bo]	diamond	300	92	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
32235365	32235365	PRJNA788929_P_NODE_22338_length_343_cov_13.292593_g21677_i0	PRJNA788929	22338	343	13.292593	45.59359399	Theileria parva strain Muguga	333668	SAR_Eukaryotes	SAR_Eukaryotes	53.5	2.5e-6	NR	XP_766445.1	333668	g21677	i0	72.7	0.883381924198251	33	9	28.9	0	333	235	80	112	XP_766445.1 60S ribosomal protein L31-1 [Theileria parva strain Muguga]	diamond	303	53.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria parva

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