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

5 rows where analysis = "diamond", bioproject = "PRJNA976345" 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
11471241	11471241	PRJNA976345_P_NODE_59989_length_229_cov_3.226804_g58381_i0	PRJNA976345	59989	229	3.226804	7.38938116	Plasmodium falciparum 3D7	36329	SAR_Eukaryotes	SAR_Eukaryotes	99	3.64e-25	NR	XP_001349810.1	36329	g58381	i0	62.7	1.75545851528384	67	25	87.8	0	4	204	15	81	XP_001349810.1 40S ribosomal protein S27 [Plasmodium falciparum 3D7]	diamond	402	99	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
12428004	12428004	PRJNA976345_P_NODE_69690_length_217_cov_1.296703_g68082_i0	PRJNA976345	69690	217	1.296703	2.81384551	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.6	3.81e-12	NR	XP_002140162.1	441375	g68082	i0	52.3	5.33640552995392	65	25	89.9	1	217	23	38	96	XP_002140162.1 DnaJ domain-containing protein [Cryptosporidium muris RN66]	diamond	1158	68.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
27000418	27000418	PRJNA976345_P_NODE_47822_length_252_cov_1.760369_g46214_i0	PRJNA976345	47822	252	1.760369	4.43612988	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	72	2.04e-12	NR	XP_029217216.1	94643	g46214	i0	50.8	5.67857142857143	59	29	70.2	0	6	182	1127	1185	XP_029217216.1 DNA polymerase [Besnoitia besnoiti]	diamond	1431	72.4	0.994475138121547	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
28895389	28895389	PRJNA976345_P_NODE_76048_length_210_cov_1.365714_g74440_i0	PRJNA976345	76048	210	1.365714	2.8679994	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00145	NR	PVC50438.1	68886	g74440	i0	56.4	2.22857142857143	39	17	55.7	0	2	118	851	889	PVC50438.1 hypothetical protein MACL_00002278 [Theileria orientalis]	diamond	468	46.6	0.991416309012876	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
31606249	31606249	PRJNA976345_P_NODE_108476_length_184_cov_2.241611_g106868_i0	PRJNA976345	108476	184	2.241611	4.12456424	Cryptosporidium andersoni	117008	SAR_Eukaryotes	SAR_Eukaryotes	42	0.0322	NR	XP_067067475.1	117008	g106868	i0	38.5	0.847826086956522	52	31	83.2	1	183	31	294	345	XP_067067475.1 uncharacterized protein cand_030590 [Cryptosporidium andersoni]	diamond	156	42	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium andersoni

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