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

5 rows where bioproject = "PRJEB17675", tax_clade = "Sar" and tax_phylum = "Cercozoa"

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
11189195	11189195	PRJEB17675_P_NODE_14429_length_215_cov_1.877778_g14125_i0	PRJEB17675	14429	215	1.877778	4.0372227	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	398	2.1099999999999997e-106	NTclustered	gi\|2493707699\|dbj\|LC764482.1\|	45107	g14125	i0	100	100	215	0	100	0	1	215	997	783	Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence	blastn	21500	398	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
11189210	11189210	PRJEB17675_P_NODE_4949_length_435_cov_7.517500_g4651_i0	PRJEB17675	4949	435	7.5175	32.701125	Chromulinales	96792	SAR_Eukaryotes	SAR_Eukaryotes	399	1.3e-106	NTclustered	gi\|160337355\|gb\|EF455774.1\|	439948	g4651	i0	83.333	96.9379310344828	438	67	100	6	1	435	560	126	Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds	blastn	42168	399	1	Eukaryota	Sar	Cercozoa			Mesofilidae	Mesofila	Mesofila sp. ATCC PRA-54
27633562	27633562	PRJEB17675_P_NODE_9224_length_291_cov_2.500000_g8920_i0	PRJEB17675	9224	291	2.5	7.275	Lotharella oceanica	641309	SAR_Eukaryotes	SAR_Eukaryotes	67.4	1.16e-12	NR	AIB09582.1	641309	g8920	i0	57.4	5.38144329896907	54	23	55.7	0	191	30	1	54	AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica]	diamond	1566	67.4	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Lotharella	Lotharella oceanica
28864770	28864770	PRJEB17675_P_NODE_5488_length_409_cov_1.689840_g5189_i0	PRJEB17675	5488	409	1.68984	6.9114456	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	65.5	1.96e-9	NR	MES1907597.1	1215613	g5189	i0	38.3	2.20048899755501	81	47	58.7	2	240	1	2	80	MES1907597.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	900	65.5	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
30286350	30286350	PRJEB17675_P_NODE_19792_length_175_cov_1.414286_g19488_i0	PRJEB17675	19792	175	1.414286	2.4750005	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	78.6	8.33e-16	NR	MES1911136.1	1215613	g19488	i0	63.2	5.94857142857143	57	21	97.7	0	1	171	140	196	MES1911136.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1041	78.6	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

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