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

11 rows where bioproject = "PRJEB29441", 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
26162	26162	PRJEB29441_P_NODE_10601_length_346_cov_1.713805_g10160_i0	PRJEB29441	10601	346	1.713805	5.9297653	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	449	9.94e-122	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g10160	i0	90.173	107.878612716763	346	32	100	2	1	346	2621538	2621881	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	37326	449	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
988337	988337	PRJEB29441_P_NODE_37521_length_170_cov_1.371901_g37080_i0	PRJEB29441	37521	170	1.371901	2.3322317	Candidatus Protochlamydia	282132	Bacteria	Bacteria	259	7.8e-65	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g37080	i0	94.152	50.5	171	9	100	1	1	170	1250027	1250197	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	8585	259	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
1300903	1300903	PRJEB29441_P_NODE_35402_length_175_cov_2.428571_g34961_i0	PRJEB29441	35402	175	2.428571	4.24999925	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	226	8.209999999999999e-55	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g34961	i0	90.588	1.96571428571429	170	16	97	0	1	170	2625034	2624865	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	344	226	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
2576442	2576442	PRJEB29441_P_NODE_30363_length_190_cov_1.397163_g29922_i0	PRJEB29441	30363	190	1.397163	2.6546097	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	263	6.93e-66	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g29922	i0	91.667	132.768421052632	192	12	100	3	1	190	1249825	1249636	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	25226	263	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
3853027	3853027	PRJEB29441_P_NODE_6864_length_447_cov_2.165829_g6425_i0	PRJEB29441	6864	447	2.165829	9.68125563	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	516	1.28e-141	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g6425	i0	87.611	59.2885906040268	452	46	100	7	1	447	2625486	2625040	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	26502	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
7679046	7679046	PRJEB29441_P_NODE_4547_length_566_cov_4.032882_g4128_i0	PRJEB29441	4547	566	4.032882	22.82611212	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	898	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4128	i0	95.707	104.249116607774	559	22	99	2	1	558	1262844	1262287	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	59005	898	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8953545	8953545	PRJEB29441_P_NODE_30388_length_190_cov_1.255319_g29947_i0	PRJEB29441	30388	190	1.255319	2.3851061	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	217	5.469999999999999e-52	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g29947	i0	88.889	109.131578947368	180	15	98	5	1	178	654886	655062	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	20735	217	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11504350	11504350	PRJEB29441_P_NODE_14570_length_286_cov_4.021097_g14129_i0	PRJEB29441	14570	286	4.021097	11.50033742	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	497	2.82e-136	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g14129	i0	98.239	199.702797202797	284	5	99	0	3	286	1251458	1251175	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	57115	497	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17878499	17878499	PRJEB29441_P_NODE_675_length_1459_cov_3.644681_g557_i0	PRJEB29441	675	1459	3.644681	53.17589579	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	2638	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g557	i0	99.315	119.493488690884	1459	9	100	1	1	1459	1249618	1251075	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	174341	2638	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19152275	19152275	PRJEB29441_P_NODE_43356_length_164_cov_0.886957_g42915_i0	PRJEB29441	43356	164	0.886957	1.45460948	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	171	3.62e-38	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g42915	i0	87.248	0.908536585365854	149	19	91	0	2	150	2059962	2060110	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	149	171	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20427523	20427523	PRJEB29441_P_NODE_48637_length_152_cov_3.456311_g48196_i0	PRJEB29441	48637	152	3.456311	5.25359272	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	270	3.15e-68	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g48196	i0	98.684	296.690789473684	152	2	100	0	1	152	1249576	1249425	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	45097	270	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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