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

8 rows where bioproject = "PRJNA1159911", 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
4134225	4134225	PRJNA1159911_P_NODE_21344_length_623_cov_2.241818_g20821_i0	PRJNA1159911	21344	623	2.241818	13.96652614	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	240	1.94e-77	NR	XP_002778466.1	423536	g20821	i0	64.4	0.905296950240771	188	64	90	2	39	599	6	191	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	564	240	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
9235316	9235316	PRJNA1159911_P_NODE_19088_length_673_cov_3.508333_g18578_i0	PRJNA1159911	19088	673	3.508333	23.61108109	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	247	9.27e-80	NR	XP_002778466.1	423536	g18578	i0	66.3	0.846953937592868	190	63	84.2	1	650	84	1	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	570	247	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
13061795	13061795	PRJNA1159911_P_NODE_61111_length_307_cov_1.619658_g60569_i0	PRJNA1159911	61111	307	1.619658	4.97235006	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	172	1.61e-51	NR	XP_002776364.1	423536	g60569	i0	80.4	16.8664495114007	102	19	99.7	1	2	307	25	125	XP_002776364.1 adenosylhomocysteinase, putative [Perkinsus marinus ATCC 50983]	diamond	5178	172	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
14337255	14337255	PRJNA1159911_P_NODE_69632_length_284_cov_2.611374_g69090_i0	PRJNA1159911	69632	284	2.611374	7.41630216	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	141	2.7e-41	NR	KAF4747601.1	32597	g69090	i0	83.3	8.55633802816901	90	14	95.1	1	272	3	1	89	KAF4747601.1 40S ribosomal protein S17 [Perkinsus olseni]	diamond	2430	142	0.992957746478873	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26660193	26660193	PRJNA1159911_P_NODE_54181_length_330_cov_2.112840_g53639_i0	PRJNA1159911	54181	330	2.11284	6.972372	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	72.4	1.44e-12	NR	TEB19254.1	2494336	g53639	i0	45.7	0.736363636363636	81	39	72.7	3	2	241	187	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	243	72.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28019689	28019689	PRJNA1159911_P_NODE_20705_length_636_cov_5.507993_g20183_i0	PRJNA1159911	20705	636	5.507993	35.03083548	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	270	6.269999999999999e-89	NR	XP_002778466.1	423536	g20183	i0	70	0.89622641509434	190	56	89.2	1	29	595	1	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	570	270	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28449493	28449493	PRJNA1159911_P_NODE_66346_length_292_cov_2.132420_g65804_i0	PRJNA1159911	66346	292	2.13242	6.2266664	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	72.4	1.62e-12	NR	KAF4676519.1	330153	g65804	i0	86.5	7.22260273972603	37	5	38	0	291	181	289	325	KAF4676519.1 suppressor of kinetochore protein mutant [Perkinsus chesapeaki]	diamond	2109	72.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
29124924	29124924	PRJNA1159911_P_NODE_63029_length_301_cov_2.280702_g62487_i0	PRJNA1159911	63029	301	2.280702	6.86491302	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0178	NR	TEB19254.1	2494336	g62487	i0	36.4	0.767441860465116	77	48	75.7	1	51	278	3	79	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	231	44.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016

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