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

5 rows where bioproject = "PRJNA683669", 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
26777477	26777477	PRJNA683669_P_NODE_15321_length_331_cov_1.492248_g15090_i0	PRJNA683669	15321	331	1.492248	4.93934088	Suessiales	89954	SAR_Eukaryotes	SAR_Eukaryotes	125	2.69e-32	NR	ETO30210.1	46433	g15090	i0	56	4.06042296072508	109	48	98.8	0	329	3	137	245	ETO30210.1 hypothetical protein RFI_06914 [Reticulomyxa filosa]	diamond	1344	125	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28661277	28661277	PRJNA683669_P_NODE_28727_length_248_cov_0.880000_g28495_i0	PRJNA683669	28727	248	0.88	2.1824	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	71.6	7.01e-13	NR	ETO06665.1	46433	g28495	i0	54.2	0.580645161290323	48	22	58.1	0	167	24	113	160	ETO06665.1 hypothetical protein RFI_30727 [Reticulomyxa filosa]	diamond	144	71.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29418807	29418807	PRJNA683669_P_NODE_10309_length_400_cov_1.681957_g10078_i0	PRJNA683669	10309	400	1.681957	6.727828	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	83.6	3.31e-17	NR	ETO36728.1	46433	g10078	i0	36.9	0.915	122	76	91.5	1	367	2	43	163	ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa]	diamond	366	83.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29651193	29651193	PRJNA683669_P_NODE_8710_length_433_cov_1.283333_g8479_i0	PRJNA683669	8710	433	1.283333	5.55683189	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	122	4.56e-30	NR	ETO10270.1	46433	g8479	i0	49.2	3.40877598152425	122	58	81.8	2	4	357	188	309	ETO10270.1 Eukaryotic translation initiation factor 4E type [Reticulomyxa filosa]	diamond	1476	122	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32042050	32042050	PRJNA683669_P_NODE_13078_length_358_cov_1.080702_g12847_i0	PRJNA683669	13078	358	1.080702	3.86891316	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	115	9.279999999999999e-28	NR	ETO21992.1	46433	g12847	i0	47.7	0.930167597765363	111	55	93	1	336	4	257	364	ETO21992.1 hypothetical protein RFI_15211 [Reticulomyxa filosa]	diamond	333	115	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);;