metadata: contig_metadata: 13 rows where bioproject = "PRJNA1174234" and tax

13 rows where bioproject = "PRJNA1174234" 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
18167660	18167660	PRJNA1174234_P_NODE_1335_length_1031_cov_5.630480_g1211_i0	PRJNA1174234	1335	1031	5.63048	58.0502488	Simkania sp.	34094	Bacteria	Bacteria	283	2.28e-91	NR	MCB1084310.1	34094	g1211	i0	69.9	0.570320077594568	196	59	57	0	749	162	1	196	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	588	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27388399	27388399	PRJNA1174234_P_NODE_24383_length_279_cov_1.082524_g24187_i0	PRJNA1174234	24383	279	1.082524	3.02024196	Simkania sp.	34094	Bacteria	Bacteria	64.3	1.89e-10	NR	MCB1084323.1	34094	g24187	i0	43.2	0.795698924731183	74	41	78.5	1	60	278	39	112	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	222	64.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28177308	28177308	PRJNA1174234_P_NODE_11426_length_408_cov_2.773134_g11230_i0	PRJNA1174234	11426	408	2.773134	11.31438672	Chlamydiales bacterium	2047757	Bacteria	Bacteria	85.5	4.87e-18	NR	MCP5470420.1	2047757	g11230	i0	80.4	0.375	51	10	37.5	0	406	254	29	79	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	153	85.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28366867	28366867	PRJNA1174234_P_NODE_14066_length_367_cov_1.299320_g13870_i0	PRJNA1174234	14066	367	1.29932	4.7685044	Simkania sp.	34094	Bacteria	Bacteria	97.1	2.0099999999999994e-23	NR	MCB1084366.1	34094	g13870	i0	92.3	0.425068119891008	52	4	42.5	0	158	3	1	52	MCB1084366.1 hypothetical protein [Simkania sp.]	diamond	156	97.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28682942	28682942	PRJNA1174234_P_NODE_20787_length_303_cov_1.100000_g20591_i0	PRJNA1174234	20787	303	1.1	3.333	Chlamydiia bacterium	2052156	Bacteria	Bacteria	47.8	6.01e-4	NR	MBI3900844.1	2052156	g20591	i0	46.8	0.930693069306931	47	25	46.5	0	166	26	15	61	MBI3900844.1 hypothetical protein [Chlamydiia bacterium]	diamond	282	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
28998880	28998880	PRJNA1174234_P_NODE_34908_length_242_cov_0.911243_g34712_i0	PRJNA1174234	34908	242	0.911243	2.20520806	Simkania sp.	34094	Bacteria	Bacteria	62.8	9.2e-11	NR	MCB1084315.1	34094	g34712	i0	93.3	0.371900826446281	30	2	37.2	0	91	2	1	30	MCB1084315.1 hypothetical protein [Simkania sp.]	diamond	90	62.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29250897	29250897	PRJNA1174234_P_NODE_16069_length_344_cov_3.346863_g15873_i0	PRJNA1174234	16069	344	3.346863	11.51320872	Chlamydiales bacterium	2047757	Bacteria	Bacteria	186	4.41e-58	NR	MCP5470420.1	2047757	g15873	i0	81.8	0.959302325581395	110	20	95.9	0	330	1	1	110	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	330	186	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30293699	30293699	PRJNA1174234_P_NODE_18292_length_322_cov_1.514056_g18096_i0	PRJNA1174234	18292	322	1.514056	4.87526032	Chlamydiia bacterium	2052156	Bacteria	Bacteria	73.9	4.29e-13	NR	MCB1113705.1	2052156	g18096	i0	45.2	0.968944099378882	104	50	96.9	3	314	3	182	278	MCB1113705.1 dimethylargininase [Chlamydiia bacterium]	diamond	312	73.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30325492	30325492	PRJNA1174234_P_NODE_9012_length_459_cov_8.787565_g8816_i0	PRJNA1174234	9012	459	8.787565	40.33492335	Chlamydiales bacterium	2047757	Bacteria	Bacteria	223	5.069999999999999e-72	NR	MCP5470420.1	2047757	g8816	i0	78.9	0.96078431372549	147	31	96.1	0	447	7	1	147	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	441	223	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30546060	30546060	PRJNA1174234_P_NODE_10033_length_435_cov_2.397790_g9837_i0	PRJNA1174234	10033	435	2.39779	10.4303865	Chlamydiales bacterium	2047757	Bacteria	Bacteria	212	6.51e-68	NR	MCP5470420.1	2047757	g9837	i0	76.4	0.993103448275862	144	34	99.3	0	434	3	2	145	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	432	212	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30925496	30925496	PRJNA1174234_P_NODE_8094_length_483_cov_1.907317_g7898_i0	PRJNA1174234	8094	483	1.907317	9.21234111	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	61.6	1.35e-8	NR	WP_051981753.1	389348	g7898	i0	38.3	1.81366459627329	94	55	57.8	2	339	61	54	145	WP_051981753.1 SET domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	876	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
30988565	30988565	PRJNA1174234_P_NODE_29694_length_250_cov_0.870056_g29498_i0	PRJNA1174234	29694	250	0.870056	2.17514	Chlamydiales bacterium	2047757	Bacteria	Bacteria	44.3	0.00178	NR	MCP5470428.1	2047757	g29498	i0	38.6	0.84	70	40	82.8	2	247	41	12	79	MCP5470428.1 hypothetical protein [Chlamydiales bacterium]	diamond	210	44.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31304463	31304463	PRJNA1174234_P_NODE_5475_length_578_cov_1.615842_g5280_i0	PRJNA1174234	5475	578	1.615842	9.33956676	Chlamydiales bacterium	2047757	Bacteria	Bacteria	47	0.017	NR	MFN0064848.1	2047757	g5280	i0	34.3	0.513840830449827	99	61	50.3	3	542	252	87	183	MFN0064848.1 toxin-antitoxin system YwqK family antitoxin [Chlamydiales bacterium]	diamond	297	47	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);;