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

9 rows where bioproject = "PRJNA939369", 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
2189842	2189842	PRJNA939369_S_NODE_58382_length_249_cov_1.312500_g57965_i0	PRJNA939369	58382	249	1.3125	3.268125	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	113	1.02e-20	NTclustered	gi\|1270519481\|ref\|XM_022955661.1\|	5861	g57965	i0	83.2	0.502008032128514	125	19	50	2	102	225	622	499	Plasmodium yoelii heat shock protein 90, putative (PY17X_0808800), partial mRNA	blastn	125	113	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
23866697	23866697	PRJNA939369_S_NODE_34399_length_289_cov_1.166667_g33982_i0	PRJNA939369	34399	289	1.166667	3.37166763	Theileria sp.	27992	SAR_Eukaryotes	SAR_Eukaryotes	387	6.46e-103	NTclustered	gi\|1425132576\|gb\|MH618774.1\|	27992	g33982	i0	90.722	34.80276816609	291	25	100	2	1	289	910	1200	Theileria sp. isolate P11 small subunit ribosomal RNA gene, partial sequence	blastn	10058	387	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria sp.
27372976	27372976	PRJNA939369_S_NODE_12683_length_391_cov_2.286164_g12266_i0	PRJNA939369	12683	391	2.286164	8.93890124	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	62	3.66e-8	NR	SBT57149.1	864142	g12266	i0	61.2	0.375959079283887	49	19	37.6	0	381	235	972	1020	SBT57149.1 STP1 protein [Plasmodium ovale wallikeri]	diamond	147	62	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
28074235	28074235	PRJNA939369_S_NODE_1425_length_895_cov_3.762774_g1087_i0	PRJNA939369	1425	895	3.762774	33.6768273	root	1	Root_unresolved	Root_unresolved	79.7	2.36e-14	NR	SBT56012.1	864142	g1087	i0	66.1	1.05251396648045	59	20	19.8	0	8	184	62	120	SBT56012.1 hypothetical protein POVWA2_071070 [Plasmodium ovale wallikeri]	diamond	942	79.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
29014859	29014859	PRJNA939369_S_NODE_8728_length_445_cov_1.220430_g8311_i0	PRJNA939369	8728	445	1.22043	5.4309135	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	69.3	1.74e-10	NR	SBT55483.1	864142	g8311	i0	72.7	0.370786516853933	55	15	37.1	0	336	172	55	109	SBT55483.1 STP1 protein [Plasmodium ovale wallikeri]	diamond	165	69.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
29582539	29582539	PRJNA939369_S_NODE_33290_length_292_cov_1.027397_g32873_i0	PRJNA939369	33290	292	1.027397	2.99999924	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0187	NR	SBT55483.1	864142	g32873	i0	58.8	0.523972602739726	51	21	52.4	0	158	6	56	106	SBT55483.1 STP1 protein [Plasmodium ovale wallikeri]	diamond	153	44.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
29803797	29803797	PRJNA939369_S_NODE_1331_length_923_cov_5.097647_g998_i0	PRJNA939369	1331	923	5.097647	47.05128181	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	78.6	7.13e-14	NR	SBT56012.1	864142	g998	i0	70.7	0.370530877573131	58	17	18.9	0	687	860	82	139	SBT56012.1 hypothetical protein POVWA2_071070 [Plasmodium ovale wallikeri]	diamond	342	78.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
29898741	29898741	PRJNA939369_S_NODE_1451_length_888_cov_1.146012_g1112_i0	PRJNA939369	1451	888	1.146012	10.17658656	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	64.3	7.96e-9	NR	SBT55279.1	864142	g1112	i0	75.7	0.125	37	9	12.5	0	279	169	93	129	SBT55279.1 hypothetical protein POVWA2_067180 [Plasmodium ovale wallikeri]	diamond	111	64.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
30561890	30561890	PRJNA939369_S_NODE_913_length_1091_cov_3.291749_g644_i0	PRJNA939369	913	1091	3.291749	35.91298159	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	73.9	3.66e-10	NR	SBT57149.1	864142	g644	i0	73.9	0.126489459211732	46	12	12.6	0	174	311	972	1017	SBT57149.1 STP1 protein [Plasmodium ovale wallikeri]	diamond	138	73.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale

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