metadata: contig_metadata: 5 rows where bioproject = "PRJNA682774", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA682774", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

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_order	tax_family	tax_genus	tax_species
1940630	1940630	PRJNA682774_P_NODE_302_length_790_cov_1.638773_g277_i0	PRJNA682774	302	790	1.638773	12.9463067	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	129	2.51e-32	NR	TEB19254.1	2494336	g277	i0	33.7	1.01392405063291	267	155	94.6	8	25	771	1	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	801	129	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
10868646	10868646	PRJNA682774_P_NODE_3689_length_252_cov_0.871508_g3660_i0	PRJNA682774	3689	252	0.871508	2.19620016	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	153	1.06e-41	NR	TEB19421.1	2494336	g3660	i0	88	0.988095238095238	83	10	98.8	0	251	3	202	284	TEB19421.1 adenosine triphosphatase, partial [Perkinsus sp. BL_2016]	diamond	249	153	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
23617515	23617515	PRJNA682774_P_NODE_1599_length_349_cov_1.083333_g1570_i0	PRJNA682774	1599	349	1.083333	3.78083217	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	86.7	5.39e-18	NR	KAF4756585.1	32597	g1570	i0	66.7	1.34097421203438	60	20	51.6	0	346	167	155	214	KAF4756585.1 70-kilodalton heat shock protein, partial [Perkinsus olseni]	diamond	468	86.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27492979	27492979	PRJNA682774_P_NODE_183_length_998_cov_2.380541_g159_i0	PRJNA682774	183	998	2.380541	23.75779918	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	172	4.22e-48	NR	TEB19254.1	2494336	g159	i0	41.5	0.796593186372745	265	143	77	4	938	171	2	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	795	172	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28818710	28818710	PRJNA682774_P_NODE_2168_length_307_cov_1.000000_g2139_i0	PRJNA682774	2168	307	1	3.07	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	56.2	1.42e-6	NR	TEB14043.1	2494336	g2139	i0	52.5	0.596091205211726	61	22	56.7	2	179	6	409	465	TEB14043.1 hypothetical protein C9890_0703, partial [Perkinsus sp. BL_2016]	diamond	183	56.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016

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