metadata: contig_metadata: 5 rows where bioproject = "PRJEB14664", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJEB14664", tax_clade = "Sar" 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
21292	21292	PRJEB14664_P_NODE_5401_length_362_cov_1.125382_g5271_i0	PRJEB14664	5401	362	1.125382	4.07388284	Sundstroemia setigera	3005	SAR_Eukaryotes	SAR_Eukaryotes	196	1.5e-45	NTclustered	gi\|2172620428\|ref\|NC_059919.1\|	3005	g5271	i0	79.649	67.8093922651934	285	48	78	9	43	324	24852	25129	Rhizosolenia setigera isolate CNS00456 mitochondrion, complete genome	blastn	24547	196	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Sundstroemia	Sundstroemia setigera
27159172	27159172	PRJEB14664_P_NODE_10022_length_241_cov_1.941748_g9892_i0	PRJEB14664	10022	241	1.941748	4.67961268	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	55.8	9.07e-7	NR	CAJ1945658.1	2856	g9892	i0	49	0.609958506224066	49	25	61	0	150	4	1712	1760	CAJ1945658.1 unnamed protein product [Cylindrotheca closterium]	diamond	147	55.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
27216116	27216116	PRJEB14664_P_NODE_14202_length_190_cov_1.548387_g14072_i0	PRJEB14664	14202	190	1.548387	2.9419353	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	98.6	4.04e-22	NR	VEU42420.1	183589	g14072	i0	73	12.9315789473684	63	17	99.5	0	1	189	726	788	VEU42420.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	2457	98.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
27412555	27412555	PRJEB14664_P_NODE_7023_length_307_cov_1.018382_g6893_i0	PRJEB14664	7023	307	1.018382	3.12643274	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	66.6	1.09e-10	NR	GKY97021.1	2872254	g6893	i0	43.8	2.20846905537459	80	41	74.3	2	6	233	132	211	GKY97021.1 hypothetical protein MPSEU_000660900 [Mayamaea pseudoterrestris]	diamond	678	66.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
27633435	27633435	PRJEB14664_P_NODE_12784_length_204_cov_1.136095_g12654_i0	PRJEB14664	12784	204	1.136095	2.3176338	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	75.1	4.51e-14	NR	GAX19416.1	1519565	g12654	i0	55.2	0.985294117647059	67	26	98.5	1	202	2	120	182	GAX19416.1 spermidine synthase [Fistulifera solaris]	diamond	201	75.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris

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