metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA698538" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA698538" 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
17761879	17761879	PRJNA698538_S_NODE_22194_length_272_cov_1.934673_g22028_i0	PRJNA698538	22194	272	1.934673	5.26231056	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	76.3	8.78e-14	NR	RHY78209.1	112090	g22028	i0	77.1	11.6360294117647	48	9	52.9	1	123	266	1221	1266	RHY78209.1 hypothetical protein DYB38_002210 [Aphanomyces astaci]	diamond	3165	76.3	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
26766236	26766236	PRJNA698538_S_NODE_21061_length_278_cov_1.765854_g20895_i0	PRJNA698538	21061	278	1.765854	4.90907412	Saprolegnia diclina VS2	112098	SAR_Eukaryotes	SAR_Eukaryotes	65.5	4e-10	NR	XP_008604768.1	1156394	g20895	i0	47.2	0.776978417266187	72	37	76.6	1	276	64	233	304	XP_008604768.1 YjeF [Saprolegnia diclina VS20]	diamond	216	65.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
27746321	27746321	PRJNA698538_S_NODE_9124_length_357_cov_4.338028_g8958_i0	PRJNA698538	9124	357	4.338028	15.48675996	Ectocarpus siliculosus	2880	SAR_Eukaryotes	SAR_Eukaryotes	51.6	8.82e-5	NR	CBJ32755.1	2880	g8958	i0	46.6	0.487394957983193	58	31	48.7	0	351	178	151	208	CBJ32755.1 conserved unknown protein [Ectocarpus siliculosus]	diamond	174	51.6	1	Eukaryota	Sar		Phaeophyceae	Ectocarpales	Ectocarpaceae	Ectocarpus	Ectocarpus siliculosus
30062184	30062184	PRJNA698538_S_NODE_31531_length_227_cov_3.467532_g31365_i0	PRJNA698538	31531	227	3.467532	7.87129764	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	49.3	1.52e-4	NR	DBA01320.1	4803	g31365	i0	49.1	8.08810572687225	53	25	67.4	1	4	156	221	273	DBA01320.1 TPA: hypothetical protein N0F65_001825, partial [Lagenidium giganteum]	diamond	1836	49.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
30694220	30694220	PRJNA698538_S_NODE_6553_length_386_cov_4.019169_g6387_i0	PRJNA698538	6553	386	4.019169	15.51399234	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	148	5.45e-39	NR	KAK1936482.1	32595	g6387	i0	77.3	15.0388601036269	97	21	75.4	1	385	95	513	608	KAK1936482.1 putative peptidyl-prolyl cis-trans isomerase [Babesia divergens]	diamond	5805	149	0.993288590604027	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia divergens
32085377	32085377	PRJNA698538_S_NODE_32338_length_206_cov_4.631579_g32172_i0	PRJNA698538	32338	206	4.631579	9.54105274	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	72	3.54e-13	NR	SCM25234.1	5826	g32172	i0	45.6	4.95145631067961	68	37	99	0	1	204	159	226	SCM25234.1 diphthine--ammonia ligase, putative [Plasmodium chabaudi adami]	diamond	1020	72	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi

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