metadata: contig_metadata: 12 rows where bioproject = "PRJNA498309", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA498309", 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
9410167	9410167	PRJNA498309_S_NODE_24628_length_374_cov_197.882006_g22462_i0	PRJNA498309	24628	374	197.882006	740.07870244	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	383	1.1099999999999998e-101	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g22462	i0	88.818	96.8930481283422	313	34	85	1	23	335	654244	653933	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	36238	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17057955	17057955	PRJNA498309_P_NODE_32234_length_498_cov_14.585683_g30216_i0	PRJNA498309	32234	498	14.585683	72.63670134	Chlamydiota bacterium	2081524	Bacteria	Bacteria	243	2.3299999999999993e-74	NR	MES2200101.1	2081524	g30216	i0	94.5	0.771084337349398	128	7	77.1	0	22	405	475	602	MES2200101.1 toprim domain-containing protein [Chlamydiota bacterium]	diamond	384	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27882173	27882173	PRJNA498309_P_NODE_87405_length_227_cov_4.694737_g85256_i0	PRJNA498309	87405	227	4.694737	10.65705299	Bacteria	2	Bacteria	Bacteria	66.6	1.14e-10	NR	MFI5333742.1	2047757	g85256	i0	88.6	5.55066079295154	35	4	46.3	0	7	111	304	338	MFI5333742.1 heavy metal translocating P-type ATPase [Chlamydiales bacterium]	diamond	1260	67	0.994029850746269	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28056068	28056068	PRJNA498309_P_NODE_78605_length_255_cov_1.908257_g76456_i0	PRJNA498309	78605	255	1.908257	4.86605535	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	110	1.9000000000000003e-28	NR	MBX9924700.1	2047756	g76456	i0	86.4	1.55294117647059	66	9	77.6	0	228	31	122	187	MBX9924700.1 elongation factor P [Rhabdochlamydiaceae bacterium]	diamond	396	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28182196	28182196	PRJNA498309_P_NODE_106746_length_179_cov_1.922535_g104597_i0	PRJNA498309	106746	179	1.922535	3.44133765	Simkania sp.	34094	Bacteria	Bacteria	98.2	2.32e-22	NR	MBS3905183.1	34094	g104597	i0	81.4	0.988826815642458	59	11	98.9	0	179	3	50	108	MBS3905183.1 tyrosine transporter [Simkania sp.]	diamond	177	98.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28340313	28340313	PRJNA498309_P_NODE_35046_length_474_cov_6.379863_g32999_i0	PRJNA498309	35046	474	6.379863	30.24055062	Chlamydiota bacterium	2081524	Bacteria	Bacteria	191	5.559999999999999e-54	NR	MEN9344352.1	2081524	g32999	i0	59.3	0.917721518987342	145	59	91.8	0	23	457	556	700	MEN9344352.1 Cyclohexadienyl dehydratase [Chlamydiota bacterium]	diamond	435	191	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28656174	28656174	PRJNA498309_P_NODE_93827_length_209_cov_2.691860_g91678_i0	PRJNA498309	93827	209	2.69186	5.6259874	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	88.6	5.21e-19	NR	MBX9922815.1	2047756	g91678	i0	61.3	0.889952153110048	62	24	89	0	209	24	184	245	MBX9922815.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	186	88.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29476648	29476648	PRJNA498309_P_NODE_29890_length_520_cov_3.594203_g27898_i0	PRJNA498309	29890	520	3.594203	18.6898556	Candidatus Neptunochlamydia vexilliferae	1651774	Bacteria	Bacteria	155	1.2e-42	NR	WP_194847292.1	1651774	g27898	i0	58.1	0.715384615384615	124	52	71.5	0	436	65	1	124	WP_194847292.1 TauD/TfdA family dioxygenase [Candidatus Neptunochlamydia vexilliferae]	diamond	372	155	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia vexilliferae
30013961	30013961	PRJNA498309_P_NODE_85991_length_232_cov_1.179487_g83842_i0	PRJNA498309	85991	232	1.179487	2.73640984	Simkania sp.	34094	Bacteria	Bacteria	105	1.95e-24	NR	MBS3905114.1	34094	g83842	i0	74	0.943965517241379	73	19	94.4	0	1	219	513	585	MBS3905114.1 UvrD-helicase domain-containing protein [Simkania sp.]	diamond	219	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30582326	30582326	PRJNA498309_P_NODE_116693_length_160_cov_2.512195_g114544_i0	PRJNA498309	116693	160	2.512195	4.019512	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	42.4	0.0168	NR	HRD56306.1	2052176	g114544	i0	58.3	2.75625	36	15	67.5	0	46	153	1	36	HRD56306.1 type II secretion system F family protein [Parachlamydiaceae bacterium]	diamond	441	42.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31214029	31214029	PRJNA498309_P_NODE_79195_length_253_cov_2.087963_g77046_i0	PRJNA498309	79195	253	2.087963	5.28254639	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	111	2.31e-26	NR	MBY0529427.1	2047756	g77046	i0	82.6	0.818181818181818	69	12	81.8	0	3	209	472	540	MBY0529427.1 chaperonin GroEL [Rhabdochlamydiaceae bacterium]	diamond	207	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31562672	31562672	PRJNA498309_S_NODE_52216_length_157_cov_2.139344_g50048_i0	PRJNA498309	52216	157	2.139344	3.35877008	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	54.7	5.38e-7	NR	MBP7074579.1	2047756	g50048	i0	59.5	1.64331210191083	42	17	80.3	0	155	30	194	235	MBP7074579.1 ABC-2 family transporter protein [Rhabdochlamydiaceae bacterium]	diamond	258	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae 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);;