metadata: contig_metadata: 16 rows where bioproject = "PRJNA1204310" and tax

16 rows where bioproject = "PRJNA1204310" 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
7982398	7982398	PRJNA1204310_P_NODE_23567_length_377_cov_1.026316_g23270_i0	PRJNA1204310	23567	377	1.026316	3.86921132	Waddliaceae bacterium	2026802	Bacteria	Bacteria	115	9.31e-29	NR	HEY4831165.1	2026802	g23270	i0	46	1.0026525198939	126	54	99.5	4	2	376	162	274	HEY4831165.1 Sir2 family NAD-dependent protein deacetylase [Waddliaceae bacterium]	diamond	378	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
13798328	13798328	PRJNA1204310_P_NODE_22411_length_385_cov_1.500000_g22114_i0	PRJNA1204310	22411	385	1.5	5.775	Bacteria	2	Bacteria	Bacteria	143	7.22e-39	NR	WP_013182214.1	71667	g22114	i0	57	22.1064935064935	121	52	94.3	0	385	23	72	192	WP_013182214.1 PLP-dependent cysteine synthase family protein [Waddlia chondrophila]	diamond	8511	144	0.993055555555556	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
20730242	20730242	PRJNA1204310_P_NODE_18757_length_415_cov_1.824561_g18460_i0	PRJNA1204310	18757	415	1.824561	7.57192815	Chlamydiales bacterium	2047757	Bacteria	Bacteria	169	5.86e-51	NR	MCP5470421.1	2047757	g18460	i0	67.9	0.946987951807229	131	37	92.5	2	2	385	28	156	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	393	169	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
20731380	20731380	PRJNA1204310_P_NODE_9557_length_565_cov_1.743902_g9265_i0	PRJNA1204310	9557	565	1.743902	9.8530463	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	196	3.5399999999999997e-57	NR	MDP1880008.1	2052176	g9265	i0	66.9	13.9752212389381	142	43	75.4	1	564	139	152	289	MDP1880008.1 asparagine--tRNA ligase [Parachlamydiaceae bacterium]	diamond	7896	196	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27767803	27767803	PRJNA1204310_P_NODE_59304_length_245_cov_0.906977_g59007_i0	PRJNA1204310	59304	245	0.906977	2.22209365	Chlamydiia bacterium	2052156	Bacteria	Bacteria	95.5	1.03e-21	NR	MCB1135084.1	2052156	g59007	i0	67.1	0.96734693877551	79	26	96.7	0	238	2	73	151	MCB1135084.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Chlamydiia bacterium]	diamond	237	95.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
28209420	28209420	PRJNA1204310_P_NODE_19186_length_411_cov_1.813609_g18889_i0	PRJNA1204310	19186	411	1.813609	7.45393299	Chlamydiales bacterium	2047757	Bacteria	Bacteria	189	9.17e-59	NR	MCP5470420.1	2047757	g18889	i0	76.5	0.992700729927007	136	30	99.3	1	3	410	6	139	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	408	189	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28525545	28525545	PRJNA1204310_P_NODE_9847_length_557_cov_1.648760_g9555_i0	PRJNA1204310	9847	557	1.64876	9.1835932	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	141	1.66e-37	NR	HSX03649.1	2047756	g9555	i0	43.5	1.00179533213645	186	93	99.6	2	556	2	74	248	HSX03649.1 cytidine deaminase [Rhabdochlamydiaceae bacterium]	diamond	558	141	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29409351	29409351	PRJNA1204310_P_NODE_52669_length_251_cov_1.314607_g52372_i0	PRJNA1204310	52669	251	1.314607	3.29966357	Simkania sp.	34094	Bacteria	Bacteria	152	2.09e-45	NR	MCB1084326.1	34094	g52372	i0	83.1	3.9681274900398402	83	14	99.2	0	250	2	21	103	MCB1084326.1 serine/threonine-protein kinase [Simkania sp.]	diamond	996	152	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29756612	29756612	PRJNA1204310_P_NODE_60351_length_244_cov_0.912281_g60054_i0	PRJNA1204310	60351	244	0.912281	2.22596564	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	55.8	9.43e-7	NR	MDJ0652090.1	2698248	g60054	i0	42.2	0.786885245901639	64	35	76.2	1	201	16	1124	1187	MDJ0652090.1 NACHT domain-containing protein [Simkaniaceae bacterium]	diamond	192	55.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
29788143	29788143	PRJNA1204310_P_NODE_51151_length_253_cov_0.866667_g50854_i0	PRJNA1204310	51151	253	0.866667	2.19266751	Candidatus Acheromyda pituitae	3076874	Bacteria	Bacteria	83.2	2.34e-16	NR	MBX3718343.1	3076874	g50854	i0	56.6	1.74308300395257	76	32	90.1	1	239	12	24	98	MBX3718343.1 GMC family oxidoreductase [Candidatus Acheromyda pituitae]	diamond	441	83.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Acheromyda	Candidatus Acheromyda pituitae
29851579	29851579	PRJNA1204310_P_NODE_16951_length_434_cov_2.238227_g16654_i0	PRJNA1204310	16951	434	2.238227	9.71390518	Chlamydiales bacterium	2047757	Bacteria	Bacteria	195	4.77e-61	NR	MCP5470421.1	2047757	g16654	i0	72.5	1.85253456221198	138	35	93.3	1	8	412	1	138	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	804	195	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31304854	31304854	PRJNA1204310_P_NODE_23995_length_374_cov_1.554817_g23698_i0	PRJNA1204310	23995	374	1.554817	5.81501558	Chlamydiales bacterium	2047757	Bacteria	Bacteria	131	3.59e-36	NR	MCP5470420.1	2047757	g23698	i0	72.7	0.882352941176471	110	28	88.2	1	374	45	39	146	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	330	131	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31652645	31652645	PRJNA1204310_P_NODE_22977_length_381_cov_1.376623_g22680_i0	PRJNA1204310	22977	381	1.376623	5.24493363	Chlamydiales bacterium	2047757	Bacteria	Bacteria	53.9	1.98e-5	NR	MFI5343530.1	2047757	g22680	i0	26.8	2.1259842519685	138	84	96.9	3	6	374	325	460	MFI5343530.1 ATP-binding protein [Chlamydiales bacterium]	diamond	810	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32190771	32190771	PRJNA1204310_P_NODE_42758_length_284_cov_0.928910_g42461_i0	PRJNA1204310	42758	284	0.92891	2.6381044	Chlamydiales bacterium	2047757	Bacteria	Bacteria	67	1.75e-10	NR	MFT4554366.1	2047757	g42461	i0	34.9	0.876760563380282	83	54	87.7	0	252	4	58	140	MFT4554366.1 sphinganine-1-phosphate aldolase [Chlamydiales bacterium]	diamond	249	67	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32380610	32380610	PRJNA1204310_P_NODE_28159_length_349_cov_1.474638_g27862_i0	PRJNA1204310	28159	349	1.474638	5.14648662	Chlamydiales bacterium	2047757	Bacteria	Bacteria	200	1.5600000000000001e-63	NR	MCP5470421.1	2047757	g27862	i0	80.9	0.988538681948424	115	22	98.9	0	3	347	2	116	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	345	200	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32494522	32494522	PRJNA1204310_P_NODE_2639_length_990_cov_1.296619_g2429_i0	PRJNA1204310	2639	990	1.296619	12.8365281	Pseudomonadati	3379134	Bacteria	Bacteria	190	1.41e-51	NR	WP_013182056.1	71667	g2429	i0	37.2	2.99393939393939	323	174	96.7	7	1	957	25	322	WP_013182056.1 hypothetical protein [Waddlia chondrophila]	diamond	2964	190	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila

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