metadata: contig_metadata: 13 rows where bioproject = "PRJNA1150539" and tax

13 rows where bioproject = "PRJNA1150539" 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_species
21978622	21978622	PRJNA1150539_S_NODE_90858_length_252_cov_3.441341_g90262_i0	PRJNA1150539	90858	252	3.441341	8.67217932	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	126	1.3299999999999999e-24	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g90262	i0	88.182	2.89285714285714	110	8	42	5	146	252	328152	328259	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	729	126	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				candidate division SR1 bacterium Aalborg_AAW-1
27261630	27261630	PRJNA1150539_S_NODE_29003_length_355_cov_3.237589_g28407_i0	PRJNA1150539	29003	355	3.237589	11.49344095	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.9	0.0325	NR	HEX6080831.1	2072417	g28407	i0	29.8	0.794366197183099	94	62	76.1	2	76	345	1	94	HEX6080831.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	282	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota				Candidatus Methylomirabilota bacterium
27829968	27829968	PRJNA1150539_S_NODE_48164_length_314_cov_3.385892_g47568_i0	PRJNA1150539	48164	314	3.385892	10.63170088	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	152	3.64e-45	NR	HJM04360.1	2830836	g47568	i0	73.8	0.984076433121019	103	27	98.4	0	311	3	8	110	HJM04360.1 divergent PAP2 family protein [Candidatus Saccharimonadaceae bacterium]	diamond	309	152	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonadaceae bacterium
27987937	27987937	PRJNA1150539_S_NODE_113205_length_203_cov_5.738462_g112609_i0	PRJNA1150539	113205	203	5.738462	11.64907786	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	45.4	0.00233	NR	MDR0861062.1	2053688	g112609	i0	38.5	0.768472906403941	52	25	66.5	1	200	66	207	258	MDR0861062.1 TPM domain-containing protein [Candidatus Peribacteria bacterium]	diamond	156	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria			Candidatus Peribacteria bacterium
29250642	29250642	PRJNA1150539_S_NODE_112749_length_206_cov_5.150376_g112153_i0	PRJNA1150539	112749	206	5.150376	10.60977456	Candidatus Methylomirabilales bacterium	3159508	Bacteria	Bacteria	40.8	0.039	NR	MFQ5801539.1	3159508	g112153	i0	51.4	0.509708737864078	35	16	49.5	1	54	155	6	40	MFQ5801539.1 hypothetical protein [Candidatus Methylomirabilales bacterium]	diamond	105	40.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales		Candidatus Methylomirabilales bacterium
29282223	29282223	PRJNA1150539_S_NODE_79509_length_266_cov_4.352332_g78913_i0	PRJNA1150539	79509	266	4.352332	11.57720312	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	43.9	0.0188	NR	MDD5103845.1	2735830	g78913	i0	43.5	0.699248120300752	62	32	67.7	3	232	53	277	337	MDD5103845.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	186	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
30356768	30356768	PRJNA1150539_S_NODE_57932_length_297_cov_6.933036_g57336_i0	PRJNA1150539	57932	297	6.933036	20.59111692	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	95.9	8.56e-21	NR	TAH36644.1	2026720	g57336	i0	53.5	0.868686868686869	86	39	85.9	1	255	1	3	88	TAH36644.1 MAG: glycosyltransferase family 1 protein [Candidatus Saccharibacteria bacterium]	diamond	258	95.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
30640464	30640464	PRJNA1150539_S_NODE_62013_length_291_cov_2.922018_g61417_i0	PRJNA1150539	62013	291	2.922018	8.50307238	Candidatus Levybacteria bacterium GW2	2052151	Bacteria	Bacteria	118	3.5e-30	NR	KKQ28287.1	1618452	g61417	i0	93.2	0.608247422680412	59	4	60.8	0	289	113	234	292	KKQ28287.1 MAG: Nucleotidyl transferase [Candidatus Levybacteria bacterium GW2011_GWA1_37_16]	diamond	177	118	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota				Candidatus Levybacteria bacterium GW2011_GWA1_37_16
31114339	31114339	PRJNA1150539_S_NODE_85795_length_258_cov_4.778378_g85199_i0	PRJNA1150539	85795	258	4.778378	12.32821524	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	43.5	0.0228	NR	MBI4022604.1	2053521	g85199	i0	31.9	0.802325581395349	69	45	77.9	1	30	230	189	257	MBI4022604.1 O-antigen ligase family protein [Candidatus Berkelbacteria bacterium]	diamond	207	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria				Candidatus Berkelbacteria bacterium
31240822	31240822	PRJNA1150539_S_NODE_41715_length_326_cov_3.948617_g41119_i0	PRJNA1150539	41715	326	3.948617	12.87249142	Candidatus Eisenbacteria bacterium	2212470	Bacteria	Bacteria	45.1	0.0139	NR	TMQ72210.1	2212470	g41119	i0	34.8	0.634969325153374	69	44	62.6	1	115	318	116	184	TMQ72210.1 MAG: hypothetical protein E6K81_08145 [Candidatus Eiseniibacteriota bacterium]	diamond	207	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota				Candidatus Eiseniibacteriota bacterium
31335717	31335717	PRJNA1150539_S_NODE_65356_length_286_cov_2.596244_g64760_i0	PRJNA1150539	65356	286	2.596244	7.4252578400000004	Candidatus Rifleibacteriota bacterium	2053586	Bacteria	Bacteria	43.1	0.0332	NR	MDD2999840.1	2053586	g64760	i0	36.5	0.545454545454545	52	33	54.5	0	93	248	31	82	MDD2999840.1 hypothetical protein [Candidatus Rifleibacteriota bacterium]	diamond	156	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacteriota bacterium
31746943	31746943	PRJNA1150539_S_NODE_74337_length_273_cov_3.265000_g73741_i0	PRJNA1150539	74337	273	3.265	8.91345	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	174	4.77e-54	NR	HQF36766.1	2099670	g73741	i0	98.9	0.956043956043956	87	1	95.6	0	13	273	44	130	HQF36766.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	261	174	1	Bacteria	Bacteria candidate phyla					Candidatus Dojkabacteria bacterium
31841739	31841739	PRJNA1150539_S_NODE_65117_length_286_cov_5.469484_g64521_i0	PRJNA1150539	65117	286	5.469484	15.64272424	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	43.5	0.0332	NR	MCR5833013.1	2026720	g64521	i0	40.4	0.597902097902098	57	34	59.8	0	75	245	18	74	MCR5833013.1 fibrobacter succinogenes major paralogous domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	171	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota 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);;