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

5 rows where bioproject = "PRJNA704949", tax_clade = "Sar" and tax_phylum = "Foraminifera"

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_family	tax_genus	tax_species
27778545	27778545	PRJNA704949_P_NODE_811984_length_295_cov_2.113821_g796652_i0	PRJNA704949	811984	295	2.113821	6.23577195	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.0111	NR	ETO26163.1	46433	g796652	i0	50	0.406779661016949	40	19	40.7	1	155	274	31	69	ETO26163.1 hypothetical protein RFI_10972 [Reticulomyxa filosa]	diamond	120	45.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28314817	28314817	PRJNA704949_P_NODE_1555546_length_196_cov_1.414966_g1540207_i0	PRJNA704949	1555546	196	1.414966	2.77333336	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	47.4	4.72e-4	NR	ETO25130.1	46433	g1540207	i0	57.1	1.10204081632653	35	15	53.6	0	166	62	316	350	ETO25130.1 hypothetical protein RFI_12017 [Reticulomyxa filosa]	diamond	216	47.4	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29357000	29357000	PRJNA704949_P_NODE_296709_length_493_cov_2.693694_g281925_i0	PRJNA704949	296709	493	2.693694	13.27991142	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	94.4	6.07e-19	NR	ETO14567.1	46433	g281925	i0	34.1	0.997971602434077	164	86	99.2	5	1	489	283	425	ETO14567.1 hypothetical protein RFI_22803 [Reticulomyxa filosa]	diamond	492	94.4	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30273191	30273191	PRJNA704949_P_NODE_401612_length_429_cov_1.642105_g386500_i0	PRJNA704949	401612	429	1.642105	7.04463045	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	114	1.19e-27	NR	ETO27333.1	46433	g386500	i0	43	2.21678321678322	151	63	98.6	3	3	425	168	305	ETO27333.1 SET domain containing protein [Reticulomyxa filosa]	diamond	951	114	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31410262	31410262	PRJNA704949_P_NODE_1389496_length_211_cov_1.604938_g1374158_i0	PRJNA704949	1389496	211	1.604938	3.38641918	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	62.8	7.89e-10	NR	ETO25545.1	46433	g1374158	i0	54.2	0.682464454976303	48	22	68.2	0	169	26	87	134	ETO25545.1 phosphatidylinositol kinase, partial [Reticulomyxa filosa]	diamond	144	62.8	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa

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