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

5 rows where analysis = "diamond", bioproject = "PRJEB28589" and tax_clade = "Sar"

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
29401674	29401674	PRJEB28589_S_NODE_9789_length_251_cov_1.387255_g9681_i0	PRJEB28589	9789	251	1.387255	3.48201005	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.022	NR	GAX12435.1	1519565	g9681	i0	34.3	0.800796812749004	67	41	78.9	3	37	234	338	402	GAX12435.1 hypothetical protein FisN_2Hh267 [Fistulifera solaris]	diamond	201	43.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
31353968	31353968	PRJEB28589_S_NODE_9256_length_258_cov_8.511848_g9148_i0	PRJEB28589	9256	258	8.511848	21.96056784	Suessiales	89954	SAR_Eukaryotes	SAR_Eukaryotes	105	4.58e-27	NR	CAE7204722.1	2951	g9148	i0	64.5	12.3023255813953	76	27	88.4	0	2	229	49	124	CAE7204722.1 rpl-22 [Symbiodinium microadriaticum]	diamond	3174	105	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
31360572	31360572	PRJEB28589_S_NODE_15216_length_185_cov_2.956522_g15108_i0	PRJEB28589	15216	185	2.956522	5.4695657	Scrippsiella trochoidea	71861	SAR_Eukaryotes	SAR_Eukaryotes	70.9	4.58e-14	NR	AYU58848.1	71861	g15108	i0	50.8	5.75675675675676	61	29	98.9	1	185	3	35	94	AYU58848.1 heat shock protein 10 [Scrippsiella trochoidea]	diamond	1065	70.9	1	Eukaryota	Sar		Dinophyceae	Peridiniales	Peridiniaceae	Scrippsiella	Scrippsiella trochoidea
31739818	31739818	PRJEB28589_S_NODE_14797_length_189_cov_4.408451_g14689_i0	PRJEB28589	14797	189	4.408451	8.33197239	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	76.6	2.01e-14	NR	TYZ64004.1	1485010	g14689	i0	54.5	1.04761904761905	66	25	96.8	1	2	184	775	840	TYZ64004.1 hypothetical protein PybrP1_004139 [[Pythium] brassicae (nom. inval.)]	diamond	198	76.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
32751527	32751527	PRJEB28589_S_NODE_4660_length_332_cov_4.701754_g4552_i0	PRJEB28589	4660	332	4.701754	15.60982328	Aureococcus anophagefferens	44056	SAR_Eukaryotes	SAR_Eukaryotes	57.4	7.95e-7	NR	KAH8081576.1	44056	g4552	i0	58.5	1.10240963855422	41	17	37	0	242	120	1695	1735	KAH8081576.1 phosphoinositide 3-kinase regulatory subunit [Aureococcus anophagefferens]	diamond	366	57.4	1	Eukaryota	Sar		Pelagophyceae	Pelagomonadales	Pelagomonadaceae	Aureococcus	Aureococcus anophagefferens

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