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

5 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax_phylum = "Planctomycetota"

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_species
27585188	27585188	PRJNA591127_P_NODE_14724_length_197_cov_3.900000_g14555_i0	PRJNA591127	14724	197	3.9	7.683	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	3.42e-4	NR	HZE98642.1	2026780	g14555	i0	79.2	0.730964467005076	24	5	36.5	0	195	124	128	151	HZE98642.1 rhomboid family intramembrane serine protease [Planctomycetota bacterium]	diamond	144	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota			Planctomycetota bacterium
31610209	31610209	PRJNA591127_P_NODE_16956_length_197_cov_2.637500_g16787_i0	PRJNA591127	16956	197	2.6375	5.195875	Pseudomonadati	3379134	Bacteria	Bacteria	47	2.34e-4	NR	MBL8881360.1	2052180	g16787	i0	100	0.761421319796954	25	0	38.1	0	123	197	74	98	MBL8881360.1 capsule biosynthesis protein [Phycisphaerales bacterium]	diamond	150	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaerales bacterium
32324670	32324670	PRJNA591127_P_NODE_26039_length_163_cov_1.349206_g25870_i0	PRJNA591127	26039	163	1.349206	2.1992057800000002	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.6	0.0328	NR	MDH4240107.1	2026778	g25870	i0	39.2	0.938650306748466	51	30	92	1	11	160	181	231	MDH4240107.1 serine/threonine protein kinase [Phycisphaerae bacterium]	diamond	153	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae		Phycisphaerae bacterium
32338067	32338067	PRJNA591127_P_NODE_31899_length_150_cov_3.053097_g31730_i0	PRJNA591127	31899	150	3.053097	4.5796455	Bacteria	2	Bacteria	Bacteria	43.9	0.00382	NR	MBX3394104.1	2026778	g31730	i0	68	4.62	25	8	50	0	2	76	226	250	MBX3394104.1 LPS export ABC transporter ATP-binding protein [Phycisphaerae bacterium]	diamond	693	44.3	0.99097065462754	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae		Phycisphaerae bacterium
32482688	32482688	PRJNA591127_P_NODE_31719_length_150_cov_3.424779_g31550_i0	PRJNA591127	31719	150	3.424779	5.1371685	Planctomycetia bacterium	2052181	Bacteria	Bacteria	94.4	6.740000000000001e-21	NR	MDA8376149.1	2052181	g31550	i0	79.6	2.94	49	10	98	0	2	148	197	245	MDA8376149.1 SMP-30/gluconolactonase/LRE family protein [Planctomycetia bacterium]	diamond	441	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia		Planctomycetia 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);;