metadata: contig_metadata: 7 rows where bioproject = "PRJNA408129" and tax

7 rows where bioproject = "PRJNA408129" 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
26885902	26885902	PRJNA408129_S_NODE_21521_length_175_cov_1.521739_g21503_i0	PRJNA408129	21521	175	1.521739	2.66304325	Candidatus Wallbacteria bacterium	2053640	Bacteria	Bacteria	42.4	0.0208	NR	MDD2716402.1	2053640	g21503	i0	46.8	0.805714285714286	47	25	80.6	0	163	23	156	202	MDD2716402.1 glycosyltransferase family 39 protein [Candidatus Wallbacteria bacterium]	diamond	141	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota					Candidatus Wallbacteria bacterium
27517944	27517944	PRJNA408129_S_NODE_7163_length_243_cov_3.213592_g7145_i0	PRJNA408129	7163	243	3.213592	7.80902856	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	44.7	0.00641	NR	MDP5038834.1	2044595	g7145	i0	53.1	0.790123456790123	32	15	39.5	0	124	29	12	43	MDP5038834.1 rRNA pseudouridine synthase [Candidatus Altimarinota bacterium]	diamond	192	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
27991644	27991644	PRJNA408129_S_NODE_24705_length_167_cov_6.053846_g24687_i0	PRJNA408129	24705	167	6.053846	10.10992282	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	41.6	0.0349	NR	RKV98313.1	1917697	g24687	i0	44.2	0.934131736526946	52	26	88	1	163	17	379	430	RKV98313.1 MAG: hypothetical protein D8G53_03085 [Candidatus Saccharimonas sp.]	diamond	156	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
28023177	28023177	PRJNA408129_S_NODE_19965_length_179_cov_2.253521_g19947_i0	PRJNA408129	19965	179	2.253521	4.03380259	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	102	2.07e-23	NR	MBH2007265.1	2026720	g19947	i0	79.7	1.97765363128492	59	12	98.9	0	1	177	430	488	MBH2007265.1 leucine--tRNA ligase [Candidatus Saccharibacteria bacterium]	diamond	354	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29570101	29570101	PRJNA408129_S_NODE_7070_length_244_cov_2.628019_g7052_i0	PRJNA408129	7070	244	2.628019	6.41236636	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	122	4.97e-30	NR	MFA6079892.1	2044595	g7052	i0	93.8	0.786885245901639	64	4	78.7	0	193	2	280	343	MFA6079892.1 ATP-dependent DNA helicase [Candidatus Altimarinota bacterium]	diamond	192	122	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
30960275	30960275	PRJNA408129_S_NODE_12854_length_205_cov_4.880952_g12836_i0	PRJNA408129	12854	205	4.880952	10.0059516	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	47.4	3.13e-5	NR	HET8709174.1	2973664	g12836	i0	79.4	0.497560975609756	34	6	49.8	1	184	83	3	35	HET8709174.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	102	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32856589	32856589	PRJNA408129_S_NODE_5520_length_260_cov_4.210762_g5502_i0	PRJNA408129	5520	260	4.210762	10.9479812	Candidatus Collierbacteria bacterium RIFCSPHIGHO2_	2053540	Bacteria	Bacteria	41.6	0.0311	NR	OGD71529.1	1817723	g5502	i0	47.4	0.438461538461538	38	20	43.8	0	147	260	24	61	OGD71529.1 MAG: hypothetical protein A3D09_02205 [Candidatus Collierbacteria bacterium RIFCSPHIGHO2_02_FULL_49_10]	diamond	114	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Collieribacteriota					Candidatus Collierbacteria bacterium RIFCSPHIGHO2_02_FULL_49_10

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