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

8 rows where bioproject = "PRJNA546018", 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
10715304	10715304	PRJNA546018_S_NODE_46289_length_224_cov_2.361963_g45964_i0	PRJNA546018	46289	224	2.361963	5.29079712	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	115	2.5e-21	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g45964	i0	90.698	36.5357142857143	86	8	38	0	48	133	426547	426462	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	8184	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
13264916	13264916	PRJNA546018_S_NODE_39071_length_246_cov_6.264865_g38746_i0	PRJNA546018	39071	246	6.264865	15.4115679	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	237	5.72e-58	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g38746	i0	85.965	78.4105691056911	228	25	91	7	23	246	1334325	1334101	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	19289	237	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
15813976	15813976	PRJNA546018_S_NODE_47373_length_221_cov_1.825000_g47048_i0	PRJNA546018	47373	221	1.825	4.03325	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g47048	i0	100	74.4932126696833	221	0	100	0	1	221	646	866	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	16463	409	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
17088881	17088881	PRJNA546018_S_NODE_60294_length_190_cov_4.689922_g59969_i0	PRJNA546018	60294	190	4.689922	8.9108518	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	292	8.83e-75	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g59969	i0	100	14.0736842105263	158	0	83	0	30	187	381	538	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	2674	292	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
20912809	20912809	PRJNA546018_S_NODE_20297_length_359_cov_1.822148_g19972_i0	PRJNA546018	20297	359	1.822148	6.54151132	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	110	6.960000000000001e-29	NR	MFN4175223.1	2052176	g19972	i0	59	0.693593314763231	83	34	69.4	0	335	87	17	99	MFN4175223.1 lipase maturation factor family protein [Parachlamydiaceae bacterium]	diamond	249	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28499234	28499234	PRJNA546018_S_NODE_14927_length_430_cov_4.967480_g14602_i0	PRJNA546018	14927	430	4.96748	21.360164	Chlamydiia bacterium	2052156	Bacteria	Bacteria	83.2	2.19e-15	NR	MCB1084891.1	2052156	g14602	i0	55.4	1.03255813953488	74	24	51.6	1	196	417	667	731	MCB1084891.1 outer membrane protein assembly factor BamA [Chlamydiia bacterium]	diamond	444	83.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30267820	30267820	PRJNA546018_S_NODE_48372_length_218_cov_3.210191_g48047_i0	PRJNA546018	48372	218	3.210191	6.99821638	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	101	4.01e-23	NR	MFN4174447.1	2052176	g48047	i0	77.4	0.853211009174312	62	14	85.3	0	186	1	150	211	MFN4174447.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Parachlamydiaceae bacterium]	diamond	186	101	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31879401	31879401	PRJNA546018_S_NODE_24297_length_324_cov_2.387833_g23972_i0	PRJNA546018	24297	324	2.387833	7.73657892	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	64.3	7.87e-11	NR	MFN4174814.1	2052176	g23972	i0	53	0.611111111111111	66	30	61.1	1	207	10	1	65	MFN4174814.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	198	64.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;