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

5 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "candidate division WOR-3"

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_phylum	tax_species
26635221	26635221	PRJNA556992_P_NODE_340541_length_283_cov_2.128571_g338352_i0	PRJNA556992	340541	283	2.128571	6.02385593	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	85.5	5.39e-17	NR	MDH5684819.1	2052148	g338352	i0	47.3	1.92932862190813	93	41	98.6	2	283	5	385	469	MDH5684819.1 GspE/PulE family protein [candidate division WOR-3 bacterium]	diamond	546	85.5	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
28089244	28089244	PRJNA556992_P_NODE_629045_length_256_cov_3.956284_g626856_i0	PRJNA556992	629045	256	3.956284	10.12808704	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	61.2	1.14e-8	NR	MBN2378209.1	2052148	g626856	i0	52.9	0.59765625	51	24	59.8	0	3	155	98	148	MBN2378209.1 patatin-like phospholipase family protein [candidate division WOR-3 bacterium]	diamond	153	61.2	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
29888897	29888897	PRJNA556992_P_NODE_1066771_length_220_cov_8.993197_g1064580_i0	PRJNA556992	1066771	220	8.993197	19.7850334	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	42	0.0438	NR	MCK4525947.1	2052148	g1064580	i0	52.9	0.463636363636364	34	16	46.4	0	117	218	1	34	MCK4525947.1 hypothetical protein [candidate division WOR-3 bacterium]	diamond	102	42	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
31564153	31564153	PRJNA556992_P_NODE_459236_length_271_cov_1.383838_g457047_i0	PRJNA556992	459236	271	1.383838	3.75020098	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	62.4	6.24e-9	NR	MEO0236781.1	2052148	g457047	i0	51.5	0.730627306273063	66	30	70.8	1	38	229	410	475	MEO0236781.1 hypothetical protein [candidate division WOR-3 bacterium]	diamond	198	62.4	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
31673082	31673082	PRJNA556992_P_NODE_67877_length_459_cov_1.445596_g65704_i0	PRJNA556992	67877	459	1.445596	6.63528564	Pseudomonadati	3379134	Bacteria	Bacteria	145	8.49e-41	NR	MEO0092113.1	2052148	g65704	i0	56.3	4.2156862745098	126	52	80.4	1	401	33	59	184	MEO0092113.1 RDD family protein [candidate division WOR-3 bacterium]	diamond	1935	145	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium

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