metadata: contig_metadata: 10 rows where bioproject = "PRJNA1144090" and tax

10 rows where bioproject = "PRJNA1144090" 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
26943876	26943876	PRJNA1144090_P_NODE_96262_length_255_cov_1.692308_g95727_i0	PRJNA1144090	96262	255	1.692308	4.3153854	Parachlamydia sp.	2052048	Bacteria	Bacteria	42.7	0.0411	NR	MCE5319048.1	2052048	g95727	i0	31.8	1	85	52	92.9	3	239	3	169	253	MCE5319048.1 SidE phosphodiesterase domain-containing protein [Parachlamydia sp.]	diamond	255	42.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
27122337	27122337	PRJNA1144090_P_NODE_17442_length_657_cov_3.856164_g16926_i0	PRJNA1144090	17442	657	3.856164	25.33499748	Bacteria	2	Bacteria	Bacteria	215	9.97e-63	NR	MBY0529696.1	2047756	g16926	i0	52	25.2146118721461	221	99	99.5	5	3	656	216	432	MBY0529696.1 phosphoenolpyruvate carboxykinase (GTP) [Rhabdochlamydiaceae bacterium]	diamond	16566	216	0.99537037037037	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28775730	28775730	PRJNA1144090_P_NODE_29647_length_484_cov_1.900243_g29113_i0	PRJNA1144090	29647	484	1.900243	9.19717612	Chlamydiales bacterium	2047757	Bacteria	Bacteria	65.5	4.07e-9	NR	HSX10637.1	2047757	g29113	i0	35.4	1.4504132231405	113	69	69.4	4	109	444	96	205	HSX10637.1 PP2C family serine/threonine-protein phosphatase [Chlamydiales bacterium]	diamond	702	65.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29123441	29123441	PRJNA1144090_P_NODE_56469_length_338_cov_1.743396_g55934_i0	PRJNA1144090	56469	338	1.743396	5.89267848	Chlamydia ibidis	1405396	Bacteria	Bacteria	58.9	2.39e-7	NR	WP_020370382.1	1405396	g55934	i0	42.6	2.23668639053254	68	27	60.4	2	214	11	451	506	WP_020370382.1 valine--tRNA ligase [Chlamydia ibidis]	diamond	756	58.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
30070402	30070402	PRJNA1144090_P_NODE_56212_length_339_cov_1.563910_g55677_i0	PRJNA1144090	56212	339	1.56391	5.3016549	Simkania sp.	34094	Bacteria	Bacteria	66.6	4.44e-10	NR	MBS3903898.1	34094	g55677	i0	51.7	0.513274336283186	58	28	51.3	0	143	316	298	355	MBS3903898.1 inorganic phosphate transporter [Simkania sp.]	diamond	174	66.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30355358	30355358	PRJNA1144090_P_NODE_42052_length_397_cov_1.938272_g41517_i0	PRJNA1144090	42052	397	1.938272	7.69493984	Waddliaceae bacterium	2026802	Bacteria	Bacteria	136	1.45e-36	NR	HEY4831165.1	2026802	g41517	i0	56.4	0.831234256926952	110	46	82.4	2	380	54	173	281	HEY4831165.1 Sir2 family NAD-dependent protein deacetylase [Waddliaceae bacterium]	diamond	330	136	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
30912691	30912691	PRJNA1144090_P_NODE_65914_length_312_cov_1.556485_g65379_i0	PRJNA1144090	65914	312	1.556485	4.8562332	Pseudomonadati	3379134	Bacteria	Bacteria	112	1.92e-26	NR	WP_068469007.1	1414722	g65379	i0	55.1	1.78846153846154	98	42	94.2	1	2	295	440	535	WP_068469007.1 ADP-ribosylhydrolase MavL family protein [Candidatus Protochlamydia phocaeensis]	diamond	558	113	0.991150442477876	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
30923760	30923760	PRJNA1144090_P_NODE_117674_length_237_cov_3.750000_g117139_i0	PRJNA1144090	117674	237	3.75	8.8875	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	80.5	2.63e-16	NR	MBP7075124.1	2047756	g117139	i0	53.9	0.962025316455696	76	34	96.2	1	4	231	134	208	MBP7075124.1 NAD(P)-dependent alcohol dehydrogenase [Rhabdochlamydiaceae bacterium]	diamond	228	80.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31576534	31576534	PRJNA1144090_P_NODE_40816_length_403_cov_3.936364_g40281_i0	PRJNA1144090	40816	403	3.936364	15.86354692	root	1	Root_unresolved	Root_unresolved	103	2.3299999999999994e-23	NR	MCC6127664.1	2081524	g40281	i0	48.5	3.75930521091811	101	40	66.3	1	271	5	13	113	MCC6127664.1 class I SAM-dependent methyltransferase [Chlamydiota bacterium]	diamond	1515	104	0.990384615384615	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32220244	32220244	PRJNA1144090_P_NODE_37498_length_423_cov_2.060000_g36963_i0	PRJNA1144090	37498	423	2.06	8.7138	Chlamydiales bacterium	2047757	Bacteria	Bacteria	44.7	0.0459	NR	MDF2578104.1	2047757	g36963	i0	50	0.297872340425532	42	21	29.8	0	6	131	255	296	MDF2578104.1 ankyrin-2 [Chlamydiales bacterium]	diamond	126	44.7	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);;