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

9 rows where analysis = "blastn", bioproject = "PRJNA876641" 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
8506120	8506120	PRJNA876641_P_NODE_19727_length_246_cov_0.890173_g19653_i0	PRJNA876641	19727	246	0.890173	2.18982558	Goussia balatonica	947538	SAR_Eukaryotes	SAR_Eukaryotes	115	2.79e-21	NTclustered	gi\|324022100\|gb\|GU593717.1\|	947538	g19653	i0	83.898	19.7926829268293	118	18	48	1	12	129	1565	1449	Goussia balatonica strain 608 28S ribosomal RNA gene, partial sequence	blastn	4869	115	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia balatonica
9781101	9781101	PRJNA876641_P_NODE_22408_length_242_cov_0.911243_g22334_i0	PRJNA876641	22408	242	0.911243	2.20520806	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	215	2.63e-51	NTclustered	gi\|1084954590\|ref\|XM_018783222.1\|	647221	g22334	i0	83.404	12.5123966942149	235	35	96	4	10	242	1145	1377	Plasmodium gaboni heat shock protein 70 partial mRNA	blastn	3028	215	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
17431250	17431250	PRJNA876641_P_NODE_11934_length_271_cov_1.297980_g11860_i0	PRJNA876641	11934	271	1.29798	3.5175258	Plasmodium gonderi	77519	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.025	NTclustered	gi\|1620951707\|ref\|XM_028687915.1\|	77519	g11860	i0	100	0.103321033210332	28	0	10	0	119	146	3591	3564	Plasmodium gonderi hypothetical protein, conserved (PGO_093270), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gonderi
18704623	18704623	PRJNA876641_P_NODE_21695_length_243_cov_0.905882_g21621_i0	PRJNA876641	21695	243	0.905882	2.20129326	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	130	9.84e-26	NTclustered	gi\|1620150562\|ref\|XM_028678648.1\|	85471	g21621	i0	84.328	10.5144032921811	134	19	55	2	1	133	592	460	Plasmodium relictum polyubiquitin, putative (PRELSG_1312500), partial mRNA	blastn	2555	130	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
19089968	19089968	PRJNA876641_P_NODE_4215_length_372_cov_1.561873_g4141_i0	PRJNA876641	4215	372	1.561873	5.81016756	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	239	2.53e-58	NTclustered	gi\|1673114745\|ref\|XM_029362621.1\|	94643	g4141	i0	79.37	28.752688172043	349	64	93	6	16	360	508	852	Besnoitia besnoiti putative vacuolar ATP synthase subunit b (BESB_040350), partial mRNA	blastn	10696	239	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
19979799	19979799	PRJNA876641_P_NODE_15196_length_253_cov_1.561111_g15122_i0	PRJNA876641	15196	253	1.561111	3.94961083	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|1145259945\|ref\|XM_012907873.2\|	5854	g15122	i0	96.97	0.130434782608696	33	0	13	1	32	64	29	60	Plasmodium reichenowi hypothetical protein partial mRNA	blastn	33	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
21640601	21640601	PRJNA876641_P_NODE_8477_length_291_cov_1.793578_g8403_i0	PRJNA876641	8477	291	1.793578	5.21931198	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	200	9.1e-47	NTclustered	gi\|1844510932\|ref\|XM_022955376.2\|	5861	g8403	i0	90.728	37.1443298969072	151	12	52	2	2	151	274	423	Plasmodium yoelii polyubiquitin, putative (PY17X_0612800), partial mRNA	blastn	10809	200	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
22916170	22916170	PRJNA876641_P_NODE_8238_length_294_cov_1.601810_g8164_i0	PRJNA876641	8238	294	1.60181	4.7093214	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	134	9.47e-27	NTclustered	gi\|1843566470\|ref\|XM_034568516.1\|	5823	g8164	i0	88.393	18.187074829932	112	11	38	2	182	292	402	292	Plasmodium berghei ANKA histone H3, putative (PBANKA_0108800), partial mRNA	blastn	5347	134	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
25079302	25079302	PRJNA876641_P_NODE_23460_length_241_cov_0.916667_g23386_i0	PRJNA876641	23460	241	0.916667	2.20916747	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|921121132\|ref\|XM_013579730.1\|	51315	g23386	i0	100	0.116182572614108	28	0	12	0	10	37	317	344	Eimeria necatrix hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix

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