metadata: contig_metadata: 5 rows where bioproject = "PRJNA560932", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA560932", tax_clade = "PVC group" 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_order	tax_family	tax_species
20946584	20946584	PRJNA560932_P_NODE_11377_length_517_cov_1.382883_g11023_i0	PRJNA560932	11377	517	1.382883	7.14950511	Kiritimatiellaceae bacterium	2026752	Bacteria	Bacteria	232	1.5e-69	NR	MAS98412.1	2026752	g11023	i0	66.1	10.5145067698259	165	56	95.7	0	513	19	482	646	MAS98412.1 acetate--CoA ligase [Kiritimatiellaceae bacterium]	diamond	5436	232	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiellaceae bacterium
27931831	27931831	PRJNA560932_P_NODE_12885_length_487_cov_1.584541_g12531_i0	PRJNA560932	12885	487	1.584541	7.71671467	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	55.1	8.23e-6	NR	MBR7181017.1	2212473	g12531	i0	26.7	1.52156057494867	120	65	59.8	1	407	117	56	175	MBR7181017.1 leucine-rich repeat domain-containing protein [Kiritimatiellia bacterium]	diamond	741	55.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
29384379	29384379	PRJNA560932_P_NODE_56389_length_248_cov_0.880000_g56033_i0	PRJNA560932	56389	248	0.88	2.1824	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	47.8	6.85e-4	NR	MBR3777698.1	2212473	g56033	i0	35.9	3.07258064516129	92	48	98	2	247	5	46	137	MBR3777698.1 GH92 family glycosyl hydrolase [Kiritimatiellia bacterium]	diamond	762	47.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
31343040	31343040	PRJNA560932_P_NODE_37756_length_296_cov_1.372197_g37400_i0	PRJNA560932	37756	296	1.3721969999999999	4.06170312	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	118	8.249999999999998e-30	NR	NKB25862.1	2212473	g37400	i0	55.1	0.993243243243243	98	44	99.3	0	1	294	38	135	NKB25862.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Kiritimatiellia bacterium]	diamond	294	118	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
32765576	32765576	PRJNA560932_P_NODE_40840_length_285_cov_1.452830_g40484_i0	PRJNA560932	40840	285	1.45283	4.1405655	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	57.4	3.57e-8	NR	MFO1492430.1	2212473	g40484	i0	42.2	0.947368421052632	90	48	92.6	3	283	20	23	110	MFO1492430.1 ankyrin repeat domain-containing protein [Kiritimatiellia bacterium]	diamond	270	57.4	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);;