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

5 rows where bioproject = "PRJNA1073712", 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
6565609	6565609	PRJNA1073712_P_NODE_7566_length_287_cov_1.598131_g7483_i0	PRJNA1073712	7566	287	1.598131	4.58663597	Paulinella micropora	1928728	SAR_Eukaryotes	SAR_Eukaryotes	215	3.2e-51	NTclustered	gi\|1389527547\|dbj\|LC383946.1\|	1928728	g7483	i0	83.772	115.383275261324	228	35	79	2	27	253	687	913	Paulinella micropora gene for polyubiquitin, complete cds	blastn	33115	215	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella micropora
12941369	12941369	PRJNA1073712_P_NODE_2611_length_412_cov_212.566372_g2528_i0	PRJNA1073712	2611	412	212.566372	875.77345264	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	294	5.96e-75	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g2528	i0	93.5	49.3131067961165	200	10	48	3	1	197	3656	3855	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	20317	294	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
15490138	15490138	PRJNA1073712_P_NODE_1053_length_577_cov_2.607143_g970_i0	PRJNA1073712	1053	577	2.607143	15.04321511	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	784	0	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g970	i0	92.086	97.7625649913345	556	44	96	0	22	577	765	210	Lecythium sp. 3678_261K actin gene, partial cds	blastn	56409	784	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K
28488655	28488655	PRJNA1073712_P_NODE_3467_length_376_cov_3.851485_g3384_i0	PRJNA1073712	3467	376	3.851485	14.4815836	Paulinella micropora	1928728	SAR_Eukaryotes	SAR_Eukaryotes	103	1.76e-25	NR	BBE07976.1	1928728	g3384	i0	47.3	0.893617021276596	112	49	83.8	2	26	340	5	113	BBE07976.1 LIM and SH3 domain protein [Paulinella micropora]	diamond	336	103	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella micropora
28994050	28994050	PRJNA1073712_P_NODE_14408_length_245_cov_0.895349_g14325_i0	PRJNA1073712	14408	245	0.895349	2.19360505	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.14e-13	NR	MES1911902.1	1215613	g14325	i0	47.8	0.844897959183673	69	36	84.5	0	11	217	942	1010	MES1911902.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	207	75.5	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);;