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

5 rows where analysis = "diamond", bioproject = "PRJNA414036" 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
26980561	26980561	PRJNA414036_P_NODE_22802_length_317_cov_6.046099_g21071_i0	PRJNA414036	22802	317	6.046099	19.16613383	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00354	NR	EJK60870.1	159749	g21071	i0	37.6	0.8801261829653	93	56	88	1	31	309	35	125	EJK60870.1 hypothetical protein THAOC_18712 [Thalassiosira oceanica]	diamond	279	46.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
27833566	27833566	PRJNA414036_P_NODE_73484_length_175_cov_2.400000_g71745_i0	PRJNA414036	73484	175	2.4	4.2	Toxarium undulatum	210620	SAR_Eukaryotes	SAR_Eukaryotes	51.2	8.16e-6	NR	YP_009495475.1	210620	g71745	i0	56.3	1.64571428571429	48	21	82.3	0	17	160	110	157	YP_009495475.1 NADH dehydrogenase subunit 9 [Toxarium undulatum]	diamond	288	51.2	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Toxariales	Toxariaceae	Toxarium	Toxarium undulatum
28780711	28780711	PRJNA414036_P_NODE_1667_length_659_cov_4.157051_g845_i2	PRJNA414036	1667	659	4.157051	27.39496609	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.0466	NR	EJK75129.1	159749	g845	i2	36.4	0.851289833080425	99	63	45.1	0	488	192	5	103	EJK75129.1 hypothetical protein THAOC_03160, partial [Thalassiosira oceanica]	diamond	561	46.2	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
30391971	30391971	PRJNA414036_P_NODE_1073_length_718_cov_2.900439_g845_i1	PRJNA414036	1073	718	2.900439	20.82515202	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	63.5	6.79e-8	NR	EJK75129.1	159749	g845	i1	39.2	0.426183844011142	102	62	42.6	0	497	192	2	103	EJK75129.1 hypothetical protein THAOC_03160, partial [Thalassiosira oceanica]	diamond	306	63.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
30517882	30517882	PRJNA414036_P_NODE_14853_length_382_cov_16.700288_g13174_i0	PRJNA414036	14853	382	16.700288	63.79510016	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	71.2	3.14e-12	NR	EJK73956.1	159749	g13174	i0	35.7	0.879581151832461	112	72	88	0	380	45	90	201	EJK73956.1 hypothetical protein THAOC_04400 [Thalassiosira oceanica]	diamond	336	71.2	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);;