metadata: contig_metadata: 5 rows where bioproject = "PRJEB43370", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJEB43370", 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
28226710	28226710	PRJEB43370_P_NODE_9286_length_165_cov_0.896552_g9243_i0	PRJEB43370	9286	165	0.896552	1.4793108	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	80.1	3.06e-16	NR	KAF4684998.1	32597	g9243	i0	73.6	32.8363636363636	53	14	96.4	0	161	3	65	117	KAF4684998.1 Protein phosphatase PP2A regulatory subunit B, partial [Perkinsus olseni]	diamond	5418	80.9	0.990111248454882	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30159600	30159600	PRJEB43370_P_NODE_2292_length_285_cov_2.343220_g2249_i0	PRJEB43370	2292	285	2.34322	6.678177	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	118	1.2e-31	NR	XP_002769307.1	423536	g2249	i0	69.8	2.73684210526316	86	23	88.4	2	271	20	62	146	XP_002769307.1 60S ribosomal protein L27a, putative [Perkinsus marinus ATCC 50983]	diamond	780	118	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31227314	31227314	PRJEB43370_P_NODE_8115_length_168_cov_0.873950_g8072_i0	PRJEB43370	8115	168	0.87395	1.468236	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	66.6	2.22e-11	NR	KAF4700924.1	32597	g8072	i0	61.8	1.96428571428571	55	21	98.2	0	2	166	46	100	KAF4700924.1 hypothetical protein FOZ62_008756, partial [Perkinsus olseni]	diamond	330	67	0.994029850746269	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31796600	31796600	PRJEB43370_P_NODE_6657_length_178_cov_1.209302_g6614_i0	PRJEB43370	6657	178	1.209302	2.15255756	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	75.5	4.98e-15	NR	KAF4700553.1	32597	g6614	i0	64.2	4.58426966292135	53	19	89.3	0	163	5	107	159	KAF4700553.1 hypothetical protein FOZ62_007786, partial [Perkinsus olseni]	diamond	816	75.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32144867	32144867	PRJEB43370_P_NODE_4318_length_215_cov_1.253012_g4275_i0	PRJEB43370	4318	215	1.253012	2.6939758	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	100	8.619999999999999e-23	NR	XP_002765541.1	423536	g4275	i0	67.6	6.93488372093023	71	22	99.1	1	213	1	85	154	XP_002765541.1 heat shock protein, putative [Perkinsus marinus ATCC 50983]	diamond	1491	101	0.99009900990099	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);;