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

9 rows where bioproject = "PRJNA1158727", 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
1577813	1577813	PRJNA1158727_P_NODE_104682_length_286_cov_1.446009_g97221_i0	PRJNA1158727	104682	286	1.446009	4.13558574	Eimeria praecox	51316	SAR_Eukaryotes	SAR_Eukaryotes	99	4.5e-23	NR	CDI80419.1	51316	g97221	i0	48.4	3.73426573426573	95	46	99.7	1	1	285	79	170	CDI80419.1 thioredoxin, putative [Eimeria praecox]	diamond	1068	99	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria praecox
11782360	11782360	PRJNA1158727_P_NODE_128510_length_258_cov_1.237838_g121049_i0	PRJNA1158727	128510	258	1.237838	3.19362204	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	350	7.44e-92	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g121049	i0	91.667	49.6046511627907	252	21	100	0	4	255	300686	300435	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	12798	350	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
11784693	11784693	PRJNA1158727_P_NODE_64610_length_400_cov_0.987768_g57149_i0	PRJNA1158727	64610	400	0.987768	3.951072	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	695	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g57149	i0	98	699.35	400	8	100	0	1	400	769	370	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	279740	695	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
14332205	14332205	PRJNA1158727_P_NODE_106832_length_283_cov_1.828571_g99371_i0	PRJNA1158727	106832	283	1.828571	5.17485593	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	335	2.319999999999999e-87	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g99371	i0	87.986	1	283	34	100	0	1	283	157420	157138	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	283	335	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20705736	20705736	PRJNA1158727_P_NODE_160597_length_242_cov_0.911243_g153135_i0	PRJNA1158727	160597	242	0.911243	2.20520806	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	448	2.3799999999999995e-121	NTclustered	gi\|124511707\|ref\|XM_001348951.1\|	36329	g153135	i0	100	4	242	0	100	0	1	242	1825	2066	Plasmodium falciparum 3D7 DNA replication licensing factor MCM7 (PF3D7_0705400), partial mRNA	blastn	968	448	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
21982891	21982891	PRJNA1158727_P_NODE_65318_length_396_cov_1.430341_g57857_i0	PRJNA1158727	65318	396	1.430341	5.66415036	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	122	7.6e-33	NR	XP_028876282.1	857276	g57857	i0	61.6	2.23484848484848	99	38	75	0	19	315	3	101	XP_028876282.1 histone H4 [Cryptosporidium ubiquitum]	diamond	885	122	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
24529818	24529818	PRJNA1158727_P_NODE_133820_length_252_cov_1.312849_g126359_i0	PRJNA1158727	133820	252	1.312849	3.30837948	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	111	1.37e-28	NR	SOV82142.1	5854	g126359	i0	67.1	8.52380952380952	82	27	97.6	0	7	252	7	88	SOV82142.1 60S ribosomal protein L17, putative [Plasmodium reichenowi]	diamond	2148	112	0.991071428571429	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
28303671	28303671	PRJNA1158727_P_NODE_146366_length_247_cov_0.885057_g138904_i0	PRJNA1158727	146366	247	0.885057	2.18609079	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	92.4	9.84e-20	NR	XP_002141413.1	441375	g138904	i0	47.4	0.947368421052632	78	40	93.5	1	1	231	71	148	XP_002141413.1 eukaryotic translation initiation factor 5, putative [Cryptosporidium muris RN66]	diamond	234	92.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
28828049	28828049	PRJNA1158727_P_NODE_133808_length_252_cov_1.335196_g126347_i0	PRJNA1158727	133808	252	1.335196	3.36469392	root	1	Root_unresolved	Root_unresolved	132	3.4e-37	NR	XP_013336607.1	5804	g126347	i0	75.9	543.440476190476	83	20	98.8	0	3	251	5	87	XP_013336607.1 polyubiquitin, putative, partial [Eimeria maxima]	diamond	136947	132	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima

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