metadata: contig_metadata: 9 rows where bioproject = "PRJNA737474", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA737474", 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
32969909	32969909	PRJNA737474b_S_NODE_17938_length_378_cov_4.396721_g16899_i0	PRJNA737474	17938	378	4.396721	16.61960538	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	77.4	1.7e-15	NR	MDR3570671.1	2053589	g16899	i0	53.7	0.753968253968254	95	38	70.6	3	354	88	13	107	MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	285	77.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32970658	32970658	PRJNA737474e_S_NODE_13866_length_327_cov_3.877953_g12984_i0	PRJNA737474	13866	327	3.877953	12.68090631	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	57.4	6.64e-7	NR	MFA5387848.1	2053589	g12984	i0	45.3	0.486238532110092	53	29	48.6	0	165	323	12	64	MFA5387848.1 phage terminase large subunit family protein [Candidatus Paceibacterota bacterium]	diamond	159	57.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32971262	32971262	PRJNA737474f_S_NODE_32506_length_385_cov_2.903846_g31828_i0	PRJNA737474	32506	385	2.903846	11.1798071	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	114	3.47e-29	NR	HUS50249.1	2053589	g31828	i0	55.4	0.716883116883117	92	41	71.7	0	383	108	74	165	HUS50249.1 NADAR family protein [Candidatus Paceibacterota bacterium]	diamond	276	114	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
33072969	33072969	PRJNA737474f_S_NODE_123989_length_278_cov_1.585366_g123311_i0	PRJNA737474	123989	278	1.585366	4.40731748	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	86.3	3.43e-19	NR	MFA6273570.1	2053589	g123311	i0	51.3	0.863309352517986	80	39	86.3	0	241	2	17	96	MFA6273570.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	240	86.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
33089695	33089695	PRJNA737474d_S_NODE_20398_length_338_cov_4.430189_g19804_i0	PRJNA737474	20398	338	4.430189	14.97403882	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	79.7	6.76e-17	NR	MDR3572201.1	2053589	g19804	i0	83.7	0.43491124260355	49	8	43.5	0	45	191	40	88	MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	147	79.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
33106938	33106938	PRJNA737474d_S_NODE_40982_length_241_cov_2.148810_g40388_i0	PRJNA737474	40982	241	2.14881	5.1786321	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	42.4	0.0466	NR	MDR3570673.1	2053589	g40388	i0	30.5	1.0207468879668	82	54	98.3	1	3	239	246	327	MDR3570673.1 cation transporter [Candidatus Paceibacterota bacterium]	diamond	246	42.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
33125565	33125565	PRJNA737474g_S_NODE_362671_length_247_cov_0.885057_g361377_i0	PRJNA737474	362671	247	0.885057	2.18609079	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	47.4	3.43e-4	NR	MCF7864904.1	2053589	g361377	i0	60.5	0.461538461538462	38	15	46.2	0	8	121	101	138	MCF7864904.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	114	47.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
33157690	33157690	PRJNA737474d_S_NODE_12776_length_431_cov_2.768156_g12185_i0	PRJNA737474	12776	431	2.768156	11.93075236	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	72	1.67e-11	NR	HRT10800.1	2053589	g12185	i0	48.8	0.556844547563805	80	35	54.3	2	428	195	67	142	HRT10800.1 Ser-Thr-rich GPI-anchored membrane family protein [Candidatus Paceibacterota bacterium]	diamond	240	72	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
33176798	33176798	PRJNA737474g_S_NODE_307800_length_252_cov_1.273743_g306506_i0	PRJNA737474	307800	252	1.273743	3.20983236	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	82.8	2.46e-17	NR	MFA6270882.1	2053589	g306506	i0	61.3	0.892857142857143	75	26	89.3	1	3	227	120	191	MFA6270882.1 DEAD/DEAH box helicase [Candidatus Paceibacterota bacterium]	diamond	225	82.8	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);;