metadata: contig_metadata: 10 rows where bioproject = "PRJNA560932", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA560932", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"

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_phylum	tax_class	tax_order	tax_species
26984061	26984061	PRJNA560932_P_NODE_35062_length_307_cov_1.102564_g34706_i0	PRJNA560932	35062	307	1.102564	3.38487148	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	45.1	0.0113	NR	MEX0918776.1	2053589	g34706	i0	34.9	0.811074918566775	83	54	81.1	0	268	20	145	227	MEX0918776.1 AI-2E family transporter [Candidatus Paceibacterota bacterium]	diamond	249	45.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
27426878	27426878	PRJNA560932_P_NODE_42683_length_279_cov_3.500000_g42327_i0	PRJNA560932	42683	279	3.5	9.765	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	62	9.17e-9	NR	HWO07132.1	2053589	g42327	i0	42.7	0.806451612903226	75	35	72	2	231	31	192	266	HWO07132.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	225	62	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
28658226	28658226	PRJNA560932_P_NODE_8407_length_599_cov_2.049430_g8054_i0	PRJNA560932	8407	599	2.04943	12.2760857	Candidatus Spechtbacterales bacterium	3085100	Bacteria	Bacteria	63.9	4.7e-8	NR	MEX0869853.1	3085100	g8054	i0	43.6	2.2787979966611	78	41	37.6	1	235	11	377	454	MEX0869853.1 chaperonin GroEL [Candidatus Spechtbacterales bacterium]	diamond	1365	63.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Candidatus Spechtbacterales	Candidatus Spechtbacterales bacterium
28878959	28878959	PRJNA560932_P_NODE_37028_length_299_cov_0.893805_g36672_i0	PRJNA560932	37028	299	0.893805	2.67247695	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	76.3	9.84e-16	NR	MDR3572201.1	2053589	g36672	i0	77.6	0.491638795986622	49	11	49.2	0	10	156	40	88	MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	147	76.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
29068741	29068741	PRJNA560932_P_NODE_9188_length_574_cov_2.453094_g8835_i0	PRJNA560932	9188	574	2.453094	14.08075956	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	71.2	7.82e-13	NR	HRH31009.1	2053589	g8835	i0	73.8	0.219512195121951	42	11	22	0	97	222	1	42	HRH31009.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	126	71.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
30805770	30805770	PRJNA560932_P_NODE_48994_length_260_cov_1.235294_g48638_i0	PRJNA560932	48994	260	1.235294	3.2117644	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	64.3	1.13e-9	NR	MFB6226163.1	3120121	g48638	i0	36.4	0.761538461538461	66	41	75	1	3	197	403	468	MFB6226163.1 lipase maturation factor family protein [Minisyncoccia bacterium]	diamond	198	64.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia		Minisyncoccia bacterium
31152902	31152902	PRJNA560932_P_NODE_53255_length_250_cov_1.542373_g52899_i0	PRJNA560932	53255	250	1.542373	3.8559325	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	89	2.6e-20	NR	HIP21689.1	2053589	g52899	i0	64.7	5.676	68	23	80.4	1	247	47	50	117	HIP21689.1 RNB domain-containing ribonuclease [Candidatus Paceibacterota bacterium]	diamond	1419	89	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
32070529	32070529	PRJNA560932_P_NODE_41838_length_282_cov_1.473684_g41482_i0	PRJNA560932	41838	282	1.473684	4.15578888	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	141	8.54e-39	NR	MFA5831000.1	2053589	g41482	i0	73	17.0744680851064	89	24	94.7	0	1	267	161	249	MFA5831000.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Paceibacterota bacterium]	diamond	4815	141	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
32450501	32450501	PRJNA560932_P_NODE_61119_length_245_cov_0.895349_g60763_i0	PRJNA560932	61119	245	0.895349	2.19360505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	41.2	0.0448	NR	MDR3570671.1	2053589	g60763	i0	42.6	0.83265306122449	68	32	74.7	2	3	185	41	108	MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	204	41.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
32545417	32545417	PRJNA560932_P_NODE_49179_length_259_cov_1.655914_g48823_i0	PRJNA560932	49179	259	1.655914	4.28881726	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	53.5	6.98e-6	NR	MDR3547381.1	2053589	g48823	i0	36.4	4.23938223938224	55	35	63.7	0	20	184	92	146	MDR3547381.1 trypsin-like serine protease [Candidatus Paceibacterota bacterium]	diamond	1098	53.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota 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);;