metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
1666484	1666484	PRJNA340009_P_NODE_14922_length_306_cov_6.147860_g14615_i0	PRJNA340009	14922	306	6.14786	18.8124516	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	305	1.98e-78	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g14615	i0	84.641	2	306	47	100	0	1	306	1768646	1768341	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	612	305	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
4219247	4219247	PRJNA340009_P_NODE_23984_length_250_cov_1.124378_g23677_i0	PRJNA340009	23984	250	1.124378	2.810945	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	283	7.379999999999999e-72	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g23677	i0	89.686	100.476	223	21	89	2	23	245	174518	174298	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	25119	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
4219374	4219374	PRJNA340009_P_NODE_34704_length_213_cov_7.207317_g34397_i0	PRJNA340009	34704	213	7.207317	15.35158521	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	204	4.8899999999999997e-48	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g34397	i0	83.962	1.99530516431925	212	34	99	0	1	212	36426	36215	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	425	204	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
8045173	8045173	PRJNA340009_P_NODE_20227_length_268_cov_13.178082_g19920_i0	PRJNA340009	20227	268	13.178082	35.31725976	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	311	3.6699999999999996e-80	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g19920	i0	87.879	0.985074626865672	264	32	99	0	4	267	826213	825950	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	264	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
10595697	10595697	PRJNA340009_P_NODE_21289_length_263_cov_1.411215_g20982_i0	PRJNA340009	21289	263	1.411215	3.71149545	Simkania negevensis	83561	Bacteria	Bacteria	147	1.07e-30	NTclustered	gi\|357575874\|gb\|HQ684732.1\|	83561	g20982	i0	84.768	12.4296577946768	151	17	57	5	115	263	765	619	Simkania negevensis strain FH07_54_6 23S ribosomal RNA gene, partial sequence	blastn	3269	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
13145790	13145790	PRJNA340009_P_NODE_39191_length_203_cov_1.402597_g38884_i0	PRJNA340009	39191	203	1.402597	2.84727191	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	320	4.39e-83	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g38884	i0	95.074	175.758620689655	203	10	100	0	1	203	1020311	1020109	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	35679	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
19518036	19518036	PRJNA340009_P_NODE_4336_length_508_cov_3.738562_g4034_i0	PRJNA340009	4336	508	3.738562	18.99189496	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	472	3.22e-128	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g4034	i0	83.821	2.01771653543307	513	65	99	11	4	504	924226	923720	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	1025	472	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
20793369	20793369	PRJNA340009_P_NODE_21857_length_260_cov_1.450237_g21550_i0	PRJNA340009	21857	260	1.450237	3.7706162	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	285	2.15e-72	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g21550	i0	86.538	1.99615384615385	260	33	99	2	2	260	1768369	1768111	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	519	285	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
22068297	22068297	PRJNA340009_P_NODE_12478_length_330_cov_3.765125_g12171_i0	PRJNA340009	12478	330	3.765125	12.4249125	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	383	9.699999999999998e-102	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g12171	i0	88.438	0.96969696969697	320	34	97	3	12	330	309724	309407	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	320	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
22068305	22068305	PRJNA340009_P_NODE_12998_length_325_cov_1.278986_g12691_i0	PRJNA340009	12998	325	1.278986	4.1567045	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	243	1.69e-59	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g12691	i0	81.126	2.91692307692308	302	57	93	0	18	319	1665496	1665195	Parachlamydia acanthamoebae UV-7, complete genome	blastn	948	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
23343880	23343880	PRJNA340009_P_NODE_19399_length_273_cov_5.343750_g19092_i0	PRJNA340009	19399	273	5.34375	14.5884375	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	322	1.73e-83	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g19092	i0	88.278	2.02197802197802	273	27	99	4	3	273	303384	303653	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	552	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis

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