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

5 rows where bioproject = "PRJNA683902", 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
665181	665181	PRJNA683902_S_NODE_14341_length_319_cov_4.687943_g13897_i0	PRJNA683902	14341	319	4.687943	14.95453817	Plasmodium vinckei	5860	SAR_Eukaryotes	SAR_Eukaryotes	71.3	8.26e-8	NTclustered	gi\|1931714359\|ref\|XR_552297.2\|	54757	g13897	i0	88.333	8.18808777429467	60	6	18	1	257	315	4102	4043	Plasmodium vinckei vinckei ribosomal RNA (PVVCY_0502190), rRNA	blastn	2612	71.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
4493169	4493169	PRJNA683902_S_NODE_19124_length_247_cov_3.761905_g18680_i0	PRJNA683902	19124	247	3.761905	9.29190535	Babesia sp.	35084	SAR_Eukaryotes	SAR_Eukaryotes	424	4.1099999999999996e-114	NTclustered	gi\|2866450392\|gb\|PQ722881.1\|	35084	g18680	i0	97.571	100.51012145749	247	6	100	0	1	247	17	263	Babesia sp. isolate YN-4 WX-T-165 small subunit ribosomal RNA gene, partial sequence	blastn	24826	424	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia sp.
7043960	7043960	PRJNA683902_S_NODE_27206_length_191_cov_1.506494_g26762_i0	PRJNA683902	27206	191	1.506494	2.87740354	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	233	5.47e-57	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g26762	i0	97.101	31.3350785340314	138	4	99	0	52	189	300800	300663	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5985	233	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
15968074	15968074	PRJNA683902_S_NODE_35873_length_159_cov_4.795082_g35429_i0	PRJNA683902	35873	159	4.795082	7.62418038	Babesia sp.	35084	SAR_Eukaryotes	SAR_Eukaryotes	292	7.13e-75	NTclustered	gi\|2866450392\|gb\|PQ722881.1\|	35084	g35429	i0	100	99.5094339622642	158	0	99	0	2	159	1524	1367	Babesia sp. isolate YN-4 WX-T-165 small subunit ribosomal RNA gene, partial sequence	blastn	15822	292	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia sp.
27714412	27714412	PRJNA683902_S_NODE_33624_length_166_cov_1.488372_g33180_i0	PRJNA683902	33624	166	1.488372	2.47069752	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	84	2.37e-19	NR	VWU51230.1	2600580	g33180	i0	80	1.98795180722892	55	11	99.4	0	165	1	18	72	VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	330	84	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles

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