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

9 rows where analysis = "diamond", bioproject = "PRJNA825466" 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
7198544	7198544	PRJNA825466_P_NODE_10826_length_282_cov_1.913876_g10725_i0	PRJNA825466	10826	282	1.913876	5.39713032	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	165	4.71e-47	NR	XP_952209.1	5874	g10725	i0	77.2	61.0851063829787	92	21	97.9	0	278	3	18	109	XP_952209.1 centromere/microtubule binding protein, putative [Theileria annulata]	diamond	17226	166	0.993975903614458	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria annulata
7198621	7198621	PRJNA825466_P_NODE_9606_length_291_cov_1.412844_g9505_i0	PRJNA825466	9606	291	1.412844	4.11137604	Plasmodium falciparum Palo Alto/Uganda	57270	SAR_Eukaryotes	SAR_Eukaryotes	73.9	4.72e-15	NR	ETW57071.1	57270	g9505	i0	89.7	0.402061855670103	39	4	40.2	0	188	72	31	69	ETW57071.1 hypothetical protein PFUGPA_00847 [Plasmodium falciparum Palo Alto/Uganda]	diamond	117	73.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
8473321	8473321	PRJNA825466_P_NODE_1767_length_527_cov_1.209251_g1668_i0	PRJNA825466	1767	527	1.209251	6.37275277	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	229	8.71e-74	NR	XP_013233901.1	5802	g1668	i0	69.4	64.1328273244782	173	50	98.5	1	8	526	6	175	XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella]	diamond	33798	230	0.995652173913044	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
16123044	16123044	PRJNA825466_P_NODE_28473_length_241_cov_0.916667_g28372_i0	PRJNA825466	28473	241	0.916667	2.20916747	Plasmodium falciparum IGH-CR14	580059	SAR_Eukaryotes	SAR_Eukaryotes	151	3.03e-44	NR	KNG75270.1	580059	g28372	i0	98.6	0.896265560165975	72	1	89.6	0	218	3	74	145	KNG75270.1 erythrocyte membrane protein 1, partial [Plasmodium falciparum IGH-CR14]	diamond	216	151	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
27063104	27063104	PRJNA825466_P_NODE_20682_length_248_cov_0.880000_g20581_i0	PRJNA825466	20682	248	0.88	2.1824	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	121	7.06e-30	NR	KNC37021.1	580058	g20581	i0	88.9	3.48387096774194	72	8	87.1	0	246	31	545	616	KNC37021.1 erythrocyte membrane protein pfemp3 [Plasmodium falciparum RAJ116]	diamond	864	121	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
30244161	30244161	PRJNA825466_P_NODE_1752_length_528_cov_2.013187_g1653_i0	PRJNA825466	1752	528	2.013187	10.62962736	Plasmodium falciparum Vietnam Oak-Knoll (FVO)	1036723	SAR_Eukaryotes	SAR_Eukaryotes	140	2.68e-39	NR	ETW18332.1	1036723	g1653	i0	65.6	0.693181818181818	122	20	66.5	2	353	3	29	133	ETW18332.1 hypothetical protein PFFVO_02848 [Plasmodium falciparum Vietnam Oak-Knoll (FVO)]	diamond	366	140	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
30947989	30947989	PRJNA825466_P_NODE_14794_length_259_cov_1.349462_g14693_i0	PRJNA825466	14794	259	1.349462	3.49510658	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	59.3	6.65e-8	NR	ETW62671.1	5835	g14693	i0	95.3	1.96911196911197	85	4	98.5	0	257	3	1910	1994	ETW62671.1 TKL protein kinase [Plasmodium falciparum CAMP/Malaysia]	diamond	510	59.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
31326995	31326995	PRJNA825466_P_NODE_21455_length_247_cov_0.885057_g21354_i0	PRJNA825466	21455	247	0.885057	2.18609079	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	131	2.28e-33	NR	ETW63135.1	5835	g21354	i0	86.4	3.93522267206478	81	11	98.4	0	245	3	122	202	ETW63135.1 hypothetical protein PFMC_01117 [Plasmodium falciparum CAMP/Malaysia]	diamond	972	131	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
32781143	32781143	PRJNA825466_P_NODE_29660_length_230_cov_2.222930_g29559_i0	PRJNA825466	29660	230	2.22293	5.112739	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	67	9e-11	NR	XP_002808642.2	36329	g29559	i0	100	4.82608695652174	37	0	48.3	0	113	3	2710	2746	XP_002808642.2 NYN domain-containing protein, putative [Plasmodium falciparum 3D7]	diamond	1110	67	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum

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