metadata: contig_metadata: 8 rows where bioproject = "PRJNA1174207", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA1174207", 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
5418497	5418497	PRJNA1174207_P_NODE_16705_length_350_cov_2.747292_g16176_i0	PRJNA1174207	16705	350	2.747292	9.615522	Rhabdochlamydiaceae bacterium cvE99	1009364	Bacteria	Bacteria	584	2.639999999999999e-162	NTclustered	gi\|330375205\|gb\|JF513057.1\|	1009364	g16176	i0	97.923	103.757142857143	337	7	96	0	14	350	2	338	Rhabdochlamydiaceae bacterium cvE99 16S ribosomal RNA gene, partial sequence	blastn	36315	584	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium cvE99
9243194	9243194	PRJNA1174207_P_NODE_10068_length_482_cov_2.114914_g9542_i0	PRJNA1174207	10068	482	2.114914	10.19388548	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	532	1.38e-146	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g9542	i0	86.68	102.265560165975	488	55	100	9	1	482	174843	175326	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	49292	532	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
10519350	10519350	PRJNA1174207_P_NODE_33089_length_251_cov_3.140449_g32560_i0	PRJNA1174207	33089	251	3.140449	7.88252699	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g32560	i0	91.235	120.03187250996	251	22	100	0	1	251	414073	414323	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	30128	342	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
15068217	15068217	PRJNA1174207_P_NODE_22532_length_299_cov_2.044248_g22003_i0	PRJNA1174207	22532	299	2.044248	6.11230152	Candidatus Protochlamydia	282132	Bacteria	Bacteria	370	6.76e-98	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g22003	i0	90.942	80.0836120401338	276	24	92	1	1	275	1250324	1250599	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	23945	372	0.99462365591397806	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
15068351	15068351	PRJNA1174207_P_NODE_31692_length_257_cov_2.739130_g31163_i0	PRJNA1174207	31692	257	2.73913	7.0395641	Bacteria	2	Bacteria	Bacteria	364	2.6399999999999993e-96	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g31163	i0	92.218	174.501945525292	257	20	100	0	1	257	175593	175849	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	44847	364	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
23268213	23268213	PRJNA1174207_P_NODE_9379_length_503_cov_4.734884_g8853_i0	PRJNA1174207	9379	503	4.734884	23.81646652	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	531	5.18e-146	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g8853	i0	86.051	130.604373757455	509	53	99	18	2	499	2058547	2059048	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	65694	531	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
30261935	30261935	PRJNA1174207_P_NODE_35332_length_249_cov_0.875000_g34803_i0	PRJNA1174207	35332	249	0.875	2.17875	Parachlamydia sp.	2052048	Bacteria	Bacteria	84.3	9.04e-17	NR	PJD96798.1	2052048	g34803	i0	51.2	1.01204819277108	84	37	98.8	2	2	247	544	625	PJD96798.1 MAG: general secretion pathway protein GspD [Parachlamydia sp.]	diamond	252	84.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
32177963	32177963	PRJNA1174207_P_NODE_33598_length_251_cov_0.865169_g33069_i0	PRJNA1174207	33598	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	110	1.83e-27	NR	HSX25597.1	2047757	g33069	i0	56.6	1.99601593625498	83	34	99.2	1	251	3	47	127	HSX25597.1 hypothetical protein [Chlamydiales bacterium]	diamond	501	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;