metadata: contig_metadata: 10 rows where bioproject = "PRJEB36940", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJEB36940", 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
988976	988976	PRJEB36940_P_NODE_16181_length_237_cov_3.140244_g16052_i0	PRJEB36940	16181	237	3.140244	7.44237828	Parachlamydia	83551	Bacteria	Bacteria	311	3.18e-80	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g16052	i0	90.295	232.898734177215	237	23	100	0	1	237	2337	2101	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	55197	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
2606755	2606755	PRJEB36940_P_NODE_5423_length_367_cov_5.139456_g5294_i0	PRJEB36940	5423	367	5.139456	18.86180352	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	601	2.7599999999999993e-167	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g5294	i0	96.185	117.58038147139	367	14	100	0	1	367	654394	654028	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	43152	601	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
5159090	5159090	PRJEB36940_P_NODE_16225_length_235_cov_3.444444_g16096_i0	PRJEB36940	16225	235	3.444444	8.0944434	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	226	1.1699999999999999e-54	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g16096	i0	85.202	27.6936170212766	223	29	94	4	1	222	2060259	2060040	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	6508	226	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8983966	8983966	PRJEB36940_P_NODE_9548_length_282_cov_2.770335_g9419_i0	PRJEB36940	9548	282	2.770335	7.8123447	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	374	4.89e-99	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g9419	i0	90.592	108.478723404255	287	20	100	6	1	282	655318	655034	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	30591	374	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19182259	19182259	PRJEB36940_P_NODE_3016_length_488_cov_4.563855_g2889_i0	PRJEB36940	3016	488	4.563855	22.2716124	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	686	0	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g2889	i0	92.708	106.622950819672	480	27	98	8	1	476	655	180	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	52032	686	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
23008761	23008761	PRJEB36940_P_NODE_12599_length_251_cov_1.820225_g12470_i0	PRJEB36940	12599	251	1.820225	4.56876475	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	414	2.52e-111	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g12470	i0	96.414	134.486055776892	251	9	100	0	1	251	652457	652707	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	33756	414	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27791587	27791587	PRJEB36940_P_NODE_6004_length_351_cov_1.115108_g5875_i0	PRJEB36940	6004	351	1.115108	3.91402908	Chlamydiales bacterium	2047757	Bacteria	Bacteria	125	1.73e-30	NR	MFT5318489.1	2047757	g5875	i0	60.2	1.76068376068376	103	39	88	1	311	3	1069	1169	MFT5318489.1 malate synthase [Chlamydiales bacterium]	diamond	618	125	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28139048	28139048	PRJEB36940_P_NODE_5045_length_380_cov_1.622150_g4916_i0	PRJEB36940	5045	380	1.62215	6.16417	Chlamydiota bacterium	2081524	Bacteria	Bacteria	92.8	1.17e-19	NR	MCX6987222.1	2081524	g4916	i0	65.4	0.615789473684211	78	24	61.6	1	145	378	2	76	MCX6987222.1 transaldolase [Chlamydiota bacterium]	diamond	234	92.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29086165	29086165	PRJEB36940_P_NODE_2768_length_508_cov_13.613793_g2641_i0	PRJEB36940	2768	508	13.613793	69.15806844	Chlamydiales bacterium	2047757	Bacteria	Bacteria	147	8.13e-42	NR	MCP5470421.1	2047757	g2641	i0	51.9	3.5255905511811	156	69	90.9	2	15	476	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1791	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32372996	32372996	PRJEB36940_P_NODE_13539_length_249_cov_0.875000_g13410_i0	PRJEB36940	13539	249	0.875	2.17875	Waddliaceae bacterium	2026802	Bacteria	Bacteria	110	1.5600000000000002e-26	NR	HEY4832801.1	2026802	g13410	i0	59.8	0.987951807228916	82	33	98.8	0	4	249	121	202	HEY4832801.1 Fe-S cluster assembly protein SufD [Waddliaceae bacterium]	diamond	246	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae 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);;