metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_clade = "Sar"

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
5868881	5868881	PRJNA784298_P_NODE_24345_length_249_cov_0.875000_g24144_i0	PRJNA784298	24345	249	0.875	2.17875	Synura petersenii	52555	SAR_Eukaryotes	SAR_Eukaryotes	156	2.06e-45	NR	ADB04540.1	52555	g24144	i0	85.4	0.987951807228916	82	12	98.8	0	3	248	97	178	ADB04540.1 cytochrome b, partial [Synura petersenii]	diamond	246	156	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Synura	Synura petersenii
7143809	7143809	PRJNA784298_P_NODE_21226_length_267_cov_1.396907_g21025_i0	PRJNA784298	21226	267	1.396907	3.72974169	Polarella glacialis	89957	SAR_Eukaryotes	SAR_Eukaryotes	134	1.42e-35	NR	CAE8642508.1	89957	g21025	i0	81.6	5.12359550561798	76	14	85.4	0	228	1	1	76	CAE8642508.1 unnamed protein product [Polarella glacialis]	diamond	1368	134	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Polarella	Polarella glacialis
13519192	13519192	PRJNA784298_P_NODE_26851_length_241_cov_0.916667_g26650_i0	PRJNA784298	26851	241	0.916667	2.20916747	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	147	3.46e-39	NR	XP_001031773.1	312017	g26650	i0	93.7	0.983402489626556	79	5	98.3	0	239	3	203	281	XP_001031773.1 methylthioribose kinase [Tetrahymena thermophila SB210]	diamond	237	147	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24991761	24991761	PRJNA784298_P_NODE_19140_length_283_cov_0.990476_g18939_i0	PRJNA784298	19140	283	0.990476	2.80304708	Rhizaria sp.	2204297	SAR_Eukaryotes	SAR_Eukaryotes	125	3.21e-32	NR	QFP99032.1	2204297	g18939	i0	66	0.996466431095406	94	32	99.6	0	282	1	138	231	QFP99032.1 NADH dehydrogenase subunit 1 [Rhizaria sp.]	diamond	282	125	1	Eukaryota	Sar						Rhizaria sp.
28474878	28474878	PRJNA784298_P_NODE_25626_length_245_cov_0.895349_g25425_i0	PRJNA784298	25626	245	0.895349	2.19360505	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	80.1	2.69e-15	NR	KAJ1435103.1	483371	g25425	i0	45.6	0.96734693877551	79	43	96.7	0	7	243	486	564	KAJ1435103.1 hypothetical protein B484DRAFT_417255, partial [Ochromonadaceae sp. CCMP2298]	diamond	237	80.1	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
28957918	28957918	PRJNA784298_P_NODE_23748_length_251_cov_0.865169_g23547_i0	PRJNA784298	23748	251	0.865169	2.17157419	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	92.8	2.31e-20	NR	KAL4436246.1	5901	g23547	i0	72.7	1.97211155378486	55	14	64.5	1	188	27	1	55	KAL4436246.1 hypothetical protein ABPG74_015837 [Tetrahymena malaccensis]	diamond	495	92.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
30622222	30622222	PRJNA784298_P_NODE_27613_length_232_cov_2.421384_g27412_i0	PRJNA784298	27613	232	2.421384	5.61761088	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	114	2.37e-28	NR	XP_001015806.1	312017	g27412	i0	73.3	0.969827586206897	75	20	97	0	7	231	1	75	XP_001015806.1 papain family cysteine protease [Tetrahymena thermophila SB210]	diamond	225	114	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31033382	31033382	PRJNA784298_P_NODE_25595_length_245_cov_0.895349_g25394_i0	PRJNA784298	25595	245	0.895349	2.19360505	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	122	8.06e-33	NR	XP_001030006.1	312017	g25394	i0	92.2	0.783673469387755	64	5	78.4	0	194	3	62	125	XP_001030006.1 ornithine decarboxylase antizyme protein [Tetrahymena thermophila SB210]	diamond	192	122	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31760353	31760353	PRJNA784298_P_NODE_20177_length_275_cov_1.074257_g19976_i0	PRJNA784298	20177	275	1.074257	2.95420675	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	147	2.37e-43	NR	CEO97530.1	37360	g19976	i0	80.9	0.970909090909091	89	17	97.1	0	269	3	33	121	CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae]	diamond	267	147	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae

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