metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA549880" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA549880" and tax_phylum = "Chlorophyta"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
29460814	29460814	PRJNA549880_P_NODE_12590_length_247_cov_0.885057_g12497_i0	PRJNA549880	12590	247	0.885057	2.18609079	Viridiplantae	33090	Plants	Plants	48.9	2.56e-4	NR	GHP08893.1	41880	g12497	i0	50	2.39271255060729	50	24	60.7	1	91	240	154	202	GHP08893.1 hypothetical protein PPROV_000763000 [Pycnococcus provasolii]	diamond	591	48.9	1	Eukaryota		Viridiplantae	Chlorophyta	Pseudoscourfieldiophyceae	Pseudoscourfieldiales	Pycnococcaceae	Pycnococcus	Pycnococcus provasolii
30219072	30219072	PRJNA549880_P_NODE_6072_length_319_cov_1.439024_g5979_i0	PRJNA549880	6072	319	1.439024	4.59048656	Opisthokonta	33154	Plants	Plants	73.9	1.53e-13	NR	XP_001415627.1	436017	g5979	i0	48	2.36990595611285	75	39	70.5	0	317	93	135	209	XP_001415627.1 predicted protein [Ostreococcus lucimarinus CCE9901]	diamond	756	73.9	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
30362710	30362710	PRJNA549880_P_NODE_7892_length_286_cov_1.089202_g7799_i0	PRJNA549880	7892	286	1.089202	3.11511772	Picochlorum sp. BPE23	2696299	Plants	Plants	50.1	1.63e-4	NR	KAI8110200.1	2696299	g7799	i0	53.1	0.671328671328671	32	15	33.6	0	286	191	470	501	KAI8110200.1 hypothetical protein M9435_001879 [Picochlorum sp. BPE23]	diamond	192	50.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. BPE23
31515141	31515141	PRJNA549880_P_NODE_11996_length_248_cov_0.880000_g11903_i0	PRJNA549880	11996	248	0.88	2.1824	Picochlorum	249344	Plants	Plants	99	6.52e-22	NR	WPT16210.1	1470871	g11903	i0	90	12.0967741935484	50	5	60.5	0	209	60	396	445	WPT16210.1 ATP-dependent zinc metalloprotease FTSH 5 [Picochlorum sp. SENEW3]	diamond	3000	99	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. SENEW3
31546679	31546679	PRJNA549880_P_NODE_11516_length_249_cov_0.875000_g11423_i0	PRJNA549880	11516	249	0.875	2.17875	Selenastraceae	35466	Plants	Plants	59.7	1.79e-8	NR	XP_013900910.1	145388	g11423	i0	45.2	5.48192771084337	62	34	74.7	0	186	1	64	125	XP_013900910.1 3-ketoacyl-CoA synthase 4 [Monoraphidium neglectum]	diamond	1365	60.1	0.993344425956739	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum

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