metadata: contig_metadata: 8 rows where bioproject = "PRJNA540466" and tax

8 rows where bioproject = "PRJNA540466" 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
26919684	26919684	PRJNA540466_S_NODE_22262_length_376_cov_3.877888_g21713_i0	PRJNA540466	22262	376	3.877888	14.58085888	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	104	9.119999999999999e-24	NR	KAF4738276.1	32597	g21713	i0	56.1	4.2686170212766	107	41	85.4	2	375	55	179	279	KAF4738276.1 Lactation elevated protein 1, partial [Perkinsus olseni]	diamond	1605	104	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27551575	27551575	PRJNA540466_S_NODE_56584_length_251_cov_2.595506_g56035_i0	PRJNA540466	56584	251	2.595506	6.51472006	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	50.1	8.99e-5	NR	KAF4703653.1	32597	g56035	i0	71.4	0.669322709163347	28	8	33.5	0	232	149	196	223	KAF4703653.1 hypothetical protein FOZ62_001071, partial [Perkinsus olseni]	diamond	168	50.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28720091	28720091	PRJNA540466_S_NODE_39147_length_293_cov_1.063636_g38598_i0	PRJNA540466	39147	293	1.063636	3.11645348	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	111	1.08e-26	NR	TEB20395.1	2494336	g38598	i0	68.7	0.849829351535836	83	26	85	0	290	42	295	377	TEB20395.1 hypothetical protein C9890_0075, partial [Perkinsus sp. BL_2016]	diamond	249	111	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28892623	28892623	PRJNA540466_S_NODE_49688_length_265_cov_1.515625_g49139_i0	PRJNA540466	49688	265	1.515625	4.01640625	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	70.9	6.01e-12	NR	KAF4711357.1	32597	g49139	i0	50.9	3.73584905660377	55	27	62.3	0	1	165	304	358	KAF4711357.1 hypothetical protein FOZ63_028272, partial [Perkinsus olseni]	diamond	990	71.2	0.995786516853933	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30203946	30203946	PRJNA540466_S_NODE_30952_length_324_cov_2.023904_g30403_i0	PRJNA540466	30952	324	2.023904	6.55744896	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	62	1.58e-8	NR	KAF4657269.1	330153	g30403	i0	55.6	0.416666666666667	45	20	41.7	0	320	186	446	490	KAF4657269.1 hypothetical protein FOL47_008531 [Perkinsus chesapeaki]	diamond	135	62	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30267739	30267739	PRJNA540466_S_NODE_52752_length_258_cov_3.670270_g52203_i0	PRJNA540466	52752	258	3.67027	9.4692966	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	89.7	9.38e-20	NR	XP_002778404.1	423536	g52203	i0	82.7	2.52325581395349	52	9	60.5	0	1	156	171	222	XP_002778404.1 ribosomal protein L3, putative [Perkinsus marinus ATCC 50983]	diamond	651	89.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31672945	31672945	PRJNA540466_S_NODE_47477_length_270_cov_1.177665_g46928_i0	PRJNA540466	47477	270	1.177665	3.1796955	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	48.5	4.97e-4	NR	KAF4660789.1	32597	g46928	i0	50	1.4	42	21	46.7	0	258	133	1007	1048	KAF4660789.1 hypothetical protein FOZ61_003751 [Perkinsus olseni]	diamond	378	48.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32590572	32590572	PRJNA540466_S_NODE_25759_length_352_cov_1.204301_g25210_i0	PRJNA540466	25759	352	1.204301	4.23913952	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	65.9	9.96e-10	NR	KAF4657269.1	330153	g25210	i0	51	3.03409090909091	51	25	43.5	0	352	200	449	499	KAF4657269.1 hypothetical protein FOL47_008531 [Perkinsus chesapeaki]	diamond	1068	65.9	1	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);;