metadata: contig_metadata: 13 rows where bioproject = "PRJEB66218", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJEB66218", 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
994102	994102	PRJEB66218_P_NODE_116541_length_279_cov_5.110092_g114112_i0	PRJEB66218	116541	279	5.110092	14.25715668	Parachlamydiales	1963360	Bacteria	Bacteria	433	7.85e-117	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g114112	i0	95.238	131.885304659498	273	13	98	0	1	273	1018269	1017997	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	36796	433	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
3544837	3544837	PRJEB66218_P_NODE_157783_length_236_cov_1.114286_g155353_i0	PRJEB66218	157783	236	1.114286	2.62971496	Candidatus Protochlamydia	282132	Bacteria	Bacteria	364	2.39e-96	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g155353	i0	94.492	125.313559322034	236	13	100	0	1	236	1250039	1249804	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	29574	364	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
7783446	7783446	PRJEB66218_P_NODE_135627_length_255_cov_3.252577_g133198_i0	PRJEB66218	135627	255	3.252577	8.29407135	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	222	1.67e-53	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g133198	i0	82.625	166.501960784314	259	38	100	7	1	255	2060004	2060259	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	42458	222	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10335675	10335675	PRJEB66218_P_NODE_22749_length_806_cov_2.785235_g20595_i0	PRJEB66218	22749	806	2.785235	22.4489941	Pseudomonadati	3379134	Bacteria	Bacteria	321	2.3299999999999997e-106	NR	OGN65139.1	1797605	g20595	i0	62.7	9.01861042183623	268	97	99.8	2	804	1	34	298	OGN65139.1 MAG: transaldolase [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9]	diamond	7269	323	0.993808049535604	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9
12472939	12472939	PRJEB66218_P_NODE_104310_length_299_cov_1.088235_g101881_i0	PRJEB66218	104310	299	1.088235	3.25382265	Candidatus Protochlamydia	282132	Bacteria	Bacteria	457	5.039999999999999e-124	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g101881	i0	94.295	171.531772575251	298	17	99	0	2	299	1250355	1250652	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	51288	457	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
15022230	15022230	PRJEB66218_P_NODE_163392_length_232_cov_1.140351_g160962_i0	PRJEB66218	163392	232	1.140351	2.64561432	Pseudomonadati	3379134	Bacteria	Bacteria	340	3.95e-89	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g160962	i0	93.162	164.396551724138	234	13	100	3	1	232	174167	173935	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	38140	342	0.994152046783626	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17982959	17982959	PRJEB66218_P_NODE_148955_length_242_cov_1.790055_g146526_i0	PRJEB66218	148955	242	1.790055	4.3319331	Chlamydiota bacterium	2081524	Bacteria	Bacteria	111	1.9400000000000003e-27	NR	NDD59003.1	2081524	g146526	i0	72.2	3.95454545454545	79	21	97.9	1	4	240	141	218	NDD59003.1 2-aminoethylphosphonate--pyruvate transaminase [Chlamydiota bacterium]	diamond	957	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
20531645	20531645	PRJEB66218_P_NODE_118417_length_277_cov_1.356481_g115988_i0	PRJEB66218	118417	277	1.356481	3.75745237	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	396	1.02e-105	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g115988	i0	92.419	163.176895306859	277	21	100	0	1	277	175494	175770	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	45200	396	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
20533469	20533469	PRJEB66218_P_NODE_221957_length_206_cov_0.896552_g219527_i0	PRJEB66218	221957	206	0.896552	1.84689712	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	246	7.7e-61	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g219527	i0	88.945	7.79126213592233	199	22	97	0	8	206	2060015	2060213	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	1605	246	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
26812481	26812481	PRJEB66218_P_NODE_131421_length_260_cov_1.929648_g128992_i0	PRJEB66218	131421	260	1.929648	5.0170848	Waddliaceae bacterium	2026802	Bacteria	Bacteria	70.1	4.21e-13	NR	HEY4832334.1	2026802	g128992	i0	46.7	0.865384615384615	75	38	86.5	2	253	29	50	122	HEY4832334.1 uL14 family ribosomal protein [Waddliaceae bacterium]	diamond	225	70.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
27160171	27160171	PRJEB66218_P_NODE_196522_length_211_cov_1.733333_g194092_i0	PRJEB66218	196522	211	1.733333	3.65733263	Chlamydiales bacterium SCGC AB-751-O23	1871322	Bacteria	Bacteria	64.7	4.35e-10	NR	SCA58993.1	1871322	g194092	i0	57.7	0.739336492890995	52	22	73.9	0	164	9	1477	1528	SCA58993.1 hypothetical protein AB751O23_BT_00010, partial [Chlamydiales bacterium SCGC AB-751-O23]	diamond	156	64.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium SCGC AB-751-O23
27350316	27350316	PRJEB66218_P_NODE_133843_length_257_cov_3.204082_g131414_i0	PRJEB66218	133843	257	3.204082	8.23449074	Chlamydiales bacterium	2047757	Bacteria	Bacteria	86.7	2.83e-19	NR	MCP5470420.1	2047757	g131414	i0	51.9	0.898832684824903	77	37	89.9	0	254	24	1	77	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	231	86.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29497228	29497228	PRJEB66218_P_NODE_8310_length_1552_cov_3.796781_g7072_i0	PRJEB66218	8310	1552	3.796781	58.92604112	Chlamydiota bacterium	2081524	Bacteria	Bacteria	157	1.5499999999999996e-40	NR	MES2273166.1	2081524	g7072	i0	37.5	1.0360824742268	269	132	51.6	8	932	132	18	252	MES2273166.1 DUF268 domain-containing protein [Chlamydiota bacterium]	diamond	1608	157	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);;