metadata: contig_metadata: 15 rows where bioproject = "PRJNA1115053" and tax

15 rows where bioproject = "PRJNA1115053" 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
5330480	5330480	PRJNA1115053_S_NODE_320205_length_156_cov_1.699115_g318388_i0	PRJNA1115053	320205	156	1.699115	2.6506194	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.013	NTclustered	gi\|915003695\|ref\|XM_013393730.1\|	5801	g318388	i0	96.875	0.205128205128205	32	0	20	1	35	65	229	260	Eimeria acervulina hypothetical protein, conserved partial mRNA	blastn	32	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
5331978	5331978	PRJNA1115053_S_NODE_60265_length_314_cov_5.003690_g58448_i0	PRJNA1115053	60265	314	5.00369	15.7115866	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	508	1.45e-139	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g58448	i0	96.178	37.1019108280255	314	7	100	4	1	314	193	501	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	11650	508	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
6601111	6601111	PRJNA1115053_S_NODE_126586_length_235_cov_8.661458_g124769_i0	PRJNA1115053	126586	235	8.661458	20.3544263	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	387	5.08e-103	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g124769	i0	96.596	35.5446808510638	235	5	100	2	1	235	333	102	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	8353	387	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
9150950	9150950	PRJNA1115053_S_NODE_13528_length_527_cov_1788.493802_g11795_i0	PRJNA1115053	13528	527	1788.493802	9425.36233654	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	451	4.36e-122	NTclustered	gi\|27764590\|gb\|AY180902.1\|	5821	g11795	i0	100	80.111954459203	244	0	81	0	51	294	928	685	Plasmodium berghei 31 kDa antigen mRNA, complete cds	blastn	42219	451	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
15051823	15051823	PRJNA1115053_S_NODE_115112_length_245_cov_1.425743_g113295_i0	PRJNA1115053	115112	245	1.425743	3.49307035	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.75e-4	NTclustered	gi\|1084780983\|ref\|XM_018784089.1\|	647221	g113295	i0	92.683	0.33469387755102	41	2	17	1	26	66	2523	2484	Plasmodium gaboni hypothetical protein partial mRNA	blastn	82	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
20624889	20624889	PRJNA1115053_S_NODE_157857_length_215_cov_1.093023_g156040_i0	PRJNA1115053	157857	215	1.093023	2.34999945	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.019	NTclustered	gi\|1843571751\|ref\|XM_034565646.1\|	5823	g156040	i0	100	0.130232558139535	28	0	13	0	76	103	1226	1253	Plasmodium berghei ANKA conserved Plasmodium protein, unknown function (PBANKA_1111500), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
20630663	20630663	PRJNA1115053_S_NODE_83197_length_278_cov_8.744681_g81380_i0	PRJNA1115053	83197	278	8.744681	24.31021318	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	158	5.2699999999999985e-34	NTclustered	gi\|2560612139\|gb\|OR419798.1\|	5807	g81380	i0	84.118	65.6870503597122	170	20	60	6	1	168	4280	4116	Cryptosporidium parvum small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	18261	158	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
22701635	22701635	PRJNA1115053_S_NODE_66778_length_302_cov_96.853282_g64961_i0	PRJNA1115053	66778	302	96.853282	292.49691164	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	481	3.03e-131	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g64961	i0	95.364	1196.37748344371	302	14	100	0	1	302	121	422	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	361306	481	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
23177590	23177590	PRJNA1115053_S_NODE_221099_length_185_cov_2.704225_g219282_i0	PRJNA1115053	221099	185	2.704225	5.00281625	Theileria equi	5872	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.016	NTclustered	gi\|510899745\|ref\|XM_004828559.1\|	1537102	g219282	i0	94.286	0.189189189189189	35	1	19	1	18	52	411	378	Theileria equi strain WA hypothetical protein (BEWA_017910), partial mRNA	blastn	35	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
27289249	27289249	PRJNA1115053_S_NODE_151183_length_219_cov_1.090909_g149366_i0	PRJNA1115053	151183	219	1.090909	2.38909071	Plasmodium falciparum Tanzania (2	5833	SAR_Eukaryotes	SAR_Eukaryotes	40.8	0.0435	NR	ETW37537.1	1036725	g149366	i0	38.2	0.753424657534247	55	32	72.6	1	54	212	29	83	ETW37537.1 hypothetical protein PFTANZ_01719 [Plasmodium falciparum Tanzania (2000708)]	diamond	165	40.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
28520847	28520847	PRJNA1115053_S_NODE_61867_length_311_cov_4.119403_g60050_i0	PRJNA1115053	61867	311	4.119403	12.81134333	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	56.6	1.03e-6	NR	XP_067922122.1	483139	g60050	i0	47.9	2.29581993569132	48	25	46.3	0	2	145	324	371	XP_067922122.1 adp atp translocase 1 [Cystoisospora suis]	diamond	714	56.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
28994632	28994632	PRJNA1115053_S_NODE_120648_length_240_cov_2.436548_g118831_i0	PRJNA1115053	120648	240	2.436548	5.8477152	Babesia caballi	5871	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0497	NR	XP_067714772.1	5871	g118831	i0	37.7	0.6625	53	33	66.3	0	210	52	468	520	XP_067714772.1 phosphoenolpyruvate synthase [Babesia caballi]	diamond	159	42.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia caballi
31774672	31774672	PRJNA1115053_S_NODE_255997_length_174_cov_1.022901_g254180_i0	PRJNA1115053	255997	174	1.022901	1.77984774	Plasmodium vivax	5855	SAR_Eukaryotes	SAR_Eukaryotes	54.3	1.23e-7	NR	CAA67111.1	5855	g254180	i0	52.2	0.793103448275862	46	22	79.3	0	28	165	2	47	CAA67111.1 PV14 [Plasmodium vivax]	diamond	138	54.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vivax
32249723	32249723	PRJNA1115053_S_NODE_79858_length_283_cov_1.800000_g78041_i0	PRJNA1115053	79858	283	1.8	5.094	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0463	NR	XP_029216990.1	94643	g78041	i0	41.8	0.710247349823322	67	33	64.7	2	256	74	1357	1423	XP_029216990.1 hypothetical protein BESB_081800 [Besnoitia besnoiti]	diamond	201	43.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
32817631	32817631	PRJNA1115053_S_NODE_125600_length_236_cov_2.487047_g123783_i0	PRJNA1115053	125600	236	2.487047	5.86943092	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0471	NR	CAL7866116.1	1344799	g123783	i0	35.7	0.889830508474576	70	35	76.3	3	185	6	186	255	CAL7866116.1 unnamed protein product [Sarcocystis calchasi]	diamond	210	42.4	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);;