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

5 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_kingdom = "Viridiplantae"

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
27722165	27722165	PRJEB2368_P_NODE_15764_length_152_cov_1.365217_g15445_i0	PRJEB2368	15764	152	1.365217	2.07512984	Eukaryota	2759	Plants	Plants	61.6	2.32e-9	NR	PTQ32829.1	3197	g15445	i0	60	63.0789473684211	50	20	98.7	0	150	1	207	256	PTQ32829.1 hypothetical protein MARPO_0094s0010 [Marchantia polymorpha]	diamond	9588	62	0.993548387096774	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Marchantiaceae	Marchantia	Marchantia polymorpha
28391209	28391209	PRJEB2368_P_NODE_1666_length_677_cov_1.875000_g1418_i0	PRJEB2368	1666	677	1.875	12.69375	Chlamydomonas eustigma	1157962	Plants	Plants	80.9	1.15e-13	NR	GAX78925.1	1157962	g1418	i0	29.5	0.735598227474151	166	95	68.7	6	657	193	291	445	GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma]	diamond	498	80.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
29047993	29047993	PRJEB2368_P_NODE_15568_length_153_cov_2.094828_g15249_i0	PRJEB2368	15568	153	2.094828	3.20508684	Closterium	34145	Plants	Plants	54.3	7.61e-7	NR	CAI5488445.1	2996811	g15249	i0	49	3.84313725490196	49	25	96.1	0	147	1	86	134	CAI5488445.1 unnamed protein product [Closterium sp. Naga37s-1]	diamond	588	54.7	0.992687385740402	Eukaryota		Viridiplantae	Streptophyta	Zygnematophyceae	Desmidiales	Closteriaceae	Closterium	Closterium sp. Naga37s-1
29875308	29875308	PRJEB2368_P_NODE_15531_length_154_cov_1.000000_g15212_i0	PRJEB2368	15531	154	1	1.54	Bathycoccus prasinos	41875	Plants	Plants	68.9	6.34e-12	NR	XP_007511939.1	41875	g15212	i0	58	3.75974025974026	50	21	97.4	0	154	5	308	357	XP_007511939.1 ammonium transporter [Bathycoccus prasinos]	diamond	579	68.9	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Bathycoccus	Bathycoccus prasinos
32720018	32720018	PRJEB2368_P_NODE_12740_length_196_cov_1.798742_g12421_i0	PRJEB2368	12740	196	1.798742	3.5255343200000002	Klebsormidium nitens	105231	Plants	Plants	64.7	2.73e-10	NR	GAQ78914.1	105231	g12421	i0	47.6	0.964285714285714	63	33	96.4	0	7	195	192	254	GAQ78914.1 hypothetical protein KFL_000200670 [Klebsormidium nitens]	diamond	189	64.7	1	Eukaryota		Viridiplantae	Streptophyta	Klebsormidiophyceae	Klebsormidiales	Klebsormidiaceae	Klebsormidium	Klebsormidium nitens

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