metadata: contig_metadata: 10 rows where bioproject = "PRJNA438572", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA438572", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

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
27092312	27092312	PRJNA438572_P_NODE_342_length_1358_cov_4.035798_g308_i0	PRJNA438572	342	1358	4.035798	54.80613684	Bacteria	2	Bacteria	Bacteria	50.4	0.0131	NR	MBN2479755.1	2052178	g308	i0	23.3	1.26583210603829	258	140	56.6	10	237	1004	182	383	MBN2479755.1 hypothetical protein [Parachlamydiales bacterium]	diamond	1719	50.8	0.992125984251969	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
27138821	27138821	PRJNA438572_P_NODE_23982_length_242_cov_1.597633_g23863_i0	PRJNA438572	23982	242	1.597633	3.86627186	Chlamydiales bacterium	2047757	Bacteria	Bacteria	150	1.13e-44	NR	MCP5470421.1	2047757	g23863	i0	87.5	0.991735537190083	80	10	99.2	0	240	1	3	82	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	240	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27202249	27202249	PRJNA438572_P_NODE_7542_length_369_cov_1.023649_g7423_i0	PRJNA438572	7542	369	1.023649	3.77726481	Chlamydiales bacterium	2047757	Bacteria	Bacteria	156	3.1599999999999997e-46	NR	MCP5470420.1	2047757	g7423	i0	85.4	0.723577235772358	89	13	72.4	0	8	274	1	89	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	267	156	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28623636	28623636	PRJNA438572_P_NODE_4607_length_459_cov_2.746114_g4488_i0	PRJNA438572	4607	459	2.746114	12.60466326	Simkania sp.	34094	Bacteria	Bacteria	136	9.35e-37	NR	MCB1084310.1	34094	g4488	i0	75.6	0.588235294117647	90	22	58.8	0	457	188	83	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	270	136	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29349739	29349739	PRJNA438572_P_NODE_17229_length_253_cov_0.866667_g17110_i0	PRJNA438572	17229	253	0.866667	2.19266751	Simkania sp.	34094	Bacteria	Bacteria	65.1	7.12e-11	NR	MCB1084323.1	34094	g17110	i0	48.4	0.735177865612648	62	32	73.5	0	67	252	42	103	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	186	65.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30075883	30075883	PRJNA438572_P_NODE_4432_length_467_cov_4.335025_g4313_i0	PRJNA438572	4432	467	4.335025	20.24456675	Chlamydiales bacterium	2047757	Bacteria	Bacteria	220	6.39e-71	NR	MCP5470420.1	2047757	g4313	i0	80.8	0.937901498929336	146	28	93.8	0	467	30	2	147	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	438	220	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30123729	30123729	PRJNA438572_P_NODE_792_length_1008_cov_4.888770_g721_i0	PRJNA438572	792	1008	4.88877	49.2788016	root	1	Root_unresolved	Root_unresolved	257	2.37e-81	NR	MCB1084310.1	34094	g721	i0	74.4	2.26488095238095	172	44	51.2	0	279	794	1	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	2283	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31166250	31166250	PRJNA438572_P_NODE_3415_length_533_cov_2.795652_g3297_i0	PRJNA438572	3415	533	2.795652	14.90082516	root	1	Root_unresolved	Root_unresolved	121	1.55e-30	NR	MCB1084310.1	34094	g3297	i0	70	1.37898686679174	80	24	45	0	240	1	1	80	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	735	122	0.991803278688525	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32383898	32383898	PRJNA438572_P_NODE_5559_length_423_cov_2.951429_g5440_i0	PRJNA438572	5559	423	2.951429	12.48454467	Chlamydiales bacterium	2047757	Bacteria	Bacteria	212	7.89e-68	NR	MCP5470420.1	2047757	g5440	i0	77.9	0.99290780141844	140	31	99.3	0	2	421	3	142	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	420	212	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32636450	32636450	PRJNA438572_P_NODE_18420_length_251_cov_0.876404_g18301_i0	PRJNA438572	18420	251	0.876404	2.19977404	Simkania sp.	34094	Bacteria	Bacteria	48.5	3.05e-4	NR	MCB1084310.1	34094	g18301	i0	60.5	0.454183266932271	38	15	45.4	0	1	114	133	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	114	48.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.

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);;