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

6 rows where bioproject = "PRJNA562549", 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
4373263	4373263	PRJNA562549_P_NODE_33724_length_207_cov_0.890411_g33491_i0	PRJNA562549	33724	207	0.890411	1.84315077	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	6.819999999999999e-31	NR	KAF4690832.1	32597	g33491	i0	88.5	17.1449275362319	61	7	88.4	0	184	2	130	190	KAF4690832.1 hypothetical protein FOZ60_016804 [Perkinsus olseni]	diamond	3549	124	0.991935483870968	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28072068	28072068	PRJNA562549_P_NODE_25925_length_231_cov_1.229412_g25692_i0	PRJNA562549	25925	231	1.229412	2.83994172	root	1	Root_unresolved	Root_unresolved	100	1.36e-22	NR	KAF4691105.1	32597	g25692	i0	60	11.6493506493506	75	30	97.4	0	6	230	335	409	KAF4691105.1 phosphoglycerate kinase [Perkinsus olseni]	diamond	2691	100	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28879100	28879100	PRJNA562549_P_NODE_35108_length_204_cov_2.118881_g34875_i0	PRJNA562549	35108	204	2.118881	4.32251724	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	111	7.89e-28	NR	XP_002774056.1	423536	g34875	i0	76.1	0.985294117647059	67	16	98.5	0	203	3	144	210	XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	201	111	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30521480	30521480	PRJNA562549_P_NODE_31613_length_211_cov_0.866667_g31380_i0	PRJNA562549	31613	211	0.866667	1.82866737	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	60.1	1.73e-8	NR	KAF4674605.1	330153	g31380	i0	70.3	2.74407582938389	37	11	52.6	0	167	57	96	132	KAF4674605.1 hypothetical protein FOL47_008996 [Perkinsus chesapeaki]	diamond	579	60.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31198432	31198432	PRJNA562549_P_NODE_18835_length_267_cov_2.597087_g18602_i0	PRJNA562549	18835	267	2.597087	6.93422229	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00475	NR	KAF4755746.1	32597	g18602	i0	65.5	2.23595505617978	29	10	32.6	0	89	3	44	72	KAF4755746.1 hypothetical protein FOZ63_024547, partial [Perkinsus olseni]	diamond	597	45.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32165775	32165775	PRJNA562549_P_NODE_25378_length_233_cov_1.511628_g25145_i0	PRJNA562549	25378	233	1.511628	3.52209324	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	89.7	3.35e-19	NR	KAF4727086.1	32597	g25145	i0	57.7	1.86695278969957	71	23	91.4	1	231	19	144	207	KAF4727086.1 asparagine synthetase, partial [Perkinsus olseni]	diamond	435	89.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni

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