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

9 rows where analysis = "diamond", bioproject = "PRJNA1123436" 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
27702375	27702375	PRJNA1123436_P_NODE_34884_length_431_cov_1.064246_g33672_i0	PRJNA1123436	34884	431	1.064246	4.58690026	Cladocopium goreaui	2562237	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.0209	NR	CAL1153044.1	2562237	g33672	i0	32.4	0.751740139211137	108	60	70.3	3	63	365	31	132	CAL1153044.1 unnamed protein product [Cladocopium goreaui]	diamond	324	45.8	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Cladocopium	Cladocopium goreaui
28523096	28523096	PRJNA1123436_P_NODE_93327_length_253_cov_1.361111_g92113_i0	PRJNA1123436	93327	253	1.361111	3.44361083	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	127	6.269999999999999e-32	NR	KAJ0412157.1	114742	g92113	i0	79.2	1.73122529644269	77	16	91.3	0	251	21	631	707	KAJ0412157.1 hypothetical protein ATCC90586_005770 [Pythium insidiosum]	diamond	438	127	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
30386578	30386578	PRJNA1123436_P_NODE_119613_length_243_cov_0.905882_g118399_i0	PRJNA1123436	119613	243	0.905882	2.20129326	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	130	3.77e-33	NR	GKY91322.1	2872254	g118399	i0	82.3	0.975308641975309	79	14	97.5	0	2	238	486	564	GKY91322.1 hypothetical protein MPSEU_000104400 [Mayamaea pseudoterrestris]	diamond	237	130	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
30860144	30860144	PRJNA1123436_P_NODE_91674_length_256_cov_1.683060_g90460_i0	PRJNA1123436	91674	256	1.68306	4.3086336	Tetraparma gracilis	2962635	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0405	NR	GMI24433.1	2962635	g90460	i0	34.1	0.9609375	82	49	92.6	4	19	255	185	264	GMI24433.1 hypothetical protein TeGR_g6426, partial [Tetraparma gracilis]	diamond	246	42.7	1	Eukaryota	Sar		Bolidophyceae	Parmales	Triparmaceae	Tetraparma	Tetraparma gracilis
31681876	31681876	PRJNA1123436_P_NODE_108437_length_247_cov_0.885057_g107223_i0	PRJNA1123436	108437	247	0.885057	2.18609079	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	55.5	1.12e-6	NR	CEP03475.1	37360	g107223	i0	36.6	0.995951417004049	82	43	96	3	8	244	45	120	CEP03475.1 hypothetical protein PBRA_003235 [Plasmodiophora brassicae]	diamond	246	55.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31808663	31808663	PRJNA1123436_P_NODE_95517_length_251_cov_0.865169_g94303_i0	PRJNA1123436	95517	251	0.865169	2.17157419	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	92.8	1e-19	NR	XP_002180731.1	556484	g94303	i0	79.1	0.800796812749004	67	13	78.9	1	199	2	660	726	XP_002180731.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	201	92.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
32304295	32304295	PRJNA1123436_P_NODE_114839_length_245_cov_0.895349_g113625_i0	PRJNA1123436	114839	245	0.895349	2.19360505	Suessiales	89954	SAR_Eukaryotes	SAR_Eukaryotes	51.6	2.74e-5	NR	CAK0849624.1	89957	g113625	i0	38.5	2.87755102040816	78	47	94.3	1	233	3	269	346	CAK0849624.1 unnamed protein product [Polarella glacialis]	diamond	705	52	0.992307692307692	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Polarella	Polarella glacialis
32788273	32788273	PRJNA1123436_P_NODE_95680_length_251_cov_0.865169_g94466_i0	PRJNA1123436	95680	251	0.865169	2.17157419	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	80.1	2.92e-15	NR	GBG33827.1	2315210	g94466	i0	55.8	0.920318725099602	77	30	92	1	251	21	665	737	GBG33827.1 Protein kinase, putative [Hondaea fermentalgiana]	diamond	231	80.1	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
32819872	32819872	PRJNA1123436_P_NODE_124760_length_242_cov_0.911243_g123546_i0	PRJNA1123436	124760	242	0.911243	2.20520806	Stephanodiscus triporus	2934178	SAR_Eukaryotes	SAR_Eukaryotes	166	2.2699999999999993e-46	NR	KAL3761713.1	2934178	g123546	i0	98.8	0.991735537190083	80	1	99.2	0	2	241	253	332	KAL3761713.1 hypothetical protein ACHAW5_005964 [Stephanodiscus triporus]	diamond	240	166	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Stephanodiscus	Stephanodiscus triporus

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