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

9 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_clade = "core chlorophytes"

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
1056632	1056632	PRJNA229468_S_NODE_801_length_185_cov_1.500000_g788_i0	PRJNA229468	801	185	1.5	2.775	Chlorophyta	3041	Plants	Plants	94.4	1.14e-20	NR	PRW20371.1	3076	g788	i0	68.3	11.6918918918919	60	19	97.3	0	183	4	127	186	PRW20371.1 60S ribosomal L7-2 [Chlorella sorokiniana]	diamond	2163	94.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
13121083	13121083	PRJNA229468_S_NODE_651_length_202_cov_1.666667_g638_i0	PRJNA229468	651	202	1.666667	3.36666734	Eukaryota	2759	Plants	Plants	105	1.7799999999999994e-24	NR	XP_002946233.1	3068	g638	i0	80.3	89.1534653465347	66	13	98	0	199	2	1370	1435	XP_002946233.1 uncharacterized protein VOLCADRAFT_120230 [Volvox carteri f. nagariensis]	diamond	18009	105	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
24593513	24593513	PRJNA229468_S_NODE_340_length_270_cov_1.153846_g327_i0	PRJNA229468	340	270	1.153846	3.1153842	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	86.7	6.69e-19	NR	KAG7672775.1	1650286	g327	i0	65.1	2.16666666666667	63	21	70	1	262	74	101	162	KAG7672775.1 hypothetical protein KSW81_001725 [Chlorella desiccata (nom. nud.)]	diamond	585	86.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
26979041	26979041	PRJNA229468_S_NODE_1002_length_170_cov_1.892562_g989_i0	PRJNA229468	1002	170	1.892562	3.2173554	Apatococcus lobatus	904363	Plants	Plants	62	9.3e-10	NR	KAK9816216.1	904363	g989	i0	54.9	0.9	51	22	88.2	1	158	9	44	94	KAK9816216.1 hypothetical protein WJX74_009459 [Apatococcus lobatus]	diamond	153	62	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Apatococcus	Apatococcus lobatus
27200212	27200212	PRJNA229468_S_NODE_582_length_212_cov_0.938650_g569_i0	PRJNA229468	582	212	0.93865	1.989938	Pedinophyceae sp. YPF-7	765719	Plants	Plants	82.8	1.92e-16	NR	CAG9467028.1	765719	g569	i0	54.4	4.79716981132075	68	31	96.2	0	208	5	614	681	CAG9467028.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	1017	82.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
28102310	28102310	PRJNA229468_S_NODE_65_length_616_cov_1.934744_g58_i0	PRJNA229468	65	616	1.934744	11.91802304	Eukaryota	2759	Plants	Plants	150	1.79e-41	NR	KAJ9523138.1	44745	g58	i0	41	1.76298701298701	183	107	89.1	1	66	614	31	212	KAJ9523138.1 hypothetical protein QJQ45_023872 [Haematococcus lacustris]	diamond	1086	150	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
28418411	28418411	PRJNA229468_S_NODE_266_length_307_cov_1.251938_g253_i0	PRJNA229468	266	307	1.251938	3.84344966	Chlorellaceae	35461	Plants	Plants	139	3.5499999999999995e-37	NR	RMZ52209.1	3075	g253	i0	68.3	5.96091205211726	101	31	98.7	1	303	1	30	129	RMZ52209.1 hypothetical protein APUTEX25_001599 [Auxenochlorella protothecoides]	diamond	1830	139	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
30168579	30168579	PRJNA229468_S_NODE_812_length_184_cov_1.503704_g799_i0	PRJNA229468	812	184	1.503704	2.76681536	Trebouxia sp. C	2796353	Plants	Plants	70.9	5.59e-14	NR	KAL0042167.1	2905653	g799	i0	57.9	0.929347826086957	57	23	91.3	1	183	16	9	65	KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004]	diamond	171	70.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
30231955	30231955	PRJNA229468_S_NODE_452_length_233_cov_2.451087_g439_i0	PRJNA229468	452	233	2.451087	5.71103271	Micractinium sp. CCAP 211/92	554058	Plants	Plants	121	1.4099999999999998e-32	NR	KAL4420073.1	554058	g439	i0	80.3	4.66094420600858	71	14	91.4	0	20	232	58	128	KAL4420073.1 hypothetical protein ABPG77_004338 [Micractinium sp. CCAP 211/92]	diamond	1086	121	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92

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