metadata: contig_metadata: 11 rows where bioproject = "PRJNA473201", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA473201", 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
1718202	1718202	PRJNA473201_P_NODE_13742_length_540_cov_1.182013_g13002_i0	PRJNA473201	13742	540	1.182013	6.3828702	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	237	4.95e-76	NR	MES1912193.1	1215613	g13002	i0	61.8	2.97777777777778	178	68	98.9	0	539	6	46	223	MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM]	diamond	1608	237	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
5547178	5547178	PRJNA473201_P_NODE_24585_length_397_cov_1.666667_g23843_i0	PRJNA473201	24585	397	1.666667	6.61666799	Mesofila sp. ATCC PRA-54	439948	SAR_Eukaryotes	SAR_Eukaryotes	296	1.59e-75	NTclustered	gi\|160337400\|gb\|EF455798.1\|	439948	g23843	i0	84.211	81.4659949622166	304	48	77	0	1	304	767	464	Dimorpha sp. ATCC PRA-54 clone 2 actin gene, partial cds	blastn	32342	296	1	Eukaryota	Sar	Cercozoa			Mesofilidae	Mesofila	Mesofila sp. ATCC PRA-54
8747876	8747876	PRJNA473201_P_NODE_44427_length_306_cov_1.253219_g43685_i0	PRJNA473201	44427	306	1.253219	3.83485014	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	177	4.5399999999999986e-55	NR	ACF24571.1	67809	g43685	i0	80.2	4.95098039215686	101	20	99	0	1	303	39	139	ACF24571.1 ubiquitin-conjugating enzyme 2 [Gymnochlora stellata]	diamond	1515	177	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
14472408	14472408	PRJNA473201_P_NODE_37652_length_325_cov_1.805556_g36910_i0	PRJNA473201	37652	325	1.805556	5.868057	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	549	8.879999999999997e-152	NTclustered	gi\|238617630\|gb\|FJ973394.1\|	188950	g36910	i0	97.222	93.7107692307692	324	9	99	0	2	325	780	457	Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds	blastn	30456	549	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
15746469	15746469	PRJNA473201_P_NODE_38973_length_320_cov_1.497976_g38231_i0	PRJNA473201	38973	320	1.497976	4.7935232	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	181	2.94e-56	NR	ADK47156.1	323453	g38231	i0	93.6	0.88125	94	6	88.1	0	39	320	1	94	ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74]	diamond	282	181	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
15747057	15747057	PRJNA473201_P_NODE_71213_length_248_cov_1.320000_g70471_i0	PRJNA473201	71213	248	1.32	3.2736	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	113	8.12e-30	NR	AAT09077.1	227086	g70471	i0	67.1	0.991935483870968	82	27	99.2	0	246	1	3	84	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	246	113	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
18295519	18295519	PRJNA473201_P_NODE_45635_length_302_cov_1.397380_g44893_i0	PRJNA473201	45635	302	1.39738	4.2200876	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	348	3.2e-91	NTclustered	gi\|300676732\|gb\|GQ377662.1\|	188950	g44893	i0	87.417	98.9470198675497	302	38	100	0	1	302	30	331	Bodomorpha minima alpha-tubulin (Atub) gene, partial cds	blastn	29882	348	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
19569192	19569192	PRJNA473201_P_NODE_21596_length_425_cov_1.093750_g20854_i0	PRJNA473201	21596	425	1.09375	4.6484375	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	209	5.95e-65	NR	ADK26624.1	323453	g20854	i0	75.6	0.952941176470588	135	33	95.3	0	2	406	142	276	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	405	209	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
21496286	21496286	PRJNA473201_P_NODE_24437_length_398_cov_2.184615_g23695_i0	PRJNA473201	24437	398	2.184615	8.6947677	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	186	2.6900000000000003e-58	NR	ADK26622.1	323453	g23695	i0	94.6	0.693467336683417	92	5	69.3	0	3	278	39	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	276	186	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
25320631	25320631	PRJNA473201_P_NODE_2080_length_1341_cov_2.347003_g1757_i0	PRJNA473201	2080	1341	2.347003	31.47331023	Cercozoa sp. DMV	1342330	SAR_Eukaryotes	SAR_Eukaryotes	483	3.029999999999999e-165	NR	BAN37425.1	1342330	g1757	i0	70.1	2.17673378076063	328	98	73.4	0	1340	357	114	441	BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV]	diamond	2919	483	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. DMV
31704215	31704215	PRJNA473201_P_NODE_32517_length_347_cov_1.470803_g31775_i0	PRJNA473201	32517	347	1.470803	5.10368641	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	143	9.37e-41	NR	ACF24579.1	67809	g31775	i0	65.2	7.6685878962536	112	38	96.8	1	345	10	3	113	ACF24579.1 40S ribosomal protein S9 [Gymnochlora stellata]	diamond	2661	144	0.993055555555556	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata

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