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

4 rows where analysis = "diamond", bioproject = "PRJNA450343" 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
27503300	27503300	PRJNA450343_P_NODE_12983_length_163_cov_0.894737_g12915_i0	PRJNA450343	12983	163	0.894737	1.45842131	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	7.29e-4	NR	OEU11196.1	635003	g12915	i0	55.2	1.38036809815951	29	13	53.4	0	89	3	39	67	OEU11196.1 hypothetical protein FRACYDRAFT_246308 [Fragilariopsis cylindrus CCMP1102]	diamond	225	46.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
28829107	28829107	PRJNA450343_P_NODE_4308_length_256_cov_1.231884_g4240_i0	PRJNA450343	4308	256	1.231884	3.15362304	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	93.2	1.54e-21	NR	OEU21027.1	635003	g4240	i0	58.3	3.90234375	84	32	97.3	3	249	1	98	179	OEU21027.1 winged helix DNA-binding domain-containing protein [Fragilariopsis cylindrus CCMP1102]	diamond	999	93.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
30424009	30424009	PRJNA450343_P_NODE_11253_length_166_cov_0.871795_g11185_i0	PRJNA450343	11253	166	0.871795	1.4471797	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	66.2	6.76e-11	NR	KAI2507300.1	210448	g11185	i0	62.5	1.96987951807229	56	20	99.4	1	1	165	462	517	KAI2507300.1 hypothetical protein MHU86_7136 [Fragilaria crotonensis]	diamond	327	66.2	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
31371846	31371846	PRJNA450343_P_NODE_12576_length_164_cov_0.886957_g12508_i0	PRJNA450343	12576	164	0.886957	1.45460948	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	83.2	7.05e-17	NR	XP_002181347.1	556484	g12508	i0	77.4	0.969512195121951	53	12	97	0	164	6	282	334	XP_002181347.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	159	83.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum

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