metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA874604" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA874604" 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
6341730	6341730	PRJNA874604_P_NODE_18245_length_418_cov_1.852174_g17893_i0	PRJNA874604	18245	418	1.852174	7.74208732	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	765	0	NTclustered	gi\|14495562\|gb\|L21708.2\|PFA34K	5821	g17893	i0	99.76	98.7488038277512	417	1	99	0	2	418	1311	895	Plasmodium berghei p23-like protein mRNA, partial cds	blastn	41277	767	0.997392438070404	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
6342045	6342045	PRJNA874604_P_NODE_58565_length_268_cov_2.010256_g58213_i0	PRJNA874604	58565	268	2.010256	5.38748608	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|915125604\|ref\|XM_013478612.1\|	5804	g58213	i0	96.97	0.242537313432836	33	0	12	1	58	90	4372	4341	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	65	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
10166957	10166957	PRJNA874604_P_NODE_94168_length_243_cov_0.905882_g93816_i0	PRJNA874604	94168	243	0.905882	2.20129326	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|820698309\|tpe\|LN714497.1\|	432359	g93816	i0	100	0.230452674897119	28	0	12	0	114	141	4695967	4695994	TPA_asm: Toxoplasma gondii VEG, chromosome chrVIIb, complete genome	blastn	56	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
11056482	11056482	PRJNA874604_P_NODE_87789_length_245_cov_0.895349_g87437_i0	PRJNA874604	87789	245	0.895349	2.19360505	Cryptosporidium hominis	237895	SAR_Eukaryotes	SAR_Eukaryotes	226	1.23e-54	NTclustered	gi\|67607323\|ref\|XM_661714.1\|	353151	g87437	i0	84.821	81.4040816326531	224	34	91	0	17	240	49	272	Cryptosporidium hominis TU502 hypothetical protein (Chro.20360) partial mRNA	blastn	19944	226	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
13605978	13605978	PRJNA874604_P_NODE_66411_length_254_cov_2.127072_g66059_i0	PRJNA874604	66411	254	2.127072	5.40276288	Babesia bigemina	5866	SAR_Eukaryotes	SAR_Eukaryotes	124	4.8199999999999996e-24	NTclustered	gi\|833485611\|ref\|XM_012912166.1\|	5866	g66059	i0	77.725	40.7125984251969	211	41	82	5	1	208	208	1	Babesia bigemina elongation factor 2, EF-2, putative partial mRNA	blastn	10341	124	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
13606562	13606562	PRJNA874604_P_NODE_95151_length_242_cov_1.467456_g94799_i0	PRJNA874604	95151	242	1.467456	3.55124352	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	67.6	7.78e-7	NTclustered	gi\|82593965\|ref\|XM_720134.1\|	5861	g94799	i0	75.13	8.85950413223141	193	23	78	15	44	231	4696	4868	Plasmodium yoelii ookinete protein (PY17X_0415800), partial mRNA	blastn	2144	67.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
13991701	13991701	PRJNA874604_P_NODE_29551_length_346_cov_2.959707_g29199_i0	PRJNA874604	29551	346	2.959707	10.24058622	root	1	Root_unresolved	Root_unresolved	640	5.4999999999999996e-179	NTclustered	gi\|937182978\|gb\|KR051079.1\|	5865	g29199	i0	100	84.9682080924856	346	0	100	0	1	346	3213	3558	Babesia bovis transgenic clone Segment23 elongation factor 1 alpha (ef-1a) gene, complete cds; gfp-bsd gene, complete sequence; and exon	blastn	29399	640	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis

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