metadata: contig_metadata: 5 rows where bioproject = "PRJNA911178" and tax

5 rows where bioproject = "PRJNA911178" and tax_phylum = "Kiritimatiellota"

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_species
27467049	27467049	PRJNA911178_P_NODE_298003_length_237_cov_2.268293_g295529_i0	PRJNA911178	298003	237	2.268293	5.37585441	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	118	6.84e-32	NR	MFU8781423.1	2212473	g295529	i0	69.7	1.91139240506329	76	23	96.2	0	2	229	30	105	MFU8781423.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	453	118	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
29329762	29329762	PRJNA911178_P_NODE_74049_length_411_cov_0.937870_g71586_i0	PRJNA911178	74049	411	0.93787	3.8546457	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	45.1	0.0323	NR	MCX7818477.1	2212473	g71586	i0	39.6	0.700729927007299	96	45	69.3	4	46	330	328	411	MCX7818477.1 PQQ-like beta-propeller repeat protein [Kiritimatiellia bacterium]	diamond	288	45.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
30782765	30782765	PRJNA911178_P_NODE_274554_length_244_cov_1.783626_g272080_i0	PRJNA911178	274554	244	1.783626	4.35204744	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	101	2.97e-24	NR	HMO04864.1	2212473	g272080	i0	64.7	0.836065573770492	68	24	83.6	0	206	3	11	78	HMO04864.1 pirin family protein [Kiritimatiellia bacterium]	diamond	204	101	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31541550	31541550	PRJNA911178_P_NODE_199976_length_272_cov_1.130653_g197503_i0	PRJNA911178	199976	272	1.130653	3.07537616	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	132	1.5e-34	NR	MCZ7592406.1	2212473	g197503	i0	71.1	3.97058823529412	90	26	99.3	0	2	271	69	158	MCZ7592406.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Kiritimatiellia bacterium]	diamond	1080	132	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
32868694	32868694	PRJNA911178_P_NODE_116160_length_339_cov_2.432331_g113688_i0	PRJNA911178	116160	339	2.432331	8.24560209	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.9	0.0438	NR	HMP75613.1	2212473	g113688	i0	38	0.628318584070796	71	36	62.8	3	9	221	594	656	HMP75613.1 PD-(D/E)XK nuclease family protein [Kiritimatiellia bacterium]	diamond	213	43.9	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia 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);;