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

9 rows where bioproject = "PRJNA944406", 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
1259512	1259512	PRJNA944406_P_NODE_64541_length_251_cov_0.865169_g63582_i0	PRJNA944406	64541	251	0.865169	2.17157419	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	165	2.8e-36	NTclustered	gi\|1941259314\|gb\|MW349707.1\|	59669	g63582	i0	92.92	45.0199203187251	113	8	45	0	136	248	1424	1312	Sarcocystis sp. isolate Af1 large subunit ribosomal RNA gene, partial sequence	blastn	11300	165	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis sp.
4752490	4752490	PRJNA944406_P_NODE_105384_length_242_cov_0.911243_g104425_i0	PRJNA944406	105384	242	0.911243	2.20520806	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|1673119919\|ref\|XM_029365989.1\|	94643	g104425	i0	100	0.115702479338843	28	0	12	0	215	242	148	121	Besnoitia besnoiti uncharacterized protein (BESB_076280), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
6028288	6028288	PRJNA944406_P_NODE_93245_length_244_cov_1.801170_g92286_i0	PRJNA944406	93245	244	1.80117	4.3948548	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	182	2.689999999999999e-41	NTclustered	gi\|82596320\|ref\|XM_721120.1\|	5861	g92286	i0	81.651	16.233606557377	218	40	89	0	27	244	688	471	Plasmodium yoelii tubulin subunit beta (PY17X_1210100), partial mRNA	blastn	3961	182	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
8912194	8912194	PRJNA944406_P_NODE_21527_length_290_cov_1.419355_g20568_i0	PRJNA944406	21527	290	1.419355	4.1161295	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	224	5.38e-54	NTclustered	gi\|2785759117\|ref\|XM_067214320.1\|	5824	g20568	i0	81.752	76.779310344827607	274	44	93	6	5	275	722	452	Plasmodium brasilianum heat shock protein 70 (MKS88_001399), partial mRNA	blastn	22266	224	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium brasilianum
18775986	18775986	PRJNA944406_P_NODE_13755_length_343_cov_3.085185_g12796_i0	PRJNA944406	13755	343	3.085185	10.58218455	Goussia bayae	2303416	SAR_Eukaryotes	SAR_Eukaryotes	193	1.83e-44	NTclustered	gi\|1450318675\|gb\|MH758782.1\|	2303416	g12796	i0	78.086	104.069970845481	324	57	93	11	15	333	1310	1624	Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence	blastn	35696	193	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia bayae
21326355	21326355	PRJNA944406_P_NODE_14757_length_333_cov_3.238462_g13798_i0	PRJNA944406	14757	333	3.238462	10.78407846	Gregarina sp. Phaedon/Daegwallyeong/2010	1049247	SAR_Eukaryotes	SAR_Eukaryotes	233	1.04e-56	NTclustered	gi\|339715944\|gb\|JF412715.1\|	1049247	g13798	i0	86.301	68.1261261261261	219	24	65	4	118	333	4291	4506	Gregarina sp. Phaedon/Daegwallyeong/2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence	blastn	22686	233	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina sp. Phaedon/Daegwallyeong/2010
22601602	22601602	PRJNA944406_P_NODE_42038_length_270_cov_3.248731_g41079_i0	PRJNA944406	42038	270	3.248731	8.7715737	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	67.6	8.84e-7	NTclustered	gi\|820690367\|tpe\|LN714481.1\|	572307	g41079	i0	95.238	0.155555555555556	42	2	16	0	229	270	2653520	2653561	TPA_asm: Neospora caninum Liverpool, chromosome chrVIIa, complete genome	blastn	42	67.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
28162496	28162496	PRJNA944406_P_NODE_49365_length_264_cov_1.235602_g48406_i0	PRJNA944406	49365	264	1.235602	3.26198928	Babesia bovis T2Bo	484906	SAR_Eukaryotes	SAR_Eukaryotes	54.3	4.05e-6	NR	XP_001612222.1	484906	g48406	i0	34.5	2.625	87	48	96.6	2	264	10	330	409	XP_001612222.1 histone deacetylase family protein [Babesia bovis T2Bo]	diamond	693	54.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
29614465	29614465	PRJNA944406_P_NODE_73270_length_249_cov_0.875000_g72311_i0	PRJNA944406	73270	249	0.875	2.17875	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	105	4.1800000000000005e-27	NR	CAL7860326.1	1344799	g72311	i0	65.8	4.67469879518072	76	26	91.6	0	232	5	41	116	CAL7860326.1 unnamed protein product [Sarcocystis calchasi]	diamond	1164	105	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);;