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

5 rows where bioproject = "PRJNA438572", 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
26822977	26822977	PRJNA438572_P_NODE_24461_length_242_cov_0.923077_g24342_i0	PRJNA438572	24461	242	0.923077	2.23384634	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	66.6	1.39e-10	NR	ETO25164.1	46433	g24342	i0	41	1.93388429752066	78	41	94.2	2	235	8	8	82	ETO25164.1 hypothetical protein RFI_11981 [Reticulomyxa filosa]	diamond	468	66.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27928857	27928857	PRJNA438572_P_NODE_12285_length_293_cov_1.886364_g12166_i0	PRJNA438572	12285	293	1.886364	5.52704652	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	75.5	9.64e-14	NR	ETO32916.1	46433	g12166	i0	62.8	0.860068259385666	43	16	44	0	291	163	87	129	ETO32916.1 hypothetical protein RFI_04200 [Reticulomyxa filosa]	diamond	252	75.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30834303	30834303	PRJNA438572_P_NODE_5654_length_421_cov_1.272989_g5535_i0	PRJNA438572	5654	421	1.272989	5.35928369	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	137	2.55e-38	NR	ETO08551.1	46433	g5535	i0	52.8	1.0118764845605701	142	59	99	3	421	5	24	160	ETO08551.1 ABC(ATP-binding) family transporter [Reticulomyxa filosa]	diamond	426	137	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31149804	31149804	PRJNA438572_P_NODE_19575_length_249_cov_0.886364_g19456_i0	PRJNA438572	19575	249	0.886364	2.20704636	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	145	4.31e-38	NR	ETO05095.1	46433	g19456	i0	77.1	2	83	19	100	0	249	1	577	659	ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa]	diamond	498	145	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31704173	31704173	PRJNA438572_P_NODE_15537_length_264_cov_1.293194_g15418_i0	PRJNA438572	15537	264	1.293194	3.41403216	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	127	2.43e-33	NR	ETO09817.1	46433	g15418	i0	64.8	11	88	31	100	0	264	1	8	95	ETO09817.1 Ras GTPase [Reticulomyxa filosa]	diamond	2904	127	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);;