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

9 rows where bioproject = "PRJNA721440", 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
6297670	6297670	PRJNA721440_S_NODE_1705_length_415_cov_2.030055_g1579_i0	PRJNA721440	1705	415	2.030055	8.42472825	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.2	2.38e-4	NTclustered	gi\|221059494\|ref\|XM_002260357.1\|	5851	g1579	i0	100	2.67469879518072	32	0	8	0	317	348	1751	1720	Plasmodium knowlesi strain H U3 small nucleolar RNA-associated protein 12, putative (PKNH_1234100), partial mRNA	blastn	1110	60.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
18561998	18561998	PRJNA721440_S_NODE_5895_length_248_cov_660.894472_g5769_i0	PRJNA721440	5895	248	660.894472	1639.01829056	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	121	6.059999999999999e-23	NTclustered	gi\|916497858\|ref\|XM_013494305.1\|	44415	g5769	i0	98.551	2.1008064516129	69	0	27	1	176	243	413	345	Eimeria mitis uncharacterized protein (EMH_0029470), partial mRNA	blastn	521	121	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
19837090	19837090	PRJNA721440_S_NODE_19056_length_164_cov_0.904348_g18930_i0	PRJNA721440	19056	164	0.904348	1.48313072	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	74.3	7.69e-14	NR	XP_011128544.1	110365	g18930	i0	64.7	1.92073170731707	51	18	93.3	0	11	163	145	195	XP_011128544.1 casein kinase I [Gregarina niphandrodes]	diamond	315	74.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
19837122	19837122	PRJNA721440_S_NODE_836_length_563_cov_204.832685_g714_i0	PRJNA721440	836	563	204.832685	1153.20801655	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	121	1.5000000000000002e-22	NTclustered	gi\|916497858\|ref\|XM_013494305.1\|	44415	g714	i0	98.551	0.827708703374778	69	0	12	1	6	73	345	413	Eimeria mitis uncharacterized protein (EMH_0029470), partial mRNA	blastn	466	121	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
23663190	23663190	PRJNA721440_S_NODE_17639_length_167_cov_1.838983_g17513_i0	PRJNA721440	17639	167	1.838983	3.07110161	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	143	8.08e-30	NTclustered	gi\|2794774941\|ref\|XM_067948443.1\|	323732	g17513	i0	87.705	0.730538922155689	122	15	73	0	46	167	514	393	Babesia duncani bifunctional FAD-NAD(P)-binding domain superfamily/FAD-dependent oxidoreductase 2 (BdWA1_003433), partial mRNA	blastn	122	143	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
24936675	24936675	PRJNA721440_S_NODE_11720_length_193_cov_3.097222_g11594_i0	PRJNA721440	11720	193	3.097222	5.97763846	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	126	9.67e-25	NTclustered	gi\|1624689524\|ref\|XM_029009637.1\|	189622	g11594	i0	86.726	34.1502590673575	113	15	59	0	5	117	326	214	Babesia ovata heat shock 90 (BOVATA_007200), partial mRNA	blastn	6591	126	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
27442040	27442040	PRJNA721440_S_NODE_11783_length_193_cov_1.083333_g11657_i0	PRJNA721440	11783	193	1.083333	2.09083269	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	88.2	1.8e-18	NR	XP_019914087.1	208452	g11657	i0	65.1	4.89637305699482	63	22	97.9	0	191	3	458	520	XP_019914087.1 Thioredoxin reductase 2 [Plasmodium coatneyi]	diamond	945	88.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium coatneyi
30410444	30410444	PRJNA721440_S_NODE_17193_length_168_cov_2.462185_g17067_i0	PRJNA721440	17193	168	2.462185	4.1364708	Eimeriidae	5799	SAR_Eukaryotes	SAR_Eukaryotes	56.6	1.77e-7	NR	XP_013439913.1	51315	g17067	i0	44	5.35714285714286	50	28	89.3	0	168	19	1177	1226	XP_013439913.1 hypothetical protein, conserved [Eimeria necatrix]	diamond	900	57	0.992982456140351	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
30936878	30936878	PRJNA721440_S_NODE_20734_length_158_cov_2.165138_g20608_i0	PRJNA721440	20734	158	2.165138	3.42091804	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00245	NR	XP_004828842.1	1537102	g20608	i0	46	0.949367088607595	50	27	94.9	0	3	152	136	185	XP_004828842.1 nucleotidyltransferase domain containing protein [Theileria equi strain WA]	diamond	150	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi

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