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

10 rows where bioproject = "PRJNA1067370", 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
28448663	28448663	PRJNA1067370_P_NODE_105246_length_244_cov_0.900585_g104697_i0	PRJNA1067370	105246	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	104	1.7e-26	NR	HEY0908476.1	2053589	g104697	i0	74	2.69262295081967	73	19	89.8	0	1	219	60	132	HEY0908476.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	657	104	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28678004	28678004	PRJNA1067370_P_NODE_87007_length_249_cov_0.875000_g86458_i0	PRJNA1067370	87007	249	0.875	2.17875	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	70.5	7e-12	NR	MDR3582278.1	2053589	g86458	i0	58.9	0.879518072289157	73	30	88	0	219	1	404	476	MDR3582278.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	219	70.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29056885	29056885	PRJNA1067370_P_NODE_9888_length_577_cov_1.527778_g9350_i0	PRJNA1067370	9888	577	1.527778	8.81527906	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	83.6	2.46e-17	NR	MDR3572201.1	2053589	g9350	i0	68.2	0.441941074523397	85	19	40	1	564	334	4	88	MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	255	83.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29782898	29782898	PRJNA1067370_P_NODE_37151_length_328_cov_1.494118_g36603_i0	PRJNA1067370	37151	328	1.494118	4.90070704	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	177	2.0699999999999993e-55	NR	MBP6924386.1	2053589	g36603	i0	97.8	0.841463414634146	92	2	84.1	0	307	32	1	92	MBP6924386.1 50S ribosomal protein L27 [Candidatus Paceibacterota bacterium]	diamond	276	177	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30130068	30130068	PRJNA1067370_P_NODE_63052_length_275_cov_1.455446_g62503_i0	PRJNA1067370	63052	275	1.455446	4.0024765	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	95.5	5.59e-23	NR	MFA6050687.1	2053589	g62503	i0	57	0.861818181818182	79	34	86.2	0	264	28	1	79	MFA6050687.1 preprotein translocase subunit SecE [Candidatus Paceibacterota bacterium]	diamond	237	95.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30383589	30383589	PRJNA1067370_P_NODE_48513_length_300_cov_1.017621_g47965_i0	PRJNA1067370	48513	300	1.017621	3.052863	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.9	0.00649	NR	HSE56470.1	2053589	g47965	i0	58.1	0.43	43	14	40	2	1	120	64	105	HSE56470.1 RNA-binding protein [Candidatus Paceibacterota bacterium]	diamond	129	43.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30572505	30572505	PRJNA1067370_P_NODE_53413_length_290_cov_0.972350_g52864_i0	PRJNA1067370	53413	290	0.97235	2.819815	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	72.8	3.17e-14	NR	MFA6049910.1	2053589	g52864	i0	50	1.48965517241379	76	35	75.5	1	3	221	27	102	MFA6049910.1 cyclic-phosphate processing receiver domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	432	72.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30762313	30762313	PRJNA1067370_P_NODE_100234_length_245_cov_0.895349_g99685_i0	PRJNA1067370	100234	245	0.895349	2.19360505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	120	5.36e-30	NR	MBP9842929.1	2053589	g99685	i0	92.2	1.56734693877551	64	5	78.4	0	52	243	183	246	MBP9842929.1 YifB family Mg chelatase-like AAA ATPase [Candidatus Paceibacterota bacterium]	diamond	384	120	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31109761	31109761	PRJNA1067370_P_NODE_93435_length_247_cov_0.885057_g92886_i0	PRJNA1067370	93435	247	0.885057	2.18609079	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	145	1.57e-39	NR	MBP6924089.1	2053589	g92886	i0	93.9	0.995951417004049	82	5	99.6	0	247	2	151	232	MBP6924089.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Candidatus Paceibacterota bacterium]	diamond	246	145	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32659098	32659098	PRJNA1067370_P_NODE_101820_length_245_cov_0.895349_g101271_i0	PRJNA1067370	101820	245	0.895349	2.19360505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	41.6	0.0279	NR	MDD5639566.1	2053589	g101271	i0	33.3	0.697959183673469	57	32	62.4	1	50	202	33	89	MDD5639566.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	171	41.6	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);;