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

6 rows where bioproject = "PRJEB36940", 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
8983940	8983940	PRJEB36940_P_NODE_7388_length_318_cov_1.273469_g7259_i0	PRJEB36940	7388	318	1.273469	4.04963142	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	165	1.44e-45	NR	ETO12540.1	46433	g7259	i0	75.2	1.9811320754717	105	26	99.1	0	317	3	309	413	ETO12540.1 hypothetical protein RFI_24836 [Reticulomyxa filosa]	diamond	630	165	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27949363	27949363	PRJEB36940_P_NODE_13285_length_249_cov_1.539773_g13156_i0	PRJEB36940	13285	249	1.539773	3.83403477	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	56.6	5.24e-7	NR	ETO23866.1	46433	g13156	i0	40.8	0.91566265060241	76	44	91.6	1	16	243	354	428	ETO23866.1 drug exporter of the RND superfamily-like protein, partial [Reticulomyxa filosa]	diamond	228	56.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28100512	28100512	PRJEB36940_P_NODE_14265_length_247_cov_0.879310_g14136_i0	PRJEB36940	14265	247	0.87931	2.1718957	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	48.5	3.47e-4	NR	ETO10142.1	46433	g14136	i0	31.1	1.78542510121457	74	51	89.9	0	1	222	236	309	ETO10142.1 hypothetical protein RFI_27235, partial [Reticulomyxa filosa]	diamond	441	48.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31518775	31518775	PRJEB36940_P_NODE_14976_length_244_cov_2.216374_g14847_i0	PRJEB36940	14976	244	2.216374	5.40795256	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	97.1	4.9799999999999996e-23	NR	ETO11964.1	46433	g14847	i0	87	8.63114754098361	54	7	66.4	0	243	82	140	193	ETO11964.1 glycoprotein FP21 precursor [Reticulomyxa filosa]	diamond	2106	97.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31613531	31613531	PRJEB36940_P_NODE_14036_length_247_cov_0.896552_g13907_i0	PRJEB36940	14036	247	0.896552	2.21448344	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	99.4	2.25e-22	NR	ETO19217.1	46433	g13907	i0	58	1.96761133603239	81	34	98.4	0	2	244	245	325	ETO19217.1 hypothetical protein RFI_18011 [Reticulomyxa filosa]	diamond	486	99.4	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32745171	32745171	PRJEB36940_P_NODE_6080_length_348_cov_2.781818_g5951_i0	PRJEB36940	6080	348	2.781818	9.68072664	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	53.1	2.38e-5	NR	ETO10361.1	46433	g5951	i0	69.4	0.629310344827586	36	11	31	0	110	3	93	128	ETO10361.1 hypothetical protein RFI_27015 [Reticulomyxa filosa]	diamond	219	53.5	0.992523364485981	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);;