metadata: contig_metadata: 5 rows where bioproject = "PRJNA1137393", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA1137393", 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
7937813	7937813	PRJNA1137393_P_NODE_55907_length_165_cov_2.112069_g55391_i0	PRJNA1137393	55907	165	2.112069	3.48491385	Babesia sp.	35084	SAR_Eukaryotes	SAR_Eukaryotes	305	9.59e-79	NTclustered	gi\|2866450392\|gb\|PQ722881.1\|	35084	g55391	i0	100	100.133333333333	165	0	100	0	1	165	1527	1363	Babesia sp. isolate YN-4 WX-T-165 small subunit ribosomal RNA gene, partial sequence	blastn	16522	305	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia sp.
11235473	11235473	PRJNA1137393_P_NODE_73109_length_162_cov_0.920354_g72593_i0	PRJNA1137393	73109	162	0.920354	1.49097348	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	63.9	6.23e-6	NTclustered	gi\|527046684\|tpe\|HG323586.1\|	5833	g72593	i0	97.297	2.3641975308642	37	1	23	0	126	162	153	189	TPA: Plasmodium falciparum SRP RNA for signal recognition particle RNA	blastn	383	63.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
15587608	15587608	PRJNA1137393_P_NODE_35473_length_174_cov_0.832000_g34957_i0	PRJNA1137393	35473	174	0.832	1.44768	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	283	4.769999999999999e-72	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g34957	i0	95.977	4.86206896551724	174	7	100	0	1	174	117339	117512	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	846	283	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
15587751	15587751	PRJNA1137393_P_NODE_75153_length_152_cov_3.097087_g74637_i0	PRJNA1137393	75153	152	3.097087	4.70757224	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	226	6.919999999999997e-55	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g74637	i0	93.464	45.1776315789474	153	9	100	1	1	152	97246	97398	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	6867	226	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
30533309	30533309	PRJNA1137393_P_NODE_15713_length_219_cov_1.170588_g15197_i0	PRJNA1137393	15713	219	1.170588	2.56358772	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	51.2	2.45e-6	NR	SCL93381.1	5821	g15197	i0	65.6	11.1643835616438	32	11	43.8	0	122	217	2	33	SCL93381.1 hypothetical protein PBNK65NY_000087000 [Plasmodium berghei]	diamond	2445	51.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei

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