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

7 rows where analysis = "diamond", bioproject = "PRJNA909412" 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
4719217	4719217	PRJNA909412_P_NODE_3324_length_288_cov_2.767068_g3183_i0	PRJNA909412	3324	288	2.767068	7.96915584	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	141	1.7099999999999996e-40	NR	AAT09077.1	227086	g3183	i0	71.9	7	96	27	100	0	288	1	25	120	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	2016	141	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
5993904	5993904	PRJNA909412_P_NODE_1605_length_434_cov_3.339241_g1465_i0	PRJNA909412	1605	434	3.339241	14.49230594	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	118	2.06e-29	NR	MES1907458.1	1215613	g1465	i0	67.8	0.601382488479263	87	28	60.1	0	172	432	33	119	MES1907458.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	261	118	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
7268868	7268868	PRJNA909412_P_NODE_66_length_1801_cov_15.603859_g50_i0	PRJNA909412	66	1801	15.603859	281.02550059	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	695	9.319999999999995e-247	NR	MES1909605.1	1215613	g50	i0	77.1	4.41588006662965	433	99	72.1	0	23	1321	1	433	MES1909605.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	7953	701	0.991440798858773	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28098257	28098257	PRJNA909412_P_NODE_15825_length_153_cov_2.008772_g15684_i0	PRJNA909412	15825	153	2.008772	3.07342116	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	57.4	7.12e-8	NR	MES1907562.1	1215613	g15684	i0	49.1	1.07843137254902	55	23	98	1	2	151	216	270	MES1907562.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	165	57.4	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28453251	28453251	PRJNA909412_P_NODE_7106_length_198_cov_2.075472_g6965_i0	PRJNA909412	7106	198	2.075472	4.10943456	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.1	2.44e-17	NR	AAP34647.1	227086	g6965	i0	64.6	5.81818181818182	65	23	98.5	0	198	4	267	331	AAP34647.1 chaperonin-containing TCP-1 theta [Bigelowiella natans]	diamond	1152	85.1	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
31446536	31446536	PRJNA909412_P_NODE_8916_length_179_cov_1.471429_g8775_i0	PRJNA909412	8916	179	1.471429	2.63385791	Paulinella micropora	1928728	SAR_Eukaryotes	SAR_Eukaryotes	77	1.5e-15	NR	BBE07971.1	1928728	g8775	i0	86.7	0.754189944134078	45	6	75.4	0	1	135	134	178	BBE07971.1 GTP-binding protein [Paulinella micropora]	diamond	135	77	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella micropora
32837145	32837145	PRJNA909412_P_NODE_13140_length_160_cov_3.859504_g12999_i0	PRJNA909412	13140	160	3.859504	6.1752064	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	40.8	0.0427	NR	MES1913617.1	1215613	g12999	i0	44.4	0.84375	45	24	84.4	1	21	155	112	155	MES1913617.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	135	40.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);;