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

11 rows where analysis = "diamond", bioproject = "PRJNA556842" 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
8174556	8174556	PRJNA556842_P_NODE_10107_length_241_cov_1.014706_g9602_i0	PRJNA556842	10107	241	1.014706	2.44544146	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	91.7	1.55e-21	NR	CAE7660559.1	2951	g9602	i0	75.8	1.54356846473029	62	13	77.2	1	240	55	79	138	CAE7660559.1 RPL18B [Symbiodinium microadriaticum]	diamond	372	91.7	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
10725963	10725963	PRJNA556842_P_NODE_16809_length_158_cov_1.264463_g16304_i0	PRJNA556842	16809	158	1.264463	1.99785154	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	114	7.41e-32	NR	KAJ1422858.1	483371	g16304	i0	96.2	0.987341772151899	52	2	98.7	0	3	158	29	80	KAJ1422858.1 ribosomal protein S27 [Ochromonadaceae sp. CCMP2298]	diamond	156	114	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
12000733	12000733	PRJNA556842_P_NODE_10190_length_239_cov_1.099010_g9685_i0	PRJNA556842	10190	239	1.09901	2.6266339	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	118	7.41e-29	NR	SPQ94571.1	37360	g9685	i0	72.2	0.99163179916318	79	22	99.2	0	2	238	196	274	SPQ94571.1 unnamed protein product [Plasmodiophora brassicae]	diamond	237	118	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27172875	27172875	PRJNA556842_P_NODE_15422_length_169_cov_1.439394_g14917_i0	PRJNA556842	15422	169	1.439394	2.43257586	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	94.4	2.2099999999999994e-23	NR	KAJ1436162.1	483371	g14917	i0	82.1	0.994082840236686	56	10	99.4	0	169	2	44	99	KAJ1436162.1 ribosomal protein S25 [Ochromonadaceae sp. CCMP2298]	diamond	168	94.4	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
28040443	28040443	PRJNA556842_P_NODE_17505_length_153_cov_1.318966_g17000_i0	PRJNA556842	17505	153	1.318966	2.01801798	Coscinodiscophyceae	33836	SAR_Eukaryotes	SAR_Eukaryotes	72	2.79e-14	NR	AAB70105.1	2843	g17000	i0	94.1	8.72549019607843	34	2	66.7	0	151	50	112	145	AAB70105.1 fucoxanthin-chlorophyll a/c light-harvesting protein, partial [Skeletonema costatum]	diamond	1335	72.4	0.994475138121547	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema costatum
28956242	28956242	PRJNA556842_P_NODE_13228_length_191_cov_1.000000_g12723_i0	PRJNA556842	13228	191	1	1.91	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	60.1	1.42e-8	NR	KAF1324593.1	82926	g12723	i0	54	2.93717277486911	63	28	97.4	1	190	5	275	337	KAF1324593.1 V-type h translocating pyrophosphatase, partial [Globisporangium splendens]	diamond	561	60.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
29477886	29477886	PRJNA556842_P_NODE_17970_length_150_cov_1.017699_g17465_i0	PRJNA556842	17970	150	1.017699	1.5265485	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	83.6	3.4e-19	NR	KAJ1443398.1	483371	g17465	i0	83.7	1.96	49	8	98	0	3	149	52	100	KAJ1443398.1 ribosomal protein L36e [Ochromonadaceae sp. CCMP2298]	diamond	294	83.6	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
29572789	29572789	PRJNA556842_P_NODE_14450_length_178_cov_1.063830_g13945_i0	PRJNA556842	14450	178	1.06383	1.8936174	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	48.5	1.43e-4	NR	KAH9086397.1	100861	g13945	i0	62.2	0.623595505617977	37	14	62.4	0	175	65	430	466	KAH9086397.1 hypothetical protein LEN26_020160 [Aphanomyces euteiches]	diamond	111	48.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
31120555	31120555	PRJNA556842_P_NODE_17515_length_153_cov_1.310345_g17010_i0	PRJNA556842	17515	153	1.310345	2.00482785	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	95.9	1.9799999999999998e-23	NR	KAJ1428270.1	483371	g17010	i0	80	0.980392156862745	50	10	98	0	153	4	110	159	KAJ1428270.1 ribosomal protein L5 domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	150	95.9	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
31152108	31152108	PRJNA556842_P_NODE_16675_length_159_cov_0.959016_g16170_i0	PRJNA556842	16675	159	0.959016	1.52483544	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	63.5	3.17e-11	NR	KAJ1440517.1	483371	g16170	i0	66.7	0.962264150943396	51	16	94.3	1	1	150	63	113	KAJ1440517.1 hypothetical protein B484DRAFT_391281 [Ochromonadaceae sp. CCMP2298]	diamond	153	63.5	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
32495839	32495839	PRJNA556842_P_NODE_17099_length_156_cov_1.277311_g16594_i0	PRJNA556842	17099	156	1.277311	1.99260516	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	101	7.05e-27	NR	XP_009032667.1	44056	g16594	i0	92.2	5.88461538461539	51	4	98.1	0	155	3	13	63	XP_009032667.1 hypothetical protein AURANDRAFT_19173 [Aureococcus anophagefferens]	diamond	918	101	1	Eukaryota	Sar		Pelagophyceae	Pelagomonadales	Pelagomonadaceae	Aureococcus	Aureococcus anophagefferens

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