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

5 rows where analysis = "diamond", bioproject = "PRJNA506002" and tax_clade = "Sar"

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
27424979	27424979	PRJNA506002_S_NODE_27943_length_314_cov_2.319502_g27697_i0	PRJNA506002	27943	314	2.319502	7.28323628	Effrenium voratum	2562239	SAR_Eukaryotes	SAR_Eukaryotes	47	0.00124	NR	CAJ1401276.1	2562239	g27697	i0	30.2	1.64331210191083	86	51	74.5	2	296	63	70	154	CAJ1401276.1 unnamed protein product [Effrenium voratum]	diamond	516	47	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Effrenium	Effrenium voratum
29382378	29382378	PRJNA506002_S_NODE_65509_length_242_cov_0.911243_g65263_i0	PRJNA506002	65509	242	0.911243	2.20520806	Symbiodinium natans	878477	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.031	NR	CAE7251258.1	878477	g65263	i0	30.9	0.84297520661157	68	47	84.3	0	1	204	114	181	CAE7251258.1 unnamed protein product [Symbiodinium natans]	diamond	204	42.7	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium natans
30550921	30550921	PRJNA506002_S_NODE_36153_length_291_cov_1.527523_g35907_i0	PRJNA506002	36153	291	1.527523	4.44509193	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	84.7	6.94e-17	NR	KRX00455.1	266149	g35907	i0	50	1.75257731958763	84	42	86.6	0	1	252	282	365	KRX00455.1 GroES (chaperonin 10)-like protein [Pseudocohnilembus persalinus]	diamond	510	84.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
30692778	30692778	PRJNA506002_S_NODE_31653_length_303_cov_2.000000_g31407_i0	PRJNA506002	31653	303	2	6.06	root	1	Root_unresolved	Root_unresolved	45.1	0.0118	NR	CEM14658.1	1169540	g31407	i0	55.9	2.45544554455446	34	15	33.7	0	8	109	1258	1291	CEM14658.1 unnamed protein product [Vitrella brassicaformis CCMP3155]	diamond	744	45.1	1	Eukaryota	Sar				Vitrellaceae	Vitrella	Vitrella brassicaformis
31752119	31752119	PRJNA506002_S_NODE_44337_length_273_cov_0.835000_g44091_i0	PRJNA506002	44337	273	0.835	2.27955	Durusdinium trenchii	1381693	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00592	NR	CAK9077052.1	1381693	g44091	i0	37	0.505494505494505	46	26	50.5	1	27	164	512	554	CAK9077052.1 unnamed protein product [Durusdinium trenchii]	diamond	138	45.4	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Durusdinium	Durusdinium trenchii

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