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

6 rows where analysis = "diamond", bioproject = "PRJNA493632" 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
26918346	26918346	PRJNA493632_P_NODE_157922_length_379_cov_1.003268_g154498_i0	PRJNA493632	157922	379	1.003268	3.80238572	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	122	8.439999999999998e-30	NR	CAB9518259.1	568900	g154498	i0	44.9	4.02110817941953	127	63	98.9	2	2	376	90	211	CAB9518259.1 protocatechuate 3,4-dioxygenase [Seminavis robusta]	diamond	1524	122	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
27108055	27108055	PRJNA493632_P_NODE_523042_length_250_cov_0.870056_g519603_i0	PRJNA493632	523042	250	0.870056	2.17514	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	81.3	1.13e-15	NR	CAB9529003.1	568900	g519603	i0	51.9	2.916	81	32	96	2	246	7	23	97	CAB9529003.1 MAP kinase-activated protein kinase 2 (Fragment) [Seminavis robusta]	diamond	729	81.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
28181777	28181777	PRJNA493632_P_NODE_477066_length_256_cov_2.956284_g473627_i0	PRJNA493632	477066	256	2.956284	7.56808704	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0122	NR	KAG7346722.1	303405	g473627	i0	39.6	0.5625	48	29	56.3	0	190	47	155	202	KAG7346722.1 EamA-like transporter family protein [Nitzschia inconspicua]	diamond	144	44.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28766092	28766092	PRJNA493632_P_NODE_361967_length_280_cov_2.014493_g358528_i0	PRJNA493632	361967	280	2.014493	5.6405804	Cylindrotheca	2852	SAR_Eukaryotes	SAR_Eukaryotes	113	1.02e-26	NR	CAJ1937934.1	2856	g358528	i0	54.3	3.33214285714286	105	36	99.6	1	2	280	225	329	CAJ1937934.1 unnamed protein product [Cylindrotheca closterium]	diamond	933	113	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
29381841	29381841	PRJNA493632_P_NODE_428929_length_266_cov_1.595855_g425490_i0	PRJNA493632	428929	266	1.595855	4.2449743	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.019	NR	EJK63077.1	159749	g425490	i0	38.6	0.789473684210526	70	41	77.8	2	211	5	185	253	EJK63077.1 hypothetical protein THAOC_16285 [Thalassiosira oceanica]	diamond	210	43.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
31562048	31562048	PRJNA493632_P_NODE_147076_length_389_cov_2.433544_g143654_i0	PRJNA493632	147076	389	2.433544	9.46648616	Psammodictyon constrictum	515483	SAR_Eukaryotes	SAR_Eukaryotes	85.5	1.61e-16	NR	YP_010283277.1	515483	g143654	i0	57	1.32647814910026	79	33	60.9	1	148	384	10	87	YP_010283277.1 hypothetical protein MKU01_pgp097 [Psammodictyon constrictum]	diamond	516	85.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Psammodictyon	Psammodictyon constrictum

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