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

9 rows where bioproject = "PRJNA929522", 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
4733791	4733791	PRJNA929522_S_NODE_6224_length_284_cov_6.744076_g6154_i0	PRJNA929522	6224	284	6.744076	19.15317584	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	125	3.3299999999999993e-34	NR	KAF4657124.1	330153	g6154	i0	77.9	7.92253521126761	68	15	71.8	0	209	6	19	86	KAF4657124.1 Eukaryotic translation initiation factor 5A-1 [Perkinsus chesapeaki]	diamond	2250	125	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
8558235	8558235	PRJNA929522_S_NODE_1107_length_609_cov_2.276119_g1042_i0	PRJNA929522	1107	609	2.276119	13.86156471	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	246	8.42e-80	NR	XP_002778466.1	423536	g1042	i0	66.3	0.935960591133005	190	63	93.1	1	30	596	1	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	570	246	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
18756882	18756882	PRJNA929522_S_NODE_435_length_904_cov_29.997593_g392_i0	PRJNA929522	435	904	29.997593	271.17824072	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	129	9.71e-32	NR	TEB19254.1	2494336	g392	i0	33.7	0.886061946902655	267	155	82.6	8	52	798	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
28604008	28604008	PRJNA929522_S_NODE_1587_length_522_cov_5.485523_g1517_i0	PRJNA929522	1587	522	5.485523	28.63443006	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	102	5.2599999999999997e-23	NR	TEB19254.1	2494336	g1517	i0	41.5	0.747126436781609	130	71	74.1	2	40	426	138	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	390	102	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28730290	28730290	PRJNA929522_S_NODE_287_length_1076_cov_23.446660_g251_i0	PRJNA929522	287	1076	23.44666	252.2860616	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	174	1.57e-48	NR	TEB19254.1	2494336	g251	i0	42.4	0.736059479553903	264	140	71.1	4	66	830	3	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	792	174	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
30498850	30498850	PRJNA929522_S_NODE_4973_length_311_cov_1.294118_g4903_i0	PRJNA929522	4973	311	1.294118	4.02470698	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	120	1.33e-29	NR	XP_002767083.1	423536	g4903	i0	50.9	1.09967845659164	114	42	96.5	2	301	2	36	149	XP_002767083.1 glycylpeptide N-tetRadecanoyltransferase, putative [Perkinsus marinus ATCC 50983]	diamond	342	120	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30980034	30980034	PRJNA929522_S_NODE_5494_length_299_cov_1.022124_g5424_i0	PRJNA929522	5494	299	1.022124	3.05615076	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	122	1.07e-29	NR	KAF4651910.1	32597	g5424	i0	56.1	4.91638795986622	98	43	98.3	0	2	295	1489	1586	KAF4651910.1 hypothetical protein FOZ61_010063 [Perkinsus olseni]	diamond	1470	122	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31952965	31952965	PRJNA929522_S_NODE_1957_length_475_cov_4.626866_g1887_i0	PRJNA929522	1957	475	4.626866	21.9776135	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	89.4	3.03e-18	NR	TEB19254.1	2494336	g1887	i0	41.3	0.978947368421053	155	81	92.2	4	445	8	3	156	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	465	89.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
32174748	32174748	PRJNA929522_S_NODE_498_length_863_cov_2.743038_g451_i0	PRJNA929522	498	863	2.743038	23.67241794	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	91.3	1.46e-17	NR	TEB19254.1	2494336	g451	i0	48.6	0.371958285052144	107	52	37.2	2	838	518	160	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	321	91.3	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);;