metadata: contig_metadata: 11 rows where bioproject = "PRJNA670521", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA670521", 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
1164911	1164911	PRJNA670521_P_NODE_36961_length_333_cov_2.073077_g36216_i0	PRJNA670521	36961	333	2.073077	6.90334641	Chlamydiia	204429	Bacteria	Bacteria	292	1.7e-74	NTclustered	gi\|1000729566\|gb\|KT030899.1\|	1345621	g36216	i0	87.795	149.558558558559	254	25	75	6	84	333	1937	1686	Candidatus Similichlamydia labri strain SM160513-33 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49803	292	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Parilichlamydiaceae	Candidatus Similichlamydia	Candidatus Similichlamydia labri
16467842	16467842	PRJNA670521_P_NODE_42913_length_315_cov_0.954545_g42168_i0	PRJNA670521	42913	315	0.954545	3.00681675	Parachlamydia	83551	Bacteria	Bacteria	359	1.55e-94	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g42168	i0	90.741	180.536507936508	270	23	85	2	1	269	1971	2239	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	56869	359	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
17216418	17216418	PRJNA670521_P_NODE_87294_length_243_cov_1.358824_g86549_i0	PRJNA670521	87294	243	1.358824	3.30194232	Chlamydiales bacterium	2047757	Bacteria	Bacteria	67.4	7.91e-11	NR	MDF2577401.1	2047757	g86549	i0	47.2	0.888888888888889	72	38	88.9	0	219	4	386	457	MDF2577401.1 hypothetical protein [Chlamydiales bacterium]	diamond	216	67.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
22315408	22315408	PRJNA670521_P_NODE_17558_length_445_cov_1.456989_g16816_i0	PRJNA670521	17558	445	1.456989	6.48360105	Simkania sp.	34094	Bacteria	Bacteria	234	4.24e-75	NR	MCB1084310.1	34094	g16816	i0	75.7	0.997752808988764	148	36	99.8	0	445	2	29	176	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	444	234	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
26986655	26986655	PRJNA670521_P_NODE_75542_length_249_cov_0.875000_g74797_i0	PRJNA670521	75542	249	0.875	2.17875	Candidatus Similichlamydia laticola	2170265	Bacteria	Bacteria	131	4.44e-36	NR	WP_114544437.1	2170265	g74797	i0	77.6	0.91566265060241	76	17	91.6	0	20	247	1	76	WP_114544437.1 30S ribosomal protein S3 [Candidatus Similichlamydia laticola]	diamond	228	131	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Parilichlamydiaceae	Candidatus Similichlamydia	Candidatus Similichlamydia laticola
27902763	27902763	PRJNA670521_P_NODE_41325_length_319_cov_1.800813_g40580_i0	PRJNA670521	41325	319	1.800813	5.74459347	Chlamydiales bacterium	2047757	Bacteria	Bacteria	174	1.5999999999999996e-53	NR	MCP5470420.1	2047757	g40580	i0	80.6	0.968652037617555	103	20	96.9	0	9	317	1	103	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	309	174	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30366456	30366456	PRJNA670521_P_NODE_49212_length_298_cov_1.124444_g48467_i0	PRJNA670521	49212	298	1.124444	3.35084312	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	60.1	6e-8	NR	MBA3238892.1	2052176	g48467	i0	30.3	1.58053691275168	89	62	89.6	0	294	28	1234	1322	MBA3238892.1 ankyrin repeat domain-containing protein [Parachlamydiaceae bacterium]	diamond	471	60.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30840002	30840002	PRJNA670521_P_NODE_91914_length_241_cov_0.916667_g91169_i0	PRJNA670521	91914	241	0.916667	2.20916747	Candidatus Neptunochlamydia vexilliferae	1651774	Bacteria	Bacteria	43.9	0.0143	NR	WP_194848015.1	1651774	g91169	i0	36.1	1.84232365145228	72	44	87.1	1	30	239	1301	1372	WP_194848015.1 tetratricopeptide repeat protein [Candidatus Neptunochlamydia vexilliferae]	diamond	444	43.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia vexilliferae
32484717	32484717	PRJNA670521_P_NODE_81059_length_246_cov_0.890173_g80314_i0	PRJNA670521	81059	246	0.890173	2.18982558	Candidatus Anoxychlamydiales bacterium	2705072	Bacteria	Bacteria	61.2	9.95e-9	NR	NGX28638.1	2705072	g80314	i0	43.9	0.804878048780488	66	37	80.5	0	200	3	191	256	NGX28638.1 3-oxoacyl-[acyl-carrier-protein] synthase 3 [Candidatus Anoxychlamydiales bacterium]	diamond	198	61.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Candidatus Anoxychlamydiales			Candidatus Anoxychlamydiales bacterium
32705200	32705200	PRJNA670521_P_NODE_29920_length_361_cov_0.902778_g29175_i0	PRJNA670521	29920	361	0.902778	3.25902858	Simkania sp.	34094	Bacteria	Bacteria	95.9	1.95e-21	NR	MCB1084310.1	34094	g29175	i0	52.4	0.681440443213296	82	39	68.1	0	2	247	115	196	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	246	95.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32799594	32799594	PRJNA670521_P_NODE_20700_length_415_cov_2.257310_g19957_i0	PRJNA670521	20700	415	2.25731	9.3678365	Chlamydiales bacterium	2047757	Bacteria	Bacteria	135	1.31e-37	NR	MCP5470420.1	2047757	g19957	i0	80.5	0.556626506024096	77	15	55.7	0	415	185	3	79	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	231	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;