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

10 rows where analysis = "diamond", bioproject = "PRJEB39643" 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
17909011	17909011	PRJEB39643_P_NODE_13115_length_523_cov_2.477778_g12925_i0	PRJEB39643	13115	523	2.477778	12.95877894	Cryptosporidium sp. chipmunk genotype I	1280935	SAR_Eukaryotes	SAR_Eukaryotes	80.1	4.06e-15	NR	XP_067202604.1	1280935	g12925	i0	36.2	2.23135755258126	141	62	67.1	4	172	522	29	165	XP_067202604.1 A20 and Znf AN1 domains [Cryptosporidium sp. chipmunk genotype I]	diamond	1167	80.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. chipmunk genotype I
26678321	26678321	PRJEB39643_P_NODE_158581_length_215_cov_4.380282_g158387_i0	PRJEB39643	158581	215	4.380282	9.4176063	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	58.5	6.82e-8	NR	GFE54840.1	5869	g158387	i0	65	1.0046511627907	40	14	55.8	0	94	213	86	125	GFE54840.1 tRNA pseudouridine(55) synthase [Babesia ovis]	diamond	216	58.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
26931875	26931875	PRJEB39643_P_NODE_92902_length_264_cov_3.225131_g92709_i0	PRJEB39643	92902	264	3.225131	8.51434584	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	136	1.33e-38	NR	XP_016655351.1	31271	g92709	i0	78.5	11.1704545454545	79	17	89.8	0	3	239	67	145	XP_016655351.1 AP-1 complex subunit sigma, putative [Plasmodium chabaudi chabaudi]	diamond	2949	137	0.992700729927007	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
27879657	27879657	PRJEB39643_P_NODE_154545_length_229_cov_5.333333_g154352_i0	PRJEB39643	154545	229	5.333333	12.21333257	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	2.2e-4	NR	XP_013233737.1	5802	g154352	i0	52.5	1.25764192139738	40	19	52.4	0	158	39	28	67	XP_013233737.1 uncharacterized protein ETH_00031420 [Eimeria tenella]	diamond	288	46.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
28953421	28953421	PRJEB39643_P_NODE_158908_length_211_cov_5.826087_g158714_i0	PRJEB39643	158908	211	5.826087	12.29304357	Viridiplantae	33090	SAR_Eukaryotes	SAR_Eukaryotes	117	4.59e-32	NR	XP_013436125.1	51315	g158714	i0	75	37.2511848341232	68	17	96.7	0	206	3	39	106	XP_013436125.1 snRNP protein Lsm5, putative [Eimeria necatrix]	diamond	7860	117	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
29710565	29710565	PRJEB39643_P_NODE_145430_length_242_cov_5.514793_g145237_i0	PRJEB39643	145430	242	5.514793	13.34579906	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	98.6	1.21e-22	NR	XP_002369872.1	508771	g145237	i0	56.4	3.86776859504132	78	34	96.7	0	239	6	138	215	XP_002369872.1 ribosomal protein RPL5 [Toxoplasma gondii ME49]	diamond	936	99.4	0.991951710261569	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
29843874	29843874	PRJEB39643_P_NODE_34331_length_317_cov_3.540984_g34138_i0	PRJEB39643	34331	317	3.540984	11.22491928	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	51.2	3.85e-5	NR	XP_028534017.1	85471	g34138	i0	26.2	0.974763406940063	103	76	97.5	0	316	8	14	116	XP_028534017.1 lsm12, putative [Plasmodium relictum]	diamond	309	51.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
30374792	30374792	PRJEB39643_P_NODE_85072_length_268_cov_1.579487_g84879_i0	PRJEB39643	85072	268	1.579487	4.23302516	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	82.4	5.7e-16	NR	XP_013250780.1	5801	g84879	i0	48.2	9.77238805970149	83	43	92.9	0	250	2	773	855	XP_013250780.1 hypothetical protein EAH_00039760 [Eimeria acervulina]	diamond	2619	82.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
31739972	31739972	PRJEB39643_P_NODE_33737_length_320_cov_1.870445_g33544_i0	PRJEB39643	33737	320	1.870445	5.985424	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	75.9	2.21e-13	NR	XP_028527553.1	5849	g33544	i0	46.7	9.50625	92	42	81.6	3	282	22	605	694	XP_028527553.1 serine/threonine protein kinase KIN, putative [Plasmodium gallinaceum]	diamond	3042	75.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
31986451	31986451	PRJEB39643_P_NODE_34798_length_315_cov_14.111570_g34605_i0	PRJEB39643	34798	315	14.11157	44.4514455	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	91.3	8.23e-22	NR	XP_013232599.1	5802	g34605	i0	64.2	10.1142857142857	67	24	63.8	0	71	271	2	68	XP_013232599.1 40S ribosomal protein S28, putative [Eimeria tenella]	diamond	3186	92	0.992391304347826	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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