metadata: contig_metadata: 10 rows where bioproject = "PRJNA1102048", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA1102048", 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
12965570	12965570	PRJNA1102048_P_NODE_1651_length_612_cov_4.178108_g1551_i0	PRJNA1102048	1651	612	4.178108	25.57002096	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	240	1.68e-77	NR	KAF4686610.1	32597	g1551	i0	60.6	0.92156862745098	188	73	91.7	1	570	10	3	190	KAF4686610.1 hypothetical protein FOZ60_005038 [Perkinsus olseni]	diamond	564	240	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
14240463	14240463	PRJNA1102048_P_NODE_14232_length_248_cov_0.880000_g14128_i0	PRJNA1102048	14232	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	111	3.16e-26	NR	KAF4695467.1	32597	g14128	i0	70.4	3.29032258064516	71	19	83.5	1	232	26	308	378	KAF4695467.1 glycerol ethanol, ferric requiring protein [Perkinsus olseni]	diamond	816	111	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
24437660	24437660	PRJNA1102048_P_NODE_4900_length_387_cov_2.197452_g4796_i0	PRJNA1102048	4900	387	2.197452	8.50413924	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	209	3.89e-62	NR	KAF4655331.1	32597	g4796	i0	75.8	64.6589147286822	124	29	96.1	1	11	382	341	463	KAF4655331.1 hypothetical protein FOZ61_007638 [Perkinsus olseni]	diamond	25023	211	0.990521327014218	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29522036	29522036	PRJNA1102048_P_NODE_7370_length_319_cov_1.841463_g7266_i0	PRJNA1102048	7370	319	1.841463	5.87426697	Viridiplantae	33090	SAR_Eukaryotes	SAR_Eukaryotes	148	1.54e-42	NR	KAF4694606.1	32597	g7266	i0	61.7	12.0094043887147	107	40	99.7	1	2	319	89	195	KAF4694606.1 Proteasome subunit alpha 1, variant 2 [Perkinsus olseni]	diamond	3831	149	0.993288590604027	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30130498	30130498	PRJNA1102048_P_NODE_14012_length_248_cov_1.662857_g13908_i0	PRJNA1102048	14012	248	1.662857	4.12388536	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	81.6	8.94e-17	NR	XP_002785517.1	423536	g13908	i0	48.6	2.6491935483871	72	34	87.1	1	217	2	17	85	XP_002785517.1 N-acetyltransferase, putative [Perkinsus marinus ATCC 50983]	diamond	657	81.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30185269	30185269	PRJNA1102048_P_NODE_6312_length_344_cov_0.937269_g6208_i0	PRJNA1102048	6312	344	0.937269	3.22420536	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	145	2.36e-39	NR	KAF4675526.1	330153	g6208	i0	64.9	2.93023255813953	111	39	96.8	0	333	1	262	372	KAF4675526.1 hypothetical protein FOL47_007664 [Perkinsus chesapeaki]	diamond	1008	145	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30690808	30690808	PRJNA1102048_P_NODE_14513_length_247_cov_1.327586_g14409_i0	PRJNA1102048	14513	247	1.327586	3.27913742	Perkinsida	27998	SAR_Eukaryotes	SAR_Eukaryotes	74.3	3.01e-13	NR	KAF4665794.1	330153	g14409	i0	40.7	2.92712550607287	81	48	98.4	0	4	246	696	776	KAF4665794.1 hypothetical protein FOL47_004423 [Perkinsus chesapeaki]	diamond	723	74.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30848871	30848871	PRJNA1102048_P_NODE_9754_length_281_cov_1.480769_g9650_i0	PRJNA1102048	9754	281	1.480769	4.16096089	Bigyra	2683628	SAR_Eukaryotes	SAR_Eukaryotes	87.8	6.16e-19	NR	KAF4653670.1	330153	g9650	i0	60.5	4.39857651245552	81	31	86.5	1	246	4	35	114	KAF4653670.1 18S rRNA pseudouridine methyltransferase, partial [Perkinsus chesapeaki]	diamond	1236	87.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31164528	31164528	PRJNA1102048_P_NODE_6015_length_352_cov_1.820789_g5911_i0	PRJNA1102048	6015	352	1.820789	6.40917728	root	1	Root_unresolved	Root_unresolved	135	6.61e-36	NR	KAF4741851.1	32597	g5911	i0	54.5	8.16477272727273	121	51	99.7	2	1	351	4	124	KAF4741851.1 hypothetical protein FOZ62_016568, partial [Perkinsus olseni]	diamond	2874	135	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31900952	31900952	PRJNA1102048_P_NODE_1377_length_653_cov_9.175862_g1277_i0	PRJNA1102048	1377	653	9.175862	59.91837886	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	271	1.94e-89	NR	XP_002778466.1	423536	g1277	i0	69.5	0.872894333843798	190	57	86.8	1	49	615	1	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	570	271	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);;