metadata: contig_metadata: 10 rows where bioproject = "PRJNA1118794", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA1118794", 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
5334081	5334081	PRJNA1118794_P_NODE_69485_length_242_cov_2.721893_g68735_i0	PRJNA1118794	69485	242	2.721893	6.58698106	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	93.6	4.1e-20	NR	ETO14870.1	46433	g68735	i0	56.4	2.87603305785124	78	34	96.7	0	236	3	364	441	ETO14870.1 hypothetical protein RFI_22497 [Reticulomyxa filosa]	diamond	696	93.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
16327553	16327553	PRJNA1118794_P_NODE_75353_length_231_cov_3.012658_g74603_i0	PRJNA1118794	75353	231	3.012658	6.95923998	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	78.6	1.12e-15	NR	ETO16568.1	46433	g74603	i0	53.2	10.3376623376623	79	35	100	2	1	231	71	149	ETO16568.1 14-3-3-like protein [Reticulomyxa filosa]	diamond	2388	78.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
23182835	23182835	PRJNA1118794_P_NODE_30979_length_289_cov_2.537037_g30229_i0	PRJNA1118794	30979	289	2.537037	7.33203693	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	136	5.67e-36	NR	ETO09453.1	46433	g30229	i0	71.9	0.996539792387543	96	24	99.7	2	2	289	197	289	ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa]	diamond	288	136	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27415950	27415950	PRJNA1118794_P_NODE_20403_length_336_cov_1.471483_g19653_i0	PRJNA1118794	20403	336	1.471483	4.94418288	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	135	5.7299999999999995e-37	NR	ETO20943.1	46433	g19653	i0	58.1	1.96428571428571	105	43	92.9	1	313	2	61	165	ETO20943.1 hypothetical protein RFI_16260 [Reticulomyxa filosa]	diamond	660	135	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27731733	27731733	PRJNA1118794_P_NODE_34404_length_281_cov_1.480769_g33654_i0	PRJNA1118794	34404	281	1.480769	4.16096089	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	123	2.3699999999999997e-30	NR	ETO26409.1	46433	g33654	i0	63.3	2.88256227758007	90	32	96.1	1	281	12	1175	1263	ETO26409.1 ubiquitin protein ligase, partial [Reticulomyxa filosa]	diamond	810	123	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30636620	30636620	PRJNA1118794_P_NODE_36153_length_277_cov_1.377451_g35403_i0	PRJNA1118794	36153	277	1.377451	3.81553927	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	91.7	3.22e-19	NR	ETO30405.1	46433	g35403	i0	52.2	7.74368231046931	92	32	97.5	2	3	272	318	399	ETO30405.1 hypothetical protein RFI_06714, partial [Reticulomyxa filosa]	diamond	2145	91.7	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31268791	31268791	PRJNA1118794_P_NODE_52755_length_249_cov_1.750000_g52005_i0	PRJNA1118794	52755	249	1.75	4.3575	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	50.1	4.82e-5	NR	ETO19138.1	46433	g52005	i0	37.8	0.891566265060241	74	43	88	2	3	221	76	147	ETO19138.1 plant synaptotagmin [Reticulomyxa filosa]	diamond	222	50.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31765786	31765786	PRJNA1118794_P_NODE_66097_length_244_cov_0.900585_g65347_i0	PRJNA1118794	66097	244	0.900585	2.1974274	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	87	2.84e-19	NR	ETO27122.1	46433	g65347	i0	64.4	5.80327868852459	59	21	72.5	0	182	6	108	166	ETO27122.1 citrate synthase [Reticulomyxa filosa]	diamond	1416	87.8	0.990888382687927	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32566092	32566092	PRJNA1118794_P_NODE_43419_length_261_cov_1.638298_g42669_i0	PRJNA1118794	43419	261	1.638298	4.27595778	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	64.3	4.69e-10	NR	ETO12621.1	46433	g42669	i0	67.4	1.54022988505747	46	15	52.9	0	260	123	185	230	ETO12621.1 aminopeptidase [Reticulomyxa filosa]	diamond	402	64.3	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32786111	32786111	PRJNA1118794_P_NODE_53880_length_249_cov_0.875000_g53130_i0	PRJNA1118794	53880	249	0.875	2.17875	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	75.5	8.98e-14	NR	ETO09631.1	46433	g53130	i0	41.5	3.89156626506024	82	48	98.8	0	248	3	65	146	ETO09631.1 hypothetical protein RFI_27747, partial [Reticulomyxa filosa]	diamond	969	75.5	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);;