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

10 rows where analysis = "diamond", bioproject = "PRJNA929522" 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
2529107	2529107	PRJNA929522_S_NODE_3742_length_349_cov_0.836957_g3672_i0	PRJNA929522	3742	349	0.836957	2.92097993	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	198	6.4e-61	NR	KAF4639249.1	5811	g3672	i0	75.9	87.730659025788	116	28	99.7	0	348	1	79	194	KAF4639249.1 serine/threonine phosophatase PP1 [Toxoplasma gondii]	diamond	30618	199	0.994974874371859	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
8906230	8906230	PRJNA929522_S_NODE_2367_length_433_cov_3.950000_g2297_i0	PRJNA929522	2367	433	3.95	17.1035	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	206	1.98e-65	NR	XP_954382.1	5874	g2297	i0	66.2	8.79214780600462	142	48	98.4	0	432	7	29	170	XP_954382.1 60S ribosomal protein l11a, putative [Theileria annulata]	diamond	3807	206	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria annulata
25131484	25131484	PRJNA929522_S_NODE_3300_length_369_cov_1.351351_g3230_i0	PRJNA929522	3300	369	1.351351	4.98648519	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	192	4.8999999999999996e-55	NR	KAL3126822.1	237895	g3230	i0	78.9	16	123	26	100	0	1	369	425	547	KAL3126822.1 heat shock protein Hsp70 [Cryptosporidium hominis]	diamond	5904	192	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
27150860	27150860	PRJNA929522_S_NODE_2542_length_419_cov_2.049133_g2472_i0	PRJNA929522	2542	419	2.049133	8.58586727	Babesia gibsoni	33632	SAR_Eukaryotes	SAR_Eukaryotes	57	2.68e-6	NR	KAK1443829.1	33632	g2472	i0	75	0.945107398568019	36	6	25.8	1	312	419	344	376	KAK1443829.1 translation initiation factor IF- 2 [Babesia gibsoni]	diamond	396	57	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
27214349	27214349	PRJNA929522_S_NODE_3322_length_368_cov_1.423729_g3252_i0	PRJNA929522	3322	368	1.423729	5.23932272	Eimeria brunetti	51314	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.0198	NR	CDJ51925.1	51314	g3252	i0	66.7	0.220108695652174	27	9	22	0	22	102	2	28	CDJ51925.1 MORN repeat-containing protein, putative [Eimeria brunetti]	diamond	81	45.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria brunetti
27411519	27411519	PRJNA929522_S_NODE_2523_length_420_cov_2.394813_g2453_i0	PRJNA929522	2523	420	2.394813	10.0582146	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	103	1.87e-22	NR	XP_012769318.1	5866	g2453	i0	57	2.64285714285714	86	37	61.4	0	344	87	518	603	XP_012769318.1 RNA recognition motif domain containing protein, putative [Babesia bigemina]	diamond	1110	103	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
29424730	29424730	PRJNA929522_S_NODE_6549_length_279_cov_1.495146_g6479_i0	PRJNA929522	6549	279	1.495146	4.17145734	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0173	NR	XP_002140808.1	441375	g6479	i0	55.8	0.924731182795699	43	19	46.2	0	257	129	37	79	XP_002140808.1 uncharacterized protein CMU_009510 [Cryptosporidium muris RN66]	diamond	258	43.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
29677119	29677119	PRJNA929522_S_NODE_8870_length_248_cov_2.171429_g8800_i0	PRJNA929522	8870	248	2.171429	5.38514392	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	87.8	2.69e-18	NR	XP_067927548.1	483139	g8800	i0	76.4	0.665322580645161	55	13	66.5	0	81	245	10	64	XP_067927548.1 fructose- -bisphosphate [Cystoisospora suis]	diamond	165	87.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
31858044	31858044	PRJNA929522_S_NODE_4317_length_330_cov_0.898833_g4247_i0	PRJNA929522	4317	330	0.898833	2.9661489	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	107	2.75e-24	NR	XP_725028.1	5861	g4247	i0	50	3.93636363636364	108	50	98.2	1	328	5	512	615	XP_725028.1 serine/threonine protein phosphatase 5, putative [Plasmodium yoelii]	diamond	1299	107	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
32687196	32687196	PRJNA929522_S_NODE_1840_length_488_cov_8.453012_g1770_i0	PRJNA929522	1840	488	8.453012	41.25069856	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	116	4e-30	NR	XP_013251421.1	5801	g1770	i0	53.7	4.67213114754098	108	48	66.4	1	144	467	16	121	XP_013251421.1 60s ribosomal protein L33-A, putative [Eimeria acervulina]	diamond	2280	117	0.991452991452991	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina

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