metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_clade = "PVC group"

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_genus	tax_species
7787580	7787580	PRJEB73599_P_NODE_8887_length_173_cov_2.270833_g8600_i0	PRJEB73599	8887	173	2.270833	3.92854109	PVC group	1783257	Bacteria	Bacteria	79	2.49e-15	NR	OED37650.1	1868283	g8600	i0	66.7	6.64161849710983	57	19	98.8	0	172	2	313	369	OED37650.1 pyruvate, phosphate dikinase [PVC group bacterium (ex Bugula neritina AB1)]	diamond	1149	79	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium (ex Bugula neritina AB1)
10338204	10338204	PRJEB73599_P_NODE_2089_length_513_cov_1.938017_g1833_i0	PRJEB73599	2089	513	1.938017	9.94202721	Planctomycetota bacterium	2026780	Bacteria	Bacteria	177	1.09e-51	NR	MFM7522431.1	2026780	g1833	i0	53.3	1.92982456140351	165	76	96.5	1	19	513	33	196	MFM7522431.1 glutamine synthetase type III [Planctomycetota bacterium]	diamond	990	177	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26868902	26868902	PRJEB73599_P_NODE_361_length_1213_cov_2.868243_g281_i0	PRJEB73599	361	1213	2.868243	34.79178759	Bacteria	2	Bacteria	Bacteria	75.1	1.92e-10	NR	MBM4090603.1	2026780	g281	i0	42.2	0.722176422093982	83	47	20.3	1	624	379	52	134	MBM4090603.1 tetratricopeptide repeat protein [Planctomycetota bacterium]	diamond	876	75.5	0.994701986754967	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29900693	29900693	PRJEB73599_P_NODE_2511_length_466_cov_2.041190_g2240_i0	PRJEB73599	2511	466	2.04119	9.5119454	Akkermansia	239934	Bacteria	Bacteria	164	2.19e-44	NR	WP_215427380.1	239934	g2240	i0	62.1	12.1158798283262	124	39	74.7	1	367	20	36	159	WP_215427380.1 MULTISPECIES: phosphoenolpyruvate carboxykinase (GTP) [Akkermansia]	diamond	5646	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia
31227443	31227443	PRJEB73599_P_NODE_3535_length_376_cov_3.360231_g3249_i0	PRJEB73599	3535	376	3.360231	12.63446856	Bacteria	2	Bacteria	Bacteria	61.6	9.69e-9	NR	MDP6849681.1	2026780	g3249	i0	32.6	7.48404255319149	132	71	93.4	3	365	15	54	182	MDP6849681.1 guanylate kinase [Planctomycetota bacterium]	diamond	2814	62	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31266460	31266460	PRJEB73599_P_NODE_9055_length_170_cov_1.858156_g8768_i0	PRJEB73599	9055	170	1.858156	3.1588652	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	59.3	1.99e-8	NR	HMP89769.1	2212473	g8768	i0	47.5	1.04117647058824	59	24	91.8	2	13	168	2503	2561	HMP89769.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium]	diamond	177	59.3	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);;