metadata: contig_metadata: 8 rows where bioproject = "PRJEB76780", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJEB76780", 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
138717	138717	PRJEB76780_P_NODE_2941_length_479_cov_1.908867_g2841_i0	PRJEB76780	2941	479	1.908867	9.14347293	Opalinata	42740	SAR_Eukaryotes	SAR_Eukaryotes	222	6.01e-65	NR	ETO10415.1	46433	g2841	i0	70.6	4.08350730688935	163	43	99.6	2	479	3	594	755	ETO10415.1 inorganic pyrophosphatase [Reticulomyxa filosa]	diamond	1956	222	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
26876312	26876312	PRJEB76780_P_NODE_4221_length_397_cov_0.959877_g4121_i0	PRJEB76780	4221	397	0.959877	3.81071169	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	115	1.06e-26	NR	ETO25163.1	46433	g4121	i0	42	2.94710327455919	131	73	99	1	2	394	160	287	ETO25163.1 ubiquitin protein ligase [Reticulomyxa filosa]	diamond	1170	115	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27571349	27571349	PRJEB76780_P_NODE_9484_length_264_cov_1.005236_g9384_i0	PRJEB76780	9484	264	1.005236	2.65382304	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	119	5.36e-29	NR	ETO28442.1	46433	g9384	i0	81.2	1.56818181818182	69	13	78.4	0	3	209	579	647	ETO28442.1 hypothetical protein RFI_08694, partial [Reticulomyxa filosa]	diamond	414	119	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28202636	28202636	PRJEB76780_P_NODE_4686_length_375_cov_1.291391_g4586_i0	PRJEB76780	4686	375	1.291391	4.84271625	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	136	7.519999999999998e-35	NR	ETO24530.1	46433	g4586	i0	66.4	0.856	107	36	85.6	0	54	374	217	323	ETO24530.1 protein kinase, cAMP-dependent, catalytic chain [Reticulomyxa filosa]	diamond	321	136	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28676582	28676582	PRJEB76780_P_NODE_12787_length_244_cov_0.912281_g12687_i0	PRJEB76780	12787	244	0.912281	2.22596564	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	61.6	8.33e-9	NR	ETO28516.1	46433	g12687	i0	46.6	0.897540983606557	73	39	89.8	0	26	244	354	426	ETO28516.1 dynein, axonemal, heavy polypeptide 5, partial [Reticulomyxa filosa]	diamond	219	61.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29813024	29813024	PRJEB76780_P_NODE_3871_length_414_cov_1.011730_g3771_i0	PRJEB76780	3871	414	1.01173	4.1885622	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	53.5	3.83e-5	NR	ETO05877.1	46433	g3771	i0	31.9	0.978260869565217	135	75	89.1	5	371	3	382	511	ETO05877.1 ubiquitin-activating enzyme E1 [Reticulomyxa filosa]	diamond	405	53.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32279043	32279043	PRJEB76780_P_NODE_5459_length_346_cov_1.428571_g5359_i0	PRJEB76780	5459	346	1.428571	4.94285566	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	114	9.64e-28	NR	ETO18614.1	46433	g5359	i0	43.3	1.22254335260116	141	54	99.7	1	346	2	111	251	ETO18614.1 hypothetical protein RFI_18649, partial [Reticulomyxa filosa]	diamond	423	114	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32776650	32776650	PRJEB76780_P_NODE_5120_length_358_cov_1.736842_g5020_i0	PRJEB76780	5120	358	1.736842	6.21789436	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	150	1.77e-39	NR	ETO05095.1	46433	g5020	i0	62.2	3.9888268156424602	119	42	99.7	1	358	2	99	214	ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa]	diamond	1428	151	0.993377483443709	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);;