metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1111448" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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
9145022	9145022	PRJNA1111448_S_NODE_110028_length_261_cov_1.228723_g109205_i0	PRJNA1111448	110028	261	1.228723	3.20696703	Symbiodiniaceae	252141	SAR_Eukaryotes	SAR_Eukaryotes	128	2.65e-33	NR	CAK9100409.1	1381693	g109205	i0	76.3	20.1034482758621	80	19	92	0	261	22	306	385	CAK9100409.1 unnamed protein product [Durusdinium trenchii]	diamond	5247	129	0.992248062015504	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Durusdinium	Durusdinium trenchii
13776325	13776325	PRJNA1111448_S_NODE_96791_length_275_cov_1.618812_g95968_i0	PRJNA1111448	96791	275	1.618812	4.451733	Albugo	65356	SAR_Eukaryotes	SAR_Eukaryotes	127	1.03e-32	NR	CCI42781.1	65357	g95968	i0	69.4	4.63636363636364	85	26	92.7	0	273	19	330	414	CCI42781.1 unnamed protein product [Albugo candida]	diamond	1275	127	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
21894818	21894818	PRJNA1111448_S_NODE_51118_length_345_cov_2.830882_g50295_i0	PRJNA1111448	51118	345	2.830882	9.7665429	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	126	1.96e-33	NR	OQS05478.1	74557	g50295	i0	61.5	6.99130434782609	109	41	94.8	1	345	19	125	232	OQS05478.1 40S ribosomal protein S3-3 [Thraustotheca clavata]	diamond	2412	126	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
26972835	26972835	PRJNA1111448_S_NODE_131142_length_245_cov_1.308140_g130319_i0	PRJNA1111448	131142	245	1.30814	3.204943	Blastocystis hominis	12968	SAR_Eukaryotes	SAR_Eukaryotes	70.1	1.09e-12	NR	XP_012893930.1	12968	g130319	i0	39.5	5.26530612244898	81	48	99.2	1	245	3	52	131	XP_012893930.1 uncharacterized protein [Blastocystis hominis]	diamond	1290	70.1	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis
27564325	27564325	PRJNA1111448_S_NODE_94304_length_278_cov_1.502439_g93481_i0	PRJNA1111448	94304	278	1.502439	4.17678042	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	111	3.68e-29	NR	KAF0694959.1	120398	g93481	i0	100	1.23021582733813	57	0	61.5	0	3	173	74	130	KAF0694959.1 hypothetical protein As57867_014131 [Aphanomyces stellatus]	diamond	342	111	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
28331060	28331060	PRJNA1111448_S_NODE_121186_length_251_cov_0.865169_g120363_i0	PRJNA1111448	121186	251	0.865169	2.17157419	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00599	NR	KAF4663921.1	330153	g120363	i0	35.4	2.47410358565737	82	47	93.2	3	10	243	25	104	KAF4663921.1 Sorl1p [Perkinsus chesapeaki]	diamond	621	45.1	1	Eukaryota	Sar	Perkinsozoa		Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
28574883	28574883	PRJNA1111448_S_NODE_99567_length_272_cov_1.371859_g98744_i0	PRJNA1111448	99567	272	1.371859	3.73145648	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.9	5.3e-13	NR	XP_012898001.1	12968	g98744	i0	43.3	8.82352941176471	90	47	99.3	1	272	3	382	467	XP_012898001.1 uncharacterized protein [Blastocystis hominis]	diamond	2400	73.9	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis
28994474	28994474	PRJNA1111448_S_NODE_81548_length_294_cov_1.045249_g80725_i0	PRJNA1111448	81548	294	1.045249	3.07303206	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	165	2.01e-50	NR	KAF0708390.1	120398	g80725	i0	82.5	1.97959183673469	97	17	99	0	293	3	40	136	KAF0708390.1 hypothetical protein As57867_006351, partial [Aphanomyces stellatus]	diamond	582	165	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
29531009	29531009	PRJNA1111448_S_NODE_109830_length_261_cov_1.468085_g109007_i0	PRJNA1111448	109830	261	1.468085	3.83170185	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	121	5.54e-32	NR	CAH0482684.1	622444	g109007	i0	70	1.75862068965517	80	24	92	0	258	19	140	219	CAH0482684.1 unnamed protein product [Peronospora belbahrii]	diamond	459	121	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
32848936	32848936	PRJNA1111448_S_NODE_70960_length_309_cov_1.305085_g70137_i0	PRJNA1111448	70960	309	1.305085	4.03271265	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	50.4	1.48e-4	NR	KAJ1439640.1	483371	g70137	i0	39.6	0.883495145631068	91	43	84.5	2	2	262	321	403	KAJ1439640.1 hypothetical protein B484DRAFT_443899 [Ochromonadaceae sp. CCMP2298]	diamond	273	50.4	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298

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