metadata: contig_metadata: 21 rows where bioproject = "PRJNA741997", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA741997", 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
1997684	1997684	PRJNA741997_P_NODE_74362_length_250_cov_0.870056_g73242_i0	PRJNA741997	74362	250	0.870056	2.17514	Chlamydiota bacterium	2081524	Bacteria	Bacteria	147	6.739999999999999e-40	NR	MES2121918.1	2081524	g73242	i0	84.3	1.992	83	13	99.6	0	249	1	273	355	MES2121918.1 L-serine ammonia-lyase [Chlamydiota bacterium]	diamond	498	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
3272656	3272656	PRJNA741997_P_NODE_19143_length_528_cov_1.481319_g18029_i0	PRJNA741997	19143	528	1.481319	7.82136432	Waddliaceae bacterium	2026802	Bacteria	Bacteria	188	2.769999999999999e-55	NR	HEY4831209.1	2026802	g18029	i0	66.9	0.840909090909091	148	49	84.1	0	528	85	201	348	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	444	188	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
3272996	3272996	PRJNA741997_P_NODE_74743_length_249_cov_2.318182_g73623_i0	PRJNA741997	74743	249	2.318182	5.77227318	Chlamydiales bacterium CRIB 34	492543	Bacteria	Bacteria	368	1.97e-97	NTclustered	gi\|165911249\|gb\|EU363465.1\|	492543	g73623	i0	95.633	95.0722891566265	229	10	92	0	17	245	140	368	Chlamydiales bacterium CRIB 34 16S ribosomal RNA gene, partial sequence	blastn	23673	368	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium CRIB 34
7100196	7100196	PRJNA741997_P_NODE_47986_length_312_cov_1.598326_g46866_i0	PRJNA741997	47986	312	1.598326	4.98677712	Chlamydiota bacterium	2081524	Bacteria	Bacteria	153	1.38e-44	NR	MCX6987734.1	2081524	g46866	i0	66.3	10.7211538461538	101	34	97.1	0	2	304	13	113	MCX6987734.1 superoxide dismutase [Chlamydiota bacterium]	diamond	3345	153	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
12200780	12200780	PRJNA741997_P_NODE_28810_length_409_cov_2.068452_g27690_i0	PRJNA741997	28810	409	2.068452	8.45996868	root	1	Root_unresolved	Root_unresolved	229	1.2499999999999998e-69	NR	MCH9609760.1	2047757	g27690	i0	77.2	11.9633251833741	136	31	99.8	0	2	409	250	385	MCH9609760.1 Phosphoenolpyruvate carboxykinase [GTP] [Chlamydiales bacterium]	diamond	4893	229	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
16024146	16024146	PRJNA741997_P_NODE_59073_length_280_cov_1.251208_g57953_i0	PRJNA741997	59073	280	1.251208	3.5033824	root	1	Root_unresolved	Root_unresolved	156	1.18e-46	NR	MCB1084350.1	34094	g57953	i0	78.4	3.78214285714286	88	19	94.3	0	277	14	9	96	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	1059	157	0.993630573248408	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27084259	27084259	PRJNA741997_P_NODE_90062_length_241_cov_0.910714_g88942_i0	PRJNA741997	90062	241	0.910714	2.19482074	Chlamydiales bacterium	2047757	Bacteria	Bacteria	64.7	2.78e-10	NR	MBI5273578.1	2047757	g88942	i0	53.1	0.609958506224066	49	23	61	0	1	147	186	234	MBI5273578.1 2OG-Fe(II) oxygenase [Chlamydiales bacterium]	diamond	147	64.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27115520	27115520	PRJNA741997_P_NODE_38222_length_351_cov_1.384892_g37102_i0	PRJNA741997	38222	351	1.384892	4.86097092	Chlamydiales bacterium	2047757	Bacteria	Bacteria	119	8.14e-29	NR	MFT5050156.1	2047757	g37102	i0	49.1	2.82905982905983	110	56	94	0	338	9	259	368	MFT5050156.1 acetylornithine deacetylase/succinyl-diaminopimelate desuccinylase-like protein [Chlamydiales bacterium]	diamond	993	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27210381	27210381	PRJNA741997_P_NODE_47042_length_316_cov_0.946502_g45922_i0	PRJNA741997	47042	316	0.946502	2.99094632	Simkania sp.	34094	Bacteria	Bacteria	82	4.03e-17	NR	MCB1084323.1	34094	g45922	i0	48	0.930379746835443	98	42	93	3	294	1	29	117	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	294	82	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27337175	27337175	PRJNA741997_P_NODE_87923_length_242_cov_0.911243_g86803_i0	PRJNA741997	87923	242	0.911243	2.20520806	Simkania sp.	34094	Bacteria	Bacteria	58.9	1.86e-9	NR	MCB1084368.1	34094	g86803	i0	69.4	0.446280991735537	36	11	44.6	0	204	97	29	64	MCB1084368.1 hypothetical protein [Simkania sp.]	diamond	108	58.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27968516	27968516	PRJNA741997_P_NODE_60725_length_276_cov_1.517241_g59605_i0	PRJNA741997	60725	276	1.517241	4.18758516	Chlamydiota bacterium	2081524	Bacteria	Bacteria	48.1	5.64e-4	NR	MBM3201113.1	2081524	g59605	i0	42.6	0.58695652173913	54	31	58.7	0	264	103	114	167	MBM3201113.1 hypothetical protein [Chlamydiota bacterium]	diamond	162	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28000312	28000312	PRJNA741997_P_NODE_22445_length_476_cov_6.540943_g21327_i0	PRJNA741997	22445	476	6.540943	31.13488868	Chlamydiales bacterium	2047757	Bacteria	Bacteria	162	4.67e-48	NR	MCP5470420.1	2047757	g21327	i0	60.8	0.901260504201681	143	56	90.1	0	474	46	4	146	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	429	162	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28126511	28126511	PRJNA741997_P_NODE_79445_length_247_cov_0.885057_g78325_i0	PRJNA741997	79445	247	0.885057	2.18609079	Chlamydiales bacterium	2047757	Bacteria	Bacteria	48.5	1.98e-4	NR	MDP1609002.1	2047757	g78325	i0	38.8	0.813765182186235	67	39	80.2	2	222	25	44	109	MDP1609002.1 hypothetical protein [Chlamydiales bacterium]	diamond	201	48.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28757778	28757778	PRJNA741997_P_NODE_24387_length_453_cov_5.697368_g23267_i0	PRJNA741997	24387	453	5.697368	25.80907704	Chlamydiales bacterium	2047757	Bacteria	Bacteria	109	3.8800000000000006e-27	NR	MCP5470420.1	2047757	g23267	i0	48.8	1.60264900662252	123	62	80.8	1	452	87	2	124	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	726	109	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28789278	28789278	PRJNA741997_P_NODE_39647_length_344_cov_3.350554_g38527_i0	PRJNA741997	39647	344	3.350554	11.52590576	Chlamydiales bacterium	2047757	Bacteria	Bacteria	107	8.54e-27	NR	MCP5470420.1	2047757	g38527	i0	48.2	0.994186046511628	114	59	99.4	0	342	1	4	117	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	342	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28820703	28820703	PRJNA741997_P_NODE_36868_length_358_cov_0.933333_g35748_i0	PRJNA741997	36868	358	0.933333	3.34133214	Simkania sp.	34094	Bacteria	Bacteria	160	1.64e-46	NR	MCB1084310.1	34094	g35748	i0	67.5	0.955307262569832	114	37	95.5	0	356	15	78	191	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	342	160	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29967897	29967897	PRJNA741997_P_NODE_25211_length_444_cov_1.760108_g24091_i0	PRJNA741997	25211	444	1.760108	7.81487952	Bacteria	2	Bacteria	Bacteria	63.2	1.07e-8	NR	MBM3196163.1	2081524	g24091	i0	27.7	2.01351351351351	148	88	99.3	4	4	444	68	197	MBM3196163.1 hypothetical protein [Chlamydiota bacterium]	diamond	894	63.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30178870	30178870	PRJNA741997_P_NODE_86332_length_243_cov_0.905882_g85212_i0	PRJNA741997	86332	243	0.905882	2.20129326	Chlamydiia bacterium	2052156	Bacteria	Bacteria	61.6	8.06e-9	NR	MCB1072267.1	2052156	g85212	i0	44.8	4.22222222222222	67	36	81.5	1	30	227	528	594	MCB1072267.1 adenylyl cyclase [Chlamydiia bacterium]	diamond	1026	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32654565	32654565	PRJNA741997_P_NODE_54220_length_291_cov_1.059633_g53100_i0	PRJNA741997	54220	291	1.059633	3.08353203	Chlamydiia	204429	Bacteria	Bacteria	80.1	1.76e-15	NR	WP_098038745.1	483423	g53100	i0	43	4.82474226804124	93	50	94.8	2	276	1	148	238	WP_098038745.1 dual specificity protein phosphatase family protein [Estrella lausannensis]	diamond	1404	80.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
32833751	32833751	PRJNA741997_P_NODE_89860_length_241_cov_0.916667_g88740_i0	PRJNA741997	89860	241	0.916667	2.20916747	Chlamydiota bacterium	2081524	Bacteria	Bacteria	76.3	4.86e-14	NR	MBM3198222.1	2081524	g88740	i0	51.3	0.995850622406639	80	34	93.4	2	239	15	336	415	MBM3198222.1 hypothetical protein [Chlamydiota bacterium]	diamond	240	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32896546	32896546	PRJNA741997_P_NODE_37180_length_356_cov_1.360424_g36060_i0	PRJNA741997	37180	356	1.360424	4.84310944	Waddlia chondrophila	71667	Bacteria	Bacteria	146	1.7899999999999996e-38	NR	WP_013182645.1	71667	g36060	i0	58.5	1.89606741573034	118	49	99.4	0	354	1	2	119	WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila]	diamond	675	146	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila

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);;