metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA841653" 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

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