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

4 rows where analysis = "diamond", bioproject = "PRJNA682370" 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
19791090	19791090	PRJNA682370_S_NODE_11876_length_210_cov_1.388571_g11264_i0	PRJNA682370	11876	210	1.388571	2.9159991	Coscinodiscophyceae	33836	SAR_Eukaryotes	SAR_Eukaryotes	120	3.0899999999999997e-32	NR	KAL3762341.1	259834	g11264	i0	84.1	5.91428571428571	69	11	98.6	0	3	209	40	108	KAL3762341.1 hypothetical protein ACHAWU_003846 [Discostella pseudostelligera]	diamond	1242	121	0.991735537190083	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
27441658	27441658	PRJNA682370_S_NODE_13243_length_197_cov_1.660494_g12631_i0	PRJNA682370	13243	197	1.660494	3.27117318	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	74.7	1.08e-13	NR	CAJ1961665.1	2856	g12631	i0	61.5	4.90355329949239	65	24	99	1	3	197	172	235	CAJ1961665.1 unnamed protein product [Cylindrotheca closterium]	diamond	966	74.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
31990299	31990299	PRJNA682370_S_NODE_13978_length_192_cov_1.299363_g13366_i0	PRJNA682370	13978	192	1.299363	2.49477696	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	53.9	9.97e-7	NR	KAI2506646.1	210448	g13366	i0	47.8	2.171875	46	24	71.9	0	187	50	143	188	KAI2506646.1 calcineurin-like phosphoesterase-like protein [Fragilaria crotonensis]	diamond	417	54.3	0.992633517495396	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
32105251	32105251	PRJNA682370_S_NODE_3678_length_427_cov_2.400510_g3072_i0	PRJNA682370	3678	427	2.40051	10.2501777	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	132	1.75e-36	NR	EJK48333.1	159749	g3072	i0	57.8	6.0983606557377	116	48	81.5	1	427	80	27	141	EJK48333.1 hypothetical protein THAOC_32880, partial [Thalassiosira oceanica]	diamond	2604	132	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica

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