metadata: contig_metadata: 9 rows where bioproject = "PRJNA631119", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA631119", 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
8256390	8256390	PRJNA631119_P_NODE_29407_length_256_cov_1.278689_g29289_i0	PRJNA631119	29407	256	1.278689	3.27344384	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	125	1.87e-31	NR	TEB19421.1	2494336	g29289	i0	68.7	0.97265625	83	26	97.3	0	254	6	412	494	TEB19421.1 adenosine triphosphatase, partial [Perkinsus sp. BL_2016]	diamond	249	125	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
16454711	16454711	PRJNA631119_P_NODE_4253_length_540_cov_2.963597_g4138_i0	PRJNA631119	4253	540	2.963597	16.0034238	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	217	7.86e-62	NR	KAF4658562.1	32597	g4138	i0	67.3	10.2	156	50	86.7	1	523	56	979	1133	KAF4658562.1 hypothetical protein FOL46_006904 [Perkinsus olseni]	diamond	5508	218	0.995412844036697	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26922719	26922719	PRJNA631119_P_NODE_28422_length_259_cov_1.930108_g28304_i0	PRJNA631119	28422	259	1.930108	4.99897972	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	51.2	4.71e-5	NR	KAF4753827.1	32597	g28304	i0	40	0.984555984555985	85	51	98.5	0	259	5	2	86	KAF4753827.1 hypothetical protein FOZ62_023405, partial [Perkinsus olseni]	diamond	255	51.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27333949	27333949	PRJNA631119_P_NODE_6943_length_442_cov_1.016260_g6825_i0	PRJNA631119	6943	442	1.01626	4.4918692	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	187	2.979999999999999e-55	NR	TEB20199.1	2494336	g6825	i0	62.8	0.929864253393665	137	49	93	1	441	31	239	373	TEB20199.1 hypothetical protein C9890_0096 [Perkinsus sp. BL_2016]	diamond	411	187	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
27933704	27933704	PRJNA631119_P_NODE_12525_length_352_cov_1.462366_g12407_i0	PRJNA631119	12525	352	1.462366	5.14752832	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	77.8	6.84e-16	NR	XP_002779756.1	423536	g12407	i0	70	0.852272727272727	50	15	42.6	0	352	203	53	102	XP_002779756.1 cysteinyl-tRNA synthetase, putative, partial [Perkinsus marinus ATCC 50983]	diamond	300	77.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28280851	28280851	PRJNA631119_P_NODE_40386_length_231_cov_3.411392_g40268_i0	PRJNA631119	40386	231	3.411392	7.88031552	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.3e-8	NR	KAF4682829.1	32597	g40268	i0	42.1	1.97402597402597	76	41	94.8	2	220	2	87	162	KAF4682829.1 hypothetical protein FOZ60_010060 [Perkinsus olseni]	diamond	456	60.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28451615	28451615	PRJNA631119_P_NODE_23586_length_279_cov_11.723301_g23468_i0	PRJNA631119	23586	279	11.723301	32.70800979	root	1	Root_unresolved	Root_unresolved	120	7.27e-32	NR	XP_002778466.1	423536	g23468	i0	77	7.16129032258065	74	17	79.6	0	49	270	1	74	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	1998	121	0.991735537190083	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30946711	30946711	PRJNA631119_P_NODE_36834_length_244_cov_0.900585_g36716_i0	PRJNA631119	36834	244	0.900585	2.1974274	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	111	3.49e-28	NR	KAF4701992.1	32597	g36716	i0	64	2.11475409836066	86	26	99.6	2	244	2	113	198	KAF4701992.1 hypothetical protein FOZ63_033655, partial [Perkinsus olseni]	diamond	516	111	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31787460	31787460	PRJNA631119_P_NODE_11217_length_366_cov_9.866894_g11099_i0	PRJNA631119	11217	366	9.866894	36.11283204	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	165	4.17e-49	NR	XP_002778466.1	423536	g11099	i0	66.9	0.991803278688525	121	39	98.4	1	364	5	70	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	363	165	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus

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