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

5 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
32913468	32913468	PRJEB7799n_S_NODE_3449_length_242_cov_9.028986_g3412_i0	PRJEB7799	3449	242	9.028986	21.85014612	Gonium pectorale	33097	Plants	Plants	42.4	0.00967	NR	KXZ52435.1	33097	g3412	i0	35.7	0.694214876033058	56	36	69.4	0	17	184	32	87	KXZ52435.1 hypothetical protein GPECTOR_9g479 [Gonium pectorale]	diamond	168	42.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
32999026	32999026	PRJEB7799n_S_NODE_5875_length_196_cov_3.801242_g5838_i0	PRJEB7799	5875	196	3.801242	7.45043432	Chlorella sp. KQ-2	3079	Plants	Plants	60.5	4.24e-10	NR	AIU80189.1	1565086	g5838	i0	61	3.16836734693878	41	16	62.8	0	194	72	46	86	AIU80189.1 acyl-CoA-binding protein [Chlorella sp. KQ-2014]	diamond	621	60.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sp. KQ-2014
33067506	33067506	PRJEB7799p_S_NODE_5741_length_224_cov_3.661376_g5718_i0	PRJEB7799	5741	224	3.661376	8.20148224	Symbiochloris irregularis	706552	Plants	Plants	63.5	9.27e-11	NR	KAK9790366.1	706552	g5718	i0	68.8	1.90178571428571	48	15	64.3	0	1	144	77	124	KAK9790366.1 hypothetical protein WJX73_010050 [Symbiochloris irregularis]	diamond	426	63.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
33100816	33100816	PRJEB7799g_S_NODE_814_length_279_cov_9.114754_g598_i0	PRJEB7799	814	279	9.114754	25.43016366	Gonium pectorale	33097	Plants	Plants	42.4	0.0146	NR	KXZ52435.1	33097	g598	i0	35.7	0.602150537634409	56	36	60.2	0	234	67	32	87	KXZ52435.1 hypothetical protein GPECTOR_9g479 [Gonium pectorale]	diamond	168	42.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
33145149	33145149	PRJEB7799a_S_NODE_15719_length_162_cov_1.574803_g15684_i0	PRJEB7799	15719	162	1.574803	2.55118086	Eukaryota	2759	Plants	Plants	43.5	0.00366	NR	YP_009162764.1	38881	g15684	i0	51.3	1.51851851851852	39	18	72.2	1	24	140	2	39	YP_009162764.1 hypothetical protein [Botryococcus braunii]	diamond	246	43.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Botryococcus	Botryococcus braunii

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