metadata: contig_metadata: 5 rows where bioproject = "PRJNA703759", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA703759", tax_clade = "Sar" 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
684744	684744	PRJNA703759_P_NODE_47121_length_244_cov_1.567251_g46645_i0	PRJNA703759	47121	244	1.567251	3.82409244	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	122	9.16e-31	NR	XP_012769366.1	5866	g46645	i0	70	147.110655737705	80	24	98.4	0	244	5	33	112	XP_012769366.1 ADP-ribosylation factor family protein, putative [Babesia bigemina]	diamond	35895	122	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
3235781	3235781	PRJNA703759_P_NODE_46963_length_244_cov_2.181287_g46487_i0	PRJNA703759	46963	244	2.181287	5.32234028	Babesia rodhaini	5870	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1606504052\|dbj\|AB665055.1\|	5870	g46487	i0	96.97	0.479508196721311	33	1	14	0	13	45	4271	4239	Babesia rodhaini apicoplast DNA, complete genome, strain: Australian	blastn	117	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia rodhaini
10888367	10888367	PRJNA703759_P_NODE_26829_length_278_cov_1.136585_g26353_i0	PRJNA703759	26829	278	1.136585	3.1597063	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	58.4	5.5e-4	NTclustered	gi\|915140275\|ref\|XM_013481871.1\|	5804	g26353	i0	97.059	0.122302158273381	34	1	12	0	26	59	2747	2714	Eimeria maxima hypothetical protein partial mRNA	blastn	34	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
13438420	13438420	PRJNA703759_P_NODE_43211_length_247_cov_0.896552_g42735_i0	PRJNA703759	43211	247	0.896552	2.21448344	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	62.1	3.71e-5	NTclustered	gi\|820688329\|tpe\|LN714474.1\|	572307	g42735	i0	97.222	4.1417004048583	36	1	15	0	8	43	1908964	1908929	TPA_asm: Neospora caninum Liverpool, chromosome chrIa, complete genome	blastn	1023	62.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14713444	14713444	PRJNA703759_P_NODE_33632_length_255_cov_1.285714_g33156_i0	PRJNA703759	33632	255	1.285714	3.2785707	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|1474771164\|gb\|MH107388.1\|	323732	g33156	i0	96.97	0.23921568627451	33	0	13	1	38	70	12686	12655	Babesia duncani isolate WA-1 apicoplast, complete genome	blastn	61	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani

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