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

10 rows where analysis = "diamond", bioproject = "PRJNA752572" 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
10932649	10932649	PRJNA752572_P_NODE_5629_length_1017_cov_27.173116_g5391_i0	PRJNA752572	5629	1017	27.173116	276.35058972	Simkania sp.	34094	Bacteria	Bacteria	283	1.92e-91	NR	MCB1084310.1	34094	g5391	i0	69.9	0.578171091445428	196	59	57.8	0	276	863	1	196	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	588	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27274150	27274150	PRJNA752572_P_NODE_201243_length_187_cov_3.414474_g200736_i0	PRJNA752572	201243	187	3.414474	6.38506638	Simkania sp.	34094	Bacteria	Bacteria	50.1	2.34e-6	NR	MCB1084371.1	34094	g200736	i0	60.5	0.609625668449198	38	15	61	0	5	118	10	47	MCB1084371.1 hypothetical protein [Simkania sp.]	diamond	114	50.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27347402	27347402	PRJNA752572_P_NODE_12303_length_746_cov_2.495077_g11931_i0	PRJNA752572	12303	746	2.495077	18.61327442	root	1	Root_unresolved	Root_unresolved	158	7.51e-46	NR	MCB1084315.1	34094	g11931	i0	88.2	1.07774798927614	85	10	34.2	0	696	442	1	85	MCB1084315.1 hypothetical protein [Simkania sp.]	diamond	804	158	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27621693	27621693	PRJNA752572_P_NODE_267084_length_164_cov_1.542636_g266577_i0	PRJNA752572	267084	164	1.542636	2.52992304	Simkania sp.	34094	Bacteria	Bacteria	52.8	1.23e-6	NR	MCB1084323.1	34094	g266577	i0	62.9	0.640243902439024	35	13	64	0	164	60	87	121	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	105	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27716649	27716649	PRJNA752572_P_NODE_262084_length_165_cov_2.861538_g261577_i0	PRJNA752572	262084	165	2.861538	4.7215377	Chlamydiota bacterium	2081524	Bacteria	Bacteria	80.9	4.58e-16	NR	MEI6531958.1	2081524	g261577	i0	62.5	2.03636363636364	56	20	100	1	1	165	342	397	MEI6531958.1 saccharopine dehydrogenase C-terminal domain-containing protein [Chlamydiota bacterium]	diamond	336	80.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28852729	28852729	PRJNA752572_P_NODE_30428_length_494_cov_8.383442_g29942_i0	PRJNA752572	30428	494	8.383442	41.41420348	Chlamydiales bacterium	2047757	Bacteria	Bacteria	197	1.7499999999999998e-61	NR	MCP5470420.1	2047757	g29942	i0	78.4	0.759109311740891	125	27	75.9	0	489	115	1	125	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	375	197	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30147405	30147405	PRJNA752572_P_NODE_92212_length_282_cov_1.647773_g91705_i0	PRJNA752572	92212	282	1.647773	4.64671986	Simkania sp.	34094	Bacteria	Bacteria	101	5.07e-26	NR	MCB1084314.1	34094	g91705	i0	87.9	0.617021276595745	58	7	61.7	0	181	8	1	58	MCB1084314.1 hypothetical protein [Simkania sp.]	diamond	174	101	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31095451	31095451	PRJNA752572_P_NODE_39515_length_435_cov_3.027500_g39010_i0	PRJNA752572	39515	435	3.0275	13.169625	Chlamydiales bacterium	2047757	Bacteria	Bacteria	150	2.91e-43	NR	MCP5470421.1	2047757	g39010	i0	69.8	2.17931034482759	106	32	73.1	0	433	116	32	137	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	948	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31633025	31633025	PRJNA752572_P_NODE_27236_length_522_cov_10.895277_g26761_i0	PRJNA752572	27236	522	10.895277	56.87334594	Chlamydiales bacterium	2047757	Bacteria	Bacteria	139	2.0199999999999998e-38	NR	MCP5470420.1	2047757	g26761	i0	81	0.454022988505747	79	15	45.4	0	9	245	1	79	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	237	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31822713	31822713	PRJNA752572_P_NODE_18537_length_624_cov_4.991511_g18104_i0	PRJNA752572	18537	624	4.991511	31.14702864	Simkania sp.	34094	Bacteria	Bacteria	53.9	5.12e-6	NR	MCB1084365.1	34094	g18104	i0	45.5	0.264423076923077	55	30	26.4	0	83	247	21	75	MCB1084365.1 hypothetical protein [Simkania sp.]	diamond	165	53.9	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);;