metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA752572" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA752572" 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
5832168	5832168	PRJNA752572_P_NODE_191685_length_192_cov_2.490446_g191178_i0	PRJNA752572	191685	192	2.490446	4.78165632	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	98.2	5.53e-22	NR	KAF4718682.1	32597	g191178	i0	76.2	7.875	63	15	98.4	0	3	191	183	245	KAF4718682.1 hypothetical protein FOZ63_025302, partial [Perkinsus olseni]	diamond	1512	98.6	0.995943204868154	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27115866	27115866	PRJNA752572_P_NODE_95242_length_277_cov_2.161157_g94735_i0	PRJNA752572	95242	277	2.161157	5.98640489	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0166	NR	KAF4693544.1	32597	g94735	i0	32	0.812274368231047	75	51	81.2	0	232	8	54	128	KAF4693544.1 hypothetical protein FOZ60_010724 [Perkinsus olseni]	diamond	225	44.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27621696	27621696	PRJNA752572_P_NODE_282784_length_156_cov_2.165289_g282277_i0	PRJNA752572	282784	156	2.165289	3.37785084	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	55.1	5.19e-7	NR	KAF4677590.1	330153	g282277	i0	53.7	6.28846153846154	41	19	78.8	0	34	156	2	42	KAF4677590.1 Ataxin 3 [Perkinsus chesapeaki]	diamond	981	55.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
28158528	28158528	PRJNA752572_P_NODE_16025_length_665_cov_3.223810_g15616_i0	PRJNA752572	16025	665	3.22381	21.4383365	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	76.3	4.58e-12	NR	KAF4733279.1	32597	g15616	i0	48.7	0.703759398496241	78	36	33.4	1	663	442	319	396	KAF4733279.1 mRNA-binding ribosome synthesis protein [Perkinsus olseni]	diamond	468	76.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28862675	28862675	PRJNA752572_P_NODE_280208_length_159_cov_2.185484_g279701_i0	PRJNA752572	280208	159	2.185484	3.47491956	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00629	NR	KAF4675177.1	330153	g279701	i0	45.5	2.13207547169811	44	18	71.7	2	143	30	114	157	KAF4675177.1 hypothetical protein FOL47_008184 [Perkinsus chesapeaki]	diamond	339	43.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30379079	30379079	PRJNA752572_P_NODE_207912_length_184_cov_2.080537_g207405_i0	PRJNA752572	207912	184	2.080537	3.82818808	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	65.5	2.4e-11	NR	KAF4737185.1	32597	g207405	i0	48.3	3.78260869565217	60	31	97.8	0	184	5	44	103	KAF4737185.1 DNA-directed RNA polymerases I and III subunit RPAC1, partial [Perkinsus olseni]	diamond	696	65.9	0.993930197268589	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31674472	31674472	PRJNA752572_P_NODE_41037_length_427_cov_1.974490_g40532_i0	PRJNA752572	41037	427	1.97449	8.4310723	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	117	3.14e-31	NR	KAF4747601.1	32597	g40532	i0	80.8	22.6088992974239	73	14	51.3	0	9	227	1	73	KAF4747601.1 40S ribosomal protein S17 [Perkinsus olseni]	diamond	9654	118	0.991525423728814	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32654651	32654651	PRJNA752572_P_NODE_195480_length_190_cov_2.600000_g194973_i0	PRJNA752572	195480	190	2.6	4.94	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.013	NR	XP_002769861.1	423536	g194973	i0	51.2	5.2578947368421	41	20	64.7	0	188	66	203	243	XP_002769861.1 splicing factor, putative [Perkinsus marinus ATCC 50983]	diamond	999	43.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);;