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

9 rows where bioproject = "PRJNA556992", 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
17113072	17113072	PRJNA556992_P_NODE_969554_length_233_cov_6.556250_g967364_i0	PRJNA556992	969554	233	6.55625	15.2760625	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	112	3.14e-28	NR	KAF4685574.1	32597	g967364	i0	63.5	5.66523605150215	74	27	95.3	0	232	11	116	189	KAF4685574.1 hypothetical protein FOZ62_006760, partial [Perkinsus olseni]	diamond	1320	112	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26681303	26681303	PRJNA556992_P_NODE_807441_length_245_cov_4.069767_g805251_i0	PRJNA556992	807441	245	4.069767	9.97092915	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0107	NR	KAF4711357.1	32597	g805251	i0	59.3	1.7265306122449	27	11	33.1	0	234	154	332	358	KAF4711357.1 hypothetical protein FOZ63_028272, partial [Perkinsus olseni]	diamond	423	44.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26857478	26857478	PRJNA556992_P_NODE_687401_length_252_cov_1.631285_g685212_i0	PRJNA556992	687401	252	1.631285	4.1108382	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	66.2	4.44e-12	NR	XP_002773395.1	423536	g685212	i0	51.8	1.33333333333333	56	27	66.7	0	251	84	28	83	XP_002773395.1 Small nuclear ribonucleoprotein G, putative [Perkinsus marinus ATCC 50983]	diamond	336	66.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
26997786	26997786	PRJNA556992_P_NODE_550822_length_263_cov_1.484211_g548633_i0	PRJNA556992	550822	263	1.484211	3.90347493	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	110	1.4e-27	NR	KAF4701558.1	32597	g548633	i0	65.1	5.70342205323194	83	29	94.7	0	263	15	51	133	KAF4701558.1 Protein transport protein Sec61 subunit alpha [Perkinsus olseni]	diamond	1500	110	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27566734	27566734	PRJNA556992_P_NODE_957064_length_235_cov_2.500000_g954874_i0	PRJNA556992	957064	235	2.5	5.875	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	58.2	1.26e-7	NR	KAF4673079.1	330153	g954874	i0	46.7	4.87659574468085	75	38	95.7	1	2	226	903	975	KAF4673079.1 translational elongation factor EF-1 alpha [Perkinsus chesapeaki]	diamond	1146	58.5	0.994871794871795	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
28121004	28121004	PRJNA556992_P_NODE_861085_length_243_cov_0.905882_g858895_i0	PRJNA556992	861085	243	0.905882	2.20129326	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	77	2.31e-14	NR	KAF4676295.1	330153	g858895	i0	69.4	3.64197530864198	49	15	60.5	0	5	151	325	373	KAF4676295.1 WD repeat-containing protein 92 [Perkinsus chesapeaki]	diamond	885	77	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
29857302	29857302	PRJNA556992_P_NODE_383471_length_278_cov_2.463415_g381282_i0	PRJNA556992	383471	278	2.463415	6.8482937	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	55.1	4.33e-7	NR	XP_002769198.1	423536	g381282	i0	61.8	1.10071942446043	34	13	36.7	0	115	216	46	79	XP_002769198.1 conserved hypothetical protein, partial [Perkinsus marinus ATCC 50983]	diamond	306	55.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31184226	31184226	PRJNA556992_P_NODE_715715_length_250_cov_2.463277_g713526_i0	PRJNA556992	715715	250	2.463277	6.1581925	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	52.8	1.19e-5	NR	KAF4657269.1	330153	g713526	i0	58.8	0.408	34	14	40.8	0	213	112	440	473	KAF4657269.1 hypothetical protein FOL47_008531 [Perkinsus chesapeaki]	diamond	102	52.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
32621996	32621996	PRJNA556992_P_NODE_439580_length_273_cov_1.055000_g437391_i0	PRJNA556992	439580	273	1.055	2.88015	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	65.1	2.22e-10	NR	KAF4676497.1	330153	g437391	i0	48.5	5.97802197802198	68	27	74.7	1	269	66	4	63	KAF4676497.1 hypothetical protein FOL47_006135 [Perkinsus chesapeaki]	diamond	1632	65.5	0.993893129770992	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki

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