metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB12296" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB12296" 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
32925110	32925110	PRJEB12296_S_NODE_12985_length_163_cov_3.164062_g12953_i0	PRJEB12296	12985	163	3.164062	5.15742106	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	75.1	1.23e-14	NR	CDW79704.1	5949	g12953	i0	60.4	1.95092024539877	53	21	97.5	0	163	5	188	240	CDW79704.1 60s ribosomal protein l7 [Stylonychia lemnae]	diamond	318	75.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
33024903	33024903	PRJEB12296_S_NODE_13852_length_161_cov_1.587302_g13820_i0	PRJEB12296	13852	161	1.587302	2.55555622	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.00546	NR	CAD8161077.1	43137	g13820	i0	50	1.93788819875776	52	26	96.9	0	1	156	63	114	CAD8161077.1 unnamed protein product [Paramecium octaurelia]	diamond	312	42.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
33044751	33044751	PRJEB12296_S_NODE_5165_length_209_cov_3.419540_g5133_i0	PRJEB12296	5165	209	3.41954	7.1468386	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	70.9	9.88e-14	NR	CAG9313846.1	1481888	g5133	i0	63	0.77511961722488	54	20	77.5	0	1	162	68	121	CAG9313846.1 unnamed protein product [Blepharisma stoltei]	diamond	162	70.9	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
33061747	33061747	PRJEB12296_S_NODE_16773_length_154_cov_2.336134_g16741_i0	PRJEB12296	16773	154	2.336134	3.59764636	Paramecium pentaurelia	43138	SAR_Eukaryotes	SAR_Eukaryotes	53.5	3.75e-7	NR	CAD8150344.1	43138	g16741	i0	68.3	2.3961038961039	41	13	79.9	0	154	32	95	135	CAD8150344.1 unnamed protein product [Paramecium pentaurelia]	diamond	369	53.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia
33164114	33164114	PRJEB12296_S_NODE_4984_length_212_cov_2.412429_g4952_i0	PRJEB12296	4984	212	2.412429	5.11434948	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	58.5	6.44e-9	NR	2XZN_5	5911	g4952	i0	65.3	0.693396226415094	49	16	67.9	1	10	153	66	114	2XZN_5 Chain 5, Ribosomal Protein S26e Containing Protein [Tetrahymena thermophila]	diamond	147	58.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
33178471	33178471	PRJEB12296_S_NODE_5488_length_205_cov_1.923529_g5456_i0	PRJEB12296	5488	205	1.923529	3.94323445	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	62.8	7.29e-10	NR	XP_001009414.2	312017	g5456	i0	51.7	2.54634146341463	58	28	84.9	0	204	31	156	213	XP_001009414.2 50S ribosomal protein L1P [Tetrahymena thermophila SB210]	diamond	522	62.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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