metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA356682" 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_species
28022541	28022541	PRJNA356682_P_NODE_25865_length_289_cov_1.425926_g25174_i0	PRJNA356682	25865	289	1.425926	4.12092614	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	123	5.82e-31	NR	MCA9334474.1	2026720	g25174	i0	78.7	0.778546712802768	75	16	77.9	0	1	225	378	452	MCA9334474.1 immunoglobulin domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	225	123	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
29096037	29096037	PRJNA356682_P_NODE_42728_length_243_cov_0.905882_g42037_i0	PRJNA356682	42728	243	0.905882	2.20129326	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	45.8	0.00281	NR	MCA9365182.1	2045217	g42037	i0	40	0.617283950617284	50	30	61.7	0	151	2	52	101	MCA9365182.1 hypothetical protein [Candidatus Moraniibacteriota bacterium]	diamond	150	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
29270739	29270739	PRJNA356682_P_NODE_38849_length_248_cov_0.880000_g38158_i0	PRJNA356682	38849	248	0.88	2.1824	Bacillati	1783272	Bacteria	Bacteria	97.8	4.600000000000001e-22	NR	OGZ84023.1	1802229	g38158	i0	64.2	6.90725806451613	81	29	98	0	3	245	247	327	OGZ84023.1 MAG: hypothetical protein A2401_00650 [Candidatus Staskawiczbacteria bacterium RIFOXYC1_FULL_38_18]	diamond	1713	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Staskawicziibacteriota	Candidatus Staskawiczbacteria bacterium RIFOXYC1_FULL_38_18
29380072	29380072	PRJNA356682_P_NODE_40549_length_246_cov_0.890173_g39858_i0	PRJNA356682	40549	246	0.890173	2.18982558	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	138	6.579999999999999e-37	NR	HUP55336.1	2072417	g39858	i0	84	0.98780487804878	81	13	98.8	0	2	244	181	261	HUP55336.1 crosslink repair DNA glycosylase YcaQ family protein [Candidatus Methylomirabilota bacterium]	diamond	243	138	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilota bacterium
30091785	30091785	PRJNA356682_P_NODE_42832_length_243_cov_0.905882_g42141_i0	PRJNA356682	42832	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	155	3e-43	NR	MDQ5912038.1	2052139	g42141	i0	87.5	1.97530864197531	80	10	98.8	0	3	242	261	340	MDQ5912038.1 hypothetical protein [Patescibacteria group bacterium]	diamond	480	155	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
32193010	32193010	PRJNA356682_P_NODE_40998_length_245_cov_0.895349_g40307_i0	PRJNA356682	40998	245	0.895349	2.19360505	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	130	6.41e-33	NR	TXG78087.1	2052139	g40307	i0	88.9	1.98367346938776	81	8	99.2	1	244	2	147	226	TXG78087.1 MAG: polyribonucleotide nucleotidyltransferase [Patescibacteria group bacterium]	diamond	486	130	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
32431655	32431655	PRJNA356682_P_NODE_36359_length_251_cov_0.865169_g35668_i0	PRJNA356682	36359	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	134	3.68e-35	NR	MBP9717617.1	2053589	g35668	i0	75.9	2.97609561752988	83	20	99.2	0	2	250	345	427	MBP9717617.1 NADP-specific glutamate dehydrogenase [Candidatus Paceibacterota bacterium]	diamond	747	134	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32526806	32526806	PRJNA356682_P_NODE_41059_length_245_cov_0.895349_g40368_i0	PRJNA356682	41059	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	82.4	1.32e-16	NR	HIG57392.1	2099671	g40368	i0	49.3	3.79591836734694	75	38	91.8	0	242	18	136	210	HIG57392.1 IS982 family transposase [Candidatus Handelsmanbacteria bacterium]	diamond	930	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria 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);;