metadata: contig_metadata: 13 rows where bioproject = "PRJNA1108009", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA1108009", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
17598216	17598216	PRJNA1108009_P_NODE_30374_length_243_cov_0.905882_g30056_i0	PRJNA1108009	30374	243	0.905882	2.20129326	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	162	6.61e-47	NR	MBQ6159221.1	2691551	g30056	i0	95	0.987654320987654	80	4	98.8	0	1	240	49	128	MBQ6159221.1 tRNA-dihydrouridine synthase [Thermoguttaceae bacterium]	diamond	240	162	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
26719155	26719155	PRJNA1108009_P_NODE_29401_length_244_cov_0.900585_g29083_i0	PRJNA1108009	29401	244	0.900585	2.1974274	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	157	4.75e-44	NR	MBR2003529.1	2691551	g29083	i0	100	6.88524590163934	80	0	98.4	0	3	242	295	374	MBR2003529.1 50S ribosome-binding GTPase [Thermoguttaceae bacterium]	diamond	1680	157	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
27004326	27004326	PRJNA1108009_P_NODE_26142_length_249_cov_0.875000_g25824_i0	PRJNA1108009	26142	249	0.875	2.17875	Bremerella cremea	1031537	Bacteria	Bacteria	68.2	4.47e-11	NR	WP_345091782.1	1031537	g25824	i0	55.9	1.56626506024096	68	30	81.9	0	239	36	1057	1124	WP_345091782.1 beta strand repeat-containing protein [Bremerella cremea]	diamond	390	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella cremea
27194016	27194016	PRJNA1108009_P_NODE_19462_length_292_cov_1.063927_g19144_i0	PRJNA1108009	19462	292	1.063927	3.10666684	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47	0.00222	NR	HCD33727.1	2052180	g19144	i0	35.1	0.76027397260274	74	47	75	1	74	292	10	83	HCD33727.1 hypothetical protein [Phycisphaerales bacterium]	diamond	222	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28078331	28078331	PRJNA1108009_P_NODE_20645_length_282_cov_1.842105_g20327_i0	PRJNA1108009	20645	282	1.842105	5.1947361	Humisphaera sp.	2807514	Bacteria	Bacteria	137	1.4499999999999998e-37	NR	HEX8916088.1	2807514	g20327	i0	69.9	4.9468085106383	93	28	98.9	0	3	281	119	211	HEX8916088.1 aldolase/citrate lyase family protein [Humisphaera sp.]	diamond	1395	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
28267692	28267692	PRJNA1108009_P_NODE_27186_length_248_cov_0.874286_g26868_i0	PRJNA1108009	27186	248	0.874286	2.16822928	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	43.5	0.0209	NR	HEY1921608.1	2876886	g26868	i0	36.4	1.64516129032258	77	45	88.3	3	19	237	203	279	HEY1921608.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	408	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29751580	29751580	PRJNA1108009_P_NODE_22811_length_265_cov_1.244792_g22493_i0	PRJNA1108009	22811	265	1.244792	3.2986988	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	130	4.8e-35	NR	MBR4975851.1	2691551	g22493	i0	98.6	1.5622641509434	69	1	78.1	0	264	58	57	125	MBR4975851.1 ACP S-malonyltransferase [Thermoguttaceae bacterium]	diamond	414	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
29846614	29846614	PRJNA1108009_P_NODE_7531_length_502_cov_0.857809_g7215_i0	PRJNA1108009	7531	502	0.857809	4.30620118	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	66.2	3.56e-9	NR	MFT3784836.1	2876886	g7215	i0	34.5	0.675298804780876	113	71	66.3	2	20	352	393	504	MFT3784836.1 kelch repeat-containing protein [Tepidisphaeraceae bacterium]	diamond	339	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30636230	30636230	PRJNA1108009_P_NODE_24593_length_251_cov_1.353933_g24275_i0	PRJNA1108009	24593	251	1.353933	3.39837183	Crateriforma	2714592	Bacteria	Bacteria	43.5	0.0216	NR	WP_146413112.1	2714592	g24275	i0	41.5	0.49003984063745	41	24	49	0	78	200	60	100	WP_146413112.1 MULTISPECIES: DUF58 domain-containing protein [Crateriforma]	diamond	123	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Crateriforma
30825967	30825967	PRJNA1108009_P_NODE_29974_length_243_cov_1.435294_g29656_i0	PRJNA1108009	29974	243	1.435294	3.48776442	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	120	6.02e-30	NR	MBM43568.1	2026778	g29656	i0	69.6	1.96296296296296	79	24	97.5	0	4	240	394	472	MBM43568.1 hypothetical protein [Phycisphaerae bacterium]	diamond	477	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30920991	30920991	PRJNA1108009_P_NODE_28374_length_246_cov_0.890173_g28056_i0	PRJNA1108009	28374	246	0.890173	2.18982558	Planctomycetales bacterium	2053591	Bacteria	Bacteria	71.6	2.56e-12	NR	MBI5759636.1	2053591	g28056	i0	49.4	0.98780487804878	81	40	97.6	1	2	241	463	543	MBI5759636.1 hypothetical protein [Planctomycetales bacterium]	diamond	243	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
32122689	32122689	PRJNA1108009_P_NODE_4578_length_653_cov_1.641379_g4271_i0	PRJNA1108009	4578	653	1.641379	10.71820487	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.1	0.0143	NR	HVS09816.1	2026780	g4271	i0	30.7	0.689127105666156	150	59	66.2	6	25	456	167	277	HVS09816.1 hypothetical protein [Planctomycetota bacterium]	diamond	450	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32817349	32817349	PRJNA1108009_P_NODE_28180_length_246_cov_0.890173_g27862_i0	PRJNA1108009	28180	246	0.890173	2.18982558	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.7	0.0382	NR	NBW95933.1	2052181	g27862	i0	41.2	0.829268292682927	68	32	82.9	2	9	212	68	127	NBW95933.1 hypothetical protein [Planctomycetia bacterium]	diamond	204	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;