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

6 rows where bioproject = "PRJNA437204", 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
2983082	2983082	PRJNA437204_P_NODE_34403_length_341_cov_1.100746_g34104_i0	PRJNA437204	34403	341	1.100746	3.75354386	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	96.7	4.65e-21	NR	ETO08530.1	46433	g34104	i0	38.9	0.994134897360704	113	69	99.4	0	340	2	214	326	ETO08530.1 hypothetical protein RFI_28857, partial [Reticulomyxa filosa]	diamond	339	96.7	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
9361459	9361459	PRJNA437204_P_NODE_84428_length_250_cov_0.870056_g84129_i0	PRJNA437204	84428	250	0.870056	2.17514	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	119	3.8499999999999996e-31	NR	ETO11380.1	46433	g84129	i0	69.9	0.996	83	21	99.6	1	250	2	37	115	ETO11380.1 malate dehydrogenase [Reticulomyxa filosa]	diamond	249	119	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
26917702	26917702	PRJNA437204_P_NODE_62402_length_277_cov_1.132353_g62103_i0	PRJNA437204	62402	277	1.132353	3.13661781	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	101	9.93e-23	NR	ETO33784.1	46433	g62103	i0	53.3	1.9927797833935	92	39	99.6	1	1	276	130	217	ETO33784.1 hypothetical protein RFI_03318 [Reticulomyxa filosa]	diamond	552	101	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29902837	29902837	PRJNA437204_P_NODE_8031_length_587_cov_0.817121_g7735_i0	PRJNA437204	8031	587	0.817121	4.79650027	root	1	Root_unresolved	Root_unresolved	135	5.21e-33	NR	ETO05208.1	46433	g7735	i0	53.4	4.91652470187393	116	54	59.3	0	348	1	127	242	ETO05208.1 homospermidine synthase [Reticulomyxa filosa]	diamond	2886	135	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32793783	32793783	PRJNA437204_P_NODE_82020_length_251_cov_0.865169_g81721_i0	PRJNA437204	82020	251	0.865169	2.17157419	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	55.1	1.29e-6	NR	ETO26908.1	46433	g81721	i0	44	0.597609561752988	50	28	59.8	0	244	95	198	247	ETO26908.1 hypothetical protein RFI_10228 [Reticulomyxa filosa]	diamond	150	55.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32873259	32873259	PRJNA437204_P_NODE_94220_length_248_cov_0.880000_g93921_i0	PRJNA437204	94220	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	96.3	5.71e-22	NR	ETO01022.1	46433	g93921	i0	58.4	1.8991935483871	77	32	93.1	0	1	231	129	205	ETO01022.1 protein-transport Sec61 protein subunit alpha, partial [Reticulomyxa filosa]	diamond	471	96.3	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);;