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

5 rows where bioproject = "PRJNA1126198", 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
281376	281376	PRJNA1126198_P_NODE_286061_length_269_cov_1.352041_g285340_i0	PRJNA1126198	286061	269	1.352041	3.63699029	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	110	8.3e-26	NR	XP_013247786.1	5801	g285340	i0	69.9	4.92936802973978	73	22	81.4	0	8	226	451	523	XP_013247786.1 ATP-dependent RNA helicase, putative [Eimeria acervulina]	diamond	1326	111	0.990990990990991	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
1556176	1556176	PRJNA1126198_P_NODE_386582_length_250_cov_0.881356_g385861_i0	PRJNA1126198	386582	250	0.881356	2.20339	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.87e-4	NTclustered	gi\|916416619\|ref\|XM_013374087.1\|	5802	g385861	i0	100	12.06	31	0	12	0	122	152	1158	1188	Eimeria tenella kelch motif domain-containing protein, putative (ETH_00008020), partial mRNA	blastn	3015	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
6658978	6658978	PRJNA1126198_P_NODE_167686_length_305_cov_1.344828_g166966_i0	PRJNA1126198	167686	305	1.344828	4.1017254	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	302	2.56e-77	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g166966	i0	84.478	32.2	335	21	100	9	1	305	300359	300692	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	9821	302	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
21957871	21957871	PRJNA1126198_P_NODE_130298_length_323_cov_1.736000_g129579_i0	PRJNA1126198	130298	323	1.736	5.60728	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	168	6.79e-49	NR	AFV39095.1	93969	g129579	i0	73.8	3.98452012383901	107	28	99.4	0	321	1	79	185	AFV39095.1 glutamate tRNA ligase, partial [Cryptosporidium meleagridis]	diamond	1287	168	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium meleagridis
31966711	31966711	PRJNA1126198_P_NODE_164558_length_306_cov_1.982833_g163838_i0	PRJNA1126198	164558	306	1.982833	6.06746898	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	57.4	4.53e-7	NR	XP_002140143.1	441375	g163838	i0	35.7	0.823529411764706	84	53	81.4	1	52	300	5	88	XP_002140143.1 synaptobrevin family protein [Cryptosporidium muris RN66]	diamond	252	57.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris

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