metadata: contig_metadata: 13 rows where bioproject = "PRJNA773247" and tax

13 rows where bioproject = "PRJNA773247" 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
26863834	26863834	PRJNA773247_P_NODE_5121_length_785_cov_15.752809_g5045_i0	PRJNA773247	5121	785	15.752809	123.65955065	Chlamydiales bacterium	2047757	Bacteria	Bacteria	160	8.14e-45	NR	HEY4255527.1	2047757	g5045	i0	56.4	1.8343949044586	133	58	50.8	0	6	404	97	229	HEY4255527.1 DNA repair protein RadC [Chlamydiales bacterium]	diamond	1440	160	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27653781	27653781	PRJNA773247_P_NODE_30504_length_250_cov_5.745763_g30420_i0	PRJNA773247	30504	250	5.745763	14.3644075	Chlamydiota bacterium	2081524	Bacteria	Bacteria	77.8	1.01e-14	NR	MCH9632324.1	2081524	g30420	i0	56.2	0.876	73	31	87.6	1	219	1	15	86	MCH9632324.1 Cell division coordinator CpoB [Chlamydiota bacterium]	diamond	219	77.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27780016	27780016	PRJNA773247_P_NODE_30944_length_249_cov_3.948864_g30860_i0	PRJNA773247	30944	249	3.948864	9.83267136	Chlamydiota bacterium	2081524	Bacteria	Bacteria	118	1.1000000000000002e-28	NR	MCH9632906.1	2081524	g30860	i0	63.9	1	83	30	100	0	1	249	319	401	MCH9632906.1 Peptidoglycan D,D-transpeptidase FtsI [Chlamydiota bacterium]	diamond	249	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27915558	27915558	PRJNA773247_P_NODE_15785_length_372_cov_2.658863_g15701_i0	PRJNA773247	15785	372	2.658863	9.89097036	Bacteria	2	Bacteria	Bacteria	72	8.88e-12	NR	WP_158622999.1	1353976	g15701	i0	35.2	11.1209677419355	125	78	98.4	2	7	372	92	216	WP_158622999.1 threonine--tRNA ligase [Neochlamydia sp. S13]	diamond	4137	72.4	0.994475138121547	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
28727105	28727105	PRJNA773247_P_NODE_14907_length_385_cov_4.147436_g14823_i0	PRJNA773247	14907	385	4.147436	15.9676286	Chlamydiota bacterium	2081524	Bacteria	Bacteria	110	3.41e-27	NR	NGX47394.1	2081524	g14823	i0	45.2	0.966233766233766	124	65	95.8	2	371	3	81	202	NGX47394.1 hypothetical protein [Chlamydiota bacterium]	diamond	372	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28916295	28916295	PRJNA773247_P_NODE_14308_length_395_cov_17.009317_g14224_i0	PRJNA773247	14308	395	17.009317	67.18680215	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	47	0.00559	NR	NRA90865.1	2698248	g14224	i0	45.5	0.334177215189873	44	24	33.4	0	393	262	310	353	NRA90865.1 hypothetical protein [Simkaniaceae bacterium]	diamond	132	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
29547798	29547798	PRJNA773247_P_NODE_13810_length_404_cov_2.728097_g13726_i0	PRJNA773247	13810	404	2.728097	11.02151188	Chlamydiota bacterium	2081524	Bacteria	Bacteria	107	1.97e-24	NR	MCH9632227.1	2081524	g13726	i0	49.6	0.913366336633663	123	58	88.4	3	361	5	68	190	MCH9632227.1 hypothetical protein [Chlamydiota bacterium]	diamond	369	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29705473	29705473	PRJNA773247_P_NODE_35110_length_240_cov_3.419162_g35026_i0	PRJNA773247	35110	240	3.419162	8.2059888	Simkania negevensis	83561	Bacteria	Bacteria	63.2	2.18e-9	NR	MBI3211730.1	83561	g35026	i0	41.7	0.9	72	42	90	0	24	239	295	366	MBI3211730.1 conjugal transfer protein TraH [Simkania negevensis]	diamond	216	63.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
30084764	30084764	PRJNA773247_P_NODE_12732_length_426_cov_11.478754_g12649_i0	PRJNA773247	12732	426	11.478754	48.89949204	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	276	4.07e-92	NR	MFI0436135.1	2052176	g12649	i0	97.8	0.971830985915493	138	3	97.2	0	425	12	73	210	MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium]	diamond	414	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31886533	31886533	PRJNA773247_P_NODE_19097_length_330_cov_3.918288_g19013_i0	PRJNA773247	19097	330	3.918288	12.9303504	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	82	1.43e-15	NR	MFS8564118.1	2047756	g19013	i0	45.2	0.945454545454545	104	50	90	3	310	14	37	138	MFS8564118.1 protein kinase [Rhabdochlamydiaceae bacterium]	diamond	312	82	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32013158	32013158	PRJNA773247_P_NODE_11338_length_459_cov_8.922280_g11255_i0	PRJNA773247	11338	459	8.92228	40.9532652	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	61.6	6.18e-8	NR	HEY5235298.1	2047756	g11255	i0	34.7	0.640522875816993	98	59	64.1	2	158	451	28	120	HEY5235298.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	294	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32771420	32771420	PRJNA773247_P_NODE_16760_length_357_cov_5.862676_g16676_i0	PRJNA773247	16760	357	5.8626760000000004	20.92975332	Chlamydiota bacterium	2081524	Bacteria	Bacteria	70.1	2.29e-11	NR	MES2200320.1	2081524	g16676	i0	50.8	1.73109243697479	61	30	51.3	0	340	158	76	136	MES2200320.1 hypothetical protein [Chlamydiota bacterium]	diamond	618	70.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32802987	32802987	PRJNA773247_P_NODE_32100_length_247_cov_0.885057_g32016_i0	PRJNA773247	32100	247	0.885057	2.18609079	Chlamydiota bacterium	2081524	Bacteria	Bacteria	112	1.35e-28	NR	MCH9633271.1	2081524	g32016	i0	64.9	0.935222672064777	77	27	93.5	0	16	246	70	146	MCH9633271.1 23S rRNA (guanosine-2'-O-)-methyltransferase RlmB [Chlamydiota bacterium]	diamond	231	112	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;