metadata: contig_metadata: 9 rows where bioproject = "PRJNA280983" and tax

9 rows where bioproject = "PRJNA280983" and tax_clade = "Sar"

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_class	tax_order	tax_family	tax_genus	tax_species
19497566	19497566	PRJNA280983_P_NODE_10496_length_164_cov_0.886957_g10381_i0	PRJNA280983	10496	164	0.886957	1.45460948	root	1	Root_unresolved	Root_unresolved	90.9	1.37e-20	NR	KAJ1380108.1	483371	g10381	i0	72.2	37.5365853658537	54	15	98.8	0	3	164	194	247	KAJ1380108.1 acetyl-CoA carboxylase, partial [Ochromonadaceae sp. CCMP2298]	diamond	6156	91.7	0.991275899672846	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
27849721	27849721	PRJNA280983_P_NODE_8864_length_182_cov_1.533835_g8749_i0	PRJNA280983	8864	182	1.533835	2.7915797	Symbiodinium	2949	SAR_Eukaryotes	SAR_Eukaryotes	88.6	1.18e-18	NR	CAE7864770.1	2951	g8749	i0	71.2	7.92857142857143	59	16	95.6	1	177	4	1914	1972	CAE7864770.1 rps4x [Symbiodinium microadriaticum]	diamond	1443	89	0.995505617977528	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
28653198	28653198	PRJNA280983_P_NODE_4747_length_297_cov_1.233871_g4632_i0	PRJNA280983	4747	297	1.233871	3.66459687	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	126	2.5899999999999997e-31	NR	GBG30547.1	2315210	g4632	i0	70.2	0.848484848484849	84	25	84.8	0	43	294	3606	3689	GBG30547.1 Calmodulin [Hondaea fermentalgiana]	diamond	252	126	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
30200266	30200266	PRJNA280983_P_NODE_4212_length_324_cov_1.298182_g4097_i0	PRJNA280983	4212	324	1.298182	4.20610968	Tribonema minus	303371	SAR_Eukaryotes	SAR_Eukaryotes	72.4	1.1e-12	NR	KAG5177864.1	303371	g4097	i0	46.5	3.61111111111111	86	43	76.9	1	75	323	107	192	KAG5177864.1 hypothetical protein JKP88DRAFT_169648 [Tribonema minus]	diamond	1170	72.4	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
31274765	31274765	PRJNA280983_P_NODE_10595_length_164_cov_0.886957_g10480_i0	PRJNA280983	10595	164	0.886957	1.45460948	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	50.1	3.25e-5	NR	OEH75612.1	88456	g10480	i0	51.9	2.98170731707317	54	26	98.8	0	162	1	25	78	OEH75612.1 ccch finger DNA binding related protein [Cyclospora cayetanensis]	diamond	489	50.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
31401539	31401539	PRJNA280983_P_NODE_8156_length_195_cov_1.397260_g8041_i0	PRJNA280983	8156	195	1.39726	2.724657	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	49.3	9.08e-5	NR	XP_002178319.1	556484	g8041	i0	46.8	0.953846153846154	62	32	95.4	1	193	8	255	315	XP_002178319.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	186	49.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31970654	31970654	PRJNA280983_P_NODE_10938_length_163_cov_0.894737_g10823_i0	PRJNA280983	10938	163	0.894737	1.45842131	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	59.3	1.79e-8	NR	KAI2512337.1	210448	g10823	i0	52.1	0.883435582822086	48	23	88.3	0	13	156	66	113	KAI2512337.1 RNA binding-protein [Fragilaria crotonensis]	diamond	144	59.3	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
32305080	32305080	PRJNA280983_P_NODE_2979_length_401_cov_1.553977_g2864_i0	PRJNA280983	2979	401	1.553977	6.23144777	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	107	5.81e-25	NR	XP_004035181.1	5932	g2864	i0	68.2	3.80798004987531	85	24	62.8	2	399	148	204	286	XP_004035181.1 hypothetical protein IMG5_104090 [Ichthyophthirius multifiliis]	diamond	1527	108	0.990740740740741	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
32666241	32666241	PRJNA280983_P_NODE_3600_length_357_cov_2.068182_g3485_i0	PRJNA280983	3600	357	2.068182	7.38340974	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	48.9	2.94e-4	NR	ETO34291.1	46433	g3485	i0	51.3	0.638655462184874	39	19	32.8	0	8	124	112	150	ETO34291.1 hypothetical protein RFI_02802 [Reticulomyxa filosa]	diamond	228	48.9	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);;