metadata: contig_metadata: 8 rows where bioproject = "PRJNA312615", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA312615", 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
2929014	2929014	PRJNA312615_P_NODE_40623_length_192_cov_1.489510_g40472_i0	PRJNA312615	40623	192	1.48951	2.8598592	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	74.3	1.37e-13	NR	KAF4659741.1	330153	g40472	i0	54.5	0.859375	55	25	85.9	0	166	2	305	359	KAF4659741.1 ubiquitin-conjugating enzyme E2 K [Perkinsus chesapeaki]	diamond	165	74.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
8716588	8716588	PRJNA312615_P_NODE_3707_length_609_cov_1.869643_g3568_i0	PRJNA312615	3707	609	1.869643	11.38612587	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	249	7.54e-81	NR	XP_002778466.1	423536	g3568	i0	65.3	0.935960591133005	190	65	93.1	1	582	16	1	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	570	249	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
10581941	10581941	PRJNA312615_P_NODE_22069_length_260_cov_0.957346_g21918_i0	PRJNA312615	22069	260	0.957346	2.4890996	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	88.2	7.28e-19	NR	KAF4724539.1	32597	g21918	i0	48.3	7.02692307692308	87	42	96.9	1	258	7	148	234	KAF4724539.1 hypothetical protein FOZ62_022861 [Perkinsus olseni]	diamond	1827	89	0.991011235955056	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26711713	26711713	PRJNA312615_P_NODE_30141_length_223_cov_1.103448_g29990_i0	PRJNA312615	30141	223	1.103448	2.46068904	Perkinsozoa	2497438	SAR_Eukaryotes	SAR_Eukaryotes	91.7	1.6e-20	NR	KAF4701558.1	32597	g29990	i0	60.3	11.7847533632287	73	29	98.2	0	223	5	66	138	KAF4701558.1 Protein transport protein Sec61 subunit alpha [Perkinsus olseni]	diamond	2628	91.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27422123	27422123	PRJNA312615_P_NODE_16823_length_299_cov_1.424000_g16672_i0	PRJNA312615	16823	299	1.424	4.25776	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	127	1.89e-31	NR	KAF4675435.1	330153	g16672	i0	57.6	9.90301003344482	99	42	99.3	0	298	2	1780	1878	KAF4675435.1 hypothetical protein FOL47_007743 [Perkinsus chesapeaki]	diamond	2961	127	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
29176227	29176227	PRJNA312615_P_NODE_23009_length_254_cov_1.702439_g22858_i0	PRJNA312615	23009	254	1.702439	4.32419506	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	134	1.1e-36	NR	KAF4718353.1	32597	g22858	i0	69	2.97637795275591	84	26	99.2	0	2	253	149	232	KAF4718353.1 hypothetical protein FOZ62_017235, partial [Perkinsus olseni]	diamond	756	135	0.992592592592593	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30548153	30548153	PRJNA312615_P_NODE_24353_length_247_cov_2.590909_g24202_i0	PRJNA312615	24353	247	2.590909	6.39954523	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	67	2.05e-12	NR	XP_002773395.1	423536	g24202	i0	51.8	1.36032388663968	56	27	68	0	245	78	28	83	XP_002773395.1 Small nuclear ribonucleoprotein G, putative [Perkinsus marinus ATCC 50983]	diamond	336	67	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31401678	31401678	PRJNA312615_P_NODE_40476_length_193_cov_0.861111_g40325_i0	PRJNA312615	40476	193	0.861111	1.66194423	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	79	3.36e-15	NR	XP_002777422.1	423536	g40325	i0	54.7	0.994818652849741	64	29	99.5	0	192	1	189	252	XP_002777422.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	192	79	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);;