metadata: contig_metadata: 27 rows where bioproject = "PRJEB64798" and tax

27 rows where bioproject = "PRJEB64798" 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
127209	127209	PRJEB64798_P_NODE_15981_length_498_cov_76.904232_g14288_i0	PRJEB64798	15981	498	76.904232	382.98307536	uncultured Perkinsea	373149	SAR_Eukaryotes	SAR_Eukaryotes	649	0	NTclustered	gi\|918566078\|gb\|KP122543.1\|	373149	g14288	i0	95.771	80.6164658634538	402	17	81	0	5	406	122	523	Uncultured Perkinsea clone G2013_T1_A7 18S ribosomal RNA gene, partial sequence	blastn	40147	649	1	Eukaryota	Sar	Perkinsozoa				uncultured Perkinsea
128202	128202	PRJEB64798_P_NODE_22881_length_413_cov_43.750000_g21139_i0	PRJEB64798	22881	413	43.75	180.6875	Salmoxcellia vastator	2874172	SAR_Eukaryotes	SAR_Eukaryotes	78.7	6.55e-10	NTclustered	gi\|2258116978\|gb\|ON819178.1\|	2874172	g21139	i0	82.759	0.210653753026634	87	15	21	0	195	281	4584	4670	Salmoxcellia vastator strain BC241120 internal transcribed spacer region, partial sequence	blastn	87	78.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Xcellidae	Salmoxcellia	Salmoxcellia vastator
4821111	4821111	PRJEB64798_P_NODE_191204_length_170_cov_1.809917_g189438_i0	PRJEB64798	191204	170	1.809917	3.0768589	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	78.7	2.35e-10	NTclustered	gi\|38885066\|gb\|AY391259.1\|	31276	g189438	i0	81.633	1.93529411764706	98	14	56	4	8	103	567	662	Perkinsus marinus heat shock protein 90 gene, partial cds	blastn	329	78.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
7371050	7371050	PRJEB64798_P_NODE_47446_length_285_cov_3.699153_g45681_i0	PRJEB64798	47446	285	3.699153	10.54258605	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	132	3.29e-26	NTclustered	gi\|22417090\|gb\|AF509333.1\|	32597	g45681	i0	89.423	5.52631578947368	104	11	36	0	177	280	7058	6955	Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	1575	132	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
9055209	9055209	PRJEB64798_P_NODE_206988_length_165_cov_7.913793_g205222_i0	PRJEB64798	206988	165	7.913793	13.05775845	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	106	6.28e-28	NR	KAF4712719.1	32597	g205222	i0	92.5	32.5272727272727	53	4	96.4	0	5	163	47	99	KAF4712719.1 hypothetical protein FOZ62_014219, partial [Perkinsus olseni]	diamond	5367	107	0.990654205607477	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
20527954	20527954	PRJEB64798_P_NODE_143417_length_191_cov_23.725352_g141651_i0	PRJEB64798	143417	191	23.725352	45.31542232	uncultured Perkinsea	373149	SAR_Eukaryotes	SAR_Eukaryotes	204	4.289999999999999e-48	NTclustered	gi\|918566068\|gb\|KP122533.1\|	373149	g141651	i0	90.323	81.8638743455497	155	15	81	0	32	186	287	133	Uncultured Perkinsea clone BIB6_B2 18S ribosomal RNA gene, partial sequence	blastn	15636	204	1	Eukaryota	Sar	Perkinsozoa				uncultured Perkinsea
22669827	22669827	PRJEB64798_P_NODE_155818_length_185_cov_7.205882_g154052_i0	PRJEB64798	155818	185	7.205882	13.3308817	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	100	5.56e-17	NTclustered	gi\|22417090\|gb\|AF509333.1\|	32597	g154052	i0	77.901	5.39459459459459	181	26	94	12	13	185	5609	5783	Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	998	100	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
23079397	23079397	PRJEB64798_P_NODE_170919_length_178_cov_5.155039_g169153_i0	PRJEB64798	170919	178	5.155039	9.17596942	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	106	1.14e-18	NTclustered	gi\|22417090\|gb\|AF509333.1\|	32597	g169153	i0	78.212	40.5056179775281	179	29	98	10	5	178	5618	5791	Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	7210	106	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
23946211	23946211	PRJEB64798_P_NODE_89899_length_212_cov_7.024540_g88133_i0	PRJEB64798	89899	212	7.02454	14.8920248	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	82.4	2.38e-11	NTclustered	gi\|218526343\|gb\|EU919449.1\|	31276	g88133	i0	94.34	25.0330188679245	53	3	25	0	4	56	932	880	Perkinsus marinus isolate EBPICv15-H6-G5 clone 3 large subunit ribosomal RNA gene, partial sequence	blastn	5307	82.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
25219511	25219511	PRJEB64798_P_NODE_28260_length_370_cov_86.299065_g26504_i0	PRJEB64798	28260	370	86.299065	319.3065405	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	222	2.53e-53	NTclustered	gi\|22417090\|gb\|AF509333.1\|	32597	g26504	i0	88.172	49.1243243243243	186	22	50	0	1	186	6902	7087	Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	18176	222	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27184707	27184707	PRJEB64798_P_NODE_127882_length_199_cov_5.400000_g126116_i0	PRJEB64798	127882	199	5.4	10.746	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	58.5	5.24e-8	NR	KAF4755778.1	32597	g126116	i0	53.3	1.80904522613065	60	24	84.4	1	193	26	284	343	KAF4755778.1 hypothetical protein FOZ63_002465, partial [Perkinsus olseni]	diamond	360	58.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27191728	27191728	PRJEB64798_P_NODE_243582_length_154_cov_2.771429_g241816_i0	PRJEB64798	243582	154	2.771429	4.26800066	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	96.3	1.39e-21	NR	XP_002787493.1	423536	g241816	i0	83.3	5.61038961038961	48	8	93.5	0	10	153	364	411	XP_002787493.1 protein phosphatase PP2A, putative [Perkinsus marinus ATCC 50983]	diamond	864	96.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27311558	27311558	PRJEB64798_P_NODE_243283_length_154_cov_3.228571_g241517_i0	PRJEB64798	243283	154	3.228571	4.97199934	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	63.9	3.72e-10	NR	XP_002774627.1	423536	g241517	i0	58	2.72727272727273	50	15	85.7	1	23	154	594	643	XP_002774627.1 cathepsin z, putative [Perkinsus marinus ATCC 50983]	diamond	420	64.3	0.993779160186625	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27886678	27886678	PRJEB64798_P_NODE_71125_length_229_cov_4.977778_g69360_i0	PRJEB64798	71125	229	4.977778	11.39911162	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0112	NR	TEB19254.1	2494336	g69360	i0	39	1.00873362445415	77	40	91.7	2	11	220	64	140	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	231	43.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
27981459	27981459	PRJEB64798_P_NODE_244465_length_153_cov_12.971154_g242699_i0	PRJEB64798	244465	153	12.971154	19.84586562	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	53.1	1.05e-6	NR	TEB19098.1	2494336	g242699	i0	46	0.980392156862745	50	27	98	0	150	1	85	134	TEB19098.1 hypothetical protein C9890_0276, partial [Perkinsus sp. BL_2016]	diamond	150	53.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28013030	28013030	PRJEB64798_P_NODE_121645_length_205_cov_6.423077_g119879_i0	PRJEB64798	121645	205	6.423077	13.16730785	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	97.4	1.2600000000000002e-21	NR	XP_002766883.1	423536	g119879	i0	70.1	12.7024390243902	67	20	98	0	201	1	271	337	XP_002766883.1 heat shock protein 70 precursor, putative [Perkinsus marinus ATCC 50983]	diamond	2604	97.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28518212	28518212	PRJEB64798_P_NODE_206627_length_165_cov_13.612069_g204861_i0	PRJEB64798	206627	165	13.612069	22.45991385	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0136	NR	XP_002785640.1	423536	g204861	i0	58.6	0.527272727272727	29	12	52.7	0	120	34	211	239	XP_002785640.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	87	42.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28890013	28890013	PRJEB64798_P_NODE_242048_length_154_cov_6.619048_g240282_i0	PRJEB64798	242048	154	6.619048	10.19333392	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	84	6.03e-18	NR	KAF4694251.1	32597	g240282	i0	81.3	12.1558441558442	48	9	93.5	0	146	3	138	185	KAF4694251.1 Ribosome bioproteinsis protein [Perkinsus olseni]	diamond	1872	84	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29174414	29174414	PRJEB64798_P_NODE_193049_length_169_cov_3.725000_g191283_i0	PRJEB64798	193049	169	3.725	6.29525	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	94.4	2.13e-21	NR	KAF4698419.1	32597	g191283	i0	83	7.52662721893491	53	9	94.1	0	160	2	155	207	KAF4698419.1 hypothetical protein FOZ62_011793 [Perkinsus olseni]	diamond	1272	94.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29584404	29584404	PRJEB64798_P_NODE_129110_length_198_cov_14.033557_g127344_i0	PRJEB64798	129110	198	14.033557	27.78644286	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	49.3	9.88e-5	NR	KAF4724294.1	32597	g127344	i0	79.3	1.75757575757576	29	6	43.9	0	88	2	435	463	KAF4724294.1 hypothetical protein FOZ62_005715 [Perkinsus olseni]	diamond	348	49.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31195503	31195503	PRJEB64798_P_NODE_204835_length_166_cov_2.247863_g203069_i0	PRJEB64798	204835	166	2.247863	3.73145258	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	110	6.77e-29	NR	KAF4691727.1	32597	g203069	i0	86.8	5.74698795180723	53	7	95.8	0	159	1	57	109	KAF4691727.1 E2 SUMO-conjugating protein ubc9 [Perkinsus olseni]	diamond	954	110	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31677234	31677234	PRJEB64798_P_NODE_38837_length_317_cov_5.097015_g37074_i0	PRJEB64798	38837	317	5.097015	16.15753755	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	87.8	1.14e-17	NR	KAF4677256.1	330153	g37074	i0	52.9	1.68454258675079	87	36	82.3	1	282	22	1	82	KAF4677256.1 Cytosolic seryl-tRNA synthetase [Perkinsus chesapeaki]	diamond	534	87.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31803738	31803738	PRJEB64798_P_NODE_9037_length_662_cov_6.296900_g7597_i0	PRJEB64798	9037	662	6.2969	41.685478	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	114	1.8e-26	NR	KAF4669530.1	32597	g7597	i0	34.2	3.62537764350453	199	122	89.7	4	52	645	18	208	KAF4669530.1 hypothetical protein FOL46_001353 [Perkinsus olseni]	diamond	2400	114	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31835334	31835334	PRJEB64798_P_NODE_81437_length_214_cov_2.878788_g79671_i0	PRJEB64798	81437	214	2.878788	6.16060632	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.00673	NR	KAF4688345.1	32597	g79671	i0	79.2	0.336448598130841	24	5	33.6	0	208	137	225	248	KAF4688345.1 Transmembrane BAX inhibitor motif-containing protein 4 [Perkinsus olseni]	diamond	72	44.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32215059	32215059	PRJEB64798_P_NODE_117018_length_208_cov_3.314465_g115252_i0	PRJEB64798	117018	208	3.314465	6.8940872	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	52	1.29e-5	NR	XP_002785670.1	423536	g115252	i0	51.1	2.32211538461538	45	22	64.9	0	71	205	28	72	XP_002785670.1 nitric-oxide synthase, putative [Perkinsus marinus ATCC 50983]	diamond	483	52	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
32429728	32429728	PRJEB64798_P_NODE_180299_length_174_cov_3.904000_g178533_i0	PRJEB64798	180299	174	3.904	6.79296	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.82e-12	NR	KAF4714612.1	32597	g178533	i0	76.2	6.51724137931035	42	10	72.4	0	49	174	19	60	KAF4714612.1 hypothetical protein FOZ63_033635, partial [Perkinsus olseni]	diamond	1134	71.6	0.990223463687151	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32436847	32436847	PRJEB64798_P_NODE_191579_length_170_cov_1.247934_g189813_i0	PRJEB64798	191579	170	1.247934	2.1214878	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.0021	NR	XP_002767145.1	423536	g189813	i0	48.6	0.652941176470588	37	19	65.3	0	153	43	74	110	XP_002767145.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	111	45.1	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);;