metadata: contig_metadata: 9 rows where bioproject = "PRJNA326068", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJNA326068", 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
4216706	4216706	PRJNA326068_P_NODE_13184_length_248_cov_3.287671_g12221_i0	PRJNA326068	13184	248	3.287671	8.15342408	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	351	1.97e-92	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g12221	i0	92.975	112.262096774194	242	15	98	2	7	248	654623	654862	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	27841	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
4897048	4897048	PRJNA326068_P_NODE_14984_length_220_cov_5.109948_g14021_i0	PRJNA326068	14984	220	5.109948	11.2418856	Neochlamydia	112987	Bacteria	Bacteria	152	1.87e-32	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g14021	i0	80.808	217.931818181818	198	34	90	4	24	220	616	810	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	47945	152	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
12547712	12547712	PRJNA326068_P_NODE_10430_length_306_cov_4.010830_g9470_i0	PRJNA326068	10430	306	4.01083	12.2731398	Candidatus Protochlamydia	282132	Bacteria	Bacteria	435	2.43e-117	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g9470	i0	92.208	118.52614379085	308	22	100	2	1	306	1250439	1250132	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	36269	435	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
12547714	12547714	PRJNA326068_P_NODE_11810_length_275_cov_3.434959_g10848_i0	PRJNA326068	11810	275	3.434959	9.44613725	Parachlamydia	83551	Bacteria	Bacteria	414	2.7999999999999992e-111	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g10848	i0	93.818	137.254545454545	275	17	100	0	1	275	2944	2670	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	37745	414	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
12547738	12547738	PRJNA326068_P_NODE_8350_length_361_cov_3.228916_g7401_i0	PRJNA326068	8350	361	3.228916	11.65638676	Chlamydiia	204429	Bacteria	Bacteria	237	8.799999999999999e-58	NTclustered	gi\|24527363\|gb\|AY144294.1\|	212218	g7401	i0	100	49.01108033241	128	0	86	0	234	361	194	321	Uncultured Neochlamydia sp. LTUNC09456 16S ribosomal RNA gene, partial sequence	blastn	17693	237	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	uncultured Neochlamydia sp.
15692083	15692083	PRJNA326068_P_NODE_14433_length_227_cov_2.742424_g13470_i0	PRJNA326068	14433	227	2.742424	6.22530248	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	300	6.54e-77	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g13470	i0	91.266	106.299559471366	229	7	100	11	1	221	655158	655381	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	24130	300	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
16371752	16371752	PRJNA326068_P_NODE_13553_length_241_cov_4.910377_g12590_i0	PRJNA326068	13553	241	4.910377	11.83400857	Chlamydiifrater	2822114	Bacteria	Bacteria	180	9.539999999999999e-41	NTclustered	gi\|2031803725\|emb\|LR777658.1\|	2681469	g12590	i0	80.083	64.8257261410788	241	48	100	0	1	241	1153672	1153912	Chlamydiaceae bacterium 14-2711_R47 genome assembly, chromosome: 14-2711_R47_omosome	blastn	15623	180	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydiifrater	Chlamydiifrater phoenicopteri
16371778	16371778	PRJNA326068_P_NODE_8173_length_366_cov_25.409496_g7225_i0	PRJNA326068	8173	366	25.409496	92.99875536	Candidatus Protochlamydia	282132	Bacteria	Bacteria	261	5.3e-65	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g7225	i0	87.391	88.9590163934426	230	25	62	3	139	366	1249340	1249113	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	32559	261	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
24615557	24615557	PRJNA326068_P_NODE_8400_length_359_cov_5.100000_g7451_i0	PRJNA326068	8400	359	5.1	18.309	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	6.209999999999997e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g7451	i0	88.858	170.476323119777	359	38	99	2	2	359	653613	653970	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	61201	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae 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);;