metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1214993" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1214993" 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
10534138	10534138	PRJNA1214993_P_NODE_17109_length_271_cov_1.040404_g16923_i0	PRJNA1214993	17109	271	1.040404	2.81949484	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	105	4.5400000000000005e-27	NR	ADK26622.1	323453	g16923	i0	93.9	0.542435424354244	49	3	54.2	0	1	147	82	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	147	105	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
14359439	14359439	PRJNA1214993_P_NODE_9152_length_361_cov_1.173611_g8966_i0	PRJNA1214993	9152	361	1.173611	4.23673571	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	230	1.14e-75	NR	ADK47156.1	323453	g8966	i0	95.7	0.972299168975069	117	5	97.2	0	360	10	29	145	ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74]	diamond	351	230	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
18181856	18181856	PRJNA1214993_P_NODE_18455_length_261_cov_1.021277_g18269_i0	PRJNA1214993	18455	261	1.021277	2.66553297	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	137	1.94e-39	NR	ADK26622.1	323453	g18269	i0	94.4	0.827586206896552	72	4	82.8	0	216	1	1	72	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	216	137	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
24556537	24556537	PRJNA1214993_P_NODE_6520_length_421_cov_2.149425_g6335_i0	PRJNA1214993	6520	421	2.149425	9.04907925	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	122	8.26e-33	NR	AAT09102.1	227086	g6335	i0	48.8	0.876484560570071	123	55	87.6	2	51	419	21	135	AAT09102.1 cysteine proteinase, partial [Bigelowiella natans]	diamond	369	122	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
25271565	25271565	PRJNA1214993_P_NODE_6320_length_427_cov_3.022599_g6135_i0	PRJNA1214993	6320	427	3.022599	12.90649773	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	237	1.12e-74	NR	MES1910618.1	1215613	g6135	i0	79.4	0.990632318501171	141	29	99.1	0	3	425	123	263	MES1910618.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	423	237	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27009272	27009272	PRJNA1214993_P_NODE_26422_length_237_cov_2.993902_g26236_i0	PRJNA1214993	26422	237	2.993902	7.09554774	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	99.4	1.7699999999999998e-23	NR	MES1909335.1	1215613	g26236	i0	59.7	0.911392405063291	72	29	91.1	0	218	3	7	78	MES1909335.1 Eukaryotic translation initiation factor 6 [Cercozoa sp. M6MM]	diamond	216	99.4	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
32000885	32000885	PRJNA1214993_P_NODE_20058_length_252_cov_1.083799_g19872_i0	PRJNA1214993	20058	252	1.083799	2.73117348	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	76.3	3.61e-15	NR	MES1909107.1	1215613	g19872	i0	51.3	1.91666666666667	80	37	95.2	2	244	5	8	85	MES1909107.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	483	76.3	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);;