metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB673" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB673" 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
27160256	27160256	PRJEB673_P_NODE_4862_length_415_cov_2.021053_g4514_i0	PRJEB673	4862	415	2.021053	8.38736995	Chlamydiales bacterium	2047757	Bacteria	Bacteria	231	1.23e-75	NR	MCP5470421.1	2047757	g4514	i0	81.5	0.975903614457831	135	25	97.6	0	413	9	24	158	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	405	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27571201	27571201	PRJEB673_P_NODE_12104_length_156_cov_1.322314_g11755_i0	PRJEB673	12104	156	1.322314	2.06280984	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.5	6.49e-9	NR	MDH4372957.1	2026799	g11755	i0	54.9	0.980769230769231	51	23	98.1	0	156	4	552	602	MDH4372957.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	153	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30255612	30255612	PRJEB673_P_NODE_4912_length_412_cov_1.920424_g4564_i0	PRJEB673	4912	412	1.920424	7.91214688	Simkania sp.	34094	Bacteria	Bacteria	74.3	5.37e-13	NR	MCB1084310.1	34094	g4564	i0	57.9	0.41504854368932	57	24	41.5	0	410	240	114	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	171	74.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30539614	30539614	PRJEB673_P_NODE_4733_length_425_cov_2.184615_g4385_i0	PRJEB673	4733	425	2.184615	9.28461375	Chlamydiales bacterium	2047757	Bacteria	Bacteria	159	8.089999999999999e-47	NR	MCP5470420.1	2047757	g4385	i0	75.2	0.910588235294118	129	30	91.1	1	423	37	29	155	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	387	159	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31417369	31417369	PRJEB673_P_NODE_9216_length_206_cov_1.391813_g8867_i0	PRJEB673	9216	206	1.391813	2.86713478	Bacteria	2	Bacteria	Bacteria	55.5	7.25e-7	NR	HVS10494.1	2026780	g8867	i0	51	2.05339805825243	49	24	71.4	0	4	150	91	139	HVS10494.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Planctomycetota bacterium]	diamond	423	55.8	0.99462365591397806	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31796733	31796733	PRJEB673_P_NODE_11317_length_162_cov_1.574803_g10968_i0	PRJEB673	11317	162	1.574803	2.55118086	Pseudomonadati	3379134	Bacteria	Bacteria	80.1	7.81e-16	NR	WP_146661715.1	1936003	g10968	i0	69.6	17.2037037037037	46	14	85.2	0	21	158	109	154	WP_146661715.1 adenosylhomocysteinase [Anaerohalosphaera lusitana]	diamond	2787	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae	Anaerohalosphaera	Anaerohalosphaera lusitana
31962250	31962250	PRJEB673_P_NODE_12418_length_154_cov_1.008403_g12069_i0	PRJEB673	12418	154	1.008403	1.55294062	Prosthecobacter sp.	1965333	Bacteria	Bacteria	79	1.22e-15	NR	WP_322282923.1	1965333	g12069	i0	75.5	5.68831168831169	49	12	95.5	0	3	149	265	313	WP_322282923.1 alkene reductase [Prosthecobacter sp.]	diamond	876	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32057191	32057191	PRJEB673_P_NODE_3698_length_518_cov_1.418219_g3371_i0	PRJEB673	3698	518	1.418219	7.34637442	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	131	3.0999999999999996e-32	NR	MBL9134577.1	2026801	g3371	i0	76.5	4.22200772200772	81	19	46.9	0	274	516	363	443	MBL9134577.1 phosphoenolpyruvate carboxykinase (ATP) [Verrucomicrobiales bacterium]	diamond	2187	131	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32088822	32088822	PRJEB673_P_NODE_1118_length_885_cov_2.136471_g916_i0	PRJEB673	1118	885	2.136471	18.90776835	PVC group bacterium	2056642	Bacteria	Bacteria	63.2	1.16e-8	NR	MCP4648866.1	2056642	g916	i0	45	0.338983050847458	100	55	33.9	0	419	718	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	63.2	1	Bacteria	PVC group	Pseudomonadati						PVC group 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);;