metadata: contig_metadata: 7 rows where bioproject = "PRJNA1253698", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA1253698", 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
359580	359580	PRJNA1253698_S_NODE_3241_length_388_cov_2.097345_g2876_i0	PRJNA1253698	3241	388	2.097345	8.1376986	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	438	2.429999999999999e-118	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2876	i0	88.714	78.4072164948454	381	13	98	15	7	386	1250514	1250163	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	30422	438	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
3603164	3603164	PRJNA1253698_S_NODE_11943_length_201_cov_1.539474_g11577_i0	PRJNA1253698	11943	201	1.539474	3.09434274	Parachlamydia	83551	Bacteria	Bacteria	311	2.61e-80	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g11577	i0	94.949	114.248756218905	198	10	99	0	1	198	1106	909	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	22964	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
9287890	9287890	PRJNA1253698_S_NODE_4448_length_330_cov_1.217082_g4082_i0	PRJNA1253698	4448	330	1.217082	4.0163706	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	453	7.29e-123	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g4082	i0	91.541	138.981818181818	331	24	99	4	1	329	2061045	2060717	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	45864	453	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11838277	11838277	PRJNA1253698_S_NODE_17110_length_172_cov_1.186992_g16744_i0	PRJNA1253698	17110	172	1.186992	2.04162624	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	283	4.700000000000002e-72	NTclustered	gi\|880804243\|gb\|KT262987.1\|	174324	g16744	i0	97.024	91.5174418604651	168	5	98	0	2	169	168	1	Uncultured Chlamydiales bacterium clone SW2A 16S ribosomal RNA gene, partial sequence	blastn	15741	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
15662553	15662553	PRJNA1253698_S_NODE_18313_length_168_cov_1.949580_g17947_i0	PRJNA1253698	18313	168	1.94958	3.2752944	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	272	9.95e-69	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g17947	i0	100	97.5952380952381	147	0	88	0	1	147	279	425	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	16396	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
19485740	19485740	PRJNA1253698_S_NODE_9716_length_221_cov_1.087209_g9350_i0	PRJNA1253698	9716	221	1.087209	2.40273189	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	298	2.28e-76	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g9350	i0	90.991	108.995475113122	222	18	100	2	1	221	2060160	2060380	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	24088	298	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20761213	20761213	PRJNA1253698_S_NODE_14757_length_183_cov_1.604478_g14391_i0	PRJNA1253698	14757	183	1.604478	2.93619474	Waddlia malaysiensis	219016	Bacteria	Bacteria	167	5.33e-37	NTclustered	gi\|27903501\|gb\|AY184804.1\|	219016	g14391	i0	83.616	135.415300546448	177	27	96	2	5	180	2073	2248	Waddlia sp. G817 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24781	167	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia malaysiensis

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