metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB14175" 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
32939501	32939501	PRJEB14175_P_NODE_12505_length_1006_cov_23.383069_g10975_i0	PRJEB14175	12505	1006	23.383069	235.23367414	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	243	1.1e-71	NR	GFE54454.1	5869	g10975	i0	51.4	8.83598409542743	222	106	65.6	2	985	326	381	602	GFE54454.1 LNS2 Lipin Ned1 Smp2 domain-containing protein [Babesia ovis]	diamond	8889	243	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
32961225	32961225	PRJEB14175_P_NODE_275042_length_180_cov_6.369748_g272774_i0	PRJEB14175	275042	180	6.369748	11.4655464	Babesia microti strain RI	1133968	SAR_Eukaryotes	SAR_Eukaryotes	47.8	2.81e-4	NR	XP_021337195.1	1133968	g272774	i0	70	5.05	30	9	50	0	111	22	138	167	XP_021337195.1 succinate dehydrogenase (ubiquinone) flavoprotein subunit [Babesia microti strain RI]	diamond	909	47.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti
33042014	33042014	PRJEB14175_P_NODE_162956_length_262_cov_1.109453_g160689_i0	PRJEB14175	162956	262	1.109453	2.90676686	root	1	Root_unresolved	Root_unresolved	57	4.25e-7	NR	XP_013440618.1	51315	g160689	i0	50	3.65267175572519	64	28	72.1	3	72	260	331	391	XP_013440618.1 OSJNBa0080E14.14 protein, related [Eimeria necatrix]	diamond	957	57	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
33062706	33062706	PRJEB14175_P_NODE_18909_length_837_cov_21.220361_g17122_i0	PRJEB14175	18909	837	21.220361	177.61442157	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	230	1.3099999999999999e-68	NR	XP_067919027.1	483139	g17122	i0	60.8	5.80286738351254	181	71	64.9	0	544	2	228	408	XP_067919027.1 gdp-mannose -dehydratase, partial [Cystoisospora suis]	diamond	4857	230	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
33093185	33093185	PRJEB14175_P_NODE_119566_length_320_cov_6.138996_g117300_i0	PRJEB14175	119566	320	6.138996	19.6447872	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	78.6	3.1e-16	NR	XP_029216964.1	94643	g117300	i0	64.5	2.90625	62	22	58.1	0	299	114	49	110	XP_029216964.1 ribosomal protein RPL36 [Besnoitia besnoiti]	diamond	930	79.3	0.991172761664565	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
33114732	33114732	PRJEB14175_P_NODE_48431_length_536_cov_6.707368_g46202_i0	PRJEB14175	48431	536	6.707368	35.95149248	Theileria parva strain Muguga	333668	SAR_Eukaryotes	SAR_Eukaryotes	149	5.93e-43	NR	XP_766445.1	333668	g46202	i0	57.6	1.25932835820896	118	50	66	0	50	403	1	118	XP_766445.1 60S ribosomal protein L31-1 [Theileria parva strain Muguga]	diamond	675	149	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria parva
33147992	33147992	PRJEB14175_P_NODE_187112_length_238_cov_28.943503_g184845_i0	PRJEB14175	187112	238	28.943503	68.88553714	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0346	NR	XP_013233511.1	5802	g184845	i0	44.7	0.592436974789916	47	22	56.7	2	152	18	570	614	XP_013233511.1 ATP-dependent RNA helicase, putative [Eimeria tenella]	diamond	141	42.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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