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

4 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax_phylum = "Ciliophora"

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
3849235	3849235	PRJEB25789_S_NODE_10444_length_300_cov_2.378855_g10365_i0	PRJEB25789	10444	300	2.378855	7.136565	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	144	7.57e-41	NR	CAD8051385.1	5886	g10365	i0	70.4	25.26	98	29	98	0	296	3	1	98	CAD8051385.1 unnamed protein product [Paramecium primaurelia]	diamond	7578	144	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia
26969775	26969775	PRJEB25789_S_NODE_4582_length_414_cov_2.730205_g4503_i0	PRJEB25789	4582	414	2.730205	11.3030487	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	97.8	2.68e-23	NR	CDW83169.1	5949	g4503	i0	49.5	0.789855072463768	109	54	79	1	44	370	8	115	CDW83169.1 UNKNOWN [Stylonychia lemnae]	diamond	327	97.8	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29300458	29300458	PRJEB25789_S_NODE_9289_length_314_cov_0.958506_g9210_i0	PRJEB25789	9289	314	0.958506	3.00970884	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	82.4	8.28e-17	NR	XP_001014308.1	312017	g9210	i0	46.4	3.19108280254777	84	41	80.3	1	2	253	127	206	XP_001014308.1 eukaryotic translation initiation factor 5A [Tetrahymena thermophila SB210]	diamond	1002	83.2	0.990384615384615	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31575461	31575461	PRJEB25789_S_NODE_17576_length_248_cov_0.880000_g17497_i0	PRJEB25789	17576	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	51.6	1.83e-5	NR	CDW74496.1	5949	g17497	i0	64.1	1.5241935483871	39	14	47.2	0	122	238	4	42	CDW74496.1 glutathione s-pi 1 [Stylonychia lemnae]	diamond	378	51.6	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae

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