metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA315314" 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
1655738	1655738	PRJNA315314_S_NODE_3082_length_452_cov_10.947991_g2764_i0	PRJNA315314	3082	452	10.947991	49.48491932	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	59.3	4.51e-7	NR	KAI4839932.1	5824	g2764	i0	40.7	1.81194690265487	91	41	60.4	2	452	180	33	110	KAI4839932.1 hypothetical protein MKS88_001284 [Plasmodium brasilianum]	diamond	819	59.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium brasilianum
15093053	15093053	PRJNA315314_S_NODE_27692_length_160_cov_2.618321_g27371_i0	PRJNA315314	27692	160	2.618321	4.1893136	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	68.6	9.4e-13	NR	XP_013251003.1	5801	g27371	i0	93.8	10.8	32	2	60	0	158	63	130	161	XP_013251003.1 40S ribosomal protein S15A, putative [Eimeria acervulina]	diamond	1728	68.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
27137101	27137101	PRJNA315314_S_NODE_16882_length_200_cov_2.807018_g16561_i0	PRJNA315314	16882	200	2.807018	5.614036	Toxoplasma gondii ME49	508771	SAR_Eukaryotes	SAR_Eukaryotes	95.1	6.949999999999999e-23	NR	XP_002367420.1	508771	g16561	i0	70	1.74	60	18	90	0	200	21	63	122	XP_002367420.1 translation initiation factor eIF-5A, putative [Toxoplasma gondii ME49]	diamond	348	95.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
28576112	28576112	PRJNA315314_S_NODE_30307_length_154_cov_2.912000_g29986_i0	PRJNA315314	30307	154	2.912	4.48448	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	1.02e-6	NR	KAF8822859.1	476202	g29986	i0	68.8	10.6168831168831	32	10	62.3	0	153	58	122	153	KAF8822859.1 ribosomal protein RPS18 [Cardiosporidium cionae]	diamond	1635	53.1	0.994350282485876	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
29113007	29113007	PRJNA315314_S_NODE_28268_length_159_cov_1.100000_g27947_i0	PRJNA315314	28268	159	1.1	1.749	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	59.7	9.68e-9	NR	OEH79184.1	88456	g27947	i0	51	5.71698113207547	51	25	96.2	0	2	154	127	177	OEH79184.1 ribosomal protein [Cyclospora cayetanensis]	diamond	909	59.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
29316426	29316426	PRJNA315314_S_NODE_25889_length_165_cov_1.808824_g25568_i0	PRJNA315314	25889	165	1.808824	2.9845596	Babesia microti strain RI	1133968	SAR_Eukaryotes	SAR_Eukaryotes	74.3	9.45e-14	NR	XP_021338005.1	1133968	g25568	i0	63	6.87272727272727	54	20	98.2	0	165	4	182	235	XP_021338005.1 mitochondrial processing peptidase [Babesia microti strain RI]	diamond	1134	74.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti
30074187	30074187	PRJNA315314_S_NODE_26672_length_163_cov_1.574627_g26351_i0	PRJNA315314	26672	163	1.574627	2.56664201	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	70.9	6.9e-13	NR	XP_067802156.1	323732	g26351	i0	61.1	4.96932515337423	54	21	99.4	0	162	1	188	241	XP_067802156.1 bifunctional Ribosomal protein L7A-L8/Ribosomal protein L7Ae-L30e-S12e-Gadd45/Ribosomal protein L7Ae conserved site/Ribosomal protein L7Ae-L8-Nhp2 family/50S ribosomal protein L30e-like [Babesia duncani]	diamond	810	70.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
31939170	31939170	PRJNA315314_S_NODE_23637_length_172_cov_1.286713_g23316_i0	PRJNA315314	23637	172	1.286713	2.21314636	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	78.6	3.39e-15	NR	OEH74436.1	88456	g23316	i0	61.4	2.98255813953488	57	22	99.4	0	172	2	140	196	OEH74436.1 vacuolar atp synthase subunit a [Cyclospora cayetanensis]	diamond	513	78.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
32305142	32305142	PRJNA315314_S_NODE_10779_length_247_cov_1.908257_g10458_i0	PRJNA315314	10779	247	1.908257	4.71339479	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	106	5.58e-26	NR	XP_028868039.1	189622	g10458	i0	61	27.9109311740891	82	32	99.6	0	247	2	130	211	XP_028868039.1 40S ribosomal protein S3 [Babesia ovata]	diamond	6894	107	0.990654205607477	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
32886767	32886767	PRJNA315314_S_NODE_17300_length_198_cov_1.757396_g16979_i0	PRJNA315314	17300	198	1.757396	3.47964408	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	55.8	1.8e-7	NR	XP_011130323.1	110365	g16979	i0	54.4	1.86363636363636	57	26	86.4	0	198	28	48	104	XP_011130323.1 translationally-controlled tumor-like protein [Gregarina niphandrodes]	diamond	369	55.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes

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