metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1195374" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1195374" 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
14350201	14350201	PRJNA1195374_P_NODE_1872_length_1313_cov_3.200000_g1713_i0	PRJNA1195374	1872	1313	3.2	42.016	Bacteria	2	Bacteria	Bacteria	527	1.0799999999999995e-180	NR	WP_013182645.1	71667	g1713	i0	60.7	69.8545316070068	399	153	91.2	3	1	1197	210	604	WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila]	diamond	91719	530	0.994339622641509	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
27249438	27249438	PRJNA1195374_P_NODE_29483_length_417_cov_1.787791_g29139_i0	PRJNA1195374	29483	417	1.787791	7.45508847	Candidatus Neptunichlamydia	1891669	Bacteria	Bacteria	87	8.72e-20	NR	WP_194847558.1	1651774	g29139	i0	76.9	2.58992805755396	52	12	37.4	0	170	15	1	52	WP_194847558.1 small basic protein [Candidatus Neptunochlamydia vexilliferae]	diamond	1080	87	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia vexilliferae
29219976	29219976	PRJNA1195374_P_NODE_8189_length_762_cov_9.200290_g7881_i0	PRJNA1195374	8189	762	9.20029	70.1062098	Chlamydiia bacterium	2052156	Bacteria	Bacteria	68.9	4.73e-10	NR	MCB1136078.1	2052156	g7881	i0	49.2	0.255905511811024	65	33	25.6	0	315	509	131	195	MCB1136078.1 U-box domain-containing protein [Chlamydiia bacterium]	diamond	195	68.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30262236	30262236	PRJNA1195374_P_NODE_44212_length_334_cov_0.885057_g43868_i0	PRJNA1195374	44212	334	0.885057	2.95609038	Chlamydiales bacterium	2047757	Bacteria	Bacteria	54.7	5.34e-6	NR	MBN9377724.1	2047757	g43868	i0	34.8	0.592814371257485	66	42	58.4	1	9	203	220	285	MBN9377724.1 hypothetical protein [Chlamydiales bacterium]	diamond	198	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31399810	31399810	PRJNA1195374_P_NODE_48976_length_315_cov_1.066116_g48632_i0	PRJNA1195374	48976	315	1.066116	3.3582654	Chlamydiales bacterium	2047757	Bacteria	Bacteria	46.6	0.00202	NR	MFT5051550.1	2047757	g48632	i0	41.5	0.619047619047619	65	30	61.9	2	5	199	123	179	MFT5051550.1 hypothetical protein [Chlamydiales bacterium]	diamond	195	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31418591	31418591	PRJNA1195374_P_NODE_84216_length_241_cov_1.827381_g83872_i0	PRJNA1195374	84216	241	1.827381	4.40398821	Chlamydiia	204429	Bacteria	Bacteria	45.1	0.00539	NR	OGN64811.1	1797605	g83872	i0	48.9	2.15352697095436	45	21	56	1	223	89	320	362	OGN64811.1 MAG: hypothetical protein A3E80_04950 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9]	diamond	519	45.4	0.993392070484582	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9
31557966	31557966	PRJNA1195374_P_NODE_23396_length_469_cov_3.207071_g23052_i0	PRJNA1195374	23396	469	3.207071	15.04116299	Chlamydiales bacterium	2047757	Bacteria	Bacteria	137	3.13e-38	NR	MCP5470420.1	2047757	g23052	i0	89	0.466950959488273	73	8	46.7	0	469	251	2	74	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	219	137	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32095515	32095515	PRJNA1195374_P_NODE_29078_length_420_cov_1.896254_g28734_i0	PRJNA1195374	29078	420	1.896254	7.9642668	Simkania sp.	34094	Bacteria	Bacteria	118	9.08e-30	NR	MCB1084310.1	34094	g28734	i0	74.4	0.557142857142857	78	20	55.7	0	3	236	95	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	234	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32570412	32570412	PRJNA1195374_P_NODE_27139_length_436_cov_0.848485_g26795_i0	PRJNA1195374	27139	436	0.848485	3.6993946	Chlamydiales bacterium	2047757	Bacteria	Bacteria	132	1.04e-32	NR	MFT4553130.1	2047757	g26795	i0	47.2	2.75229357798165	144	68	99.1	2	3	434	1085	1220	MFT4553130.1 malate synthase [Chlamydiales bacterium]	diamond	1200	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32570417	32570417	PRJNA1195374_P_NODE_31619_length_402_cov_1.161094_g31275_i0	PRJNA1195374	31619	402	1.161094	4.66759788	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	52.8	6.02e-5	NR	HEY2810417.1	2047756	g31275	i0	28.4	0.865671641791045	116	77	86.6	1	2	349	128	237	HEY2810417.1 class I SAM-dependent methyltransferase [Rhabdochlamydiaceae bacterium]	diamond	348	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32759110	32759110	PRJNA1195374_P_NODE_7400_length_794_cov_2.568655_g7098_i0	PRJNA1195374	7400	794	2.568655	20.3951207	Simkania sp.	34094	Bacteria	Bacteria	257	1.96e-82	NR	MCB1084310.1	34094	g7098	i0	74.4	0.649874055415617	172	44	65	0	737	222	1	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	516	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania 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);;