metadata: contig_metadata: 15 rows where bioproject = "PRJNA520845" and tax

15 rows where bioproject = "PRJNA520845" 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
3663009	3663009	PRJNA520845_P_NODE_257823_length_243_cov_0.905882_g256324_i0	PRJNA520845	257823	243	0.905882	2.20129326	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	121	7.789999999999998e-32	NR	TEB14745.1	2494336	g256324	i0	74.4	3.03703703703704	82	19	98.8	1	3	242	121	202	TEB14745.1 ribosomal protein L2 [Perkinsus sp. BL_2016]	diamond	738	121	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
8140832	8140832	PRJNA520845_P_NODE_124067_length_335_cov_1.248092_g122568_i0	PRJNA520845	124067	335	1.248092	4.1811082	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	54.7	4.98e-6	NR	TEB19254.1	2494336	g122568	i0	39.3	0.797014925373134	89	50	79.7	2	269	3	138	222	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	267	54.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
15791940	15791940	PRJNA520845_P_NODE_179113_length_278_cov_1.878049_g177614_i0	PRJNA520845	179113	278	1.878049	5.22097622	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	117	8.95e-22	NTclustered	gi\|294933094\|ref\|XM_002780549.1\|	423536	g177614	i0	79.412	3	170	31	60	4	3	170	427	594	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	834	117	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
17068745	17068745	PRJNA520845_P_NODE_263174_length_241_cov_1.833333_g261675_i0	PRJNA520845	263174	241	1.833333	4.41833253	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	115	2.73e-21	NTclustered	gi\|294925483\|ref\|XM_002778887.1\|	423536	g261675	i0	80.952	13.3070539419087	147	26	61	2	96	241	444	299	Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA	blastn	3207	115	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
18339007	18339007	PRJNA520845_P_NODE_108055_length_358_cov_1.178947_g106556_i0	PRJNA520845	108055	358	1.178947	4.22063026	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	139	3.5499999999999995e-37	NR	KAF4692036.1	32597	g106556	i0	61.6	9.1340782122905	99	38	83	0	298	2	1	99	KAF4692036.1 hypothetical protein FOZ62_017327 [Perkinsus olseni]	diamond	3270	139	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
19613538	19613538	PRJNA520845_P_NODE_113316_length_350_cov_1.111913_g111817_i0	PRJNA520845	113316	350	1.111913	3.8916955	root	1	Root_unresolved	Root_unresolved	172	4.1e-51	NR	KAF4689453.1	32597	g111817	i0	72.8	31.2857142857143	114	31	97.7	0	345	4	39	152	KAF4689453.1 40S ribosomal protein S4, X isoform [Perkinsus olseni]	diamond	10950	172	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
19619312	19619312	PRJNA520845_P_NODE_92036_length_387_cov_1.471338_g90537_i0	PRJNA520845	92036	387	1.471338	5.69407806	Perkinsida	27998	SAR_Eukaryotes	SAR_Eukaryotes	186	1.45e-51	NR	KAF4665937.1	330153	g90537	i0	73.4	21.8294573643411	128	34	99.2	0	2	385	621	748	KAF4665937.1 Splicing factor 3B subunit 1 [Perkinsus chesapeaki]	diamond	8448	187	0.994652406417112	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
24718645	24718645	PRJNA520845_P_NODE_62740_length_470_cov_1.639798_g61241_i0	PRJNA520845	62740	470	1.639798	7.7070506	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	228	2.8299999999999998e-74	NR	XP_002768542.1	423536	g61241	i0	77.2	17.5787234042553	145	33	92.6	0	7	441	1	145	XP_002768542.1 ribosomal protein S23, putative [Perkinsus marinus ATCC 50983]	diamond	8262	228	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27362063	27362063	PRJNA520845_P_NODE_96343_length_378_cov_2.678689_g94844_i0	PRJNA520845	96343	378	2.678689	10.125444419999999	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	147	4.9e-40	NR	XP_002780198.1	423536	g94844	i0	62.5	1.64285714285714	104	39	82.5	0	377	66	260	363	XP_002780198.1 cAMP-dependent protein kinase catalytic subunit, putative [Perkinsus marinus ATCC 50983]	diamond	621	147	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28182475	28182475	PRJNA520845_P_NODE_261686_length_242_cov_0.911243_g260187_i0	PRJNA520845	261686	242	0.911243	2.20520806	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	76.3	2.93e-14	NR	XP_002764392.1	423536	g260187	i0	61.8	8.21900826446281	55	20	66.9	1	163	2	18	72	XP_002764392.1 homeobox-containing protein, putative, partial [Perkinsus marinus ATCC 50983]	diamond	1989	76.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28277311	28277311	PRJNA520845_P_NODE_75226_length_428_cov_1.518310_g73727_i0	PRJNA520845	75226	428	1.51831	6.4983668	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	222	5.1e-67	NR	XP_002786963.1	423536	g73727	i0	75.4	2.98598130841122	142	35	99.5	0	426	1	116	257	XP_002786963.1 Isocitrate lyase, putative [Perkinsus marinus ATCC 50983]	diamond	1278	222	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28719561	28719561	PRJNA520845_P_NODE_41487_length_585_cov_1.169922_g40010_i0	PRJNA520845	41487	585	1.169922	6.8440437	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	113	5.39e-27	NR	TEB19254.1	2494336	g40010	i0	39.2	0.969230769230769	189	106	92.3	3	46	585	3	191	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	567	113	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
29476903	29476903	PRJNA520845_P_NODE_179650_length_278_cov_1.282927_g178151_i0	PRJNA520845	179650	278	1.282927	3.56653706	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	48.1	3.27e-4	NR	XP_002777755.1	423536	g178151	i0	33.7	0.960431654676259	89	58	95	1	268	5	6	94	XP_002777755.1 S-phase kinase-associated protein 1A, putative [Perkinsus marinus ATCC 50983]	diamond	267	48.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31008878	31008878	PRJNA520845_P_NODE_240214_length_246_cov_0.890173_g238715_i0	PRJNA520845	240214	246	0.890173	2.18982558	Phaeophyceae	2870	SAR_Eukaryotes	SAR_Eukaryotes	124	1.9199999999999999e-31	NR	KAF4666479.1	330153	g238715	i0	67.9	7.80487804878049	81	26	98.8	0	244	2	9	89	KAF4666479.1 ADP-ribosylation factor GTPase-activating protein 1 [Perkinsus chesapeaki]	diamond	1920	124	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
32480307	32480307	PRJNA520845_P_NODE_218859_length_250_cov_0.870056_g217360_i0	PRJNA520845	218859	250	0.870056	2.17514	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	67	4.48e-11	NR	KAF4725977.1	32597	g217360	i0	49.3	3.3	67	30	80.4	1	1	201	43	105	KAF4725977.1 hypothetical protein FOZ63_008683, partial [Perkinsus olseni]	diamond	825	67	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni

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);;