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

13 rows where bioproject = "PRJNA841653", 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
1230687	1230687	PRJNA841653_P_NODE_3201_length_976_cov_37.481728_g1802_i2	PRJNA841653	3201	976	37.481728	365.82166528	Candidatus Protochlamydia	282132	Bacteria	Bacteria	1467	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g1802	i2	93.776	185.394467213115	980	56	100	5	1	976	1250754	1249776	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	180945	1472	0.996603260869565	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
3380926	3380926	PRJNA841653_P_NODE_16043_length_409_cov_3.845238_g15371_i0	PRJNA841653	16043	409	3.845238	15.72702342	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	449	1.1899999999999998e-121	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g15371	i0	87.065	183.61369193154	402	47	98	5	2	400	2061044	2060645	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	75098	449	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11033836	11033836	PRJNA841653_P_NODE_15989_length_410_cov_2.477745_g15317_i0	PRJNA841653	15989	410	2.477745	10.1587545	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	540	6.8899999999999996e-149	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g15317	i0	91.969	163.1	386	29	99	2	26	410	1250849	1250465	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	66871	540	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
12710328	12710328	PRJNA841653_P_NODE_2990_length_1014_cov_35.274176_g1802_i1	PRJNA841653	2990	1014	35.274176	357.68014464	Candidatus Protochlamydia	282132	Bacteria	Bacteria	1537	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g1802	i1	94.002	169.760355029586	1017	58	100	3	1	1014	1249738	1250754	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	172137	1537	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
19956697	19956697	PRJNA841653_P_NODE_23856_length_333_cov_2.680769_g23182_i0	PRJNA841653	23856	333	2.680769	8.92696077	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	359	1.6499999999999998e-94	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g23182	i0	87.227	110.60960960961	321	33	95	8	1	316	1250232	1250549	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	36833	359	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19957488	19957488	PRJNA841653_P_NODE_7956_length_599_cov_4.680608_g7298_i0	PRJNA841653	7956	599	4.680608	28.03684192	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	667	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g7298	i0	92.034	138.874791318865	477	34	79	4	1	474	654515	654990	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	83186	667	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21632592	21632592	PRJNA841653_P_NODE_21877_length_348_cov_3.196364_g21203_i0	PRJNA841653	21877	348	3.196364	11.12334672	Candidatus Protochlamydia	282132	Bacteria	Bacteria	527	4.489999999999998e-145	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g21203	i0	94.461	175.42816091954	343	17	98	2	7	348	1249474	1249133	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	61049	532	0.990601503759398	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
23782934	23782934	PRJNA841653_P_NODE_4119_length_852_cov_5.000000_g1494_i1	PRJNA841653	4119	852	5	42.6	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1018	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1494	i1	88.538	114.772300469484	855	79	99	18	1	844	2059382	2058536	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	97786	1018	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
25056164	25056164	PRJNA841653_P_NODE_10640_length_512_cov_20.011390_g9973_i0	PRJNA841653	10640	512	20.01139	102.4583168	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	475	2.5099999999999998e-129	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g9973	i0	83.721	175.693359375	516	70	99	14	1	506	654891	655402	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	89955	475	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27560046	27560046	PRJNA841653_P_NODE_39604_length_262_cov_1.529101_g38930_i0	PRJNA841653	39604	262	1.529101	4.00624462	Chlamydiales bacterium	2047757	Bacteria	Bacteria	63.2	2.17e-9	NR	MCE5293881.1	2047757	g38930	i0	57.6	0.973282442748092	85	30	97.3	2	8	262	125	203	MCE5293881.1 hypothetical protein [Chlamydiales bacterium]	diamond	255	63.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29620531	29620531	PRJNA841653_P_NODE_58190_length_243_cov_0.905882_g57516_i0	PRJNA841653	58190	243	0.905882	2.20129326	Candidatus Protochlamydia	282132	Bacteria	Bacteria	111	5.23e-27	NR	WP_059059816.1	389348	g57516	i0	71.3	2.96296296296296	80	23	98.8	0	242	3	117	196	WP_059059816.1 mechanosensitive ion channel family protein [Candidatus Protochlamydia naegleriophila]	diamond	720	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
30212507	30212507	PRJNA841653_P_NODE_26672_length_316_cov_0.930041_g25998_i0	PRJNA841653	26672	316	0.930041	2.93892956	Chlamydiales bacterium	2047757	Bacteria	Bacteria	116	1.3e-28	NR	MFI5342588.1	2047757	g25998	i0	50	1.72784810126582	90	43	83.5	1	48	311	219	308	MFI5342588.1 hypothetical protein [Chlamydiales bacterium]	diamond	546	116	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31508574	31508574	PRJNA841653_P_NODE_49076_length_248_cov_0.880000_g48402_i0	PRJNA841653	49076	248	0.88	2.1824	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	57.8	2.07e-7	NR	MFA6917102.1	2052178	g48402	i0	40.3	1.93548387096774	77	41	89.5	2	225	4	3497	3571	MFA6917102.1 DUF3638 domain-containing protein [Parachlamydiales bacterium]	diamond	480	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales 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);;