metadata: contig_metadata: 11 rows where bioproject = "PRJNA1005695", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA1005695", 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
1428202	1428202	PRJNA1005695_P_NODE_20522_length_333_cov_1.496154_g19670_i0	PRJNA1005695	20522	333	1.496154	4.98219282	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	544	4.25e-150	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g19670	i0	96.108	120.141141141141	334	12	100	1	1	333	1249990	1249657	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	40007	544	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
1428444	1428444	PRJNA1005695_P_NODE_802_length_1713_cov_3.975610_g540_i0	PRJNA1005695	802	1713	3.97561	68.1021993	Chlamydiales bacterium BSEPT1	3097555	Bacteria	Bacteria	830	0	NTclustered	gi\|2783367630\|emb\|OZ156466.1\|	3097555	g540	i0	82.401	122.981903093987	983	144	86	24	734	1703	1421479	1420513	Chlamydiales bacterium BSEPT1 isolate 488b1680-3485-4b59-b0c6-665df4973624 genome assembly, chromosome: 1	blastn	210668	830	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium BSEPT1
1428459	1428459	PRJNA1005695_P_NODE_9602_length_502_cov_1.757576_g8751_i0	PRJNA1005695	9602	502	1.757576	8.82303152	Neochlamydia sp. Trut23-12-2015_Venoge-Embouchure	1771895	Bacteria	Bacteria	774	0	NTclustered	gi\|985700640\|emb\|LN995859.1\|	1771895	g8751	i0	95.112	111.745019920319	491	24	98	0	1	491	60	550	Neochlamydia sp. Trut23-12-2015_Venoge-Embouchure partial 16S rRNA gene, clone Trut23-12-2015_Venoge-Embouchure	blastn	56096	774	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. Trut23-12-2015_Venoge-Embouchure
9929143	9929143	PRJNA1005695_P_NODE_33068_length_259_cov_1.677419_g32216_i0	PRJNA1005695	33068	259	1.677419	4.34451521	Parachlamydia	83551	Bacteria	Bacteria	267	7.739999999999999e-67	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g32216	i0	85.441	22.1312741312741	261	33	100	5	1	259	1653	1396	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	5732	267	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
18005281	18005281	PRJNA1005695_P_NODE_28675_length_279_cov_1.893204_g27823_i0	PRJNA1005695	28675	279	1.893204	5.28203916	Candidatus Piscichlamydia salmonis	263190	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|985700636\|emb\|LN995855.1\|	263190	g27823	i0	100	99.1792114695341	279	0	100	0	1	279	1405	1127	Candidatus Piscichlamydia salmonis partial 16S rRNA gene, clone Trut1-48-2014_Fish_Farm_Eclepens	blastn	27671	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia salmonis
21830255	21830255	PRJNA1005695_P_NODE_20978_length_329_cov_1.214844_g20126_i0	PRJNA1005695	20978	329	1.214844	3.99683676	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	494	4.2799999999999996e-135	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g20126	i0	93.656	23.6504559270517	331	19	100	1	1	329	627724	627394	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	7781	494	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
21830373	21830373	PRJNA1005695_P_NODE_35338_length_251_cov_2.516854_g34486_i0	PRJNA1005695	35338	251	2.516854	6.31730354	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	418	1.9499999999999994e-112	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g34486	i0	96.813	155.434262948207	251	7	100	1	1	251	652791	652542	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	39014	418	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21830417	21830417	PRJNA1005695_P_NODE_38958_length_244_cov_1.152047_g38106_i0	PRJNA1005695	38958	244	1.152047	2.81099468	Candidatus Fritschea bemisiae	206681	Bacteria	Bacteria	344	3.2399999999999993e-90	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g38106	i0	93.506	147.25	231	15	95	0	14	244	9254	9484	Candidatus Fritschea bemisiae strain Falk YaeL (yaeL) gene, partial cds; putative glycosylhydrolase and putative transposase genes, complete cds; 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence; putative endonuclease gene, complete cds; 5S ribosomal RNA gene, complete sequence; argynyl tRNA synthetase (argS), YjeE (yjeE), probable GTP-binding protein, DNA polymerase III epsilon subunit, and phosphoglycerate kinase (pgk) genes, complete cds; and unknown gene	blastn	35929	344	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
23105646	23105646	PRJNA1005695_P_NODE_14599_length_399_cov_2.058282_g13747_i0	PRJNA1005695	14599	399	2.058282	8.21254518	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	628	1.3899999999999998e-175	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g13747	i0	95.025	106.117794486216	402	16	100	3	1	399	175648	176048	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	42341	628	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
27319103	27319103	PRJNA1005695_P_NODE_29963_length_272_cov_4.994975_g29111_i0	PRJNA1005695	29963	272	4.994975	13.586332	Candidatus Anoxychlamydiales bacterium	2705072	Bacteria	Bacteria	43.1	0.0376	NR	NGX48595.1	2705072	g29111	i0	32.3	0.716911764705882	65	44	71.7	0	260	66	123	187	NGX48595.1 hypothetical protein [Candidatus Anoxychlamydiales bacterium]	diamond	195	43.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Candidatus Anoxychlamydiales			Candidatus Anoxychlamydiales bacterium
32564109	32564109	PRJNA1005695_P_NODE_40099_length_242_cov_0.923077_g39247_i0	PRJNA1005695	40099	242	0.923077	2.23384634	Chlamydiota bacterium	2081524	Bacteria	Bacteria	55.5	1.23e-6	NR	MCX6988744.1	2081524	g39247	i0	41.7	1.04132231404959	84	40	93	2	5	229	767	850	MCX6988744.1 protein translocase subunit SecD [Chlamydiota bacterium]	diamond	252	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;