metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA494251" 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
14503804	14503804	PRJNA494251_P_NODE_10172_length_420_cov_1.069164_g9866_i0	PRJNA494251	10172	420	1.069164	4.4904888	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	127	4.12e-35	NR	HNA62975.1	2047756	g9866	i0	95.5	0.471428571428571	66	3	47.1	0	38	235	4	69	HNA62975.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	198	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
15777756	15777756	PRJNA494251_P_NODE_1633_length_925_cov_1.500000_g1415_i0	PRJNA494251	1633	925	1.5	13.875	Bacteria	2	Bacteria	Bacteria	482	6.849999999999999e-164	NR	MBA3815839.1	2052176	g1415	i0	74.8	57.6648648648649	306	70	99.2	2	2	919	187	485	MBA3815839.1 catalase [Parachlamydiaceae bacterium]	diamond	53340	482	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
18326728	18326728	PRJNA494251_P_NODE_12175_length_389_cov_2.813291_g11868_i0	PRJNA494251	12175	389	2.813291	10.94370199	Bacteria	2	Bacteria	Bacteria	228	4.37e-71	NR	MBN1915003.1	2052178	g11868	i0	83.6	63.4087403598972	128	21	98.7	0	387	4	10	137	MBN1915003.1 elongation factor Tu [Parachlamydiales bacterium]	diamond	24666	228	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
22151971	22151971	PRJNA494251_P_NODE_35858_length_253_cov_2.388889_g35544_i0	PRJNA494251	35858	253	2.388889	6.04388917	root	1	Root_unresolved	Root_unresolved	124	2.19e-31	NR	WP_032125010.1	389348	g35544	i0	83.1	13.5059288537549	71	12	84.2	0	38	250	190	260	WP_032125010.1 asparagine--tRNA ligase [Candidatus Protochlamydia naegleriophila]	diamond	3417	125	0.992	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26982046	26982046	PRJNA494251_P_NODE_46442_length_243_cov_1.600000_g46128_i0	PRJNA494251	46442	243	1.6	3.888	Waddlia chondrophila	71667	Bacteria	Bacteria	45.8	0.00307	NR	WP_013181240.1	71667	g46128	i0	38.2	0.679012345679012	55	34	67.9	0	177	13	394	448	WP_013181240.1 hydantoinase/oxoprolinase N-terminal domain-containing protein [Waddlia chondrophila]	diamond	165	45.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
27013605	27013605	PRJNA494251_P_NODE_51002_length_233_cov_3.150000_g50688_i0	PRJNA494251	51002	233	3.15	7.3395	Chlamydiales bacterium	2047757	Bacteria	Bacteria	79.7	2.04e-17	NR	HSW72455.1	2047757	g50688	i0	51.3	3.79828326180258	76	36	97.9	1	1	228	18	92	HSW72455.1 transaldolase family protein [Chlamydiales bacterium]	diamond	885	79.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28687809	28687809	PRJNA494251_P_NODE_28007_length_279_cov_1.475728_g27693_i0	PRJNA494251	28007	279	1.475728	4.11728112	Parachlamydia sp. AcF125	2795736	Bacteria	Bacteria	49.7	2.14e-4	NR	WP_213157080.1	2795736	g27693	i0	37.7	0.741935483870968	69	42	74.2	1	63	269	613	680	WP_213157080.1 ankyrin repeat domain-containing protein [Parachlamydia sp. AcF125]	diamond	207	49.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp. AcF125
28703189	28703189	PRJNA494251_P_NODE_26647_length_284_cov_1.459716_g26333_i0	PRJNA494251	26647	284	1.459716	4.14559344	Pseudomonadati	3379134	Bacteria	Bacteria	115	1.11e-27	NR	WP_013182152.1	71667	g26333	i0	61.7	2.95774647887324	94	36	99.3	0	283	2	350	443	WP_013182152.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Waddlia chondrophila]	diamond	840	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
28908279	28908279	PRJNA494251_P_NODE_44748_length_245_cov_0.895349_g44434_i0	PRJNA494251	44748	245	0.895349	2.19360505	Chlamydiales bacterium	2047757	Bacteria	Bacteria	153	4.8099999999999996e-42	NR	HSX13610.1	2047757	g44434	i0	85	0.979591836734694	80	12	98	0	3	242	373	452	HSX13610.1 carboxypeptidase M32 [Chlamydiales bacterium]	diamond	240	153	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29129825	29129825	PRJNA494251_P_NODE_8029_length_463_cov_5.061538_g7726_i0	PRJNA494251	8029	463	5.061538	23.43492094	Chlamydiales bacterium	2047757	Bacteria	Bacteria	135	2.36e-37	NR	MCP5470420.1	2047757	g7726	i0	57.4	0.881209503239741	136	58	88.1	0	462	55	18	153	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	408	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29224558	29224558	PRJNA494251_P_NODE_26069_length_286_cov_2.084507_g25755_i0	PRJNA494251	26069	286	2.084507	5.96169002	Chlamydiales bacterium	2047757	Bacteria	Bacteria	52	3.22e-5	NR	MBN9377481.1	2047757	g25755	i0	32.4	1.06993006993007	102	53	92.3	3	282	19	140	239	MBN9377481.1 hypothetical protein [Chlamydiales bacterium]	diamond	306	52	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29760915	29760915	PRJNA494251_P_NODE_2251_length_798_cov_3.219310_g2006_i0	PRJNA494251	2251	798	3.21931	25.6900938	Simkania sp.	34094	Bacteria	Bacteria	234	3.53e-73	NR	MCB1084310.1	34094	g2006	i0	62.3	1.68796992481203	191	72	71.8	0	758	186	1	191	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	1347	234	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31293138	31293138	PRJNA494251_P_NODE_28075_length_279_cov_1.213592_g27761_i0	PRJNA494251	28075	279	1.213592	3.38592168	root	1	Root_unresolved	Root_unresolved	57.4	3.91e-7	NR	MCB1148972.1	2052156	g27761	i0	40.2	3.53763440860215	82	47	88.2	1	30	275	361	440	MCB1148972.1 alkaline phosphatase family protein [Chlamydiia bacterium]	diamond	987	57.8	0.993079584775087	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32036826	32036826	PRJNA494251_P_NODE_43458_length_246_cov_0.890173_g43144_i0	PRJNA494251	43458	246	0.890173	2.18982558	Chlamydiia bacterium	2052156	Bacteria	Bacteria	57.8	1.75e-7	NR	MBI3508072.1	2052156	g43144	i0	45.1	0.865853658536585	71	39	86.6	0	3	215	234	304	MBI3508072.1 type I glyceraldehyde-3-phosphate dehydrogenase [Chlamydiia bacterium]	diamond	213	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32448358	32448358	PRJNA494251_P_NODE_17079_length_339_cov_0.868421_g16766_i0	PRJNA494251	17079	339	0.868421	2.94394719	Chlamydiales bacterium	2047757	Bacteria	Bacteria	95.5	2.48e-20	NR	MBN9377599.1	2047757	g16766	i0	45.5	0.991150442477876	112	59	98.2	2	3	335	33	143	MBN9377599.1 protoporphyrinogen oxidase [Chlamydiales bacterium]	diamond	336	95.5	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);;