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

13 rows where bioproject = "PRJNA682078", 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
4490366	4490366	PRJNA682078_P_NODE_297024_length_229_cov_2.807692_g295247_i0	PRJNA682078	297024	229	2.807692	6.42961468	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	204	5.33e-48	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g295247	i0	83.262	425.152838427948	233	28	100	11	1	229	2631847	2632072	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	97360	204	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
7039947	7039947	PRJNA682078_P_NODE_253626_length_246_cov_1.763006_g251849_i0	PRJNA682078	253626	246	1.763006	4.33699476	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	95.3	3.64e-15	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g251849	i0	95	1.78861788617886	60	3	24	0	185	244	1923494	1923435	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	440	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
8311643	8311643	PRJNA682078_P_NODE_138487_length_305_cov_2.396552_g136710_i0	PRJNA682078	138487	305	2.396552	7.3094836	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	322	1.96e-83	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g136710	i0	86.824	117.744262295082	296	29	97	9	6	295	2058561	2058852	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	35912	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10100091	10100091	PRJNA682078_P_NODE_100448_length_351_cov_1.327338_g98672_i0	PRJNA682078	100448	351	1.327338	4.65895638	Parachlamydia	83551	Bacteria	Bacteria	289	2.32e-73	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g98672	i0	86.397	145.487179487179	272	28	76	9	29	296	1496	1762	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	51066	289	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
14688314	14688314	PRJNA682078_P_NODE_170052_length_281_cov_0.961538_g168275_i0	PRJNA682078	170052	281	0.961538	2.70192178	Candidatus Euplotechlamydia quinta	2936506	Bacteria	Bacteria	399	8.029999999999998e-107	NTclustered	gi\|2226301499\|gb\|ON271409.1\|	2936506	g168275	i0	92.553	96.0284697508897	282	16	99	5	1	279	292	13	Chlamydiia bacterium (ex Euplotes octocarinatus) isolate Zam5b-1 16S ribosomal RNA gene, partial sequence	blastn	26984	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Euplotechlamydia	Candidatus Euplotechlamydia quinta
22337840	22337840	PRJNA682078_P_NODE_218658_length_252_cov_2.268156_g216881_i0	PRJNA682078	218658	252	2.268156	5.71575312	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g216881	i0	98.81	97.2103174603175	252	3	100	0	1	252	403	152	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	24497	449	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
22340902	22340902	PRJNA682078_P_NODE_7998_length_1270_cov_2.502089_g6865_i0	PRJNA682078	7998	1270	2.502089	31.7765303	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1735	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g6865	i0	91.366	173.476377952756	1274	100	100	7	1	1270	653436	654703	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	220315	1735	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
26638892	26638892	PRJNA682078_P_NODE_244021_length_248_cov_0.880000_g242244_i0	PRJNA682078	244021	248	0.88	2.1824	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	60.1	2.74e-8	NR	MEI8365171.1	2052176	g242244	i0	60	0.544354838709677	45	16	52	1	119	247	11	55	MEI8365171.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	135	60.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27335101	27335101	PRJNA682078_P_NODE_226003_length_251_cov_0.865169_g224226_i0	PRJNA682078	226003	251	0.865169	2.17157419	Chlamydiales bacterium	2047757	Bacteria	Bacteria	71.6	2.62e-12	NR	MFI5343006.1	2047757	g224226	i0	42.2	0.99203187250996006	83	47	98	1	1	246	242	324	MFI5343006.1 hypothetical protein [Chlamydiales bacterium]	diamond	249	71.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27650883	27650883	PRJNA682078_P_NODE_251664_length_247_cov_0.885057_g249887_i0	PRJNA682078	251664	247	0.885057	2.18609079	Chlamydiota bacterium	2081524	Bacteria	Bacteria	54.7	2.51e-6	NR	MCC6128156.1	2081524	g249887	i0	40	1.5668016194332	65	39	78.9	0	4	198	1131	1195	MCC6128156.1 hypothetical protein [Chlamydiota bacterium]	diamond	387	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30777252	30777252	PRJNA682078_P_NODE_231194_length_250_cov_0.870056_g229417_i0	PRJNA682078	231194	250	0.870056	2.17514	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	112	9.44e-27	NR	WP_059061894.1	389348	g229417	i0	62.5	0.96	80	29	94.8	1	249	13	290	369	WP_059061894.1 transcription-repair coupling factor [Candidatus Protochlamydia naegleriophila]	diamond	240	112	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
31472704	31472704	PRJNA682078_P_NODE_199056_length_263_cov_2.300000_g197279_i0	PRJNA682078	199056	263	2.3	6.049	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	58.2	3.3e-8	NR	HEV8051030.1	2052176	g197279	i0	67.6	0.422053231939163	37	12	42.2	0	153	263	3	39	HEV8051030.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	111	58.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32232040	32232040	PRJNA682078_P_NODE_165618_length_283_cov_1.857143_g163841_i0	PRJNA682078	165618	283	1.857143	5.25571469	Chlamydiota bacterium	2081524	Bacteria	Bacteria	54.3	5.17e-6	NR	MEM1283013.1	2081524	g163841	i0	28.6	3.8904593639576	98	63	99.6	2	1	282	143	237	MEM1283013.1 6-hydroxymethylpterin diphosphokinase MptE-like protein [Chlamydiota bacterium]	diamond	1101	54.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;