metadata: contig_metadata: 15 rows where bioproject = "PRJNA1123436", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJNA1123436", 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
14307969	14307969	PRJNA1123436_P_NODE_120232_length_243_cov_0.905882_g119018_i0	PRJNA1123436	120232	243	0.905882	2.20129326	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	355	1.49e-93	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g119018	i0	93.004	2	243	17	100	0	1	243	229746	229988	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	486	355	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
15056884	15056884	PRJNA1123436_P_NODE_111412_length_246_cov_0.890173_g110198_i0	PRJNA1123436	111412	246	0.890173	2.18982558	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	65.9	1.74e-10	NR	HRZ86117.1	2053589	g110198	i0	38.1	1.02439024390244	84	40	96.3	3	246	10	100	176	HRZ86117.1 DHHA1 domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	252	65.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27323135	27323135	PRJNA1123436_P_NODE_71723_length_294_cov_1.045249_g70509_i0	PRJNA1123436	71723	294	1.045249	3.07303206	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	60.1	5.39e-8	NR	MFA5936540.1	2053589	g70509	i0	41.5	0.836734693877551	82	47	82.7	1	265	23	250	331	MFA5936540.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	246	60.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27354870	27354870	PRJNA1123436_P_NODE_118643_length_244_cov_0.900585_g117429_i0	PRJNA1123436	118643	244	0.900585	2.1974274	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	54.3	3.09e-6	NR	HUC89002.1	2053589	g117429	i0	50	1.32786885245902	54	25	66.4	1	244	83	14	65	HUC89002.1 site-specific DNA-methyltransferase [Candidatus Paceibacterota bacterium]	diamond	324	54.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27765387	27765387	PRJNA1123436_P_NODE_105604_length_248_cov_0.880000_g104390_i0	PRJNA1123436	105604	248	0.88	2.1824	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	47	8.54e-5	NR	HUS48537.1	2053589	g104390	i0	61	0.495967741935484	41	16	49.6	0	126	248	1	41	HUS48537.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	123	47	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27828369	27828369	PRJNA1123436_P_NODE_121204_length_243_cov_0.905882_g119990_i0	PRJNA1123436	121204	243	0.905882	2.20129326	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	89	1.23e-18	NR	MFA5715013.1	2053589	g119990	i0	53.2	2.95061728395062	79	37	97.5	0	2	238	18	96	MFA5715013.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	717	89	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28238597	28238597	PRJNA1123436_P_NODE_17726_length_638_cov_1.368142_g16536_i0	PRJNA1123436	17726	638	1.368142	8.72874596	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	83.6	1.27e-15	NR	MFA6251563.1	2053589	g16536	i0	44.6	0.945141065830721	101	56	47.5	0	332	634	3	103	MFA6251563.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	603	83.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28491477	28491477	PRJNA1123436_P_NODE_122487_length_242_cov_1.289941_g121273_i0	PRJNA1123436	122487	242	1.289941	3.12165722	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	101	9.31e-23	NR	HSA03374.1	2053589	g121273	i0	70.9	1.95867768595041	79	23	97.9	0	239	3	396	474	HSA03374.1 immunoglobulin domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	474	101	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29186212	29186212	PRJNA1123436_P_NODE_104649_length_248_cov_0.880000_g103435_i0	PRJNA1123436	104649	248	0.88	2.1824	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	128	3.5799999999999997e-35	NR	MFA6315604.1	2053589	g103435	i0	69.6	0.955645161290323	79	24	95.6	0	3	239	20	98	MFA6315604.1 7-carboxy-7-deazaguanine synthase QueE [Candidatus Paceibacterota bacterium]	diamond	237	128	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29186254	29186254	PRJNA1123436_P_NODE_96929_length_251_cov_0.865169_g95715_i0	PRJNA1123436	96929	251	0.865169	2.17157419	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	80.9	1.53e-15	NR	HEY6019682.1	2053589	g95715	i0	51.2	1.00398406374502	84	39	99.2	2	251	3	3	85	HEY6019682.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	252	80.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29406966	29406966	PRJNA1123436_P_NODE_101569_length_249_cov_0.875000_g100355_i0	PRJNA1123436	101569	249	0.875	2.17875	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.5	3.49e-10	NR	HEX4104023.1	2053589	g100355	i0	57.6	0.710843373493976	59	25	71.1	0	190	14	8	66	HEX4104023.1 methyltransferase domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	177	63.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30638840	30638840	PRJNA1123436_P_NODE_95613_length_251_cov_0.865169_g94399_i0	PRJNA1123436	95613	251	0.865169	2.17157419	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	44.7	0.00355	NR	HMA77698.1	2053589	g94399	i0	59.5	0.50199203187251	42	15	47.8	1	240	121	100	141	HMA77698.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	126	44.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31618793	31618793	PRJNA1123436_P_NODE_103136_length_249_cov_0.875000_g101922_i0	PRJNA1123436	103136	249	0.875	2.17875	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	64.7	7.28e-10	NR	MEZ0287009.1	2053589	g101922	i0	56.3	1.5421686746988	64	27	75.9	1	2	190	217	280	MEZ0287009.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Paceibacterota bacterium]	diamond	384	64.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32725448	32725448	PRJNA1123436_P_NODE_115000_length_245_cov_0.895349_g113786_i0	PRJNA1123436	115000	245	0.895349	2.19360505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	48.9	2.34e-4	NR	MBP9856074.1	2053589	g113786	i0	43.5	0.759183673469388	62	32	72.2	1	179	3	5	66	MBP9856074.1 FAD-dependent thymidylate synthase [Candidatus Paceibacterota bacterium]	diamond	186	48.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32882714	32882714	PRJNA1123436_P_NODE_122980_length_242_cov_0.911243_g121766_i0	PRJNA1123436	122980	242	0.911243	2.20520806	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	105	3.0799999999999994e-24	NR	HUS50809.1	2053589	g121766	i0	73	0.91735537190082606	74	20	91.7	0	224	3	185	258	HUS50809.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	222	105	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);;