metadata: contig_metadata: 10 rows where bioproject = "PRJEB2925", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJEB2925", tax_clade = "Sar" 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
26138	26138	PRJEB2925_P_NODE_9161_length_395_cov_2.013889_g7894_i0	PRJEB2925	9161	395	2.013889	7.95486155	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	173	7.44e-48	NR	XP_002142079.1	441375	g7894	i0	68.7	1.98987341772152	131	41	99.5	0	395	3	455	585	XP_002142079.1 heat shock protein 70, putative [Cryptosporidium muris RN66]	diamond	786	173	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
1300357	1300357	PRJEB2925_P_NODE_15782_length_251_cov_1.064815_g14504_i0	PRJEB2925	15782	251	1.064815	2.67268565	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	326	1.21e-84	NTclustered	gi\|124507039\|ref\|XM_001352081.1\|	36329	g14504	i0	100	2.02390438247012	176	0	70	0	76	251	1137	962	Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_0924600), partial mRNA	blastn	508	326	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
5128448	5128448	PRJEB2925_P_NODE_1365_length_1738_cov_6.762184_g1008_i0	PRJEB2925	1365	1738	6.762184	117.52675792	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	3070	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g1008	i0	98.561	1206.01898734177	1737	25	99	0	1	1737	1894	158	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	2096061	3070	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
5128513	5128513	PRJEB2925_P_NODE_5605_length_563_cov_7.626894_g4551_i0	PRJEB2925	5605	563	7.626894	42.93941322	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	202	3.05e-62	NR	OEH76901.1	88456	g4551	i0	61.5	2.79751332149201	179	69	95.4	0	559	23	29	207	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	1575	202	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
11504230	11504230	PRJEB2925_P_NODE_8010_length_440_cov_2.958025_g6790_i0	PRJEB2925	8010	440	2.958025	13.01531	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	91.6	9.01e-14	NTclustered	gi\|1474771164\|gb\|MH107388.1\|	323732	g6790	i0	84.536	0.536363636363636	97	9	21	6	233	326	15781	15874	Babesia duncani isolate WA-1 apicoplast, complete genome	blastn	236	91.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
16602904	16602904	PRJEB2925_P_NODE_16014_length_248_cov_1.079812_g14736_i0	PRJEB2925	16014	248	1.079812	2.67793376	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	307	4.34e-79	NTclustered	gi\|124512965\|ref\|XM_001349803.1\|	36329	g14736	i0	98.837	2.41532258064516	172	2	69	0	1	172	815	644	Plasmodium falciparum 3D7 meiosis-specific nuclear structural protein 1, putative (PF3D7_1311100), partial mRNA	blastn	599	307	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
24251888	24251888	PRJEB2925_P_NODE_15120_length_260_cov_1.022222_g13842_i0	PRJEB2925	15120	260	1.022222	2.6577772	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	405	1.58e-108	NTclustered	gi\|124513881\|ref\|XM_001350261.1\|	36329	g13842	i0	100	1.68076923076923	219	0	84	0	42	260	1085	867	Plasmodium falciparum 3D7 zinc finger protein, putative (PF3D7_1358600), partial mRNA	blastn	437	405	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
24251975	24251975	PRJEB2925_P_NODE_9240_length_392_cov_1.658263_g7972_i0	PRJEB2925	9240	392	1.658263	6.50039096	Babesia microti strain RI	1133968	SAR_Eukaryotes	SAR_Eukaryotes	149	3.2199999999999993e-43	NR	XP_021338074.1	1133968	g7972	i0	60.7	7.125	117	46	89.5	0	4	354	39	155	XP_021338074.1 small subunit ribosomal protein S18e [Babesia microti strain RI]	diamond	2793	149	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti
25214151	25214151	PRJEB2925_P_NODE_16020_length_248_cov_0.981221_g14742_i0	PRJEB2925	16020	248	0.981221	2.43342808	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	165	2.76e-36	NTclustered	gi\|160646\|gb\|M14599.1\|PFARGSS	5821	g14742	i0	100	38.3145161290323	89	0	60	0	160	248	1730	1642	P.berghei small subunit rRNA gene	blastn	9502	165	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
30279935	30279935	PRJEB2925_P_NODE_14132_length_273_cov_2.084034_g12854_i0	PRJEB2925	14132	273	2.084034	5.68941282	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.2	2.72e-14	NR	XP_067067485.1	117008	g12854	i0	52.1	3.68131868131868	73	34	80.2	1	55	273	3	74	XP_067067485.1 60s ribosomal protein L35A [Cryptosporidium andersoni]	diamond	1005	73.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium andersoni

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