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

9 rows where analysis = "diamond", bioproject = "PRJNA637328" 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_species
608974	608974	PRJNA637328_P_NODE_16381_length_252_cov_2.886700_g15904_i0	PRJNA637328	16381	252	2.8867	7.274484	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	132	5.67e-36	NR	HEY7090713.1	2876886	g15904	i0	79.7	0.94047619047619	79	16	94	0	14	250	1	79	HEY7090713.1 5'/3'-nucleotidase SurE [Tepidisphaeraceae bacterium]	diamond	237	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaeraceae bacterium
27744663	27744663	PRJNA637328_S_NODE_3984_length_156_cov_1.033613_g3907_i0	PRJNA637328	3984	156	1.033613	1.61243628	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40.8	0.0439	NR	GIT06037.1	2026799	g3907	i0	50	0.769230769230769	40	18	76.9	1	19	138	29	66	GIT06037.1 MAG: hypothetical protein CM1200mP29_14480 [Verrucomicrobiota bacterium]	diamond	120	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
27870572	27870572	PRJNA637328_P_NODE_13505_length_266_cov_3.580645_g13029_i0	PRJNA637328	13505	266	3.580645	9.5245157	Opitutia bacterium	2026771	Bacteria	Bacteria	119	3.71e-32	NR	MEL0099990.1	2026771	g13029	i0	62.5	1.98496240601504	88	33	99.2	0	266	3	14	101	MEL0099990.1 hypothetical protein [Opitutia bacterium]	diamond	528	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia			Opitutia bacterium
29828170	29828170	PRJNA637328_P_NODE_17431_length_248_cov_1.507538_g16954_i0	PRJNA637328	17431	248	1.507538	3.73869424	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.9	9.64e-11	NR	MCC7014462.1	2026780	g16954	i0	64.4	3.22983870967742	45	16	54.4	0	239	105	58	102	MCC7014462.1 hypothetical protein [Planctomycetota bacterium]	diamond	801	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
30365777	30365777	PRJNA637328_P_NODE_7112_length_334_cov_1.224561_g6637_i0	PRJNA637328	7112	334	1.224561	4.09003374	Opitutales bacterium	2026772	Bacteria	Bacteria	44.7	0.0194	NR	HNX04777.1	2026772	g6637	i0	42.6	0.94311377245509	54	20	45.8	2	57	209	14	59	HNX04777.1 prepilin peptidase [Opitutales bacterium]	diamond	315	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales		Opitutales bacterium
30460569	30460569	PRJNA637328_P_NODE_10573_length_289_cov_2.079167_g10098_i0	PRJNA637328	10573	289	2.079167	6.00879263	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	182	6.09e-56	NR	HEX5471787.1	2691534	g10098	i0	82.3	1.98269896193772	96	17	99.7	0	288	1	52	147	HEX5471787.1 orotidine 5'-phosphate decarboxylase / HUMPS family protein [Lacipirellulaceae bacterium]	diamond	573	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellulaceae bacterium
30839286	30839286	PRJNA637328_P_NODE_13134_length_268_cov_4.972603_g12658_i0	PRJNA637328	13134	268	4.972603	13.32657604	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	134	5.979999999999998e-35	NR	HVT29988.1	2691534	g12658	i0	69.3	1.97014925373134	88	27	98.5	0	264	1	347	434	HVT29988.1 CehA/McbA family metallohydrolase [Lacipirellulaceae bacterium]	diamond	528	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellulaceae bacterium
31389223	31389223	PRJNA637328_P_NODE_20376_length_231_cov_2.901099_g19899_i0	PRJNA637328	20376	231	2.901099	6.70153869	Bacteria	2	Bacteria	Bacteria	43.5	0.0171	NR	PIE24439.1	2026780	g19899	i0	36.7	2.36363636363636	60	35	74	1	10	180	196	255	PIE24439.1 MAG: hypothetical protein CSA62_03955 [Planctomycetota bacterium]	diamond	546	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32199146	32199146	PRJNA637328_P_NODE_19058_length_241_cov_2.916667_g18581_i0	PRJNA637328	19058	241	2.916667	7.02916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	136	2.9199999999999996e-37	NR	TXT18583.1	2026780	g18581	i0	98.8	0.995850622406639	80	1	99.6	0	1	240	12	91	TXT18583.1 MAG: phosphonate transport system permease protein [Planctomycetota bacterium]	diamond	240	136	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota 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);;