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

4 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_clade = "Embryophyta"

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
24637085	24637085	PRJNA393181_S_NODE_37920_length_175_cov_2.384058_g37814_i0	PRJNA393181	37920	175	2.384058	4.1721015	Macleaya cordata	56857	Plants	Plants	65.9	2.66e-11	NR	OVA17630.1	56857	g37814	i0	59.6	3.75428571428571	57	21	94.3	1	165	1	113	169	OVA17630.1 Small GTPase superfamily [Macleaya cordata]	diamond	657	65.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Macleaya	Macleaya cordata
29460173	29460173	PRJNA393181_S_NODE_31930_length_197_cov_0.968750_g31824_i0	PRJNA393181	31930	197	0.96875	1.9084375	Magnoliopsida	3398	Plants	Plants	63.9	1.22e-10	NR	XP_028115218.1	4442	g31824	i0	64.4	7.29441624365482	59	20	88.3	1	196	23	87	145	XP_028115218.1 transmembrane protein 208-like [Camellia sinensis]	diamond	1437	63.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
31339194	31339194	PRJNA393181_S_NODE_43996_length_159_cov_0.942623_g43890_i0	PRJNA393181	43996	159	0.942623	1.49877057	Ceratodon purpureus	3225	Plants	Plants	89.4	2.77e-21	NR	KAG0576969.1	3225	g43890	i0	90.6	1	53	5	100	0	159	1	46	98	KAG0576969.1 hypothetical protein KC19_5G122100 [Ceratodon purpureus]	diamond	159	89.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Pseudoditrichales	Ditrichaceae	Ceratodon	Ceratodon purpureus
32761960	32761960	PRJNA393181_S_NODE_34500_length_187_cov_1.280000_g34394_i0	PRJNA393181	34500	187	1.28	2.3936	Trapa incisa	236973	Plants	Plants	42.4	0.0237	NR	KAK4750609.1	236973	g34394	i0	39.2	1.66844919786096	51	30	80.2	1	152	3	257	307	KAK4750609.1 hypothetical protein SAY87_004091 [Trapa incisa]	diamond	312	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Lythraceae	Trapa	Trapa incisa

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