metadata: contig_metadata: 9 rows where bioproject = "PRJNA395690", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA395690", 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
9339872	9339872	PRJNA395690_P_NODE_31368_length_165_cov_0.879310_g31216_i0	PRJNA395690	31368	165	0.87931	1.4508615	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	66.6	1.92e-11	NR	XP_067919363.1	483139	g31216	i0	66.7	1.94545454545455	54	18	98.2	0	3	164	3	56	XP_067919363.1 ribosome biogenesis protein nsa2 [Cystoisospora suis]	diamond	321	66.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
22756010	22756010	PRJNA395690_P_NODE_31558_length_164_cov_2.913043_g31406_i0	PRJNA395690	31558	164	2.913043	4.77739052	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	95.3	2.24e-15	NTclustered	gi\|21039067\|gb\|AF401507.1\|	5807	g31406	i0	100	138.341463414634	51	0	31	0	105	155	915	865	Cryptosporidium parvum isolate H299 heat shock protein 70 gene, partial cds	blastn	22688	95.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
24030819	24030819	PRJNA395690_P_NODE_35819_length_161_cov_0.910714_g35667_i0	PRJNA395690	35819	161	0.910714	1.46624954	Haemosporida	5819	SAR_Eukaryotes	SAR_Eukaryotes	86.1	1.32e-12	NTclustered	gi\|1610217327\|gb\|MK695424.1\|	191679	g35667	i0	87.179	42.1552795031056	78	6	47	3	84	159	200	125	Haemoproteus sp. isolate PACVAL01 from Brazil cytochrome b (cytB) gene, partial cds; mitochondrial	blastn	6787	86.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Haemoproteidae	Haemoproteus	Haemoproteus sp.
27218303	27218303	PRJNA395690_P_NODE_9782_length_260_cov_1.274882_g9630_i0	PRJNA395690	9782	260	1.274882	3.3146932	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	68.9	1.57e-11	NR	EWC86765.1	5843	g9630	i0	46.2	5.4	78	39	88.8	2	6	236	213	288	EWC86765.1 hypothetical protein PFNF54_04318 [Plasmodium falciparum NF54]	diamond	1404	68.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
27517764	27517764	PRJNA395690_P_NODE_7623_length_292_cov_1.983539_g7471_i0	PRJNA395690	7623	292	1.983539	5.79193388	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	137	1.58e-38	NR	XP_067804708.1	323732	g7471	i0	68	11.0034246575342	97	31	99.7	0	292	2	2	98	XP_067804708.1 bifunctional Ribosomal protein S8e/Ribosomal protein S8e [Babesia duncani]	diamond	3213	137	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
27802022	27802022	PRJNA395690_P_NODE_32164_length_164_cov_0.886957_g32012_i0	PRJNA395690	32164	164	0.886957	1.45460948	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	67.4	2.54e-11	NR	KAF8821299.1	476202	g32012	i0	56.6	3.89634146341463	53	23	97	0	5	163	264	316	KAF8821299.1 sarcalumenin/eps15 family protein [Cardiosporidium cionae]	diamond	639	67.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
29365839	29365839	PRJNA395690_P_NODE_24929_length_175_cov_1.214286_g24777_i0	PRJNA395690	24929	175	1.214286	2.1250005	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.6	4.64e-13	NR	GFE54039.1	5869	g24777	i0	60.3	11.3657142857143	58	23	99.4	0	174	1	5	62	GFE54039.1 60S ribosomal protein L31 [Babesia ovis]	diamond	1989	68.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
30692336	30692336	PRJNA395690_P_NODE_18193_length_191_cov_1.077465_g18041_i0	PRJNA395690	18193	191	1.077465	2.05795815	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	96.3	5.37e-22	NR	WBY55016.1	73239	g18041	i0	68.3	93.0157068062827	63	20	99	0	1	189	5	67	WBY55016.1 eukaryotic peptide chain release factor subunit 1 [Plasmodium yoelii yoelii]	diamond	17766	96.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
31180846	31180846	PRJNA395690_P_NODE_22795_length_180_cov_1.335878_g22643_i0	PRJNA395690	22795	180	1.335878	2.4045804	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	62.4	1.86e-9	NR	XP_011128609.1	110365	g22643	i0	42.4	0.983333333333333	59	34	98.3	0	2	178	2585	2643	XP_011128609.1 hypothetical protein GNI_005330 [Gregarina niphandrodes]	diamond	177	62.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes

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