metadata: contig_metadata: 7 rows where bioproject = "PRJNA1000943", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA1000943", 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
1419913	1419913	PRJNA1000943_P_NODE_7602_length_298_cov_2.146667_g7464_i0	PRJNA1000943	7602	298	2.146667	6.39706766	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	113	1.25e-20	NTclustered	gi\|294933094\|ref\|XM_002780549.1\|	423536	g7464	i0	79.394	2.53355704697987	165	30	55	4	136	298	594	432	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	755	113	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
14173805	14173805	PRJNA1000943_P_NODE_6492_length_319_cov_0.930894_g6354_i0	PRJNA1000943	6492	319	0.930894	2.96955186	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	152	2.05e-41	NR	KAF4671046.1	32597	g6354	i0	67	11.9905956112853	106	34	98.7	1	4	318	189	294	KAF4671046.1 hypothetical protein FOZ61_006864 [Perkinsus olseni]	diamond	3825	152	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26868958	26868958	PRJNA1000943_P_NODE_11041_length_253_cov_0.866667_g10903_i0	PRJNA1000943	11041	253	0.866667	2.19266751	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	115	2.11e-28	NR	KAF4683798.1	32597	g10903	i0	69	20.7154150197628	84	26	99.6	0	2	253	5	88	KAF4683798.1 ATP-dependent RNA helicase dbp2 [Perkinsus olseni]	diamond	5241	115	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27413887	27413887	PRJNA1000943_P_NODE_1603_length_599_cov_6.939163_g1468_i0	PRJNA1000943	1603	599	6.939163	41.56558637	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	81.6	9.07e-16	NR	XP_002784356.1	423536	g1468	i0	31.8	1.34724540901502	129	88	64.6	0	532	146	19	147	XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983]	diamond	807	81.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29371292	29371292	PRJNA1000943_P_NODE_13769_length_246_cov_0.901734_g13631_i0	PRJNA1000943	13769	246	0.901734	2.21826564	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0278	NR	KAF4671470.1	330153	g13631	i0	86.4	0.268292682926829	22	3	26.8	0	246	181	26	47	KAF4671470.1 hypothetical protein FOL47_001522 [Perkinsus chesapeaki]	diamond	66	43.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
29465548	29465548	PRJNA1000943_P_NODE_3530_length_414_cov_1.275660_g3393_i0	PRJNA1000943	3530	414	1.27566	5.2812324	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	185	9.97e-57	NR	XP_002778466.1	423536	g3393	i0	65.2	0.978260869565217	135	46	97.1	1	413	12	56	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	405	185	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
32721201	32721201	PRJNA1000943_P_NODE_840_length_809_cov_5.404891_g726_i0	PRJNA1000943	840	809	5.404891	43.72556819	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	174	2.01e-45	NR	KAF4675741.1	330153	g726	i0	41.8	8.08034610630408	232	133	86	2	798	103	748	977	KAF4675741.1 40S ribosomal protein S3-1 [Perkinsus chesapeaki]	diamond	6537	174	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);;