metadata: contig_metadata: 8 rows where bioproject = "PRJNA966993", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA966993", 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
7320715	7320715	PRJNA966993_P_NODE_93246_length_245_cov_0.889535_g92794_i0	PRJNA966993	93246	245	0.889535	2.17936075	Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8	1797601	Bacteria	Bacteria	83.6	1.08e-17	NR	OGN59821.1	1797601	g92794	i0	50.6	0.991836734693878	81	39	99.2	1	3	245	87	166	OGN59821.1 MAG: superoxide dismutase [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8]	diamond	243	83.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8
20069161	20069161	PRJNA966993_P_NODE_7836_length_747_cov_3.649852_g7443_i0	PRJNA966993	7836	747	3.649852	27.26439444	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g7443	i0	100	0.0388219544846051	29	0	4	0	242	270	822713	822741	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
26614126	26614126	PRJNA966993_P_NODE_35361_length_360_cov_1.738676_g34909_i0	PRJNA966993	35361	360	1.738676	6.2592336	Chlamydiales bacterium	2047757	Bacteria	Bacteria	53.9	1.25e-5	NR	MFT4554285.1	2047757	g34909	i0	37	0.675	81	46	65.8	2	121	357	18	95	MFT4554285.1 steroid 5-alpha reductase family enzyme [Chlamydiales bacterium]	diamond	243	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27594692	27594692	PRJNA966993_P_NODE_100944_length_231_cov_2.436709_g100492_i0	PRJNA966993	100944	231	2.436709	5.62879779	Chlamydiae bacterium CG1	2081524	Bacteria	Bacteria	74.3	2.28e-13	NR	PIS00336.1	1973935	g100492	i0	52	0.974025974025974	75	34	97.4	1	231	7	20	92	PIS00336.1 MAG: delta(24(24(1)))-sterol reductase [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9]	diamond	225	74.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9
28005300	28005300	PRJNA966993_P_NODE_69445_length_271_cov_1.545455_g68993_i0	PRJNA966993	69445	271	1.545455	4.18818305	Candidatus Rhabdochlamydia sp. T3358	2099795	Bacteria	Bacteria	68.2	5.3e-11	NR	WP_138107150.1	2099795	g68993	i0	47.7	0.974169741697417	88	37	93	3	268	17	40	122	WP_138107150.1 molecular chaperone DnaJ [Candidatus Rhabdochlamydia sp. T3358]	diamond	264	68.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp. T3358
28794198	28794198	PRJNA966993_P_NODE_20507_length_463_cov_2.364103_g20062_i0	PRJNA966993	20507	463	2.364103	10.94579689	Chlamydiia bacterium	2052156	Bacteria	Bacteria	75.1	1.99e-12	NR	MCB1111354.1	2052156	g20062	i0	32.7	3.30453563714903	168	89	95.9	8	463	20	50	213	MCB1111354.1 phosphoenolpyruvate carboxykinase (GTP) [Chlamydiia bacterium]	diamond	1530	75.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
29678131	29678131	PRJNA966993_P_NODE_31790_length_377_cov_2.289474_g31338_i0	PRJNA966993	31790	377	2.289474	8.63131698	Parachlamydia sp. AcF125	2795736	Bacteria	Bacteria	82	3.01e-15	NR	WP_213157379.1	2795736	g31338	i0	33.1	1.0106100795756	127	82	98.7	1	4	375	137	263	WP_213157379.1 GTPase [Parachlamydia sp. AcF125]	diamond	381	82	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp. AcF125
32239071	32239071	PRJNA966993_P_NODE_25818_length_415_cov_1.549708_g25371_i0	PRJNA966993	25818	415	1.549708	6.4312882	Estrella lausannensis	483423	Bacteria	Bacteria	45.8	0.0197	NR	WP_098037350.1	483423	g25371	i0	24.4	1.41686746987952	135	92	97.6	3	413	9	530	654	WP_098037350.1 hypothetical protein [Estrella lausannensis]	diamond	588	45.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis

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