metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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
20583851	20583851	PRJNA1068830_P_NODE_41697_length_343_cov_3.177778_g40994_i0	PRJNA1068830	41697	343	3.177778	10.89977854	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	117	7.259999999999999e-31	NR	XP_028876282.1	857276	g40994	i0	57.6	3.52478134110787	99	42	86.6	0	34	330	3	101	XP_028876282.1 histone H4 [Cryptosporidium ubiquitum]	diamond	1209	117	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
27415271	27415271	PRJNA1068830_P_NODE_73863_length_252_cov_0.871508_g73160_i0	PRJNA1068830	73863	252	0.871508	2.19620016	Babesia ovis	5869	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00368	NR	GFE52946.1	5869	g73160	i0	41.2	0.80952380952381	68	40	81	0	247	44	36	103	GFE52946.1 SNF7 family protein [Babesia ovis]	diamond	204	45.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
30098813	30098813	PRJNA1068830_P_NODE_9912_length_804_cov_2.265390_g9274_i0	PRJNA1068830	9912	804	2.26539	18.2137356	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	67.4	7.4e-9	NR	XP_028865435.1	189622	g9274	i0	44.8	1.00746268656716	67	36	24.6	1	455	258	2	68	XP_028865435.1 PP-loop family protein [Babesia ovata]	diamond	810	67.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
32398570	32398570	PRJNA1068830_P_NODE_28739_length_428_cov_1.752113_g28036_i0	PRJNA1068830	28739	428	1.752113	7.49904364	Piroplasmida	5863	SAR_Eukaryotes	SAR_Eukaryotes	186	6.22e-57	NR	KAK1441808.1	33632	g28036	i0	58.5	7.93457943925234	142	59	99.5	0	427	2	3	144	KAK1441808.1 ribosomal protein L22/L17 like protein [Babesia gibsoni]	diamond	3396	187	0.994652406417112	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
32722594	32722594	PRJNA1068830_P_NODE_82900_length_246_cov_0.901734_g82197_i0	PRJNA1068830	82900	246	0.901734	2.21826564	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	68.2	3.63e-11	NR	XP_013250213.1	5801	g82197	i0	46.8	13.6219512195122	79	41	96.3	1	8	244	93	170	XP_013250213.1 heterogeneous nuclear ribonucleoprotein A3, putative [Eimeria acervulina]	diamond	3351	68.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina

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