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

5 rows where analysis = "diamond", bioproject = "PRJNA485080" 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
2372903	2372903	PRJNA485080_P_NODE_26542_length_249_cov_0.875000_g26448_i0	PRJNA485080	26542	249	0.875	2.17875	Chlorella variabilis	554065	Plants	Plants	102	1.2299999999999997e-23	NR	XP_005851680.1	554065	g26448	i0	87.9	1.39759036144578	58	7	69.9	0	2	175	360	417	XP_005851680.1 hypothetical protein CHLNCDRAFT_29144 [Chlorella variabilis]	diamond	348	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
11927690	11927690	PRJNA485080_P_NODE_18530_length_269_cov_2.219388_g18436_i0	PRJNA485080	18530	269	2.219388	5.97015372	Eukaryota	2759	Plants	Plants	147	6.36e-39	NR	KAI3437883.1	3077	g18436	i0	75	17.7323420074349	88	22	98.1	0	2	265	203	290	KAI3437883.1 hypothetical protein D9Q98_000328 [Chlorella vulgaris]	diamond	4770	148	0.993243243243243	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
27060767	27060767	PRJNA485080_P_NODE_30042_length_247_cov_0.885057_g29948_i0	PRJNA485080	30042	247	0.885057	2.18609079	Chlorophyta	3041	Plants	Plants	65.9	2e-10	NR	KAJ9528545.1	44745	g29948	i0	45.5	3.86234817813765	77	41	93.5	1	5	235	54	129	KAJ9528545.1 hypothetical protein QJQ45_020474 [Haematococcus lacustris]	diamond	954	65.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
28323995	28323995	PRJNA485080_P_NODE_37346_length_244_cov_0.900585_g37252_i0	PRJNA485080	37346	244	0.900585	2.1974274	Trebouxia	13786	Plants	Plants	114	1.8e-27	NR	KAL0032166.1	2905653	g37252	i0	74.4	2.87704918032787	78	19	95.9	1	234	1	633	709	KAL0032166.1 hypothetical protein WJX77_008567 [Trebouxia sp. C0004]	diamond	702	114	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
28844602	28844602	PRJNA485080_P_NODE_29288_length_248_cov_0.880000_g29194_i0	PRJNA485080	29288	248	0.88	2.1824	Chlorella variabilis	554065	Plants	Plants	59.3	5.67e-8	NR	XP_005851108.1	554065	g29194	i0	45.1	0.991935483870968	82	39	99.2	2	246	1	397	472	XP_005851108.1 hypothetical protein CHLNCDRAFT_49822 [Chlorella variabilis]	diamond	246	59.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis

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