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

13 rows where bioproject = "PRJNA751877" 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
27094298	27094298	PRJNA751877_P_NODE_16842_length_285_cov_1.169811_g16720_i0	PRJNA751877	16842	285	1.169811	3.33396135	Bacteria	2	Bacteria	Bacteria	87	4.25e-18	NR	PIQ24743.1	2014262	g16720	i0	63.6	1.17894736842105	55	20	57.9	0	1	165	241	295	PIQ24743.1 MAG: adhesin [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	336	87	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria			bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
27337376	27337376	PRJNA751877_P_NODE_17023_length_284_cov_1.146919_g16901_i0	PRJNA751877	17023	284	1.146919	3.2572499600000002	Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5	2044595	Bacteria	Bacteria	143	3.2499999999999996e-37	NR	PIV90092.1	1974580	g16901	i0	78.5	0.982394366197183	93	20	98.2	0	284	6	700	792	PIV90092.1 MAG: DNA polymerase III subunit alpha [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13]	diamond	279	143	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota			Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13
27432254	27432254	PRJNA751877_P_NODE_25083_length_248_cov_0.880000_g24961_i0	PRJNA751877	25083	248	0.88	2.1824	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	79	5.54e-15	NR	MDD4931711.1	2750074	g24961	i0	56.3	1.8991935483871	80	33	96.8	1	241	2	309	386	MDD4931711.1 DDE-type integrase/transposase/recombinase [Candidatus Colwellbacteria bacterium]	diamond	471	79	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota			Candidatus Colwellbacteria bacterium
28884336	28884336	PRJNA751877_P_NODE_10808_length_338_cov_1.162264_g10686_i0	PRJNA751877	10808	338	1.162264	3.92845232	Candidatus Peribacterales bacterium	2711152	Bacteria	Bacteria	76.3	2.07e-13	NR	HLC75740.1	2711152	g10686	i0	40	1.98816568047337	115	33	97.6	2	3	332	1859	1942	HLC75740.1 DUF4215 domain-containing protein [Candidatus Peribacterales bacterium]	diamond	672	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacterales bacterium
28979296	28979296	PRJNA751877_P_NODE_22468_length_251_cov_0.865169_g22346_i0	PRJNA751877	22468	251	0.865169	2.17157419	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	95.5	7.270000000000001e-21	NR	HDZ27397.1	2052149	g22346	i0	55.4	2.97609561752988	83	35	99.2	2	251	3	341	421	HDZ27397.1 saccharopine dehydrogenase [Candidatus Aminicenantes bacterium]	diamond	747	95.5	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota			Candidatus Aminicenantes bacterium
28979299	28979299	PRJNA751877_P_NODE_27688_length_244_cov_0.900585_g27566_i0	PRJNA751877	27688	244	0.900585	2.1974274	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	117	8.55e-29	NR	MEO0131076.1	2052148	g27566	i0	66.7	0.995901639344262	81	27	99.6	0	243	1	210	290	MEO0131076.1 class IV adenylate cyclase [candidate division WOR-3 bacterium]	diamond	243	117	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3			candidate division WOR-3 bacterium
29515698	29515698	PRJNA751877_P_NODE_24990_length_248_cov_0.880000_g24868_i0	PRJNA751877	24990	248	0.88	2.1824	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	42.7	0.04	NR	HEY7142322.1	2072417	g24868	i0	41.7	0.580645161290323	48	28	58.1	0	162	19	66	113	HEY7142322.1 SLC13 family permease [Candidatus Methylomirabilota bacterium]	diamond	144	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota			Candidatus Methylomirabilota bacterium
29989627	29989627	PRJNA751877_P_NODE_18351_length_276_cov_1.137931_g18229_i0	PRJNA751877	18351	276	1.137931	3.14068956	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	48.5	1.08e-4	NR	PIQ28831.1	2014262	g18229	i0	63.9	0.391304347826087	36	13	39.1	0	11	118	85	120	PIQ28831.1 MAG: hypothetical protein COW64_01670 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	108	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria			bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
30463938	30463938	PRJNA751877_P_NODE_29413_length_242_cov_0.911243_g29291_i0	PRJNA751877	29413	242	0.911243	2.20520806	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	64.3	9.27e-10	NR	MFA5131931.1	2053589	g29291	i0	44.7	1.8595041322314	76	42	94.2	0	238	11	525	600	MFA5131931.1 ATP-dependent DNA helicase [Candidatus Paceibacterota bacterium]	diamond	450	64.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
31126664	31126664	PRJNA751877_P_NODE_28655_length_243_cov_0.905882_g28533_i0	PRJNA751877	28655	243	0.905882	2.20129326	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	92.8	2.39e-21	NR	PIQ24678.1	2014262	g28533	i0	51.9	1	81	39	100	0	1	243	93	173	PIQ24678.1 MAG: hypothetical protein COW64_17375 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	243	92.8	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria			bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
31316720	31316720	PRJNA751877_P_NODE_25695_length_247_cov_0.885057_g25573_i0	PRJNA751877	25695	247	0.885057	2.18609079	Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5	2044595	Bacteria	Bacteria	136	1.6200000000000002e-36	NR	PIV90808.1	1974580	g25573	i0	82.9	0.995951417004049	82	14	99.6	0	1	246	212	293	PIV90808.1 MAG: GTPase HflX [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13]	diamond	246	136	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota			Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13
31358392	31358392	PRJNA751877_P_NODE_30096_length_241_cov_0.916667_g29974_i0	PRJNA751877	30096	241	0.916667	2.20916747	Candidatus Nanoperiomorbus	2171988	Bacteria	Bacteria	152	2.28e-44	NR	MCG5079546.1	2026720	g29974	i0	95	1.99170124481328	80	4	99.6	0	240	1	110	189	MCG5079546.1 SIS domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	480	152	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
32275924	32275924	PRJNA751877_P_NODE_25598_length_247_cov_0.885057_g25476_i0	PRJNA751877	25598	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	105	5.18e-26	NR	OJU97279.1	1895828	g25476	i0	58.4	1.87044534412955	77	30	91.1	1	2	226	52	128	OJU97279.1 MAG: hypothetical protein BGO18_03895 [Candidatus Saccharibacteria bacterium 47-87]	diamond	462	105	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 47-87

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