metadata: contig_metadata: 10 rows where bioproject = "PRJNA797475", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA797475", 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
2057322	2057322	PRJNA797475_P_NODE_26742_length_245_cov_0.895349_g26643_i0	PRJNA797475	26742	245	0.895349	2.19360505	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	453	5.1900000000000006e-123	NTclustered	gi\|258597813\|ref\|XM_001348557.2\|	36329	g26643	i0	100	4.01224489795918	245	0	100	0	1	245	16095	15851	Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1444100), partial mRNA	blastn	983	453	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
5045109	5045109	PRJNA797475_P_NODE_4944_length_450_cov_1.978780_g4846_i0	PRJNA797475	4944	450	1.97878	8.90451	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.044	NTclustered	gi\|260233916\|dbj\|AK318321.1\|	5811	g4846	i0	100	0.186666666666667	28	0	6	0	215	242	509	536	Toxoplasma gondii cDNA, clone: XTG07019.2, full cDNA, XTG Sugano cDNA library	blastn	84	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
7595107	7595107	PRJNA797475_P_NODE_9926_length_332_cov_4.926641_g9827_i0	PRJNA797475	9926	332	4.926641	16.35644812	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	117	1.7699999999999996e-31	NR	VWU51230.1	2600580	g9827	i0	68.2	12.75	88	27	78.6	1	8	268	5	92	VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	4233	117	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
16083978	16083978	PRJNA797475_P_NODE_24773_length_247_cov_1.356322_g24674_i0	PRJNA797475	24773	247	1.356322	3.35011534	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|2795613622\|ref\|XM_068060841.1\|	483139	g24674	i0	100	0.11336032388664	28	0	11	0	20	47	3225	3252	Cystoisospora suis uncharacterized protein (CSUI_000608), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
17359876	17359876	PRJNA797475_P_NODE_27634_length_244_cov_0.900585_g27535_i0	PRJNA797475	27634	244	0.900585	2.1974274	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	77.4	2.34e-14	NR	KAF4645632.1	5811	g27535	i0	61.1	5.95081967213115	54	21	66.4	0	4	165	542	595	KAF4645632.1 aldehyde dehydrogenase [Toxoplasma gondii]	diamond	1452	77.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
27316050	27316050	PRJNA797475_P_NODE_26743_length_245_cov_0.895349_g26644_i0	PRJNA797475	26743	245	0.895349	2.19360505	Theileria	5873	SAR_Eukaryotes	SAR_Eukaryotes	50.1	9.23e-5	NR	XP_954833.1	5874	g26644	i0	33.8	2.48571428571429	71	46	85.7	1	36	245	182	252	XP_954833.1 polyphosphoinositol binding protein, putative [Theileria annulata]	diamond	609	50.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria annulata
30085381	30085381	PRJNA797475_P_NODE_12592_length_301_cov_1.635965_g12493_i0	PRJNA797475	12592	301	1.635965	4.92425465	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	89.7	4.91e-20	NR	XP_013334640.1	5804	g12493	i0	56.8	4.0265780730897	81	35	80.7	0	248	6	1	81	XP_013334640.1 60S ribosomal protein L10a, putative [Eimeria maxima]	diamond	1212	89.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
30211696	30211696	PRJNA797475_P_NODE_4432_length_474_cov_4.451372_g4334_i0	PRJNA797475	4432	474	4.451372	21.09950328	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	197	9.099999999999999e-61	NR	OEH76901.1	88456	g4334	i0	66	3.9493670886076	156	53	98.7	0	5	472	29	184	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	1872	197	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
30749000	30749000	PRJNA797475_P_NODE_5294_length_437_cov_1.247253_g5196_i0	PRJNA797475	5294	437	1.247253	5.45049561	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	75.5	6.9e-14	NR	XP_013235093.1	5802	g5196	i0	42.2	1.40045766590389	102	47	61.8	3	391	122	1	102	XP_013235093.1 translationally-controlled tumor protein, putative [Eimeria tenella]	diamond	612	75.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
31887126	31887126	PRJNA797475_P_NODE_18437_length_266_cov_1.300518_g18338_i0	PRJNA797475	18437	266	1.300518	3.45937788	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	48.1	5.88e-4	NR	XP_067925506.1	483139	g18338	i0	36	1.73684210526316	86	36	75.6	2	201	1	56	141	XP_067925506.1 snap protein (soluble n-ethylmaleimide-sensitive factor attachment protein) [Cystoisospora suis]	diamond	462	48.1	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);;