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

5 rows where analysis = "diamond", bioproject = "PRJNA635874" 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
3158803	3158803	PRJNA635874_P_NODE_55923_length_247_cov_1.609195_g55776_i0	PRJNA635874	55923	247	1.609195	3.97471165	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	108	4.64e-26	NR	XP_067804442.1	323732	g55776	i0	63	0.983805668016194	81	29	98.4	1	246	4	113	192	XP_067804442.1 bifunctional Ribosomal protein L3 [Babesia duncani]	diamond	243	108	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
10811448	10811448	PRJNA635874_P_NODE_30009_length_302_cov_1.694323_g29862_i0	PRJNA635874	30009	302	1.694323	5.11685546	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	136	5.26e-36	NR	VWU50564.1	2600580	g29862	i0	69	4.96688741721854	100	31	99.3	0	1	300	268	367	VWU50564.1 S-adenosylmethionine synthetase, putative [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	1500	136	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
12086659	12086659	PRJNA635874_P_NODE_31070_length_298_cov_1.542222_g30923_i0	PRJNA635874	31070	298	1.542222	4.59582156	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	166	5.75e-47	NR	OLQ16365.1	237895	g30923	i0	77.6	10.8523489932886	98	22	98.7	0	296	3	278	375	OLQ16365.1 tRNA synthetase class II core domain (G H P S and T) [Cryptosporidium hominis]	diamond	3234	166	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
30302590	30302590	PRJNA635874_P_NODE_74212_length_237_cov_2.817073_g74065_i0	PRJNA635874	74212	237	2.817073	6.67646301	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	108	7.840000000000001e-29	NR	VWU51230.1	2600580	g74065	i0	74.7	1.89873417721519	75	18	93.7	1	236	15	6	80	VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	450	108	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
32167610	32167610	PRJNA635874_P_NODE_35118_length_284_cov_1.454976_g34971_i0	PRJNA635874	35118	284	1.454976	4.1321318399999996	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	129	1.06e-35	NR	XP_067804708.1	323732	g34971	i0	67.8	5.70422535211268	90	29	95.1	0	270	1	1	90	XP_067804708.1 bifunctional Ribosomal protein S8e/Ribosomal protein S8e [Babesia duncani]	diamond	1620	129	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);;