metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB2925" 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
26138	26138	PRJEB2925_P_NODE_9161_length_395_cov_2.013889_g7894_i0	PRJEB2925	9161	395	2.013889	7.95486155	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	173	7.44e-48	NR	XP_002142079.1	441375	g7894	i0	68.7	1.98987341772152	131	41	99.5	0	395	3	455	585	XP_002142079.1 heat shock protein 70, putative [Cryptosporidium muris RN66]	diamond	786	173	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
5128513	5128513	PRJEB2925_P_NODE_5605_length_563_cov_7.626894_g4551_i0	PRJEB2925	5605	563	7.626894	42.93941322	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	202	3.05e-62	NR	OEH76901.1	88456	g4551	i0	61.5	2.79751332149201	179	69	95.4	0	559	23	29	207	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	1575	202	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
24251975	24251975	PRJEB2925_P_NODE_9240_length_392_cov_1.658263_g7972_i0	PRJEB2925	9240	392	1.658263	6.50039096	Babesia microti strain RI	1133968	SAR_Eukaryotes	SAR_Eukaryotes	149	3.2199999999999993e-43	NR	XP_021338074.1	1133968	g7972	i0	60.7	7.125	117	46	89.5	0	4	354	39	155	XP_021338074.1 small subunit ribosomal protein S18e [Babesia microti strain RI]	diamond	2793	149	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti
30279935	30279935	PRJEB2925_P_NODE_14132_length_273_cov_2.084034_g12854_i0	PRJEB2925	14132	273	2.084034	5.68941282	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.2	2.72e-14	NR	XP_067067485.1	117008	g12854	i0	52.1	3.68131868131868	73	34	80.2	1	55	273	3	74	XP_067067485.1 60s ribosomal protein L35A [Cryptosporidium andersoni]	diamond	1005	73.2	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);;