metadata: contig_metadata: 16 rows where bioproject = "PRJNA631119" and tax

16 rows where bioproject = "PRJNA631119" 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
12630940	12630940	PRJNA631119_P_NODE_26450_length_267_cov_1.587629_g26332_i0	PRJNA631119	26450	267	1.587629	4.23896943	Candidatus Protochlamydia	282132	Bacteria	Bacteria	449	7.410000000000001e-122	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g26332	i0	97.348	136.674157303371	264	7	99	0	1	264	1250359	1250622	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	36492	451	0.995565410199557	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
24829467	24829467	PRJNA631119_P_NODE_25000_length_273_cov_1.620000_g24882_i0	PRJNA631119	25000	273	1.62	4.4226	Chlamydiales bacterium	2047757	Bacteria	Bacteria	90.9	1.78e-19	NR	HSX26922.1	2047757	g24882	i0	53.3	1.94505494505495	90	41	97.8	1	5	271	206	295	HSX26922.1 cysteine synthase family protein [Chlamydiales bacterium]	diamond	531	90.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
26891310	26891310	PRJNA631119_P_NODE_34041_length_247_cov_0.885057_g33923_i0	PRJNA631119	34041	247	0.885057	2.18609079	Chlamydiales bacterium STE3	1910938	Bacteria	Bacteria	100	7.989999999999998e-24	NR	KAF3362988.1	1910938	g33923	i0	60.5	0.983805668016194	81	32	98.4	0	3	245	78	158	KAF3362988.1 hypothetical protein PHSC3_000523 [Chlamydiales bacterium STE3]	diamond	243	100	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium STE3
26922725	26922725	PRJNA631119_P_NODE_34182_length_247_cov_0.885057_g34064_i0	PRJNA631119	34182	247	0.885057	2.18609079	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	89.7	3.21e-19	NR	MBA3723252.1	2052176	g34064	i0	47.6	0.995951417004049	82	42	98.4	1	246	4	127	208	MBA3723252.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	246	89.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27333915	27333915	PRJNA631119_P_NODE_1043_length_993_cov_9.922826_g967_i0	PRJNA631119	1043	993	9.922826	98.53366218	Chlamydiota bacterium	2081524	Bacteria	Bacteria	60.5	2.35e-6	NR	NGX39248.1	2081524	g967	i0	29	0.561933534743202	186	104	52.6	6	862	341	38	207	NGX39248.1 hypothetical protein [Chlamydiota bacterium]	diamond	558	60.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27883064	27883064	PRJNA631119_P_NODE_9345_length_393_cov_1.859375_g9227_i0	PRJNA631119	9345	393	1.859375	7.30734375	Parachlamydia	83551	Bacteria	Bacteria	185	4.3399999999999996e-54	NR	WP_100067520.1	83552	g9227	i0	66.2	13.9618320610687	130	44	99.2	0	2	391	202	331	WP_100067520.1 7-dehydrocholesterol reductase [Parachlamydia acanthamoebae]	diamond	5487	185	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
28217615	28217615	PRJNA631119_P_NODE_34366_length_247_cov_0.885057_g34248_i0	PRJNA631119	34366	247	0.885057	2.18609079	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	57	3.6e-7	NR	MBP7074845.1	2047756	g34248	i0	61	0.497975708502024	41	16	49.8	0	126	4	182	222	MBP7074845.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	123	57	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28312690	28312690	PRJNA631119_P_NODE_13806_length_340_cov_1.149813_g13688_i0	PRJNA631119	13806	340	1.149813	3.9093642	Chlamydiia bacterium	2052156	Bacteria	Bacteria	62.4	2.13e-9	NR	MCB1115924.1	2052156	g13688	i0	50.7	0.644117647058824	73	32	60.9	3	340	134	81	153	MCB1115924.1 DoxX family protein [Chlamydiia bacterium]	diamond	219	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
28723133	28723133	PRJNA631119_P_NODE_23527_length_280_cov_1.381643_g23409_i0	PRJNA631119	23527	280	1.381643	3.8686004	Chlamydiales bacterium	2047757	Bacteria	Bacteria	94.4	4.25e-20	NR	MFT5319030.1	2047757	g23409	i0	48.5	2.68928571428571	99	37	99.6	5	1	279	335	425	MFT5319030.1 5-histidylcysteine sulfoxide synthase/putative 4-mercaptohistidine N1-methyltransferase [Chlamydiales bacterium]	diamond	753	94.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28754642	28754642	PRJNA631119_P_NODE_32487_length_249_cov_0.875000_g32369_i0	PRJNA631119	32487	249	0.875	2.17875	Chlamydiales bacterium	2047757	Bacteria	Bacteria	134	9.32e-38	NR	MDP1609002.1	2047757	g32369	i0	86.7	0.903614457831325	75	10	90.4	0	245	21	51	125	MDP1609002.1 hypothetical protein [Chlamydiales bacterium]	diamond	225	134	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29417585	29417585	PRJNA631119_P_NODE_4969_length_506_cov_15.242494_g4851_i0	PRJNA631119	4969	506	15.242494	77.12701964	Chlamydiales bacterium	2047757	Bacteria	Bacteria	147	8.13e-42	NR	MCP5470421.1	2047757	g4851	i0	51.9	3.5395256916996	156	69	91.3	2	13	474	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1791	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29493404	29493404	PRJNA631119_P_NODE_29810_length_254_cov_1.850829_g29692_i0	PRJNA631119	29810	254	1.850829	4.70110566	Bacteria	2	Bacteria	Bacteria	57.8	1.99e-7	NR	HRW58590.1	2047757	g29692	i0	42.1	2.69291338582677	76	32	89.8	2	8	235	5	68	HRW58590.1 hypothetical protein [Chlamydiales bacterium]	diamond	684	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29745723	29745723	PRJNA631119_P_NODE_37830_length_243_cov_0.905882_g37712_i0	PRJNA631119	37830	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	44.3	0.00632	NR	MCB1136191.1	2052156	g37712	i0	41.8	5.38271604938272	55	31	66.7	1	241	80	80	134	MCB1136191.1 CesT family type III secretion system chaperone [Chlamydiia bacterium]	diamond	1308	44.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30270734	30270734	PRJNA631119_P_NODE_38912_length_241_cov_1.744048_g38794_i0	PRJNA631119	38912	241	1.744048	4.20315568	Parachlamydia sp.	2052048	Bacteria	Bacteria	58.5	9.78e-8	NR	MCE5316308.1	2052048	g38794	i0	42.5	0.908713692946058	73	42	90.9	0	23	241	469	541	MCE5316308.1 ankyrin repeat domain-containing protein [Parachlamydia sp.]	diamond	219	58.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
32009172	32009172	PRJNA631119_P_NODE_35918_length_245_cov_0.895349_g35800_i0	PRJNA631119	35918	245	0.895349	2.19360505	Simkania negevensis	83561	Bacteria	Bacteria	48.1	4.06e-4	NR	WP_013944019.1	83561	g35800	i0	42	1.23673469387755	50	28	61.2	1	1	150	206	254	WP_013944019.1 DUF268 domain-containing protein [Simkania negevensis]	diamond	303	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
32104000	32104000	PRJNA631119_P_NODE_25078_length_273_cov_1.370000_g24960_i0	PRJNA631119	25078	273	1.37	3.7401	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	67.8	8.15e-11	NR	MBP7074276.1	2047756	g24960	i0	44.4	2.96703296703297	90	44	94.5	4	260	3	363	450	MBP7074276.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	810	67.8	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);;