metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA806354" 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
3356968	3356968	PRJNA806354_P_NODE_34023_length_255_cov_1.648352_g33914_i0	PRJNA806354	34023	255	1.648352	4.2032976	Karenia selliformis	262428	SAR_Eukaryotes	SAR_Eukaryotes	158	7.37e-47	NR	AEK64786.1	262428	g33914	i0	88.1	0.988235294117647	84	10	98.8	0	253	2	122	205	AEK64786.1 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit, partial [Karenia selliformis]	diamond	252	158	1	Eukaryota	Sar		Dinophyceae	Gymnodiniales	Kareniaceae	Karenia	Karenia selliformis
21208303	21208303	PRJNA806354_P_NODE_31637_length_264_cov_2.209424_g31528_i0	PRJNA806354	31637	264	2.209424	5.83287936	Karenia mikimotoi	225107	SAR_Eukaryotes	SAR_Eukaryotes	178	1.41e-53	NR	AIG99628.1	225107	g31528	i0	88.5	1.97727272727273	87	10	98.9	0	3	263	1	87	AIG99628.1 photosystem II protein D2, partial [Karenia mikimotoi]	diamond	522	178	1	Eukaryota	Sar		Dinophyceae	Gymnodiniales	Kareniaceae	Karenia	Karenia mikimotoi
26800904	26800904	PRJNA806354_P_NODE_40781_length_242_cov_0.911243_g40672_i0	PRJNA806354	40781	242	0.911243	2.20520806	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	67	1.04e-10	NR	OLP93353.1	2951	g40672	i0	79.4	1.68595041322314	34	7	42.1	0	242	141	516	549	OLP93353.1 Eukaryotic translation initiation factor 3 subunit G [Symbiodinium microadriaticum]	diamond	408	67	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
27970114	27970114	PRJNA806354_P_NODE_40185_length_243_cov_0.900000_g40076_i0	PRJNA806354	40185	243	0.9	2.187	Symbiodinium pilosum	2952	SAR_Eukaryotes	SAR_Eukaryotes	49.7	1.33e-4	NR	CAE7649784.1	2952	g40076	i0	45.3	0.654320987654321	53	29	65.4	0	1	159	158	210	CAE7649784.1 unnamed protein product [Symbiodinium pilosum]	diamond	159	49.7	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium pilosum
28862976	28862976	PRJNA806354_P_NODE_38068_length_246_cov_0.890173_g37959_i0	PRJNA806354	38068	246	0.890173	2.18982558	Symbiodiniaceae	252141	SAR_Eukaryotes	SAR_Eukaryotes	88.2	3.85e-18	NR	CAE6912105.1	878477	g37959	i0	59.2	5.5609756097561	76	31	92.7	0	17	244	356	431	CAE6912105.1 unnamed protein product [Symbiodinium natans]	diamond	1368	88.6	0.99548532731377	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium natans
28949185	28949185	PRJNA806354_P_NODE_28588_length_277_cov_1.416667_g28479_i0	PRJNA806354	28588	277	1.416667	3.92416759	Symbiodinium natans	878477	SAR_Eukaryotes	SAR_Eukaryotes	77.4	3.1e-14	NR	CAE7247584.1	878477	g28479	i0	45.1	4.92779783393502	91	50	98.6	0	275	3	256	346	CAE7247584.1 scn4ab [Symbiodinium natans]	diamond	1365	77.4	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium natans
29368330	29368330	PRJNA806354_P_NODE_36529_length_249_cov_0.875000_g36420_i0	PRJNA806354	36529	249	0.875	2.17875	Suessiales	89954	SAR_Eukaryotes	SAR_Eukaryotes	89.7	9.49e-19	NR	CAE8603987.1	89957	g36420	i0	54.4	1.78313253012048	79	28	91.6	2	17	244	25	98	CAE8603987.1 unnamed protein product, partial [Polarella glacialis]	diamond	444	89.7	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Polarella	Polarella glacialis
30022742	30022742	PRJNA806354_P_NODE_36991_length_248_cov_0.880000_g36882_i0	PRJNA806354	36991	248	0.88	2.1824	Polarella glacialis	89957	SAR_Eukaryotes	SAR_Eukaryotes	140	4.2499999999999997e-38	NR	CAE8653977.1	89957	g36882	i0	82.9	4.95967741935484	82	14	99.2	0	247	2	207	288	CAE8653977.1 unnamed protein product, partial [Polarella glacialis]	diamond	1230	140	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Polarella	Polarella glacialis
30284614	30284614	PRJNA806354_P_NODE_26212_length_288_cov_1.255814_g26103_i0	PRJNA806354	26212	288	1.255814	3.61674432	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	73.9	7.15e-13	NR	GFH50519.1	426638	g26103	i0	46.5	1.60416666666667	71	38	74	0	58	270	3	73	GFH50519.1 hypothetical protein CTEN210_06995 [Chaetoceros tenuissimus]	diamond	462	73.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus

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);;