metadata: contig_metadata: 6 rows where bioproject = "PRJNA811237", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA811237", 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
27117244	27117244	PRJNA811237_S_NODE_28942_length_166_cov_0.871795_g28702_i0	PRJNA811237	28942	166	0.871795	1.4471797	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	48.1	9.54e-5	NR	ETO18542.1	46433	g28702	i0	46.3	0.740963855421687	41	22	74.1	0	164	42	144	184	ETO18542.1 hypothetical protein RFI_18721 [Reticulomyxa filosa]	diamond	123	48.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28380681	28380681	PRJNA811237_S_NODE_28726_length_166_cov_0.871795_g28486_i0	PRJNA811237	28726	166	0.871795	1.4471797	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	53.5	2.08e-6	NR	ETO33241.1	46433	g28486	i0	45.5	0.993975903614458	55	30	99.4	0	1	165	1515	1569	ETO33241.1 hypothetical protein RFI_03866 [Reticulomyxa filosa]	diamond	165	53.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29242031	29242031	PRJNA811237_S_NODE_13769_length_216_cov_1.832335_g13529_i0	PRJNA811237	13769	216	1.832335	3.9578436	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	120	4.61e-31	NR	ETO36954.1	46433	g13529	i0	67.6	13.8055555555556	71	23	98.6	0	215	3	169	239	ETO36954.1 hypothetical protein RFI_00108 [Reticulomyxa filosa]	diamond	2982	120	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29580205	29580205	PRJNA811237_S_NODE_18930_length_193_cov_1.527778_g18690_i0	PRJNA811237	18930	193	1.527778	2.94861154	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	63.5	3.26e-10	NR	ETO24192.1	46433	g18690	i0	65	0.621761658031088	40	14	62.2	0	180	61	112	151	ETO24192.1 hypothetical protein RFI_12965 [Reticulomyxa filosa]	diamond	120	63.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30402251	30402251	PRJNA811237_S_NODE_25513_length_172_cov_1.243902_g25273_i0	PRJNA811237	25513	172	1.243902	2.13951144	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	92	5.94e-20	NR	ETO25728.1	46433	g25273	i0	73.2	3.90697674418605	56	15	97.7	0	170	3	244	299	ETO25728.1 AMP deaminase, partial [Reticulomyxa filosa]	diamond	672	92	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32615057	32615057	PRJNA811237_S_NODE_14220_length_214_cov_0.927273_g13980_i0	PRJNA811237	14220	214	0.927273	1.98436422	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	51.2	2.61e-5	NR	ETO14507.1	46433	g13980	i0	43.9	0.925233644859813	66	35	89.7	1	23	214	255	320	ETO14507.1 hypothetical protein RFI_22867 [Reticulomyxa filosa]	diamond	198	51.2	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);;