metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA796753" 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
3331733	3331733	PRJNA796753_P_NODE_23083_length_311_cov_1.142857_g22771_i0	PRJNA796753	23083	311	1.142857	3.55428527	Babesia vogeli	2705332	SAR_Eukaryotes	SAR_Eukaryotes	180	1.2799999999999996e-40	NTclustered	gi\|146134153\|gb\|EF527401.1\|	2705332	g22771	i0	78	52.7395498392283	300	56	95	9	8	302	1000	1294	Babesia canis vogeli heat shock protein 70 (hsp70) gene, complete cds	blastn	16402	180	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia vogeli
5044871	5044871	PRJNA796753_P_NODE_47964_length_245_cov_0.895349_g47652_i0	PRJNA796753	47964	245	0.895349	2.19360505	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	172	1.63e-38	NTclustered	gi\|1027954050\|ref\|XM_736288.2\|	31271	g47652	i0	82.126	8.39183673469388	207	31	83	6	26	229	841	1044	Plasmodium chabaudi chabaudi heat shock protein 90, putative (PCHAS_0806000), partial mRNA	blastn	2056	172	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
7159036	7159036	PRJNA796753_P_NODE_23706_length_307_cov_1.974359_g23394_i0	PRJNA796753	23706	307	1.974359	6.06128213	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	244	4.4e-60	NTclustered	gi\|915123364\|ref\|XM_013477492.1\|	5804	g23394	i0	81.481	14.3745928338762	297	55	97	0	9	305	414	118	Eimeria maxima ribosomal protein S23, putative partial mRNA	blastn	4413	244	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
8433730	8433730	PRJNA796753_P_NODE_20147_length_328_cov_1.811765_g19835_i0	PRJNA796753	20147	328	1.811765	5.9425892	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	272	2.1799999999999993e-68	NTclustered	gi\|1620113280\|ref\|XM_028675005.1\|	5849	g19835	i0	81.707	72.4207317073171	328	59	99	1	2	328	69	396	Plasmodium gallinaceum histone H3 variant, putative (H3.3), partial mRNA	blastn	23754	272	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
12260190	12260190	PRJNA796753_P_NODE_29810_length_281_cov_1.038462_g29498_i0	PRJNA796753	29810	281	1.038462	2.91807822	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.026	NTclustered	gi\|1145257511\|ref\|XM_012906439.2\|	5854	g29498	i0	100	0.099644128113879	28	0	10	0	8	35	6089	6062	Plasmodium reichenowi hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
14809314	14809314	PRJNA796753_P_NODE_40092_length_250_cov_1.711864_g39780_i0	PRJNA796753	40092	250	1.711864	4.27966	Plasmodium fragile	5857	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|817739014\|ref\|XM_012479039.1\|	5857	g39780	i0	100	0.112	28	0	11	0	142	169	7075	7048	Plasmodium fragile uncharacterized protein (AK88_01404), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium fragile
16083354	16083354	PRJNA796753_P_NODE_52693_length_242_cov_0.911243_g52381_i0	PRJNA796753	52693	242	0.911243	2.20520806	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	220	5.65e-53	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g52381	i0	83.983	24.2892561983471	231	35	99	2	9	237	300507	300737	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	5878	220	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
22457867	22457867	PRJNA796753_P_NODE_36698_length_258_cov_1.178378_g36386_i0	PRJNA796753	36698	258	1.178378	3.04021524	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.4e-4	NTclustered	gi\|915132034\|ref\|XM_013480208.1\|	5804	g36386	i0	100	0.124031007751938	32	0	12	0	130	161	1669	1700	Eimeria maxima Beta-fructofuranosidase-like protein, related partial mRNA	blastn	32	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
25007082	25007082	PRJNA796753_P_NODE_25160_length_299_cov_1.659292_g24848_i0	PRJNA796753	25160	299	1.659292	4.96128308	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	309	1.49e-79	NTclustered	gi\|1620150562\|ref\|XM_028678648.1\|	85471	g24848	i0	89.474	111.508361204013	247	23	82	3	4	248	702	457	Plasmodium relictum polyubiquitin, putative (PRELSG_1312500), partial mRNA	blastn	33341	309	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum

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