metadata: contig_metadata: 8 rows where bioproject = "PRJNA533623", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA533623", 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
6884686	6884686	PRJNA533623_P_NODE_65126_length_236_cov_1.177143_g63345_i0	PRJNA533623	65126	236	1.177143	2.77805748	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	302	1.9e-77	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g63345	i0	90.749	21.1610169491525	227	19	95	2	1	225	97171	97397	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4994	302	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
6884899	6884899	PRJNA533623_P_NODE_7666_length_839_cov_2.516710_g6244_i0	PRJNA533623	7666	839	2.51671	21.1151969	Plasmodium vinckei	5860	SAR_Eukaryotes	SAR_Eukaryotes	65.8	1.08e-5	NTclustered	gi\|669198468\|ref\|XM_008626022.1\|	54757	g6244	i0	91.489	0.761620977353993	47	4	6	0	339	385	1294	1248	Plasmodium vinckei vinckei conserved Plasmodium protein, unknown function (PVVCY_1103560), partial mRNA	blastn	639	65.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
9434638	9434638	PRJNA533623_P_NODE_32128_length_397_cov_2.830357_g30357_i0	PRJNA533623	32128	397	2.830357	11.23651729	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	507	6.749999999999998e-139	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g30357	i0	89.673	4.30226700251889	397	41	100	0	1	397	157849	157453	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1708	507	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
11985181	11985181	PRJNA533623_P_NODE_37130_length_362_cov_9.823920_g35358_i0	PRJNA533623	37130	362	9.82392	35.5625904	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	158	7.07e-34	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g35358	i0	77.407	1.22375690607735	270	57	74	4	68	336	80674	80408	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	443	158	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18358913	18358913	PRJNA533623_P_NODE_9895_length_745_cov_4.681287_g8341_i0	PRJNA533623	9895	745	4.681287	34.87558815	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.021	NTclustered	gi\|916504956\|ref\|XM_013497643.1\|	44415	g8341	i0	92.308	0.0523489932885906	39	2	5	1	600	637	142	104	Eimeria mitis uncharacterized protein (EMH_0006740), partial mRNA	blastn	39	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
26966129	26966129	PRJNA533623_P_NODE_44602_length_320_cov_2.795367_g42828_i0	PRJNA533623	44602	320	2.795367	8.9451744	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	118	3.73e-29	NR	UKK00412.1	68886	g42828	i0	70.9	14.390625	79	23	74.1	0	299	63	304	382	UKK00412.1 ribosomal protein L3 [Theileria orientalis]	diamond	4605	119	0.991596638655462	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
31246820	31246820	PRJNA533623_P_NODE_7715_length_836_cov_15.223226_g6288_i0	PRJNA533623	7715	836	15.223226	127.26616936	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	167	3.09e-44	NR	XP_029217687.1	94643	g6288	i0	47.8	0.65311004784689	182	92	64.2	2	812	276	317	498	XP_029217687.1 putative vacuolar protein sorting-associated protein vps4 [Besnoitia besnoiti]	diamond	546	167	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
31879271	31879271	PRJNA533623_P_NODE_78857_length_194_cov_2.511278_g77076_i0	PRJNA533623	78857	194	2.511278	4.87187932	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	41.6	0.017	NR	XP_067926279.1	483139	g77076	i0	55.6	0.556701030927835	36	16	55.7	0	5	112	75	110	XP_067926279.1 c6orf165-like protein [Cystoisospora suis]	diamond	108	41.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis

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