metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA637219" 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	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
26637767	26637767	PRJNA637219_S_NODE_11001_length_167_cov_0.864407_g10956_i0	PRJNA637219	11001	167	0.864407	1.44355969	Monoraphidium neglectum	145388	Plants	Plants	43.5	0.00134	NR	XP_013891194.1	145388	g10956	i0	42.9	1.50898203592814	42	24	75.4	167	42	21	62	XP_013891194.1 hypothetical protein MNEG_15788 [Monoraphidium neglectum]	diamond	252	43.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
28533920	28533920	PRJNA637219_S_NODE_10507_length_167_cov_1.296610_g10462_i0	PRJNA637219	10507	167	1.29661	2.1653387	Ulva partita	1605170	Plants	Plants	97.4	1.28e-24	NR	BAV58192.1	1605170	g10462	i0	80	0.988023952095808	55	11	98.8	2	166	51	105	BAV58192.1 H/ACA ribonucleoprotein complex subunit 3 [Ulva partita]	diamond	165	97.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva partita
28533923	28533923	PRJNA637219_S_NODE_16567_length_161_cov_0.910714_g16522_i0	PRJNA637219	16567	161	0.910714	1.46624954	Micromonas pusilla CCMP1545	564608	Plants	Plants	42.7	0.0123	NR	XP_003063910.1	564608	g16522	i0	42.6	1.67701863354037	47	27	87.6	142	2	301	347	XP_003063910.1 protein kinase [Micromonas pusilla CCMP1545]	diamond	270	42.7	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
28893359	28893359	PRJNA637219_S_NODE_15908_length_162_cov_0.902655_g15863_i0	PRJNA637219	15908	162	0.902655	1.4623011	Chlorophyta	3041	Plants	Plants	63.2	7.56e-10	NR	XP_007510048.1	41875	g15863	i0	52	2.85185185185185	50	24	92.6	8	157	492	541	XP_007510048.1 predicted protein [Bathycoccus prasinos]	diamond	462	63.5	0.995275590551181	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Bathycoccus	Bathycoccus prasinos
30270832	30270832	PRJNA637219_S_NODE_712_length_490_cov_7.390023_g667_i0	PRJNA637219	712	490	7.390023	36.2111127	Picochlorum sp. BPE23	2696299	Plants	Plants	142	2.1e-40	NR	KAI8104783.1	2696299	g667	i0	65.6	3.03673469387755	122	42	74.7	27	392	1	122	KAI8104783.1 hypothetical protein M9434_003335 [Picochlorum sp. BPE23]	diamond	1488	142	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. BPE23
30270833	30270833	PRJNA637219_S_NODE_7452_length_190_cov_1.085106_g7407_i0	PRJNA637219	7452	190	1.085106	2.0617014	Gonium pectorale	33097	Plants	Plants	52.4	6.96e-6	NR	KXZ42091.1	33097	g7407	i0	77.8	2.13157894736842	27	6	42.6	190	110	285	311	KXZ42091.1 hypothetical protein GPECTOR_208g403 [Gonium pectorale]	diamond	405	52.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
31104368	31104368	PRJNA637219_S_NODE_7315_length_191_cov_2.042254_g7270_i0	PRJNA637219	7315	191	2.042254	3.90070514	root	1	Root_unresolved	Root_unresolved	50.4	3.59e-5	NR	XP_003058476.1	564608	g7270	i0	66.7	1.02094240837696	30	10	47.1	91	2	509	538	XP_003058476.1 SNF2 super family [Micromonas pusilla CCMP1545]	diamond	195	50.4	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
31325765	31325765	PRJNA637219_S_NODE_15935_length_162_cov_0.902655_g15890_i0	PRJNA637219	15935	162	0.902655	1.4623011	Opisthokonta	33154	Plants	Plants	76.6	1.56e-16	NR	KAK3276844.1	36881	g15890	i0	72	3.87037037037037	50	14	92.6	11	160	9	58	KAK3276844.1 40S ribosomal protein S25 [Cymbomonas tetramitiformis]	diamond	627	76.6	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
31439766	31439766	PRJNA637219_S_NODE_12036_length_166_cov_0.871795_g11991_i0	PRJNA637219	12036	166	0.871795	1.4471797	Cymbomonas tetramitiformis	36881	Plants	Plants	59.7	1.3e-8	NR	KAK3245194.1	36881	g11991	i0	67.4	0.77710843373494	43	14	77.7	1	129	291	333	KAK3245194.1 proteasome regulatory particle subunit RPN11 [Cymbomonas tetramitiformis]	diamond	129	59.7	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
31692840	31692840	PRJNA637219_S_NODE_16477_length_161_cov_1.366071_g16432_i0	PRJNA637219	16477	161	1.366071	2.19937431	Tetraselmis sp. RG-15	65602	Plants	Plants	46.2	6.67e-4	NR	AAB70556.1	65602	g16432	i0	87	0.428571428571429	23	3	42.9	161	93	229	251	AAB70556.1 chlorophyll a/b binding protein [Tetraselmis sp. RG-15]	diamond	69	46.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorodendrophyceae	Chlorodendrales	Chlorodendraceae	Tetraselmis	Tetraselmis sp. RG-15

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