metadata: contig_metadata: 9 rows where bioproject = "PRJNA1262902" and tax

9 rows where bioproject = "PRJNA1262902" and tax_clade = "Bacteria candidate phyla"

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
2914224	2914224	PRJNA1262902_P_NODE_12083_length_241_cov_0.916667_g12041_i0	PRJNA1262902	12083	241	0.916667	2.20916747	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	196	9.47e-46	NTclustered	gi\|2874254017\|emb\|OY970342.1\|	2212470	g12041	i0	81.405	70.3029045643154	242	43	100	2	1	241	1829965	1829725	MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1	blastn	16943	196	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota			Candidatus Eiseniibacteriota bacterium
11842250	11842250	PRJNA1262902_P_NODE_9330_length_247_cov_0.885057_g9288_i0	PRJNA1262902	9330	247	0.885057	2.18609079	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	128	8.559999999999999e-34	NR	HTK44619.1	2052139	g9288	i0	85.2	0.983805668016194	81	12	98.4	0	245	3	15	95	HTK44619.1 aspartate kinase [Patescibacteria group bacterium]	diamond	243	128	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
15666486	15666486	PRJNA1262902_P_NODE_9953_length_246_cov_0.890173_g9911_i0	PRJNA1262902	9953	246	0.890173	2.18982558	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	111	3.61e-20	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g9911	i0	98.413	11.9146341463415	63	1	26	0	184	246	317151	317213	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	2931	111	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
27755367	27755367	PRJNA1262902_P_NODE_9664_length_246_cov_0.890173_g9622_i0	PRJNA1262902	9664	246	0.890173	2.18982558	Bacillati	1783272	Bacteria	Bacteria	137	1.95e-36	NR	HTK45926.1	2052139	g9622	i0	81.3	8.76829268292683	80	15	97.6	0	244	5	108	187	HTK45926.1 M20/M25/M40 family metallo-hydrolase [Patescibacteria group bacterium]	diamond	2157	137	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
28368656	28368656	PRJNA1262902_P_NODE_9346_length_247_cov_0.885057_g9304_i0	PRJNA1262902	9346	247	0.885057	2.18609079	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	97.8	1.4e-21	NR	HET7006138.1	2838779	g9304	i0	58	0.983805668016194	81	32	98.4	1	4	246	53	131	HET7006138.1 IS21 family transposase [Candidatus Binatia bacterium]	diamond	243	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
29631417	29631417	PRJNA1262902_P_NODE_7110_length_253_cov_1.677778_g7068_i0	PRJNA1262902	7110	253	1.677778	4.24477834	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	125	3.0299999999999996e-32	NR	HXS71503.1	2052139	g7068	i0	69	1.99209486166008	84	26	99.6	0	2	253	144	227	HXS71503.1 MBL fold metallo-hydrolase [Patescibacteria group bacterium]	diamond	504	125	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
29789450	29789450	PRJNA1262902_P_NODE_3671_length_301_cov_1.219298_g3629_i0	PRJNA1262902	3671	301	1.219298	3.67008698	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	45.8	0.00546	NR	HYH93229.1	2973664	g3629	i0	56.5	0.458471760797342	46	18	45.8	1	164	301	1	44	HYH93229.1 intradiol ring-cleavage dioxygenase [Candidatus Saccharimonadales bacterium]	diamond	138	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
31464599	31464599	PRJNA1262902_P_NODE_9916_length_246_cov_0.890173_g9874_i0	PRJNA1262902	9916	246	0.890173	2.18982558	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	137	2.1299999999999998e-39	NR	HXS69954.1	2052139	g9874	i0	87.7	0.98780487804878	81	10	98.8	0	3	245	27	107	HXS69954.1 DUF6325 family protein [Patescibacteria group bacterium]	diamond	243	137	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
32445305	32445305	PRJNA1262902_P_NODE_7939_length_250_cov_0.870056_g7897_i0	PRJNA1262902	7939	250	0.870056	2.17514	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	101	7.729999999999999e-23	NR	HSX46418.1	2052139	g7897	i0	55.4	0.996	83	37	99.6	0	1	249	282	364	HSX46418.1 hypothetical protein [Patescibacteria group bacterium]	diamond	249	101	1	Bacteria	Bacteria candidate phyla				Patescibacteria group 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);;