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

8 rows where analysis = "blastn", bioproject = "PRJNA493632" 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
463106	463106	PRJNA493632_P_NODE_392561_length_273_cov_68.235000_g389122_i0	PRJNA493632	392561	273	68.235	186.28155	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	394	3.61e-105	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g389122	i0	93.015	119.380952380952	272	15	99	3	5	273	2059960	2059690	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32591	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
1102448	1102448	PRJNA493632_P_NODE_407841_length_270_cov_2.989848_g404402_i0	PRJNA493632	407841	270	2.989848	8.0725896	Bacteria	2	Bacteria	Bacteria	394	3.57e-105	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g404402	i0	93.609	160.440740740741	266	14	98	3	1	264	652924	653188	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	43319	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
4292187	4292187	PRJNA493632_P_NODE_511904_length_251_cov_0.865169_g508465_i0	PRJNA493632	511904	251	0.865169	2.17157419	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	311	3.4e-80	NTclustered	gi\|206572563\|gb\|FJ160741.1\|	305355	g508465	i0	89.837	98.4262948207171	246	19	97	6	9	251	2	244	Uncultured Chlamydiae bacterium clone USC9 16S ribosomal RNA gene, partial sequence	blastn	24705	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
9394054	9394054	PRJNA493632_P_NODE_560728_length_247_cov_2.655172_g557289_i0	PRJNA493632	560728	247	2.655172	6.55827484	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g557289	i0	98.785	106.275303643725	247	3	100	0	1	247	21	267	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	26250	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
11946684	11946684	PRJNA493632_P_NODE_677250_length_235_cov_5.067901_g673809_i0	PRJNA493632	677250	235	5.067901	11.90956735	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g673809	i0	100	101.442553191489	235	0	100	0	1	235	1054	1288	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	23839	435	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
14493533	14493533	PRJNA493632_P_NODE_492232_length_253_cov_3.077778_g488793_i0	PRJNA493632	492232	253	3.077778	7.78677834	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	235	2.12e-57	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g488793	i0	83.399	36.9644268774704	253	42	100	0	1	253	790391	790643	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	9352	235	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17037070	17037070	PRJNA493632_P_NODE_215394_length_335_cov_1.125954_g211959_i0	PRJNA493632	215394	335	1.125954	3.7719459	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	383	9.86e-102	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g211959	i0	87.537	359.041791044776	337	35	99	7	1	333	904	571	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	120279	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
20864848	20864848	PRJNA493632_P_NODE_398297_length_272_cov_2.819095_g394858_i0	PRJNA493632	398297	272	2.819095	7.6679384	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	398	2.7799999999999997e-106	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g394858	i0	93.015	121.183823529412	272	19	100	0	1	272	654248	654519	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32962	398	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);;