metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA493632" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA493632" 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
26601566	26601566	PRJNA493632_P_NODE_595201_length_245_cov_0.895349_g591760_i0	PRJNA493632	595201	245	0.895349	2.19360505	Chlamydiota bacterium	2081524	Bacteria	Bacteria	148	4.26e-44	NR	NGX42125.1	2081524	g591760	i0	79	0.991836734693878	81	17	99.2	0	243	1	22	102	NGX42125.1 hypothetical protein [Chlamydiota bacterium]	diamond	243	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27202920	27202920	PRJNA493632_P_NODE_715262_length_215_cov_4.901408_g711820_i0	PRJNA493632	715262	215	4.901408	10.5380272	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	109	1.22e-28	NR	MFN4174301.1	2052176	g711820	i0	66.2	0.990697674418605	71	24	99.1	0	214	2	83	153	MFN4174301.1 UDP-N-acetylglucosamine 2-epimerase [Parachlamydiaceae bacterium]	diamond	213	109	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28592647	28592647	PRJNA493632_P_NODE_639607_length_242_cov_0.911243_g636166_i0	PRJNA493632	639607	242	0.911243	2.20520806	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	128	1.5399999999999999e-34	NR	MBY0529708.1	2047756	g636166	i0	77.5	5.9504132231405	80	18	99.2	0	3	242	65	144	MBY0529708.1 LPS export ABC transporter ATP-binding protein [Rhabdochlamydiaceae bacterium]	diamond	1440	128	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28624378	28624378	PRJNA493632_P_NODE_673367_length_237_cov_2.426829_g669926_i0	PRJNA493632	673367	237	2.426829	5.75158473	Chlamydia psittaci	83554	Bacteria	Bacteria	53.5	1.33e-7	NR	EPJ19115.1	1112257	g669926	i0	95.7	0.291139240506329	23	1	29.1	0	2	70	12	34	EPJ19115.1 hypothetical protein CP02DC21_1289, partial [Chlamydia psittaci 02DC21]	diamond	69	53.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
28687596	28687596	PRJNA493632_P_NODE_701947_length_226_cov_17.339869_g698506_i0	PRJNA493632	701947	226	17.339869	39.18810394	Simkania negevensis	83561	Bacteria	Bacteria	86.7	9.63e-18	NR	MBN4066495.1	83561	g698506	i0	67.2	1.7787610619469	67	22	88.9	0	25	225	1	67	MBN4066495.1 ABC transporter permease [Simkania negevensis]	diamond	402	86.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
28844810	28844810	PRJNA493632_P_NODE_129168_length_410_cov_0.913947_g125754_i0	PRJNA493632	129168	410	0.913947	3.7471827	Chlamydiales bacterium	2047757	Bacteria	Bacteria	44.7	0.0473	NR	HEV7738464.1	2047757	g125754	i0	52.6	0.278048780487805	38	18	27.8	0	115	2	223	260	HEV7738464.1 helitron helicase-like domain-containing protein [Chlamydiales bacterium]	diamond	114	44.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28876678	28876678	PRJNA493632_P_NODE_619048_length_243_cov_3.311765_g615607_i0	PRJNA493632	619048	243	3.311765	8.04758895	Chlamydia psittaci	83554	Bacteria	Bacteria	40.8	0.0116	NR	EPL01720.1	1112253	g615607	i0	94.1	0.432098765432099	17	1	21	0	47	97	1	17	EPL01720.1 hypothetical protein CP02DC14_2224A, partial [Chlamydia psittaci 02DC14]	diamond	105	40.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
29413369	29413369	PRJNA493632_P_NODE_583749_length_246_cov_0.890173_g580308_i0	PRJNA493632	583749	246	0.890173	2.18982558	Chlamydia psittaci C6/98	1112249	Bacteria	Bacteria	95.5	6.52e-24	NR	EPP32773.1	1112249	g580308	i0	75.8	0.75609756097561	62	15	75.6	0	61	246	1	62	EPP32773.1 putative lipoprotein, partial [Chlamydia psittaci C6/98]	diamond	186	95.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
29981888	29981888	PRJNA493632_P_NODE_592831_length_245_cov_1.523256_g589390_i0	PRJNA493632	592831	245	1.523256	3.7319772	Parachlamydia sp.	2052048	Bacteria	Bacteria	58.5	2.06e-8	NR	MCE5318403.1	2052048	g589390	i0	37	0.893877551020408	73	46	89.4	0	244	26	14	86	MCE5318403.1 hypothetical protein [Parachlamydia sp.]	diamond	219	58.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
30393015	30393015	PRJNA493632_P_NODE_422373_length_267_cov_2.927835_g418934_i0	PRJNA493632	422373	267	2.927835	7.81731945	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	114	1.2900000000000002e-27	NR	MFI0434844.1	2052176	g418934	i0	69.7	1	89	27	100	0	267	1	173	261	MFI0434844.1 alanine/glycine:cation symporter family protein [Parachlamydiaceae bacterium]	diamond	267	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30708497	30708497	PRJNA493632_P_NODE_588414_length_245_cov_56.947674_g584973_i0	PRJNA493632	588414	245	56.947674	139.5218013	Chlamydiota bacterium	2081524	Bacteria	Bacteria	119	1.0699999999999999e-32	NR	NNM43268.1	2081524	g584973	i0	70.4	0.869387755102041	71	21	86.9	0	213	1	4	74	NNM43268.1 hypothetical protein [Chlamydiota bacterium]	diamond	213	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30898268	30898268	PRJNA493632_P_NODE_612774_length_244_cov_0.900585_g609333_i0	PRJNA493632	612774	244	0.900585	2.1974274	Chlamydia psittaci	83554	Bacteria	Bacteria	64.3	7.14e-12	NR	EPJ33691.1	1112244	g609333	i0	93.3	0.368852459016393	30	2	36.9	0	232	143	2	31	EPJ33691.1 hypothetical protein CP061683_2398, partial [Chlamydia psittaci 06-1683]	diamond	90	64.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30961450	30961450	PRJNA493632_P_NODE_645934_length_242_cov_0.911243_g642493_i0	PRJNA493632	645934	242	0.911243	2.20520806	Chlamydia psittaci	83554	Bacteria	Bacteria	78.6	4.41e-17	NR	EPJ15750.1	1112252	g642493	i0	81.3	0.59504132231405	48	9	59.5	0	163	20	30	77	EPJ15750.1 hypothetical protein CP01DC11_1288, partial [Chlamydia psittaci 01DC11]	diamond	144	78.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30992922	30992922	PRJNA493632_P_NODE_422074_length_267_cov_3.432990_g418635_i0	PRJNA493632	422074	267	3.43299	9.1660833	Chlamydia psittaci	83554	Bacteria	Bacteria	70.5	4.12e-14	NR	EPJ16938.1	1112257	g418635	i0	81.8	0.49438202247191	44	6	48.3	2	149	21	1	43	EPJ16938.1 hypothetical protein CP02DC21_1876 [Chlamydia psittaci 02DC21]	diamond	132	70.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31087579	31087579	PRJNA493632_P_NODE_234495_length_323_cov_1.564000_g231059_i0	PRJNA493632	234495	323	1.564	5.05172	Chlamydia trachomatis	813	Bacteria	Bacteria	79	9.2e-17	NR	WP_216594844.1	813	g231059	i0	46.3	0.743034055727554	80	43	74.3	0	262	23	1	80	WP_216594844.1 hypothetical protein, partial [Chlamydia trachomatis]	diamond	240	79	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
32289999	32289999	PRJNA493632_P_NODE_466779_length_258_cov_3.200000_g463340_i0	PRJNA493632	466779	258	3.2	8.256	Chlamydia psittaci	83554	Bacteria	Bacteria	82.4	8.13e-19	NR	EPJ24094.1	1112268	g463340	i0	84.1	1.02325581395349	44	7	51.2	0	185	54	3	46	EPJ24094.1 nef attachable domain protein, partial [Chlamydia psittaci 09DC77]	diamond	264	82.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32479729	32479729	PRJNA493632_P_NODE_607259_length_244_cov_1.637427_g603818_i0	PRJNA493632	607259	244	1.637427	3.99532188	Chlamydia psittaci	83554	Bacteria	Bacteria	158	2.9099999999999996e-48	NR	EPJ17555.1	1112252	g603818	i0	94.7	0.934426229508197	76	4	93.4	0	17	244	4	79	EPJ17555.1 hypothetical protein CP01DC11_1209 [Chlamydia psittaci 01DC11]	diamond	228	158	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32542888	32542888	PRJNA493632_P_NODE_295579_length_297_cov_1.910714_g292141_i0	PRJNA493632	295579	297	1.910714	5.67482058	Chlamydia psittaci	83554	Bacteria	Bacteria	52.8	5.32e-7	NR	EPJ19115.1	1112257	g292141	i0	74.2	0.313131313131313	31	8	31.3	0	218	126	4	34	EPJ19115.1 hypothetical protein CP02DC21_1289, partial [Chlamydia psittaci 02DC21]	diamond	93	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci

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