metadata: contig_metadata: 6 rows where bioproject = "PRJEB36940", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJEB36940", 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
16633598	16633598	PRJEB36940_P_NODE_1614_length_657_cov_4.015411_g1494_i0	PRJEB36940	1614	657	4.015411	26.38125027	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	274	1.74e-90	NR	XP_002778466.1	423536	g1494	i0	70	0.867579908675799	190	56	86.3	1	608	42	1	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	570	274	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28163878	28163878	PRJEB36940_P_NODE_9585_length_282_cov_1.234450_g9456_i0	PRJEB36940	9585	282	1.23445	3.481149	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	134	2.04e-38	NR	KAF4747601.1	32597	g9456	i0	80	26.2659574468085	85	17	90.4	0	256	2	1	85	KAF4747601.1 40S ribosomal protein S17 [Perkinsus olseni]	diamond	7407	135	0.992592592592593	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28423157	28423157	PRJEB36940_P_NODE_7586_length_314_cov_1.161826_g7457_i0	PRJEB36940	7586	314	1.161826	3.64813364	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	151	3.459999999999999e-43	NR	XP_002788034.1	423536	g7457	i0	66.3	1.81528662420382	95	32	90.8	0	286	2	14	108	XP_002788034.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	570	151	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29805559	29805559	PRJEB36940_P_NODE_7691_length_312_cov_1.292887_g7562_i0	PRJEB36940	7691	312	1.292887	4.03380744	Perkinsida	27998	SAR_Eukaryotes	SAR_Eukaryotes	59.7	8.64e-8	NR	KAF4658313.1	330153	g7562	i0	35.2	2.61538461538462	91	58	87.5	1	275	3	182	271	KAF4658313.1 hypothetical protein FOL47_008024 [Perkinsus chesapeaki]	diamond	816	59.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31006190	31006190	PRJEB36940_P_NODE_7494_length_316_cov_1.271605_g7365_i0	PRJEB36940	7494	316	1.271605	4.0182718	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	88.2	2.76e-18	NR	KAF4742019.1	32597	g7365	i0	39.8	4.7373417721519004	103	59	97.8	1	311	3	182	281	KAF4742019.1 hypothetical protein FOZ63_033582, partial [Perkinsus olseni]	diamond	1497	88.6	0.99548532731377	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32562924	32562924	PRJEB36940_P_NODE_12459_length_252_cov_0.871508_g12330_i0	PRJEB36940	12459	252	0.871508	2.19620016	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	46.6	8.75e-4	NR	KAF4672085.1	330153	g12330	i0	47.7	0.523809523809524	44	22	52.4	1	239	108	35	77	KAF4672085.1 hypothetical protein FOL47_000952 [Perkinsus chesapeaki]	diamond	132	46.6	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);;