metadata: contig_metadata: 15 rows where bioproject = "PRJNA1059246", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA1059246", 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
1451684	1451684	PRJNA1059246_P_NODE_3722_length_1290_cov_3.761709_g3379_i0	PRJNA1059246	3722	1290	3.761709	48.5260461	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	406	3.3199999999999996e-133	NR	HSX03888.1	2047756	g3379	i0	48.5	0.988372093023256	425	199	96	9	1286	48	203	619	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	1275	406	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
4839522	4839522	PRJNA1059246_P_NODE_47064_length_302_cov_1.794760_g46438_i0	PRJNA1059246	47064	302	1.79476	5.4201752	Candidatus Protochlamydia	282132	Bacteria	Bacteria	436	6.64e-118	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g46438	i0	92.715	164.327814569536	302	22	100	0	1	302	1250189	1249888	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	49627	436	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
7389112	7389112	PRJNA1059246_P_NODE_16426_length_573_cov_1.552000_g15816_i0	PRJNA1059246	16426	573	1.552	8.89296	Candidatus Protochlamydia	282132	Bacteria	Bacteria	863	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g15816	i0	93.902	108.820244328098	574	31	100	4	1	573	1252830	1253400	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	62354	863	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
10380655	10380655	PRJNA1059246_P_NODE_63629_length_249_cov_1.312500_g63003_i0	PRJNA1059246	63629	249	1.3125	3.268125	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	394	3.25e-105	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g63003	i0	95.2	149.718875502008	250	11	100	1	1	249	654664	654913	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	37280	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
26623770	26623770	PRJNA1059246_P_NODE_35341_length_363_cov_1.296552_g34715_i0	PRJNA1059246	35341	363	1.296552	4.70648376	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	70.5	2.35e-11	NR	MFI0434572.1	2052176	g34715	i0	36.7	0.991735537190083	120	61	99.2	1	4	363	63	167	MFI0434572.1 SET domain-containing protein-lysine N-methyltransferase [Parachlamydiaceae bacterium]	diamond	360	70.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28109173	28109173	PRJNA1059246_P_NODE_53125_length_279_cov_2.606796_g52499_i0	PRJNA1059246	53125	279	2.606796	7.27296084	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.4	0.00288	NR	NGX38307.1	2081524	g52499	i0	36.7	0.645161290322581	60	35	64.5	2	229	50	48	104	NGX38307.1 hypothetical protein [Chlamydiota bacterium]	diamond	180	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28488260	28488260	PRJNA1059246_P_NODE_46787_length_304_cov_1.000000_g46161_i0	PRJNA1059246	46787	304	1	3.04	Candidatus Protochlamydia sp. W-9	1785087	Bacteria	Bacteria	51.2	8.44e-5	NR	WP_075882663.1	1785087	g46161	i0	32.7	1.93421052631579	98	61	91.8	2	303	25	1022	1119	WP_075882663.1 F-box protein [Candidatus Protochlamydia sp. W-9]	diamond	588	51.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
29245953	29245953	PRJNA1059246_P_NODE_44409_length_315_cov_0.954545_g43783_i0	PRJNA1059246	44409	315	0.954545	3.00681675	Chlamydiota bacterium	2081524	Bacteria	Bacteria	48.1	0.00113	NR	NGX59353.1	2081524	g43783	i0	42.2	0.428571428571429	45	26	42.9	0	313	179	1375	1419	NGX59353.1 Photosystem I assembly protein Ycf3 [Chlamydiota bacterium]	diamond	135	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29964113	29964113	PRJNA1059246_P_NODE_25731_length_439_cov_1.683060_g25106_i0	PRJNA1059246	25731	439	1.68306	7.3886334	PVC group	1783257	Bacteria	Bacteria	60.8	1.26e-7	NR	MFI0434572.1	2052176	g25106	i0	50	0.854214123006834	60	26	40.3	2	1	177	318	374	MFI0434572.1 SET domain-containing protein-lysine N-methyltransferase [Parachlamydiaceae bacterium]	diamond	375	61.2	0.993464052287582	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30035511	30035511	PRJNA1059246_P_NODE_64831_length_248_cov_0.880000_g64205_i0	PRJNA1059246	64831	248	0.88	2.1824	Chlamydiales bacterium	2047757	Bacteria	Bacteria	92	1.25e-19	NR	MCP5469077.1	2047757	g64205	i0	66.2	0.858870967741935	71	24	85.9	0	213	1	58	128	MCP5469077.1 asparagine--tRNA ligase [Chlamydiales bacterium]	diamond	213	92	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31172494	31172494	PRJNA1059246_P_NODE_31975_length_385_cov_1.131410_g31349_i0	PRJNA1059246	31975	385	1.13141	4.3559285	Chlamydiota bacterium	2081524	Bacteria	Bacteria	115	5.5100000000000005e-27	NR	NGX43128.1	2081524	g31349	i0	45.7	1.00519480519481	129	69	99.7	1	1	384	117	245	NGX43128.1 Sodium-dependent dicarboxylate transporter SdcS [Chlamydiota bacterium]	diamond	387	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31868572	31868572	PRJNA1059246_P_NODE_72497_length_241_cov_0.916667_g71871_i0	PRJNA1059246	72497	241	0.916667	2.20916747	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	42.7	0.0358	NR	QVL54739.1	2698248	g71871	i0	38	0.983402489626556	79	41	92.1	2	224	3	614	689	QVL54739.1 MAG: LTA synthase family protein [Simkaniaceae bacterium]	diamond	237	42.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
32343553	32343553	PRJNA1059246_P_NODE_58479_length_262_cov_1.222222_g57853_i0	PRJNA1059246	58479	262	1.222222	3.20222164	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	99	7.780000000000001e-22	NR	HSX03888.1	2047756	g57853	i0	51.9	0.927480916030534	81	37	90.5	1	4	240	53	133	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	243	99	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32848098	32848098	PRJNA1059246_P_NODE_40160_length_336_cov_0.973384_g39534_i0	PRJNA1059246	40160	336	0.973384	3.27057024	Candidatus Neptunochlamydia vexilliferae	1651774	Bacteria	Bacteria	154	2e-43	NR	WP_320412044.1	1651774	g39534	i0	64	0.991071428571429	111	40	99.1	0	335	3	182	292	WP_320412044.1 transaldolase [Candidatus Neptunochlamydia vexilliferae]	diamond	333	154	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia vexilliferae
32871472	32871472	PRJNA1059246_P_NODE_16400_length_573_cov_3.386000_g15790_i0	PRJNA1059246	16400	573	3.386	19.40178	PVC group	1783257	Bacteria	Bacteria	174	6.22e-47	NR	MCB1181537.1	2052156	g15790	i0	58.6	8.23560209424084	145	60	75.9	0	569	135	650	794	MCB1181537.1 phosphoketolase family protein [Chlamydiia bacterium]	diamond	4719	175	0.994285714285714	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia 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);;