metadata: contig_metadata: 7 rows where bioproject = "PRJNA1164198" and tax

7 rows where bioproject = "PRJNA1164198" 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
311963	311963	PRJNA1164198_P_NODE_17781_length_293_cov_1.545455_g17512_i0	PRJNA1164198	17781	293	1.545455	4.52818315	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	80.5	1.25e-10	NTclustered	gi\|379988059\|dbj\|AB649418.1\|	5858	g17512	i0	78	27.8430034129693	150	17	51	12	126	273	26427	26562	Plasmodium malariae apicoplast DNA, partial sequence, strain: Kisii67	blastn	8158	80.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
5415020	5415020	PRJNA1164198_P_NODE_14105_length_329_cov_3.531250_g13836_i0	PRJNA1164198	14105	329	3.53125	11.6178125	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	115	1.53e-30	NR	GFE54039.1	5869	g13836	i0	56.9	4.8145896656535	109	45	98.5	2	6	329	1	108	GFE54039.1 60S ribosomal protein L31 [Babesia ovis]	diamond	1584	115	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
16889133	16889133	PRJNA1164198_P_NODE_8454_length_429_cov_2.292135_g8192_i0	PRJNA1164198	8454	429	2.292135	9.83325915	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	244	6.36e-60	NTclustered	gi\|401402052\|ref\|XM_003881109.1\|	572307	g8192	i0	78.421	64.5198135198135	380	78	88	4	4	381	1	378	Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA	blastn	27679	244	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
28322932	28322932	PRJNA1164198_P_NODE_29186_length_245_cov_0.906977_g28917_i0	PRJNA1164198	29186	245	0.906977	2.22209365	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	94.7	3.9e-23	NR	XP_028534353.1	85471	g28917	i0	51.9	13.5061224489796	81	38	98	1	3	242	1	81	XP_028534353.1 thioredoxin 1, putative [Plasmodium relictum]	diamond	3309	95.5	0.991623036649215	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
29156506	29156506	PRJNA1164198_P_NODE_10749_length_379_cov_1.519608_g10481_i0	PRJNA1164198	10749	379	1.519608	5.75931432	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	157	1.4699999999999999e-43	NR	XP_004831395.1	1537102	g10481	i0	64.9	2.68337730870712	111	39	87.9	0	377	45	286	396	XP_004831395.1 S-adenosylmethionine synthetase, putative [Theileria equi strain WA]	diamond	1017	157	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
31734685	31734685	PRJNA1164198_P_NODE_29797_length_244_cov_0.906433_g29528_i0	PRJNA1164198	29797	244	0.906433	2.21169652	root	1	Root_unresolved	Root_unresolved	55.5	1.25e-6	NR	XP_002262494.2	5851	g29528	i0	60.5	2.68032786885246	43	17	52.9	0	243	115	589	631	XP_002262494.2 queuine tRNA-ribosyltransferase, putative [Plasmodium knowlesi strain H]	diamond	654	55.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
32253718	32253718	PRJNA1164198_P_NODE_24538_length_252_cov_1.765363_g24269_i0	PRJNA1164198	24538	252	1.765363	4.44871476	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	112	9.74e-29	NR	OEH76901.1	88456	g24269	i0	69	10	84	26	100	0	252	1	30	113	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	2520	112	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis

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