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

6 rows where analysis = "diamond", bioproject = "PRJNA825466" and tax_phylum = "Bacillariophyta"

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
19079757	19079757	PRJNA825466_P_NODE_15655_length_254_cov_1.386740_g15554_i0	PRJNA825466	15655	254	1.38674	3.5223196	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	91.3	4.4300000000000005e-21	NR	CAB9505015.1	568900	g15554	i0	70.6	2.69291338582677	68	19	80.3	1	205	2	36	102	CAB9505015.1 cleavage system H protein [Seminavis robusta]	diamond	684	91.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
21222482	21222482	PRJNA825466_P_NODE_24817_length_244_cov_0.900585_g24716_i0	PRJNA825466	24817	244	0.900585	2.1974274	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	167	3.59e-46	NR	KAI2512956.1	210448	g24716	i0	95	53.1147540983607	80	4	98.4	0	242	3	419	498	KAI2512956.1 Aconitate B N-terminal domain [Fragilaria crotonensis]	diamond	12960	168	0.994047619047619	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
26841830	26841830	PRJNA825466_P_NODE_25721_length_243_cov_1.564706_g25620_i0	PRJNA825466	25721	243	1.564706	3.80223558	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.2	1.36e-7	NR	KAG7374107.1	303405	g25620	i0	54.9	1.24691358024691	51	23	63	0	238	86	383	433	KAG7374107.1 sserine/threonine protein kinase with PASTA sensor domain [Nitzschia inconspicua]	diamond	303	58.5	0.994871794871795	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
27252674	27252674	PRJNA825466_P_NODE_10703_length_283_cov_1.438095_g10602_i0	PRJNA825466	10703	283	1.438095	4.06980885	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	129	3.21e-36	NR	CAJ1944271.1	2856	g10602	i0	62.5	7.10247349823322	96	34	99.6	1	2	283	8	103	CAJ1944271.1 unnamed protein product [Cylindrotheca closterium]	diamond	2010	130	0.992307692307692	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
30252894	30252894	PRJNA825466_P_NODE_652_length_828_cov_3.852980_g571_i0	PRJNA825466	652	828	3.85298	31.9026744	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	174	1.75e-49	NR	CAJ1934959.1	2856	g571	i0	41.4	1.72826086956522	239	138	86.2	2	6	719	1	238	CAJ1934959.1 unnamed protein product [Cylindrotheca closterium]	diamond	1431	174	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
31666214	31666214	PRJNA825466_P_NODE_18597_length_249_cov_1.295455_g18496_i0	PRJNA825466	18597	249	1.295455	3.22568295	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	122	6.549999999999999e-32	NR	KAI2505670.1	210448	g18496	i0	79.5	5.27710843373494	73	15	88	0	26	244	6	78	KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis]	diamond	1314	122	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis

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