metadata: contig_metadata: 18 rows where bioproject = "PRJNA1067443" and tax

18 rows where bioproject = "PRJNA1067443" 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
1456219	1456219	PRJNA1067443_P_NODE_22_length_1860_cov_17.407387_g19_i0	PRJNA1067443	22	1860	17.407387	323.7773982	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	620	7.31e-214	NR	HEV8666245.1	2053589	g19	i0	89.5	2.29516129032258	354	37	57.1	0	1065	4	1	354	HEV8666245.1 molecular chaperone DnaK [Candidatus Paceibacterota bacterium]	diamond	4269	620	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
6559463	6559463	PRJNA1067443_P_NODE_226_length_860_cov_18.391360_g212_i0	PRJNA1067443	226	860	18.39136	158.165696	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	87.8	2.14e-16	NR	MEK7109393.1	2052139	g212	i0	59.3	0.205813953488372	59	24	20.6	0	187	11	1	59	MEK7109393.1 hypothetical protein [Patescibacteria group bacterium]	diamond	177	87.8	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
16315881	16315881	PRJNA1067443_P_NODE_173_length_926_cov_17.262603_g160_i0	PRJNA1067443	173	926	17.262603	159.85170378	Bacteria	2	Bacteria	Bacteria	221	1.1299999999999999e-68	NR	OGC84560.1	1797242	g160	i0	73.7	3.45032397408207	152	39	48.9	1	474	926	5	156	OGC84560.1 MAG: translation initiation factor IF-3 [Candidatus Adlerbacteria bacterium RIFCSPHIGHO2_12_FULL_53_18]	diamond	3195	221	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium RIFCSPHIGHO2_12_FULL_53_18
18033385	18033385	PRJNA1067443_P_NODE_4995_length_356_cov_5.194346_g4977_i0	PRJNA1067443	4995	356	5.194346	18.49187176	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	96.7	1.8e-20	NR	MBU6414680.1	2052139	g4977	i0	58.5	0.691011235955056	82	29	64.9	1	261	31	942	1023	MBU6414680.1 sulfatase-like hydrolase/transferase [Patescibacteria group bacterium]	diamond	246	96.7	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
22690349	22690349	PRJNA1067443_P_NODE_478_length_698_cov_13.729600_g462_i0	PRJNA1067443	478	698	13.7296	95.832608	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	189	6.85e-57	NR	MCD8561725.1	2026720	g462	i0	71.4	2.26934097421203	133	38	57.2	0	410	12	1	133	MCD8561725.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Candidatus Saccharibacteria bacterium]	diamond	1584	189	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
26592201	26592201	PRJNA1067443_P_NODE_1721_length_492_cov_14.102625_g1703_i0	PRJNA1067443	1721	492	14.102625	69.384915	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	132	7.960000000000001e-36	NR	MBI2005004.1	2052139	g1703	i0	51.6	2.14024390243902	122	59	74.4	0	47	412	32	153	MBI2005004.1 DUF192 domain-containing protein [Patescibacteria group bacterium]	diamond	1053	132	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
27415220	27415220	PRJNA1067443_P_NODE_22083_length_242_cov_0.911243_g22065_i0	PRJNA1067443	22083	242	0.911243	2.20520806	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	134	6.13e-35	NR	MBP6931234.1	2053589	g22065	i0	81.3	4.95867768595041	80	15	99.2	0	2	241	162	241	MBP6931234.1 recombinase family protein [Candidatus Paceibacterota bacterium]	diamond	1200	134	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28298926	28298926	PRJNA1067443_P_NODE_10666_length_281_cov_1.634615_g10648_i0	PRJNA1067443	10666	281	1.634615	4.59326815	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	125	9.53e-34	NR	HVB33744.1	2052139	g10648	i0	69.3	2.85053380782918	88	27	94	0	18	281	58	145	HVB33744.1 YqaJ viral recombinase family protein [Patescibacteria group bacterium]	diamond	801	125	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
28835737	28835737	PRJNA1067443_P_NODE_188_length_903_cov_18.369880_g175_i0	PRJNA1067443	188	903	18.36988	165.8800164	Parcubacteria group bacterium	2026774	Bacteria	Bacteria	123	9.12e-31	NR	MDB5237221.1	2026774	g175	i0	65.6	0.318936877076412	96	31	31.9	1	273	560	43	136	MDB5237221.1 hypothetical protein [Parcubacteria group bacterium]	diamond	288	123	1	Bacteria	Bacteria candidate phyla		Parcubacteria group bacterium
29624645	29624645	PRJNA1067443_P_NODE_750_length_619_cov_8.223443_g732_i0	PRJNA1067443	750	619	8.223443	50.90311217	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	108	6.3799999999999996e-24	NR	MEI7689381.1	2026720	g732	i0	34.4	0.901453957996769	186	117	88.7	4	46	594	72	255	MEI7689381.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	558	108	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
29679541	29679541	PRJNA1067443_P_NODE_11370_length_277_cov_1.411765_g11352_i0	PRJNA1067443	11370	277	1.411765	3.91058905	Bacteria	2	Bacteria	Bacteria	107	8.800000000000001e-27	NR	MDB5184991.1	2026720	g11352	i0	57.1	1.91696750902527	91	39	98.6	0	275	3	111	201	MDB5184991.1 isochorismatase hydrolase, nicotinamidase/pyrazinamidase [Candidatus Saccharibacteria bacterium]	diamond	531	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30288849	30288849	PRJNA1067443_P_NODE_852_length_597_cov_8.463740_g834_i0	PRJNA1067443	852	597	8.46374	50.5285278	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	190	5.669999999999998e-55	NR	MDB5160362.1	2026720	g834	i0	86.1	1.60804020100503	108	15	54.3	0	273	596	1	108	MDB5160362.1 obg, GTPase obg [Candidatus Saccharibacteria bacterium]	diamond	960	190	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30312152	30312152	PRJNA1067443_P_NODE_9812_length_286_cov_3.934272_g9794_i0	PRJNA1067443	9812	286	3.934272	11.25201792	Bacteria	2	Bacteria	Bacteria	165	2.1099999999999998e-47	NR	MCC7500289.1	2052152	g9794	i0	90.8	4.56293706293706	87	8	91.3	0	262	2	282	368	MCC7500289.1 replication-associated recombination protein A [Candidatus Nomurabacteria bacterium]	diamond	1305	166	0.993975903614458	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
30920561	30920561	PRJNA1067443_P_NODE_12554_length_270_cov_1.456853_g12536_i0	PRJNA1067443	12554	270	1.456853	3.9335031	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	88.2	3.2e-19	NR	MBB1558610.1	2026720	g12536	i0	95.7	0.511111111111111	46	2	51.1	0	139	2	1	46	MBB1558610.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	138	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
31647362	31647362	PRJNA1067443_P_NODE_1217_length_543_cov_4.997872_g1199_i0	PRJNA1067443	1217	543	4.997872	27.13844496	Candidatus Adlerbacteria bacterium	1932010	Bacteria	Bacteria	150	8.93e-40	NR	MDB5224618.1	1932010	g1199	i0	50.9	0.900552486187845	163	77	88.4	1	30	509	224	386	MDB5224618.1 hypothetical protein [Candidatus Adlerbacteria bacterium]	diamond	489	150	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
31900583	31900583	PRJNA1067443_P_NODE_16477_length_251_cov_0.865169_g16459_i0	PRJNA1067443	16477	251	0.865169	2.17157419	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	75.1	1.68e-13	NR	MCK9369649.1	2099670	g16459	i0	85.4	0.573705179282869	48	7	57.4	0	107	250	851	898	MCK9369649.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	144	75.1	1	Bacteria	Bacteria candidate phyla		Candidatus Dojkabacteria bacterium
32113788	32113788	PRJNA1067443_P_NODE_1698_length_494_cov_6.334917_g1680_i0	PRJNA1067443	1698	494	6.334917	31.29448998	Bacteria	2	Bacteria	Bacteria	136	5.19e-38	NR	KKW35481.1	1618605	g1680	i0	83.1	2.03441295546559	83	10	50.4	1	489	241	40	118	KKW35481.1 MAG: hypothetical protein UY83_C0007G0005 [Candidatus Adlerbacteria bacterium GW2011_GWA1_54_10]	diamond	1005	137	0.992700729927007	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium GW2011_GWA1_54_10
32375303	32375303	PRJNA1067443_P_NODE_17599_length_249_cov_0.875000_g17581_i0	PRJNA1067443	17599	249	0.875	2.17875	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	95.1	6.8e-21	NR	MDP3987524.1	2052151	g17581	i0	56.6	1	83	36	100	0	249	1	193	275	MDP3987524.1 glycosyltransferase family 4 protein [Candidatus Levyibacteriota bacterium]	diamond	249	95.1	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota 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);;