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

5 rows where bioproject = "PRJNA1146029", 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
290077	290077	PRJNA1146029_P_NODE_18001_length_248_cov_0.880000_g17720_i0	PRJNA1146029	18001	248	0.88	2.1824	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	134	7.79e-27	NTclustered	gi\|1624694795\|ref\|XM_029012269.1\|	189622	g17720	i0	82.895	5.58467741935484	152	22	60	4	42	191	353	204	Babesia ovata 60S ribosomal protein L44 (BOVATA_033520), partial mRNA	blastn	1385	134	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
27860124	27860124	PRJNA1146029_P_NODE_17125_length_249_cov_1.431818_g16844_i0	PRJNA1146029	17125	249	1.431818	3.56522682	Plasmodium fragile	5857	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0311	NR	XP_012336853.1	5857	g16844	i0	39.6	0.63855421686747	53	32	63.9	0	64	222	694	746	XP_012336853.1 uncharacterized protein AK88_03820 [Plasmodium fragile]	diamond	159	43.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium fragile
30544558	30544558	PRJNA1146029_P_NODE_9353_length_298_cov_1.026667_g9072_i0	PRJNA1146029	9353	298	1.026667	3.05946766	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	94.4	1.1e-20	NR	XP_067922602.1	483139	g9072	i0	48.5	4.66107382550336	97	50	97.7	0	2	292	103	199	XP_067922602.1 60s acidic ribosomal protein p0 [Cystoisospora suis]	diamond	1389	94.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
31081725	31081725	PRJNA1146029_P_NODE_19995_length_244_cov_6.403509_g19714_i0	PRJNA1146029	19995	244	6.403509	15.62456196	Cryptosporidium hominis TU5	237895	SAR_Eukaryotes	SAR_Eukaryotes	59.7	4.04e-9	NR	XP_664835.1	353151	g19714	i0	60.3	1.38934426229508	58	23	71.3	0	51	224	71	128	XP_664835.1 LacOPZ-alpha peptide from pUC9 [Cryptosporidium hominis TU502]	diamond	339	59.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
31998819	31998819	PRJNA1146029_P_NODE_21598_length_242_cov_0.911243_g21317_i0	PRJNA1146029	21598	242	0.911243	2.20520806	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	80.9	1.41e-15	NR	CAL7865035.1	1344799	g21317	i0	47.1	0.84297520661157	68	32	79.3	2	3	194	2332	2399	CAL7865035.1 unnamed protein product [Sarcocystis calchasi]	diamond	204	80.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi

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