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

6 rows where analysis = "diamond", bioproject = "PRJNA792582" 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
27116763	27116763	PRJNA792582_P_NODE_59202_length_241_cov_0.916667_g58388_i0	PRJNA792582	59202	241	0.916667	2.20916747	Pedinophyceae sp. YPF-7	765719	Plants	Plants	60.5	1.9e-8	NR	CAG9461212.1	765719	g58388	i0	50	0.697095435684647	56	28	69.7	0	5	172	230	285	CAG9461212.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	168	60.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
27433241	27433241	PRJNA792582_P_NODE_14863_length_446_cov_1.404826_g14050_i0	PRJNA792582	14863	446	1.404826	6.26552396	Micractinium tetrahymenae	2728915	Plants	Plants	62	6.6e-8	NR	KAL4436932.1	2728915	g14050	i0	39.1	0.739910313901345	110	59	70	4	329	18	280	387	KAL4436932.1 hypothetical protein ABPG75_004071 [Micractinium tetrahymenae]	diamond	330	62	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium tetrahymenae
29485032	29485032	PRJNA792582_P_NODE_29970_length_315_cov_1.516529_g29156_i0	PRJNA792582	29970	315	1.516529	4.77706635	Monoraphidium neglectum	145388	Plants	Plants	45.8	0.00715	NR	XP_013900854.1	145388	g29156	i0	40.8	0.466666666666667	49	27	46.7	1	95	241	155	201	XP_013900854.1 hypothetical protein MNEG_6122 [Monoraphidium neglectum]	diamond	147	45.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
29715192	29715192	PRJNA792582_P_NODE_58350_length_242_cov_0.911243_g57536_i0	PRJNA792582	58350	242	0.911243	2.20520806	Eukaryota	2759	Plants	Plants	120	1.38e-29	NR	XP_011396312.1	3075	g57536	i0	73.8	7.89669421487603	80	21	99.2	0	2	241	125	204	XP_011396312.1 Importin subunit alpha-1 [Auxenochlorella protothecoides]	diamond	1911	120	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
30379282	30379282	PRJNA792582_P_NODE_50272_length_251_cov_0.865169_g49458_i0	PRJNA792582	50272	251	0.865169	2.17157419	Eukaryota	2759	Plants	Plants	55.1	1.77e-6	NR	KAK9799825.1	706552	g49458	i0	37.5	2.90438247011952	80	42	95.6	2	247	8	283	354	KAK9799825.1 hypothetical protein WJX73_006001 [Symbiochloris irregularis]	diamond	729	55.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
31855332	31855332	PRJNA792582_P_NODE_17857_length_408_cov_0.919403_g17043_i0	PRJNA792582	17857	408	0.919403	3.75116424	Coccomyxa sp. Obi	2315456	Plants	Plants	48.9	0.00159	NR	BDA50377.1	2315456	g17043	i0	40.6	0.507352941176471	69	39	50.7	1	5	211	124	190	BDA50377.1 probable inactive leucine-rich repeat receptor kinase XIAO [Coccomyxa sp. Obi]	diamond	207	48.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi

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