metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1041773" 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
170296	170296	PRJNA1041773_P_NODE_42841_length_324_cov_3.374502_g42508_i0	PRJNA1041773	42841	324	3.374502	10.93338648	Cymbomonas tetramitiformis	36881	Plants	Plants	108	4.83e-25	NR	KAK3253051.1	36881	g42508	i0	52.9	0.944444444444444	102	48	94.4	0	308	3	375	476	KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis]	diamond	306	108	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
11649440	11649440	PRJNA1041773_P_NODE_86610_length_247_cov_0.885057_g86277_i0	PRJNA1041773	86610	247	0.885057	2.18609079	Ostreococcus lucimarinus CCE99	242159	Plants	Plants	146	4.99e-43	NR	XP_001416208.1	436017	g86277	i0	100	0.959514170040486	79	0	96	0	9	245	21	99	XP_001416208.1 predicted protein [Ostreococcus lucimarinus CCE9901]	diamond	237	146	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
15473739	15473739	PRJNA1041773_P_NODE_84213_length_248_cov_0.880000_g83880_i0	PRJNA1041773	84213	248	0.88	2.1824	Micromonas commoda	296587	Plants	Plants	152	3.65e-42	NR	XP_002507655.1	296587	g83880	i0	92.7	0.991935483870968	82	6	99.2	0	246	1	16	97	XP_002507655.1 predicted protein [Micromonas commoda]	diamond	246	152	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
26908656	26908656	PRJNA1041773_P_NODE_89402_length_246_cov_0.890173_g89069_i0	PRJNA1041773	89402	246	0.890173	2.18982558	Micromonas commoda	296587	Plants	Plants	105	1.81e-26	NR	YP_002808621.1	296587	g89069	i0	75.9	0.963414634146341	79	19	96.3	0	3	239	27	105	YP_002808621.1 ATP synthase CF0 subunit B [Micromonas commoda]	diamond	237	105	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
26971821	26971821	PRJNA1041773_P_NODE_22562_length_437_cov_3.002747_g22231_i0	PRJNA1041773	22562	437	3.002747	13.12200439	[Myrmecia] bisecta	41462	Plants	Plants	130	7.78e-32	NR	KAK9817796.1	41462	g22231	i0	75	1.21510297482838	88	22	60.4	0	432	169	556	643	KAK9817796.1 hypothetical protein WJX72_002302 [[Myrmecia] bisecta]	diamond	531	130	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
28235156	28235156	PRJNA1041773_P_NODE_96146_length_243_cov_0.905882_g95813_i0	PRJNA1041773	96146	243	0.905882	2.20129326	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	56.6	4.78e-7	NR	KAG1669795.1	1653778	g95813	i0	41.4	1.07407407407407	87	42	98.8	4	3	242	209	293	KAG1669795.1 hypothetical protein FOA52_001625 [Chlamydomonas sp. UWO 241]	diamond	261	56.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
28645990	28645990	PRJNA1041773_P_NODE_82587_length_249_cov_0.875000_g82254_i0	PRJNA1041773	82587	249	0.875	2.17875	Micromonas commoda	296587	Plants	Plants	100	1.94e-22	NR	XP_002508371.1	296587	g82254	i0	68.4	0.91566265060241	76	24	91.6	0	229	2	2631	2706	XP_002508371.1 mastigoneme-like protein [Micromonas commoda]	diamond	228	100	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
28858755	28858755	PRJNA1041773_P_NODE_89928_length_246_cov_0.890173_g89595_i0	PRJNA1041773	89928	246	0.890173	2.18982558	Chlorophyta	3041	Plants	Plants	66.6	1.54e-10	NR	KAK3269280.1	36881	g89595	i0	47.6	3.28048780487805	63	32	75.6	1	246	61	693	755	KAK3269280.1 hypothetical protein CYMTET_22272 [Cymbomonas tetramitiformis]	diamond	807	66.6	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
30438186	30438186	PRJNA1041773_P_NODE_85053_length_248_cov_0.880000_g84720_i0	PRJNA1041773	85053	248	0.88	2.1824	Chloropicon	2302914	Plants	Plants	71.2	2.9e-12	NR	WZN58848.1	1461544	g84720	i0	46.9	1.54838709677419	64	34	77.4	0	193	2	295	358	WZN58848.1 Bax inhibitor 1-like apoptosis-related protein [Chloropicon roscoffensis]	diamond	384	71.2	1	Eukaryota		Viridiplantae	Chlorophyta	Chloropicophyceae	Chloropicales	Chloropicaceae	Chloropicon	Chloropicon roscoffensis
31386136	31386136	PRJNA1041773_P_NODE_77636_length_251_cov_0.865169_g77303_i0	PRJNA1041773	77636	251	0.865169	2.17157419	Mamiellales	13792	Plants	Plants	152	1.58e-44	NR	YP_717211.1	70448	g77303	i0	89	1.9601593625498	82	9	98	0	251	6	6	87	YP_717211.1 ATP-dependent Clp protease proteolytic subunit [Ostreococcus tauri]	diamond	492	152	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus tauri
31394183	31394183	PRJNA1041773_P_NODE_101736_length_241_cov_0.916667_g101403_i0	PRJNA1041773	101736	241	0.916667	2.20916747	Micromonas commoda	296587	Plants	Plants	45.1	0.00494	NR	YP_002860142.1	296587	g101403	i0	29.3	1.0207468879668	82	56	99.6	1	1	240	124	205	YP_002860142.1 hypothetical protein MicpuN_mit54 [Micromonas commoda]	diamond	246	45.1	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
32153300	32153300	PRJNA1041773_P_NODE_98178_length_242_cov_0.911243_g97845_i0	PRJNA1041773	98178	242	0.911243	2.20520806	Micromonas commoda	296587	Plants	Plants	139	4.09e-36	NR	XP_002505604.1	296587	g97845	i0	78.8	0.991735537190083	80	17	99.2	0	1	240	3427	3506	XP_002505604.1 dynein heavy chain [Micromonas commoda]	diamond	240	139	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda

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