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

10 rows where bioproject = "PRJNA498309", 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_species
14509539	14509539	PRJNA498309_P_NODE_42612_length_420_cov_2.261097_g40495_i0	PRJNA498309	42612	420	2.261097	9.4966074	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	252	6.76e-76	NR	HYF29176.1	2053589	g40495	i0	96.3	0.957142857142857	134	5	95.7	0	404	3	272	405	HYF29176.1 AAA family ATPase [Candidatus Paceibacterota bacterium]	diamond	402	252	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27645907	27645907	PRJNA498309_P_NODE_31064_length_508_cov_28.602972_g29054_i0	PRJNA498309	31064	508	28.602972	145.30309776000001	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.5	3.45e-8	NR	MDD3007061.1	2053589	g29054	i0	31.7	1.40551181102362	126	59	66.7	5	452	114	1309	1420	MDD3007061.1 LamG domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	714	63.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29508506	29508506	PRJNA498309_P_NODE_70330_length_284_cov_8.651822_g68181_i0	PRJNA498309	70330	284	8.651822	24.57117448	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.1	0.0455	NR	MFA5086690.1	2053589	g68181	i0	35.9	0.676056338028169	64	41	67.6	0	217	26	804	867	MFA5086690.1 DUF2341 domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	192	43.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29792542	29792542	PRJNA498309_P_NODE_106091_length_180_cov_15.895105_g103942_i0	PRJNA498309	106091	180	15.895105	28.611189	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	48.9	7.99e-5	NR	MDD4804787.1	2053589	g103942	i0	40	0.916666666666667	55	32	90	1	167	6	33	87	MDD4804787.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	165	48.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31752072	31752072	PRJNA498309_P_NODE_94957_length_206_cov_3.946746_g92808_i0	PRJNA498309	94957	206	3.946746	8.13029676	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	83.6	5.78e-18	NR	MFA6608748.1	2053589	g92808	i0	59	0.888349514563107	61	25	88.8	0	204	22	67	127	MFA6608748.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	183	83.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31783644	31783644	PRJNA498309_P_NODE_109297_length_174_cov_1.751825_g107148_i0	PRJNA498309	109297	174	1.751825	3.0481755	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	55.5	8.63e-8	NR	MFA5841482.1	2053589	g107148	i0	76.5	0.586206896551724	34	8	58.6	0	108	7	70	103	MFA5841482.1 HIT family protein [Candidatus Paceibacterota bacterium]	diamond	102	55.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31973597	31973597	PRJNA498309_P_NODE_106178_length_180_cov_3.048951_g104029_i0	PRJNA498309	106178	180	3.048951	5.4881118	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	101	1.42e-23	NR	HEY9583786.1	2053589	g104029	i0	78.3	1	60	13	100	0	1	180	304	363	HEY9583786.1 MFS transporter [Candidatus Paceibacterota bacterium]	diamond	180	101	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32131977	32131977	PRJNA498309_P_NODE_26598_length_556_cov_9.649326_g24640_i0	PRJNA498309	26598	556	9.649326	53.65025256	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	125	2.93e-32	NR	MFA6408490.1	2053589	g24640	i0	56.6	1.68884892086331	113	46	61	1	117	455	94	203	MFA6408490.1 peptidoglycan-binding domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	939	125	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32511844	32511844	PRJNA498309_P_NODE_87079_length_228_cov_3.738220_g84930_i0	PRJNA498309	87079	228	3.73822	8.5231416	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	126	2.4e-33	NR	MFA5433179.1	2053589	g84930	i0	98.5	0.881578947368421	67	1	88.2	0	201	1	1	67	MFA5433179.1 DUF3644 domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	201	126	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32841988	32841988	PRJNA498309_P_NODE_119960_length_155_cov_1.601695_g117811_i0	PRJNA498309	119960	155	1.601695	2.48262725	Bacteria	2	Bacteria	Bacteria	83.2	5.57e-17	NR	MBP7770396.1	2053589	g117811	i0	68.8	3.75483870967742	48	15	92.9	0	147	4	385	432	MBP7770396.1 FAD-binding oxidoreductase [Candidatus Paceibacterota bacterium]	diamond	582	83.2	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);;