metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA168635" 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
3604694	3604694	PRJNA168635_P_NODE_23943_length_171_cov_7.360656_g23527_i0	PRJNA168635	23943	171	7.360656	12.58672176	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	101	3.5399999999999995e-23	NR	MFI0478845.1	2320511	g23527	i0	96.4	0.964912280701754	55	2	96.5	0	165	1	102	156	MFI0478845.1 hypothetical protein [Candidatus Rhabdochlamydia sp.]	diamond	165	101	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.
27073879	27073879	PRJNA168635_P_NODE_31102_length_163_cov_0.912281_g30686_i0	PRJNA168635	31102	163	0.912281	1.48701803	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	47	4.09e-4	NR	MBX7065685.1	2052178	g30686	i0	38.9	0.993865030674847	54	26	86.5	1	2	142	406	459	MBX7065685.1 translocation/assembly module TamB domain-containing protein [Parachlamydiales bacterium]	diamond	162	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
27597392	27597392	PRJNA168635_P_NODE_27544_length_166_cov_22.700855_g27128_i0	PRJNA168635	27544	166	22.700855	37.6834193	PVC group	1783257	Bacteria	Bacteria	46.2	2.43e-4	NR	pir\|E81737\|	83560	g27128	i0	52.4	2.33132530120482	42	20	75.9	0	38	163	25	66	pir\|E81737\| hypothetical protein TC0128 [imported] - Chlamydia muridarum (strain Nigg) [Chlamydia muridarum]	diamond	387	46.6	0.991416309012876	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia muridarum
27863495	27863495	PRJNA168635_P_NODE_20725_length_180_cov_1.557252_g20309_i0	PRJNA168635	20725	180	1.557252	2.8030536	Parachlamydia sp. AcF125	2795736	Bacteria	Bacteria	48.1	1.72e-4	NR	WP_213157004.1	2795736	g20309	i0	72.4	1.03333333333333	29	8	48.3	0	158	72	220	248	WP_213157004.1 glycosyltransferase family 2 protein [Parachlamydia sp. AcF125]	diamond	186	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp. AcF125
28905268	28905268	PRJNA168635_P_NODE_17888_length_190_cov_1.304965_g17472_i0	PRJNA168635	17888	190	1.304965	2.4794335	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	98.6	3.53e-22	NR	MFS8563298.1	2047756	g17472	i0	72.6	0.978947368421053	62	17	97.9	0	188	3	84	145	MFS8563298.1 NAD-dependent DNA ligase LigA [Rhabdochlamydiaceae bacterium]	diamond	186	98.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29347647	29347647	PRJNA168635_P_NODE_21729_length_177_cov_1.601562_g21313_i0	PRJNA168635	21729	177	1.601562	2.83476474	Chlamydiales bacterium	2047757	Bacteria	Bacteria	70.9	1.4e-13	NR	MCP5470420.1	2047757	g21313	i0	51.7	1.96610169491525	58	28	98.3	0	3	176	2	59	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	348	70.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29505332	29505332	PRJNA168635_P_NODE_30810_length_163_cov_0.912281_g30394_i0	PRJNA168635	30810	163	0.912281	1.48701803	Waddliaceae bacterium	2026802	Bacteria	Bacteria	68.6	9.93e-12	NR	HEY4832570.1	2026802	g30394	i0	53.7	1.98773006134969	54	25	99.4	0	163	2	426	479	HEY4832570.1 alpha/beta hydrolase [Waddliaceae bacterium]	diamond	324	68.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
30295493	30295493	PRJNA168635_P_NODE_30892_length_163_cov_0.912281_g30476_i0	PRJNA168635	30892	163	0.912281	1.48701803	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	67.8	1.34e-11	NR	HEY2810543.1	2047756	g30476	i0	72	0.920245398773006	50	14	92	0	12	161	131	180	HEY2810543.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	150	67.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32508653	32508653	PRJNA168635_P_NODE_24119_length_171_cov_1.934426_g23703_i0	PRJNA168635	24119	171	1.934426	3.30786846	Parachlamydia acanthamoebae str. Hall's coccus	159254	Bacteria	Bacteria	55.1	2.3e-7	NR	EFB40215.1	159254	g23703	i0	61	1.03508771929825	59	20	100	2	171	1	24	81	EFB40215.1 hypothetical protein pah_c222o002 [Parachlamydia acanthamoebae str. Hall's coccus]	diamond	177	55.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
32634346	32634346	PRJNA168635_P_NODE_19880_length_183_cov_1.223881_g19464_i0	PRJNA168635	19880	183	1.223881	2.23970223	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	107	3.78e-25	NR	MFI0478845.1	2320511	g19464	i0	98.3	0.983606557377049	60	1	98.4	0	182	3	532	591	MFI0478845.1 hypothetical protein [Candidatus Rhabdochlamydia sp.]	diamond	180	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.

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