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

8 rows where analysis = "diamond", bioproject = "PRJNA757618" 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
732175	732175	PRJNA757618_P_NODE_12621_length_322_cov_1.686747_g11569_i0	PRJNA757618	12621	322	1.686747	5.43132534	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	167	3.78e-50	NR	KAJ1429072.1	483371	g11569	i0	69.2	0.996894409937888	107	31	97.8	1	4	318	34	140	KAJ1429072.1 ribosomal protein L6, alpha-beta domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	321	167	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
732502	732502	PRJNA757618_P_NODE_32641_length_249_cov_1.767045_g31589_i0	PRJNA757618	32641	249	1.767045	4.39994205	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	158	2.03e-45	NR	KAJ1414914.1	483371	g31589	i0	95.2	1.92771084337349	83	4	100	0	1	249	219	301	KAJ1414914.1 hypothetical protein B484DRAFT_454707, partial [Ochromonadaceae sp. CCMP2298]	diamond	480	158	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
10131057	10131057	PRJNA757618_P_NODE_21148_length_272_cov_1.175879_g20096_i0	PRJNA757618	21148	272	1.175879	3.19839088	root	1	Root_unresolved	Root_unresolved	155	4.37e-46	NR	CAE7561516.1	2951	g20096	i0	85.6	2.97794117647059	90	13	99.3	0	3	272	23	112	CAE7561516.1 RPS7 [Symbiodinium microadriaticum]	diamond	810	155	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
16034911	16034911	PRJNA757618_P_NODE_15913_length_296_cov_2.089686_g14861_i0	PRJNA757618	15913	296	2.089686	6.18547056	Tribonema minus	303371	SAR_Eukaryotes	SAR_Eukaryotes	140	8.47e-40	NR	KAG5181400.1	303371	g14861	i0	77	0.881756756756757	87	20	88.2	0	262	2	1	87	KAG5181400.1 hypothetical protein JKP88DRAFT_215280 [Tribonema minus]	diamond	261	140	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
30062633	30062633	PRJNA757618_P_NODE_36211_length_248_cov_0.880000_g35159_i0	PRJNA757618	36211	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.8	4.51e-4	NR	CAI5713765.1	86335	g35159	i0	62.2	2.23790322580645	37	14	44.8	0	12	122	16	52	CAI5713765.1 unnamed protein product [Peronospora destructor]	diamond	555	45.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
30526816	30526816	PRJNA757618_P_NODE_39273_length_246_cov_0.901734_g38221_i0	PRJNA757618	39273	246	0.901734	2.21826564	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	64.7	3.32e-10	NR	KAJ1419800.1	483371	g38221	i0	62.8	0.524390243902439	43	16	52.4	0	244	116	204	246	KAJ1419800.1 glycoside hydrolase superfamily [Ochromonadaceae sp. CCMP2298]	diamond	129	64.7	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
30811222	30811222	PRJNA757618_P_NODE_12774_length_321_cov_1.165323_g11722_i0	PRJNA757618	12774	321	1.165323	3.74068683	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	129	3.69e-36	NR	KAJ1431703.1	483371	g11722	i0	57.9	1	107	45	100	0	321	1	22	128	KAJ1431703.1 ribosomal protein L14-domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	321	129	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
32117655	32117655	PRJNA757618_P_NODE_19438_length_279_cov_1.276699_g18386_i0	PRJNA757618	19438	279	1.276699	3.56199021	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.1	4.78e-8	NR	TMW68031.1	41045	g18386	i0	34.8	4.72043010752688	92	56	94.6	2	1	264	934	1025	TMW68031.1 hypothetical protein Poli38472_007703 [Pythium oligandrum]	diamond	1317	60.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum

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