metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB43370" 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
5162555	5162555	PRJEB43370_P_NODE_7865_length_168_cov_0.873950_g7822_i0	PRJEB43370	7865	168	0.87395	1.468236	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	92	4.76e-20	NR	ETO28688.1	46433	g7822	i0	70.9	0.982142857142857	55	16	98.2	0	166	2	386	440	ETO28688.1 disulfide-isomerase [Reticulomyxa filosa]	diamond	165	92	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
26589990	26589990	PRJEB43370_P_NODE_7741_length_169_cov_0.866667_g7698_i0	PRJEB43370	7741	169	0.866667	1.46466723	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	66.2	6.07e-11	NR	ETO20748.1	46433	g7698	i0	49.1	1.97041420118343	55	28	97.6	0	4	168	281	335	ETO20748.1 hypothetical protein RFI_16469, partial [Reticulomyxa filosa]	diamond	333	66.2	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28353241	28353241	PRJEB43370_P_NODE_6606_length_178_cov_2.418605_g6563_i0	PRJEB43370	6606	178	2.418605	4.3051169	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	79.7	1.63e-17	NR	ETO31022.1	46433	g6563	i0	64.9	1.85393258426966	57	20	96.1	0	171	1	6	62	ETO31022.1 heat shock protein 60 [Reticulomyxa filosa]	diamond	330	79.7	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28833533	28833533	PRJEB43370_P_NODE_6788_length_176_cov_1.637795_g6745_i0	PRJEB43370	6788	176	1.637795	2.8825192	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	52.8	2.6e-6	NR	ETO30832.1	46433	g6745	i0	52.5	0.681818181818182	40	19	68.2	0	54	173	136	175	ETO30832.1 poly ADP-ribose polymerase, partial [Reticulomyxa filosa]	diamond	120	52.8	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29970274	29970274	PRJEB43370_P_NODE_9011_length_166_cov_0.888889_g8968_i0	PRJEB43370	9011	166	0.888889	1.47555574	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	63.2	3.76e-10	NR	ETO22559.1	46433	g8968	i0	58	2.67469879518072	50	21	90.4	0	162	13	86	135	ETO22559.1 hypothetical protein RFI_14632 [Reticulomyxa filosa]	diamond	444	63.2	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30728530	30728530	PRJEB43370_P_NODE_3934_length_223_cov_1.494253_g3891_i0	PRJEB43370	3934	223	1.494253	3.33218419	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	72	1.25e-13	NR	ETO13147.1	46433	g3891	i0	52.6	1.9103139013452901	76	33	98.2	2	3	221	1	76	ETO13147.1 hypothetical protein RFI_24228 [Reticulomyxa filosa]	diamond	426	72	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);;