metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA927284" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA927284" and tax_phylum = "Streptophyta"

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
28414533	28414533	PRJNA927284_P_NODE_2946_length_386_cov_2.543417_g2744_i0	PRJNA927284	2946	386	2.543417	9.81758962	Zingiber officinale	94328	Plants	Plants	43.9	0.0373	NR	XP_042421737.1	94328	g2744	i0	46.8	0.365284974093264	47	24	36.5	1	371	231	9	54	XP_042421737.1 probable calcium-binding protein CML18 [Zingiber officinale]	diamond	141	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Zingiberaceae	Zingiber	Zingiber officinale
30695397	30695397	PRJNA927284_P_NODE_5893_length_224_cov_3.164103_g5686_i0	PRJNA927284	5893	224	3.164103	7.08759072	Solanales	4069	Plants	Plants	49.3	9.99e-5	NR	KAH0649391.1	4113	g5686	i0	78.6	3.88392857142857	28	6	37.5	0	115	198	90	117	KAH0649391.1 hypothetical protein KY285_034639 [Solanum tuberosum]	diamond	870	49.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum tuberosum
30846284	30846284	PRJNA927284_P_NODE_9294_length_151_cov_1.893443_g9087_i0	PRJNA927284	9294	151	1.893443	2.85909893	Brassica napus	3708	Plants	Plants	56.6	1.35e-7	NR	WZZ14951.1	3708	g9087	i0	61	2.44370860927152	41	16	81.5	0	151	29	102	142	WZZ14951.1 hypothetical protein YC2023_108040 [Brassica napus]	diamond	369	56.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica napus
32435062	32435062	PRJNA927284_P_NODE_1059_length_736_cov_5.647808_g921_i0	PRJNA927284	1059	736	5.647808	41.56786688	Eukaryota	2759	Plants	Plants	82	1.35e-15	NR	XP_004983440.1	4555	g921	i0	41	1.28396739130435	105	51	38.3	4	623	342	11	115	XP_004983440.1 cell number regulator 4-like isoform X1 [Setaria italica]	diamond	945	82.8	0.990338164251208	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Setaria	Setaria italica

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