metadata: contig_metadata: 15 rows where bioproject = "PRJNA908278", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA908278", tax_clade = "PVC group" 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
7268382	7268382	PRJNA908278_P_NODE_22786_length_272_cov_1.160804_g22683_i0	PRJNA908278	22786	272	1.160804	3.15738688	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	497	2.67e-136	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g22683	i0	99.632	75.7279411764706	272	1	100	0	1	272	1249920	1250191	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	20598	497	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17468449	17468449	PRJNA908278_P_NODE_17034_length_308_cov_1.612766_g16931_i0	PRJNA908278	17034	308	1.612766	4.96731928	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g16931	i0	100	0.0909090909090909	28	0	9	0	72	99	373616	373589	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
21292389	21292389	PRJNA908278_P_NODE_9117_length_397_cov_2.074074_g9014_i0	PRJNA908278	9117	397	2.074074	8.23407378	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	205	1.43e-60	NR	HEX4840108.1	2047756	g9014	i0	69.7	1.99496221662469	132	40	99.7	0	1	396	380	511	HEX4840108.1 phosphoenolpyruvate carboxykinase (GTP) [Rhabdochlamydiaceae bacterium]	diamond	792	205	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
26929513	26929513	PRJNA908278_P_NODE_36002_length_229_cov_2.301282_g35899_i0	PRJNA908278	36002	229	2.301282	5.26993578	Chlamydiales bacterium	2047757	Bacteria	Bacteria	52.8	2.72e-6	NR	MCP5470420.1	2047757	g35899	i0	61.7	0.615720524017467	47	18	61.6	0	30	170	62	108	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	141	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
26960944	26960944	PRJNA908278_P_NODE_802_length_1128_cov_2.483412_g745_i0	PRJNA908278	802	1128	2.483412	28.01288736	Simkania sp.	34094	Bacteria	Bacteria	219	3.7899999999999996e-67	NR	MCB1084326.1	34094	g745	i0	79.7	0.986702127659574	123	25	32.7	0	1016	648	7	129	MCB1084326.1 serine/threonine-protein kinase [Simkania sp.]	diamond	1113	219	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
26960946	26960946	PRJNA908278_P_NODE_9102_length_398_cov_0.947692_g8999_i0	PRJNA908278	9102	398	0.947692	3.77181416	Simkania sp.	34094	Bacteria	Bacteria	156	9.18e-45	NR	MCB1084310.1	34094	g8999	i0	62.7	0.949748743718593	126	47	95	0	382	5	8	133	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	378	156	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27118934	27118934	PRJNA908278_P_NODE_16042_length_316_cov_1.267490_g15939_i0	PRJNA908278	16042	316	1.26749	4.0052684	Chlamydiales bacterium	2047757	Bacteria	Bacteria	117	6.94e-31	NR	MCP5470421.1	2047757	g15939	i0	53.4	0.977848101265823	103	48	97.8	0	3	311	21	123	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	309	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27118948	27118948	PRJNA908278_P_NODE_25922_length_253_cov_1.711111_g25819_i0	PRJNA908278	25922	253	1.711111	4.32911083	Simkania sp.	34094	Bacteria	Bacteria	91.7	3.13e-21	NR	MCB1084323.1	34094	g25819	i0	59.4	0.758893280632411	64	26	75.9	0	253	62	96	159	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	192	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27529927	27529927	PRJNA908278_P_NODE_21963_length_277_cov_1.132353_g21860_i0	PRJNA908278	21963	277	1.132353	3.13661781	Simkania sp.	34094	Bacteria	Bacteria	133	1.88e-37	NR	MCB1084323.1	34094	g21860	i0	69.2	0.985559566787004	91	28	98.6	0	2	274	52	142	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	273	133	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27758758	27758758	PRJNA908278_P_NODE_6704_length_455_cov_2.015707_g6601_i0	PRJNA908278	6704	455	2.015707	9.17146685	Pseudomonadati	3379134	Bacteria	Bacteria	61.2	1.47e-8	NR	WP_051981753.1	389348	g6601	i0	41.3	1.84615384615385	80	45	52.7	1	168	407	68	145	WP_051981753.1 SET domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	840	61.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
27845535	27845535	PRJNA908278_P_NODE_21004_length_282_cov_1.473684_g20901_i0	PRJNA908278	21004	282	1.473684	4.15578888	Chlamydiota bacterium	2081524	Bacteria	Bacteria	47	0.00187	NR	MCX6987548.1	2081524	g20901	i0	36.7	0.840425531914894	79	45	84	2	238	2	37	110	MCX6987548.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Chlamydiota bacterium]	diamond	237	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27908605	27908605	PRJNA908278_P_NODE_6445_length_463_cov_2.920513_g6342_i0	PRJNA908278	6445	463	2.920513	13.52197519	Chlamydiales bacterium	2047757	Bacteria	Bacteria	211	3.78e-67	NR	MCP5470420.1	2047757	g6342	i0	76.8	0.920086393088553	142	33	92	0	461	36	6	147	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	426	211	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29329649	29329649	PRJNA908278_P_NODE_23409_length_268_cov_1.394872_g23306_i0	PRJNA908278	23409	268	1.394872	3.73825696	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	50.1	1.35e-4	NR	MBA3722137.1	2052176	g23306	i0	31.7	0.917910447761194	82	55	91.8	1	263	18	1563	1643	MBA3722137.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	246	50.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30877461	30877461	PRJNA908278_P_NODE_30214_length_247_cov_0.885057_g30111_i0	PRJNA908278	30214	247	0.885057	2.18609079	Simkania sp.	34094	Bacteria	Bacteria	124	3.74e-35	NR	MCB1084313.1	34094	g30111	i0	95.4	0.789473684210526	65	3	78.9	0	44	238	1	65	MCB1084313.1 hypothetical protein [Simkania sp.]	diamond	195	124	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32047584	32047584	PRJNA908278_P_NODE_6138_length_473_cov_7.015000_g6035_i0	PRJNA908278	6138	473	7.015	33.18095	Chlamydiales bacterium	2047757	Bacteria	Bacteria	219	2.81e-70	NR	MCP5470420.1	2047757	g6035	i0	78.6	0.919661733615222	145	31	92	0	473	39	3	147	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	435	219	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;