metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA473201" 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
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
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
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);;