metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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
2719088	2719088	PRJNA1035005_P_NODE_1583_length_987_cov_5.768053_g1258_i0	PRJNA1035005	1583	987	5.768053	56.93068311	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	313	1.12e-103	NR	MES1912193.1	1215613	g1258	i0	67.9	7.96656534954407	234	75	71.1	0	904	203	6	239	MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM]	diamond	7863	313	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
14197296	14197296	PRJNA1035005_P_NODE_1452_length_1053_cov_4.357143_g1147_i0	PRJNA1035005	1452	1053	4.357143	45.880715790000004	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	357	1.3099999999999994e-119	NR	MES1911029.1	1215613	g1147	i0	61.6	0.897435897435897	315	106	88.3	5	36	965	1	305	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	945	357	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
19294508	19294508	PRJNA1035005_P_NODE_2356_length_752_cov_7.863034_g1981_i0	PRJNA1035005	2356	752	7.863034	59.13001568	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	286	1.53e-95	NR	ADK47156.1	323453	g1981	i0	96.6	0.578457446808511	145	5	57.8	0	707	273	1	145	ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74]	diamond	435	286	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
19294681	19294681	PRJNA1035005_P_NODE_4696_length_492_cov_1.116945_g4296_i0	PRJNA1035005	4696	492	1.116945	5.4953694	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	241	1.2500000000000001e-77	NR	ACF24562.1	67809	g4296	i0	73.8	0.975609756097561	160	42	97.6	0	3	482	57	216	ACF24562.1 proteasome alpha 5 subunit [Gymnochlora stellata]	diamond	480	241	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
20569933	20569933	PRJNA1035005_P_NODE_3037_length_633_cov_7.450000_g2648_i0	PRJNA1035005	3037	633	7.45	47.1585	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	256	1.0699999999999999e-84	NR	ADK26622.1	323453	g2648	i0	94.6	0.616113744075829	130	7	61.6	0	584	195	1	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	390	256	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
27951243	27951243	PRJNA1035005_P_NODE_42285_length_266_cov_2.404145_g41879_i0	PRJNA1035005	42285	266	2.404145	6.3950257	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	89.4	5.12e-19	NR	MES1911486.1	1215613	g41879	i0	52.3	0.992481203007519	88	40	99.2	1	264	1	127	212	MES1911486.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	264	89.4	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28898244	28898244	PRJNA1035005_P_NODE_3248_length_608_cov_3.345794_g2858_i0	PRJNA1035005	3248	608	3.345794	20.34242752	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	181	2.2299999999999998e-54	NR	AAT09077.1	227086	g2858	i0	59	0.769736842105263	156	62	77	1	32	499	1	154	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	468	181	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
29498261	29498261	PRJNA1035005_P_NODE_30590_length_282_cov_1.110048_g30184_i0	PRJNA1035005	30590	282	1.110048	3.13033536	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	64.7	1.09e-9	NR	MES1914001.1	1215613	g30184	i0	46.7	0.978723404255319	92	46	97.9	2	6	281	298	386	MES1914001.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	276	64.7	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29719034	29719034	PRJNA1035005_P_NODE_11130_length_352_cov_2.075269_g10725_i0	PRJNA1035005	11130	352	2.075269	7.30494688	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	114	4.25e-27	NR	MES1909771.1	1215613	g10725	i0	47.3	0.954545454545455	112	59	95.5	0	345	10	52	163	MES1909771.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	336	114	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31267484	31267484	PRJNA1035005_P_NODE_62795_length_250_cov_0.881356_g62389_i0	PRJNA1035005	62795	250	0.881356	2.20339	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	125	6.129999999999999e-32	NR	MES1911740.1	1215613	g62389	i0	74.4	1.968	82	21	98.4	0	3	248	253	334	MES1911740.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	492	125	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
32469816	32469816	PRJNA1035005_P_NODE_17359_length_312_cov_2.422594_g16953_i0	PRJNA1035005	17359	312	2.422594	7.55849328	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	97.4	9.36e-23	NR	ACF24574.1	67809	g16953	i0	93.9	0.471153846153846	49	3	47.1	0	3	149	11	59	ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata]	diamond	147	97.4	1	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);;