metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
4909329	4909329	PRJNA404067_P_NODE_28464_length_214_cov_3.758170_g28077_i0	PRJNA404067	28464	214	3.75817	8.0424838	Candidatus Protochlamydia	282132	Bacteria	Bacteria	351	1.66e-92	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g28077	i0	96.262	166.308411214953	214	8	100	0	1	214	1249306	1249093	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	35590	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
11893224	11893224	PRJNA404067_P_NODE_14150_length_276_cov_3.990698_g13763_i0	PRJNA404067	14150	276	3.990698	11.01432648	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	440	4.6399999999999984e-119	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13763	i0	95.62	108.090579710145	274	12	99	0	1	274	1249716	1249989	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	29833	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
13834863	13834863	PRJNA404067_P_NODE_29871_length_211_cov_5.113333_g29484_i0	PRJNA404067	29871	211	5.113333	10.78913263	Candidatus Protochlamydia	282132	Bacteria	Bacteria	233	6.169999999999999e-57	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g29484	i0	87.317	40.6303317535545	205	25	97	1	1	205	1249841	1250044	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	8573	233	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
14443358	14443358	PRJNA404067_P_NODE_14492_length_273_cov_1.061321_g14105_i0	PRJNA404067	14492	273	1.061321	2.89740633	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	313	1.04e-80	NTclustered	gi\|880804030\|gb\|KT258855.1\|	174324	g14105	i0	87.97	99.4945054945055	266	30	97	2	9	273	1	265	Uncultured Chlamydiales bacterium clone CL46D 16S ribosomal RNA gene, partial sequence	blastn	27162	313	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
15717106	15717106	PRJNA404067_P_NODE_14173_length_276_cov_1.939535_g13786_i0	PRJNA404067	14173	276	1.939535	5.3531166	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	322	1.75e-83	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g13786	i0	87.814	196.572463768116	279	29	100	4	1	276	1881584	1881860	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	54254	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
20816119	20816119	PRJNA404067_P_NODE_18917_length_240_cov_2.882682_g18530_i0	PRJNA404067	18917	240	2.882682	6.9184368	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	350	6.839999999999999e-92	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g18530	i0	93.249	171.620833333333	237	16	99	0	3	239	1251784	1252020	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	41189	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23366983	23366983	PRJNA404067_P_NODE_6759_length_467_cov_3.514778_g6382_i0	PRJNA404067	6759	467	3.514778	16.41401326	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	719	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g6382	i0	94.635	175.304068522484	466	21	99	4	1	463	1250098	1250562	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	81867	719	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24033072	24033072	PRJNA404067_P_NODE_28459_length_214_cov_4.686275_g28072_i0	PRJNA404067	28459	214	4.686275	10.0286285	Pseudomonadati	3379134	Bacteria	Bacteria	222	1.36e-53	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g28072	i0	91.875	47.5373831775701	160	11	100	2	56	214	176308	176150	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	10173	222	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae 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);;