metadata: contig_metadata: 6 rows where bioproject = "PRJNA169559" and tax

6 rows where bioproject = "PRJNA169559" 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
10569132	10569132	PRJNA169559_P_NODE_3849_length_855_cov_3.467312_g2700_i0	PRJNA169559	3849	855	3.467312	29.6455176	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	79	4.22e-13	NR	TEB19254.1	2494336	g2700	i0	31	0.701754385964912	200	121	64.2	5	809	261	1	200	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	600	79	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
22041695	22041695	PRJNA169559_P_NODE_4018_length_838_cov_3.833127_g2700_i1	PRJNA169559	4018	838	3.833127	32.12160426	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	132	5.08e-33	NR	TEB19254.1	2494336	g2700	i1	34.5	0.955847255369928	267	153	89.1	8	47	793	1	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	801	132	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
29744009	29744009	PRJNA169559_P_NODE_23790_length_317_cov_2.541667_g21715_i0	PRJNA169559	23790	317	2.541667	8.05708439	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	61.2	9.41e-10	NR	XP_002768158.1	423536	g21715	i0	46.2	3.10410094637224	65	27	61.5	1	314	120	31	87	XP_002768158.1 translation initiation factor SUI1, putative [Perkinsus marinus ATCC 50983]	diamond	984	61.6	0.993506493506494	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30421845	30421845	PRJNA169559_P_NODE_4253_length_815_cov_3.170483_g3037_i0	PRJNA169559	4253	815	3.170483	25.83943645	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	139	6.29e-36	NR	TEB19254.1	2494336	g3037	i0	45.1	0.669938650306748	182	92	65.2	2	177	707	85	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	546	139	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
31401340	31401340	PRJNA169559_P_NODE_4476_length_798_cov_3.322497_g3037_i1	PRJNA169559	4476	798	3.322497	26.51352606	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	160	2.49e-44	NR	TEB19254.1	2494336	g3037	i1	42.4	0.894736842105263	238	125	86.1	4	4	690	29	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	714	160	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
32318880	32318880	PRJNA169559_P_NODE_18679_length_393_cov_1.953297_g16671_i0	PRJNA169559	18679	393	1.953297	7.67645721	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	97.8	7.320000000000001e-21	NR	KAF4677827.1	330153	g16671	i0	51.1	2.06106870229008	92	45	70.2	0	3	278	93	184	KAF4677827.1 Methionine aminopeptidase 2 [Perkinsus chesapeaki]	diamond	810	97.8	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);;