metadata: contig_metadata: 15 rows where bioproject = "PRJNA1237347" and tax

15 rows where bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Hydrogenedentota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_species
19467319	19467319	PRJNA1237347_P_NODE_334656_length_312_cov_1.267782_g328083_i0	PRJNA1237347	334656	312	1.267782	3.95547984	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	60.8	2.45e-9	NR	HDP34538.1	2030809	g328083	i0	46.7	0.721153846153846	75	37	72.1	1	294	70	13	84	HDP34538.1 class I SAM-dependent methyltransferase [Candidatus Hydrogenedentota bacterium]	diamond	225	60.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
28052399	28052399	PRJNA1237347_P_NODE_529725_length_244_cov_0.900585_g523152_i0	PRJNA1237347	529725	244	0.900585	2.1974274	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	135	4.68e-35	NR	MCC6698911.1	2030809	g523152	i0	77.8	2.98770491803279	81	18	99.6	0	2	244	517	597	MCC6698911.1 metallophosphoesterase family protein [Candidatus Hydrogenedentota bacterium]	diamond	729	135	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
28102132	28102132	PRJNA1237347_P_NODE_375545_length_290_cov_1.414747_g368972_i0	PRJNA1237347	375545	290	1.414747	4.1027663	Pseudomonadati	3379134	Bacteria	Bacteria	129	1.44e-35	NR	HOQ89357.1	2030809	g368972	i0	64.9	8.00689655172414	97	33	99.3	1	289	2	66	162	HOQ89357.1 FAD-dependent oxidoreductase [Candidatus Hydrogenedentota bacterium]	diamond	2322	129	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
28304681	28304681	PRJNA1237347_P_NODE_270926_length_356_cov_1.618375_g264353_i0	PRJNA1237347	270926	356	1.618375	5.761415	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	81.6	1.22e-15	NR	MFM1919959.1	2030809	g264353	i0	39.8	3.87640449438202	113	68	95.2	0	341	3	67	179	MFM1919959.1 hypothetical protein [Candidatus Hydrogenedentota bacterium]	diamond	1380	81.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
28367668	28367668	PRJNA1237347_P_NODE_198846_length_435_cov_1.966851_g192274_i0	PRJNA1237347	198846	435	1.966851	8.55580185	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	50.8	4.47e-4	NR	MBI2423385.1	2030809	g192274	i0	46.7	0.310344827586207	45	24	31	0	3	137	1437	1481	MBI2423385.1 exo-alpha-sialidase [Candidatus Hydrogenedentota bacterium]	diamond	135	50.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
28733876	28733876	PRJNA1237347_P_NODE_500567_length_248_cov_0.874286_g493994_i0	PRJNA1237347	500567	248	0.874286	2.16822928	Candidatus Hydrogenedens	1462415	Bacteria	Bacteria	57.8	1.96e-7	NR	MBW7864270.1	2030809	g493994	i0	42.5	3.87096774193548	80	45	96.8	1	7	246	376	454	MBW7864270.1 hypothetical protein [Candidatus Hydrogenedentota bacterium]	diamond	960	57.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
28746821	28746821	PRJNA1237347_P_NODE_329027_length_315_cov_1.710744_g322454_i0	PRJNA1237347	329027	315	1.710744	5.3888436	Candidatus Hydrogenedentes bacterium ADurb.Bin179	1852849	Bacteria	Bacteria	43.5	0.0319	NR	OQB43620.1	1852849	g322454	i0	41.2	0.485714285714286	51	30	48.6	0	140	292	92	142	OQB43620.1 MAG: hypothetical protein BWY09_00077 [Candidatus Hydrogenedentes bacterium ADurb.Bin179]	diamond	153	43.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentes bacterium ADurb.Bin179
28999535	28999535	PRJNA1237347_P_NODE_145348_length_535_cov_1.636364_g138802_i0	PRJNA1237347	145348	535	1.636364	8.7545474	Candidatus Hydrogenedentales bacterium	3120109	Bacteria	Bacteria	116	8.12e-27	NR	MFA6245223.1	3120109	g138802	i0	34.4	1.00934579439252	180	113	99.3	3	534	4	72	249	MFA6245223.1 7TM diverse intracellular signaling domain-containing protein [Candidatus Hydrogenedentales bacterium]	diamond	540	116	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentia	Candidatus Hydrogenedentales	Candidatus Hydrogenedentales bacterium
29189179	29189179	PRJNA1237347_P_NODE_448069_length_260_cov_1.278075_g441496_i0	PRJNA1237347	448069	260	1.278075	3.322995	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	99	9.37e-23	NR	MFP6581002.1	2030809	g441496	i0	52.4	0.946153846153846	82	39	94.6	0	246	1	5	86	MFP6581002.1 oxygen-dependent coproporphyrinogen oxidase [Candidatus Hydrogenedentota bacterium]	diamond	246	99	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
29630413	29630413	PRJNA1237347_P_NODE_230690_length_395_cov_0.953416_g224118_i0	PRJNA1237347	230690	395	0.953416	3.7659932	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	63.5	1.01e-8	NR	MCL4693872.1	2030809	g224118	i0	36.8	2.83291139240506	95	57	72.2	1	2	286	321	412	MCL4693872.1 DegQ family serine endoprotease [Candidatus Hydrogenedentota bacterium]	diamond	1119	63.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
29788854	29788854	PRJNA1237347_P_NODE_506991_length_247_cov_0.885057_g500418_i0	PRJNA1237347	506991	247	0.885057	2.18609079	Candidatus Hydrogenedentales bacterium	3120109	Bacteria	Bacteria	100	1.4100000000000001e-22	NR	MFA6241520.1	3120109	g500418	i0	56.1	0.995951417004049	82	36	99.6	0	1	246	312	393	MFA6241520.1 ATP-binding protein [Candidatus Hydrogenedentales bacterium]	diamond	246	100	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentia	Candidatus Hydrogenedentales	Candidatus Hydrogenedentales bacterium
30705044	30705044	PRJNA1237347_P_NODE_442774_length_262_cov_1.460317_g436201_i0	PRJNA1237347	442774	262	1.460317	3.82603054	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	64.3	1.21e-9	NR	MBI2422689.1	2030809	g436201	i0	63	2.8969465648855	46	17	52.7	0	124	261	199	244	MBI2422689.1 protein kinase [Candidatus Hydrogenedentota bacterium]	diamond	759	64.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
31084136	31084136	PRJNA1237347_P_NODE_307575_length_329_cov_1.199219_g301002_i0	PRJNA1237347	307575	329	1.199219	3.94543051	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	129	3.2599999999999993e-34	NR	MDK1021202.1	2030809	g301002	i0	59.2	1.83282674772036	98	40	89.4	0	27	320	198	295	MDK1021202.1 oxygen-dependent coproporphyrinogen oxidase [Candidatus Hydrogenedentota bacterium]	diamond	603	129	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
32128141	32128141	PRJNA1237347_P_NODE_388398_length_284_cov_4.009479_g381825_i0	PRJNA1237347	388398	284	4.009479	11.38692036	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	45.8	0.00491	NR	HPO17171.1	2030809	g381825	i0	36.8	1.86971830985915	68	37	70.8	3	212	12	190	252	HPO17171.1 RHS repeat-associated core domain-containing protein [Candidatus Hydrogenedentota bacterium]	diamond	531	45.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota bacterium
32317844	32317844	PRJNA1237347_P_NODE_184959_length_456_cov_3.780679_g178388_i0	PRJNA1237347	184959	456	3.780679	17.23989624	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	63.9	2.33e-9	NR	HIA48344.1	2030809	g178388	i0	41.3	1.36842105263158	104	53	66.4	4	133	435	69	167	HIA48344.1 hypothetical protein [Candidatus Hydrogenedentota bacterium]	diamond	624	63.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota			Candidatus Hydrogenedentota 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);;