metadata: contig_metadata: 6 rows where bioproject = "PRJNA573544" and tax

6 rows where bioproject = "PRJNA573544" 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
5663132	5663132	PRJNA573544_P_NODE_4745_length_266_cov_1.279793_g4727_i0	PRJNA573544	4745	266	1.279793	3.40424938	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	372	1.64e-98	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g4727	i0	99.034	99.4022556390977	207	2	78	0	59	265	1	207	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	26441	372	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
9487833	9487833	PRJNA573544_P_NODE_8168_length_242_cov_0.923077_g8150_i0	PRJNA573544	8168	242	0.923077	2.23384634	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	233	7.25e-57	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g8150	i0	84.426	29.2933884297521	244	31	100	6	1	242	3756	3994	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	7089	233	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
14588184	14588184	PRJNA573544_P_NODE_4912_length_261_cov_1.382979_g4894_i0	PRJNA573544	4912	261	1.382979	3.60957519	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	73.2	4.14e-13	NR	CAE7827161.1	2951	g4894	i0	45.2	0.839080459770115	73	39	82.8	1	258	43	112	184	CAE7827161.1 CCAMK, partial [Symbiodinium microadriaticum]	diamond	219	73.2	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
27882759	27882759	PRJNA573544_P_NODE_5285_length_253_cov_0.866667_g5267_i0	PRJNA573544	5285	253	0.866667	2.19266751	root	1	Root_unresolved	Root_unresolved	84.7	9.55e-18	NR	KAL3790894.1	382360	g5267	i0	59.3	2.89328063241107	54	22	64	0	5	166	102	155	KAL3790894.1 hypothetical protein ACHAWO_010891 [Cyclotella atomus]	diamond	732	84.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
29258199	29258199	PRJNA573544_P_NODE_4429_length_275_cov_1.405941_g4411_i0	PRJNA573544	4429	275	1.405941	3.86633775	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	62	9.07e-9	NR	XP_728965.1	5861	g4411	i0	38.5	2.73818181818182	78	45	85.1	2	2	235	27	101	XP_728965.1 uncharacterized protein PY17X_1243100 [Plasmodium yoelii]	diamond	753	62	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
31722954	31722954	PRJNA573544_P_NODE_5177_length_254_cov_1.651934_g5159_i0	PRJNA573544	5177	254	1.651934	4.19591236	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	92.8	2.1e-20	NR	MES1911029.1	1215613	g5159	i0	55.6	0.956692913385827	81	36	95.7	0	1	243	204	284	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	243	92.8	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);;