metadata: contig_metadata: 11 rows where bioproject = "PRJNA270367" and tax

11 rows where bioproject = "PRJNA270367" 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
27326967	27326967	PRJNA270367_P_NODE_35663_length_181_cov_1.734848_g35458_i0	PRJNA270367	35663	181	1.734848	3.14007488	Simkania sp.	34094	Bacteria	Bacteria	48.9	4.64e-5	NR	MCB1084323.1	34094	g35458	i0	82.6	0.38121546961326	23	4	38.1	0	112	180	91	113	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	69	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27390279	27390279	PRJNA270367_P_NODE_16483_length_309_cov_1.815385_g16278_i0	PRJNA270367	16483	309	1.815385	5.60953965	Chlamydiales bacterium	2047757	Bacteria	Bacteria	171	3.4599999999999995e-52	NR	MCP5470420.1	2047757	g16278	i0	79.6	1	103	21	100	0	1	309	1	103	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	309	171	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27421927	27421927	PRJNA270367_P_NODE_7223_length_503_cov_1.607930_g7025_i0	PRJNA270367	7223	503	1.60793	8.0878879	Simkania sp.	34094	Bacteria	Bacteria	148	4.99e-41	NR	MCB1084310.1	34094	g7025	i0	79.6	0.554671968190855	93	19	55.5	0	464	186	92	184	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	279	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27769264	27769264	PRJNA270367_P_NODE_7724_length_485_cov_6.392202_g7526_i0	PRJNA270367	7724	485	6.392202	31.0021797	Chlamydiales bacterium	2047757	Bacteria	Bacteria	218	4.67e-70	NR	MCP5470420.1	2047757	g7526	i0	79.2	0.890721649484536	144	30	89.1	0	484	53	4	147	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	432	218	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27863642	27863642	PRJNA270367_P_NODE_40385_length_168_cov_1.033613_g40180_i0	PRJNA270367	40385	168	1.033613	1.73646984	Chlamydiales bacterium	2047757	Bacteria	Bacteria	44.7	0.00278	NR	MDP1609001.1	2047757	g40180	i0	32.3	1.16071428571429	65	30	96.4	2	6	167	46	107	MDP1609001.1 hypothetical protein [Chlamydiales bacterium]	diamond	195	44.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28968908	28968908	PRJNA270367_P_NODE_31588_length_197_cov_1.054054_g31383_i0	PRJNA270367	31588	197	1.054054	2.07648638	Simkania sp.	34094	Bacteria	Bacteria	81.3	1.52e-18	NR	MCB1084368.1	34094	g31383	i0	65.6	0.928934010152284	61	21	92.9	0	197	15	4	64	MCB1084368.1 hypothetical protein [Simkania sp.]	diamond	183	81.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29347769	29347769	PRJNA270367_P_NODE_24969_length_230_cov_1.436464_g24764_i0	PRJNA270367	24969	230	1.436464	3.3038672	Simkania sp.	34094	Bacteria	Bacteria	99.4	2.78e-25	NR	MCB1084315.1	34094	g24764	i0	85.7	0.730434782608696	56	8	73	0	3	170	13	68	MCB1084315.1 hypothetical protein [Simkania sp.]	diamond	168	99.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30895676	30895676	PRJNA270367_P_NODE_26934_length_219_cov_1.135294_g26729_i0	PRJNA270367	26934	219	1.135294	2.48629386	Simkania sp.	34094	Bacteria	Bacteria	57.8	3.01e-8	NR	MCB1084323.1	34094	g26729	i0	74.2	0.424657534246575	31	8	42.5	0	59	151	128	158	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	93	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30958812	30958812	PRJNA270367_P_NODE_7414_length_496_cov_2.769575_g7216_i0	PRJNA270367	7414	496	2.769575	13.737092	Chlamydiales bacterium	2047757	Bacteria	Bacteria	214	1.82e-68	NR	MCP5470420.1	2047757	g7216	i0	74.8	0.913306451612903	151	38	91.3	0	496	44	3	153	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	453	214	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32192193	32192193	PRJNA270367_P_NODE_15558_length_322_cov_1.029304_g15353_i0	PRJNA270367	15558	322	1.029304	3.31435888	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	60.8	5.66e-9	NR	WP_051981753.1	389348	g15353	i0	41.3	0.745341614906832	80	45	74.5	1	297	58	68	145	WP_051981753.1 SET domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	240	60.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
32634483	32634483	PRJNA270367_P_NODE_7720_length_486_cov_1.334096_g7522_i0	PRJNA270367	7720	486	1.334096	6.48370656	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	98.6	1.73e-20	NR	MFI0435025.1	2052176	g7522	i0	42.3	1.48765432098765	123	65	73.5	3	7	363	592	712	MFI0435025.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Parachlamydiaceae bacterium]	diamond	723	98.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;