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

5 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_phylum = "Gemmatimonadota"

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_species
27580769	27580769	PRJNA395690_P_NODE_10284_length_254_cov_0.995122_g10132_i0	PRJNA395690	10284	254	0.995122	2.52760988	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.5	0.0231	NR	HEY8063046.1	2448054	g10132	i0	46	0.590551181102362	50	20	50.8	2	216	88	627	676	HEY8063046.1 protein kinase [Gemmatimonadales bacterium]	diamond	150	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
28559802	28559802	PRJNA395690_P_NODE_27347_length_169_cov_1.325000_g27195_i0	PRJNA395690	27347	169	1.325	2.23925	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	95.9	3.87e-22	NR	MBA3759289.1	2448054	g27195	i0	97.9	1.70414201183432	48	1	85.2	0	145	2	1	48	MBA3759289.1 CDP-diacylglycerol--serine O-phosphatidyltransferase [Gemmatimonadales bacterium]	diamond	288	95.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
28811954	28811954	PRJNA395690_P_NODE_36568_length_159_cov_2.154545_g36416_i0	PRJNA395690	36568	159	2.154545	3.42572655	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.9	0.00391	NR	HEY4659501.1	2026741	g36416	i0	49	1.92452830188679	51	19	83	2	15	146	73	123	HEY4659501.1 MFS transporter [Gemmatimonadaceae bacterium]	diamond	306	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
30454814	30454814	PRJNA395690_P_NODE_29433_length_166_cov_1.307692_g29281_i0	PRJNA395690	29433	166	1.307692	2.17076872	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	65.9	8.87e-11	NR	HWC74330.1	2448054	g29281	i0	61.5	4.46385542168675	52	20	94	0	158	3	423	474	HWC74330.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	741	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
30565715	30565715	PRJNA395690_P_NODE_7633_length_292_cov_1.469136_g7481_i0	PRJNA395690	7633	292	1.469136	4.28987712	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00851	NR	MBC7843425.1	2026741	g7481	i0	95.7	1.18150684931507	23	1	23.6	0	290	222	234	256	MBC7843425.1 type 1 glutamine amidotransferase domain-containing protein [Gemmatimonadaceae bacterium]	diamond	345	45.4	0.993392070484582	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae 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);;