metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1067443" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1067443" 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_class	tax_order	tax_family	tax_genus	tax_species
9941677	9941677	PRJNA1067443_P_NODE_48_length_1373_cov_25.523077_g44_i0	PRJNA1067443	48	1373	25.523077	350.43184721	Pylaiella littoralis	2885	SAR_Eukaryotes	SAR_Eukaryotes	112	4.18e-24	NR	NP_150402.1	2885	g44	i0	47.2	0.268754552075747	123	65	26.9	0	196	564	124	246	NP_150402.1 cytochrome c oxidase subunit 3 [Pylaiella littoralis]	diamond	369	112	1	Eukaryota	Sar	Phaeophyceae	Ectocarpales	Acinetosporaceae	Pylaiella	Pylaiella littoralis
19307256	19307256	PRJNA1067443_P_NODE_6056_length_335_cov_1.175573_g6038_i0	PRJNA1067443	6056	335	1.175573	3.93816955	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	120	6.549999999999999e-31	NR	BBE27972.1	2829	g6038	i0	55.6	16.4238805970149	108	48	96.7	0	334	11	145	252	BBE27972.1 ATP synthase F0 subunit 6 [Heterosigma akashiwo]	diamond	5502	121	0.991735537190083	Eukaryota	Sar	Raphidophyceae	Chattonellales	Chattonellaceae	Heterosigma	Heterosigma akashiwo
21858558	21858558	PRJNA1067443_P_NODE_8658_length_297_cov_1.031250_g8640_i0	PRJNA1067443	8658	297	1.03125	3.0628125	Cafileria marina	2557541	SAR_Eukaryotes	SAR_Eukaryotes	148	5.999999999999998e-42	NR	YP_009688851.1	2557541	g8640	i0	68.4	0.98989898989899	98	31	99	0	295	2	40	137	YP_009688851.1 cytochrome c oxidase subunit 3 [Cafileria marina]	diamond	294	148	1	Eukaryota	Sar	Bigyra	Bicosoecida		Cafileria	Cafileria marina
26782640	26782640	PRJNA1067443_P_NODE_23921_length_227_cov_2.935065_g23903_i0	PRJNA1067443	23921	227	2.935065	6.66259755	Leukarachnion sp. ATCC PRA-24	568390	SAR_Eukaryotes	SAR_Eukaryotes	53.1	6.45e-6	NR	XAL83109.1	568390	g23903	i0	46.2	1.74449339207048	65	35	85.9	0	19	213	427	491	XAL83109.1 NADH dehydrogenase subunit 5 [Leukarachnion sp. ATCC PRA-24]	diamond	396	53.1	1	Eukaryota	Sar					Leukarachnion sp. ATCC PRA-24
26940625	26940625	PRJNA1067443_P_NODE_17782_length_249_cov_0.875000_g17764_i0	PRJNA1067443	17782	249	0.875	2.17875	Symbiodinium necroappetens	1628268	SAR_Eukaryotes	SAR_Eukaryotes	60.5	2.27e-8	NR	CAE7856609.1	1628268	g17764	i0	43.2	0.975903614457831	81	41	95.2	2	240	4	50	127	CAE7856609.1 unnamed protein product [Symbiodinium necroappetens]	diamond	243	60.5	1	Eukaryota	Sar	Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium necroappetens
32406908	32406908	PRJNA1067443_P_NODE_22939_length_240_cov_2.185629_g22921_i0	PRJNA1067443	22939	240	2.185629	5.2455096	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	74.3	2.76e-13	NR	KAJ1431022.1	483371	g22921	i0	63.8	0.725	58	20	71.3	1	1	171	568	625	KAJ1431022.1 hypothetical protein B484DRAFT_44968, partial [Ochromonadaceae sp. CCMP2298]	diamond	174	74.3	1	Eukaryota	Sar	Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298

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