metadata: contig_metadata: 3 rows where bioproject = "PRJNA674308", tax_clade = "Sar" and tax

3 rows where bioproject = "PRJNA674308", 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
13398950	13398950	PRJNA674308_P_NODE_49091_length_164_cov_0.904348_g48856_i0	PRJNA674308	49091	164	0.904348	1.48313072	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.2	2.35e-13	NR	ETO12540.1	46433	g48856	i0	77.8	29.6341463414634	45	10	82.3	0	163	29	498	542	ETO12540.1 hypothetical protein RFI_24836 [Reticulomyxa filosa]	diamond	4860	73.2	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28060843	28060843	PRJNA674308_P_NODE_34565_length_172_cov_1.569106_g34330_i0	PRJNA674308	34565	172	1.569106	2.69886232	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00743	NR	ETO28118.1	46433	g34330	i0	42.6	0.819767441860465	47	27	82	0	167	27	13	59	ETO28118.1 hypothetical protein RFI_09014, partial [Reticulomyxa filosa]	diamond	141	43.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31946555	31946555	PRJNA674308_P_NODE_27657_length_191_cov_1.464789_g27422_i0	PRJNA674308	27657	191	1.464789	2.79774699	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	60.5	9.27e-9	NR	ETO04727.1	46433	g27422	i0	45.2	1.94764397905759	62	31	97.4	2	3	188	9	67	ETO04727.1 hypothetical protein RFI_32671, partial [Reticulomyxa filosa]	diamond	372	60.5	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);;