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

8 rows where analysis = "diamond", bioproject = "PRJNA415856" 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
12562364	12562364	PRJNA415856_P_NODE_9090_length_298_cov_1.429719_g8829_i0	PRJNA415856	9090	298	1.429719	4.26056262	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	128	9.439999999999999e-35	NR	XP_001014308.1	312017	g8829	i0	58.9	1.91275167785235	95	39	95.6	0	12	296	56	150	XP_001014308.1 eukaryotic translation initiation factor 5A [Tetrahymena thermophila SB210]	diamond	570	128	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27123484	27123484	PRJNA415856_P_NODE_27202_length_179_cov_1.523077_g26941_i0	PRJNA415856	27202	179	1.523077	2.72630783	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	53.9	1.04e-7	NR	KAG5187933.1	303371	g26941	i0	72.7	1.70949720670391	33	9	55.3	0	10	108	4	36	KAG5187933.1 hypothetical protein JKP88DRAFT_218338 [Tribonema minus]	diamond	306	53.9	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
27138354	27138354	PRJNA415856_P_NODE_37742_length_166_cov_0.871795_g37481_i0	PRJNA415856	37742	166	0.871795	1.4471797	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	53.1	4.78e-7	NR	MES1912234.1	1215613	g37481	i0	67.7	1.12048192771084	31	10	56	0	158	66	89	119	MES1912234.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	186	53.1	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27328563	27328563	PRJNA415856_P_NODE_27323_length_179_cov_1.330769_g27062_i0	PRJNA415856	27323	179	1.330769	2.38207651	Nyctotherus ovalis	70075	SAR_Eukaryotes	SAR_Eukaryotes	58.9	3.03e-8	NR	AAX19093.1	70075	g27062	i0	53.6	0.93854748603352	56	25	93.9	1	12	179	67	121	AAX19093.1 eukaryotic release factor 1b [Nyctotherus ovalis]	diamond	168	58.9	1	Eukaryota	Sar	Ciliophora	Armophorea	Clevelandellida	Nyctotheridae	Nyctotherus	Nyctotherus ovalis
29145164	29145164	PRJNA415856_P_NODE_23429_length_186_cov_1.875912_g23168_i0	PRJNA415856	23429	186	1.875912	3.48919632	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00925	NR	KAG7401495.1	109152	g23168	i0	76.9	1.25806451612903	26	6	41.9	0	115	38	87	112	KAG7401495.1 Hsp90 cochaperone shq1 [Phytophthora boehmeriae]	diamond	234	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
29334300	29334300	PRJNA415856_P_NODE_39109_length_166_cov_0.871795_g38848_i0	PRJNA415856	39109	166	0.871795	1.4471797	Albugo	65356	SAR_Eukaryotes	SAR_Eukaryotes	54.3	1.04e-6	NR	CCI40038.1	65357	g38848	i0	51.1	4.33734939759036	47	23	84.9	0	164	24	264	310	CCI40038.1 unnamed protein product [Albugo candida]	diamond	720	54.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
30297240	30297240	PRJNA415856_P_NODE_38152_length_166_cov_0.871795_g37891_i0	PRJNA415856	38152	166	0.871795	1.4471797	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0187	NR	KAJ8571932.1	4785	g37891	i0	40.7	1.7710843373494	54	30	97.6	1	163	2	1323	1374	KAJ8571932.1 hypothetical protein ON010_g4901 [Phytophthora cinnamomi]	diamond	294	42.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
32368744	32368744	PRJNA415856_P_NODE_42539_length_164_cov_1.773913_g42278_i0	PRJNA415856	42539	164	1.773913	2.90921732	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.4	5.04e-6	NR	GFH56056.1	426638	g42278	i0	71.9	3.53048780487805	32	9	58.5	0	102	7	119	150	GFH56056.1 hypothetical protein CTEN210_12532 [Chaetoceros tenuissimus]	diamond	579	52.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus

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