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

9 rows where bioproject = "PRJNA1199330", 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
27009150	27009150	PRJNA1199330_P_NODE_36862_length_341_cov_0.858209_g36163_i0	PRJNA1199330	36862	341	0.858209	2.92649269	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	48.9	7.05e-4	NR	KAF4710102.1	32597	g36163	i0	44.6	2.28739002932551	65	24	46.6	2	138	296	123	187	KAF4710102.1 hypothetical protein FOZ63_030741, partial [Perkinsus olseni]	diamond	780	48.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27186071	27186071	PRJNA1199330_P_NODE_115162_length_242_cov_5.047337_g114463_i0	PRJNA1199330	115162	242	5.047337	12.21455554	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	62.8	2.92e-9	NR	KAF4705211.1	32597	g114463	i0	56.5	5.33057851239669	46	20	57	0	3	140	207	252	KAF4705211.1 hypothetical protein FOZ62_003239 [Perkinsus olseni]	diamond	1290	63.2	0.993670886075949	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27597126	27597126	PRJNA1199330_P_NODE_49844_length_303_cov_2.213043_g49145_i0	PRJNA1199330	49844	303	2.213043	6.70552029	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	49.7	1.78e-4	NR	XP_002773820.1	423536	g49145	i0	56.1	1.3960396039604	41	18	40.6	0	178	300	20	60	XP_002773820.1 hypothetical protein Pmar_PMAR011664 [Perkinsus marinus ATCC 50983]	diamond	423	49.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28177720	28177720	PRJNA1199330_P_NODE_42406_length_316_cov_1.596708_g41707_i0	PRJNA1199330	42406	316	1.596708	5.04559728	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	62.4	1.15e-8	NR	KAF4746249.1	32597	g41707	i0	27.2	8.85759493670886	103	72	97.8	1	8	316	1014	1113	KAF4746249.1 hypothetical protein FOZ63_016075 [Perkinsus olseni]	diamond	2799	62.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29144390	29144390	PRJNA1199330_P_NODE_112689_length_244_cov_2.725146_g111990_i0	PRJNA1199330	112689	244	2.725146	6.64935624	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00427	NR	KAF4659497.1	32597	g111990	i0	40	5.11475409836066	60	33	73.8	1	53	232	82	138	KAF4659497.1 hypothetical protein FOL46_006563, partial [Perkinsus olseni]	diamond	1248	45.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30546500	30546500	PRJNA1199330_P_NODE_66453_length_285_cov_1.471698_g65754_i0	PRJNA1199330	66453	285	1.471698	4.1943393	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	47.4	0.00128	NR	KAF4671107.1	330153	g65754	i0	28.7	1.67368421052632	94	50	98.9	2	2	283	50	126	KAF4671107.1 hypothetical protein FOL47_001697 [Perkinsus chesapeaki]	diamond	477	47.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30799096	30799096	PRJNA1199330_P_NODE_108214_length_247_cov_3.724138_g107515_i0	PRJNA1199330	108214	247	3.724138	9.19862086	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	54.7	2.25e-6	NR	KAF4668906.1	330153	g107515	i0	58.3	1.03238866396761	48	19	57.1	1	6	146	331	378	KAF4668906.1 hypothetical protein FOL47_002812 [Perkinsus chesapeaki]	diamond	255	54.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31874154	31874154	PRJNA1199330_P_NODE_12977_length_572_cov_1.400802_g12297_i0	PRJNA1199330	12977	572	1.400802	8.01258744	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	63.9	3.4e-8	NR	KAF4736437.1	32597	g12297	i0	27.7	1.66783216783217	159	102	81.3	5	5	469	114	263	KAF4736437.1 hypothetical protein FOZ62_016183, partial [Perkinsus olseni]	diamond	954	63.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32000762	32000762	PRJNA1199330_P_NODE_115678_length_242_cov_1.846154_g114979_i0	PRJNA1199330	115678	242	1.846154	4.46769268	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	52	2e-5	NR	KAF4672480.1	330153	g114979	i0	49	1.97107438016529	51	25	63.2	1	237	85	68	117	KAF4672480.1 hypothetical protein FOL47_000479 [Perkinsus chesapeaki]	diamond	477	52	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);;