metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA358009" 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_family	tax_genus	tax_species
26663046	26663046	PRJNA358009_P_NODE_9521_length_185_cov_5.823529_g9452_i0	PRJNA358009	9521	185	5.823529	10.77352865	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	100	4.48e-24	NR	MEO5690616.1	2973664	g9452	i0	88.1	0.956756756756757	59	7	95.7	0	185	9	165	223	MEO5690616.1 undecaprenyl-diphosphate phosphatase [Candidatus Saccharimonadales bacterium]	diamond	177	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27612043	27612043	PRJNA358009_P_NODE_10924_length_177_cov_2.203125_g10855_i0	PRJNA358009	10924	177	2.203125	3.89953125	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	107	3.56e-27	NR	OJU87671.1	1895829	g10855	i0	100	3.79661016949153	56	0	94.9	0	8	175	57	112	OJU87671.1 MAG: 30S ribosomal protein S3 [Candidatus Saccharibacteria bacterium 49-20]	diamond	672	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
27629251	27629251	PRJNA358009_P_NODE_11364_length_174_cov_5.192000_g11295_i0	PRJNA358009	11364	174	5.192	9.03408	Bacillati	1783272	Bacteria	Bacteria	69.7	4.69e-12	NR	MFN8626087.1	2838779	g11295	i0	73.5	5.05172413793103	49	13	84.5	0	153	7	2255	2303	MFN8626087.1 SdrD B-like domain-containing protein [Candidatus Binatia bacterium]	diamond	879	69.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27707088	27707088	PRJNA358009_P_NODE_18004_length_153_cov_6.990385_g17935_i0	PRJNA358009	18004	153	6.990385	10.69528905	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	51.6	7.98e-6	NR	NTW90069.1	2045217	g17935	i0	81.3	0.627450980392157	32	6	62.7	0	145	50	95	126	NTW90069.1 hypothetical protein [Candidatus Moraniibacteriota bacterium]	diamond	96	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
28355182	28355182	PRJNA358009_P_NODE_8366_length_199_cov_3.646667_g8297_i0	PRJNA358009	8366	199	3.646667	7.25686733	Bacteria	2	Bacteria	Bacteria	100	1.27e-22	NR	KKR49263.1	1619047	g8297	i0	73	15.4371859296482	63	17	95	0	194	6	1010	1072	KKR49263.1 MAG: hypothetical protein UT86_C0001G0235 [Candidatus Magasanikbacteria bacterium GW2011_GWC2_40_17]	diamond	3072	101	0.99009900990099	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikbacteria bacterium GW2011_GWC2_40_17
28513124	28513124	PRJNA358009_P_NODE_16107_length_161_cov_2.928571_g16038_i0	PRJNA358009	16107	161	2.928571	4.71499931	Candidatus Nanosynsacchari	2789662	Bacteria	Bacteria	48.9	2.41e-5	NR	WP_129693305.1	1986206	g16038	i0	71	1.77018633540373	31	9	57.8	0	66	158	1	31	WP_129693305.1 Holliday junction resolvase RuvX [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	285	49.3	0.991886409736308	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
28685639	28685639	PRJNA358009_P_NODE_11667_length_173_cov_2.048387_g11598_i0	PRJNA358009	11667	173	2.048387	3.54370951	Parcubacteria group bacterium GW2	2026774	Bacteria	Bacteria	69.7	4.44e-12	NR	KKQ87669.1	1618961	g11598	i0	83.3	10.3352601156069	42	7	72.8	0	173	48	141	182	KKQ87669.1 MAG: hypothetical protein UT09_C0011G0005 [Parcubacteria group bacterium GW2011_GWF2_38_8]	diamond	1788	69.7	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWF2_38_8
28811435	28811435	PRJNA358009_P_NODE_4788_length_327_cov_1.985612_g4725_i0	PRJNA358009	4788	327	1.985612	6.49295124	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	94.4	6.68e-20	NR	MES2630352.1	2052139	g4725	i0	50.5	7.77981651376147	107	15	98.2	1	2	322	376	444	MES2630352.1 RelA/SpoT family protein [Patescibacteria group bacterium]	diamond	2544	94.4	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29839193	29839193	PRJNA358009_P_NODE_13551_length_166_cov_0.871795_g13482_i0	PRJNA358009	13551	166	0.871795	1.4471797	Pseudomonadati	3379134	Bacteria	Bacteria	72.8	2.08e-13	NR	OGB93077.1	1801658	g13482	i0	66	11.4939759036145	53	18	95.8	0	2	160	44	96	OGB93077.1 MAG: hypothetical protein A3H39_13795 [candidate division NC10 bacterium RIFCSPLOWO2_02_FULL_66_22]	diamond	1908	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					candidate division NC10 bacterium RIFCSPLOWO2_02_FULL_66_22

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);;