metadata: contig_metadata: 7 rows where bioproject = "PRJNA356682", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA356682", 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
2947830	2947830	PRJNA356682_P_NODE_10523_length_431_cov_2.689944_g9833_i0	PRJNA356682	10523	431	2.689944	11.59365864	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	274	8.15e-69	NTclustered	gi\|1673113577\|ref\|XM_029362037.1\|	94643	g9833	i0	79.075	77.046403712297	411	76	94	8	6	411	618	213	Besnoitia besnoiti ribosomal protein RPL10A (BESB_034510), partial mRNA	blastn	33207	274	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
4224917	4224917	PRJNA356682_P_NODE_35104_length_253_cov_1.711111_g34413_i0	PRJNA356682	35104	253	1.711111	4.32911083	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	134	3.61e-34	NR	XP_627193.1	353152	g34413	i0	78.3	6.9604743083004	83	18	98.4	0	249	1	286	368	XP_627193.1 Eft2p GTpase; translation elongation factor 2 (EF-2), partial [Cryptosporidium parvum Iowa II]	diamond	1761	135	0.992592592592593	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
10601493	10601493	PRJNA356682_P_NODE_36469_length_250_cov_3.016949_g35778_i0	PRJNA356682	36469	250	3.016949	7.5423725	Theileria equi	5872	SAR_Eukaryotes	SAR_Eukaryotes	121	6.12e-23	NTclustered	gi\|510901943\|ref\|XM_004829571.1\|	1537102	g35778	i0	84.677	13.248	124	15	49	4	13	134	276	155	Theileria equi strain WA histone H2b, putative (BEWA_028110), mRNA	blastn	3312	121	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
11275730	11275730	PRJNA356682_P_NODE_42629_length_243_cov_1.358824_g41938_i0	PRJNA356682	42629	243	1.358824	3.30194232	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	125	1.0099999999999999e-32	NR	XP_067925573.1	483139	g41938	i0	78.8	2.96296296296296	80	17	98.8	0	241	2	241	320	XP_067925573.1 40s ribosomal protein [Cystoisospora suis]	diamond	720	126	0.992063492063492	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
13151101	13151101	PRJNA356682_P_NODE_21931_length_310_cov_1.624473_g21240_i0	PRJNA356682	21931	310	1.624473	5.0358663	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	215	3.49e-51	NTclustered	gi\|1673115679\|ref\|XM_029363146.1\|	94643	g21240	i0	84.651	70.1806451612903	215	33	69	0	57	271	418	204	Besnoitia besnoiti ribosomal protein RPS15 (BESB_046950), partial mRNA	blastn	21756	215	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
28008125	28008125	PRJNA356682_P_NODE_47585_length_202_cov_4.294574_g46894_i0	PRJNA356682	47585	202	4.294574	8.67503948	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	112	1.63e-29	NR	KAK9170867.1	93969	g46894	i0	83.3	3.90594059405941	66	11	98	0	1	198	2	67	KAK9170867.1 Ribosomal protein S4/S9 [Cryptosporidium meleagridis]	diamond	789	112	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium meleagridis
32715601	32715601	PRJNA356682_P_NODE_17220_length_344_cov_1.933579_g16529_i0	PRJNA356682	17220	344	1.933579	6.65151176	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	155	4.159999999999999e-46	NR	KAF7456264.1	83540	g16529	i0	67.5	3.96802325581395	114	37	99.4	0	2	343	4	117	KAF7456264.1 putative 40S ribosomal protein S24 [Cryptosporidium felis]	diamond	1365	155	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium felis

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