metadata: contig_metadata: 14 rows where bioproject = "PRJNA611476" and tax

14 rows where bioproject = "PRJNA611476" 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
588958	588958	PRJNA611476_P_NODE_110761_length_243_cov_0.905882_g109970_i0	PRJNA611476	110761	243	0.905882	2.20129326	Candidatus Parilichlamydia sp. CR160513-20	1803833	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|1000729704\|gb\|KT158463.1\|	1803833	g109970	i0	86.585	43.1851851851852	246	24	100	7	1	243	1916	1677	Chlamydiales bacterium CR160513-20 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	10494	263	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Parilichlamydiaceae	Candidatus Parilichlamydia	Candidatus Parilichlamydia sp. CR160513-20
27522471	27522471	PRJNA611476_P_NODE_17123_length_477_cov_3.049505_g16333_i0	PRJNA611476	17123	477	3.049505	14.54613885	Chlamydiales bacterium	2047757	Bacteria	Bacteria	140	4.4399999999999997e-39	NR	MCP5470421.1	2047757	g16333	i0	52	2.72327044025157	148	65	91.8	2	477	40	14	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1299	140	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27933037	27933037	PRJNA611476_P_NODE_65445_length_275_cov_1.346535_g64654_i0	PRJNA611476	65445	275	1.346535	3.70297125	Criblamydia sequanensis	340071	Bacteria	Bacteria	105	5.43e-24	NR	WP_041017764.1	340071	g64654	i0	63.3	0.861818181818182	79	27	84	1	43	273	20	98	WP_041017764.1 sulfatase-like hydrolase/transferase [Criblamydia sequanensis]	diamond	237	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
29745588	29745588	PRJNA611476_P_NODE_98870_length_246_cov_0.890173_g98079_i0	PRJNA611476	98870	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	79	6.39e-15	NR	MCB1076117.1	34094	g98079	i0	49.4	2.97560975609756	81	41	98.8	0	4	246	190	270	MCB1076117.1 enoyl-CoA hydratase/isomerase family protein [Simkania sp.]	diamond	732	79	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31375880	31375880	PRJNA611476_P_NODE_22156_length_426_cov_0.872521_g21365_i0	PRJNA611476	22156	426	0.872521	3.71693946	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	60.1	2.08e-7	NR	WP_059061088.1	389348	g21365	i0	37.6	0.711267605633803	101	45	59.9	3	257	3	194	292	WP_059061088.1 hypothetical protein [Candidatus Protochlamydia naegleriophila]	diamond	303	60.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
31375908	31375908	PRJNA611476_P_NODE_53996_length_297_cov_3.022321_g53205_i0	PRJNA611476	53996	297	3.022321	8.97629337	Chlamydiota bacterium	2081524	Bacteria	Bacteria	50.1	1.86e-4	NR	NBU62582.1	2081524	g53205	i0	33.6	1.11111111111111	110	49	100	3	297	1	152	248	NBU62582.1 hypothetical protein [Chlamydiota bacterium]	diamond	330	50.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31597494	31597494	PRJNA611476_P_NODE_99216_length_246_cov_0.890173_g98425_i0	PRJNA611476	99216	246	0.890173	2.18982558	Simkania sp.	34094	Bacteria	Bacteria	63.5	5.38e-10	NR	MCB1084431.1	34094	g98425	i0	54.4	0.695121951219512	57	26	69.5	0	238	68	70	126	MCB1084431.1 hypothetical protein [Simkania sp.]	diamond	171	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32103363	32103363	PRJNA611476_P_NODE_99038_length_246_cov_0.890173_g98247_i0	PRJNA611476	99038	246	0.890173	2.18982558	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	148	4.25e-41	NR	MFV0339878.1	2052176	g98247	i0	86.6	1	82	11	100	0	1	246	228	309	MFV0339878.1 FtsW/RodA/SpoVE family cell cycle protein [Parachlamydiaceae bacterium]	diamond	246	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32515007	32515007	PRJNA611476_P_NODE_82759_length_250_cov_0.870056_g81968_i0	PRJNA611476	82759	250	0.870056	2.17514	Chlamydia psittaci	83554	Bacteria	Bacteria	40.4	0.0273	NR	EPJ27355.1	1112269	g81968	i0	42	1.08	50	29	60	0	194	45	2	51	EPJ27355.1 nef attachable domain protein [Chlamydia psittaci 09DC78]	diamond	270	40.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32748394	32748394	PRJNA611476_P_NODE_110720_length_243_cov_0.905882_g109929_i0	PRJNA611476	110720	243	0.905882	2.20129326	PVC group	1783257	Bacteria	Bacteria	65.5	3.57e-10	NR	MBI1871333.1	2081524	g109929	i0	55.2	2.76543209876543	67	28	80.2	1	196	2	358	424	MBI1871333.1 hypothetical protein [Chlamydiota bacterium]	diamond	672	65.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32766776	32766776	PRJNA611476_P_NODE_73040_length_260_cov_1.946524_g72249_i0	PRJNA611476	73040	260	1.946524	5.0609624	Chlamydia psittaci	83554	Bacteria	Bacteria	47	1.25e-4	NR	EPJ15322.1	1112256	g72249	i0	76.9	1.2	26	6	30	0	141	64	13	38	EPJ15322.1 retrovirus-related Pol polyLINE-1 domain protein, partial [Chlamydia psittaci 02DC18]	diamond	312	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32829883	32829883	PRJNA611476_P_NODE_45580_length_320_cov_1.214575_g44789_i0	PRJNA611476	45580	320	1.214575	3.88664	Chlamydiales bacterium	2047757	Bacteria	Bacteria	99	9.41e-24	NR	MCP5470420.1	2047757	g44789	i0	72.2	0.740625	79	22	74.1	0	70	306	58	136	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	237	99	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32861303	32861303	PRJNA611476_P_NODE_82140_length_250_cov_0.870056_g81349_i0	PRJNA611476	82140	250	0.870056	2.17514	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	52.8	7.61e-7	NR	MBP9842320.1	2698248	g81349	i0	41.9	0.888	74	42	87.6	1	3	221	7	80	MBP9842320.1 hypothetical protein [Simkaniaceae bacterium]	diamond	222	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
32874299	32874299	PRJNA611476_P_NODE_44060_length_324_cov_1.729084_g43269_i0	PRJNA611476	44060	324	1.729084	5.60223216	Chlamydia	810	Bacteria	Bacteria	50.8	5.87e-6	NR	EPP30691.1	1112248	g43269	i0	61	0.759259259259259	41	16	38	0	172	50	11	51	EPP30691.1 nef attachable domain protein [Chlamydia psittaci C1/97]	diamond	246	50.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);;