metadata: contig_metadata: 15 rows where bioproject = "PRJEB11748", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJEB11748", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Methylomirabilota"

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
5119379	5119379	PRJEB11748_P_NODE_256045_length_243_cov_3.054945_g253862_i0	PRJEB11748	256045	243	3.054945	7.42351635	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	127	1.1e-34	NR	HET8529791.1	2072417	g253862	i0	74	2.74074074074074	73	19	90.1	0	221	3	52	124	HET8529791.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	666	127	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
7666845	7666845	PRJEB11748_P_NODE_136227_length_353_cov_9.640411_g134049_i0	PRJEB11748	136227	353	9.640411	34.03065083	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	144	1.5499999999999996e-40	NR	HEY5725160.1	2072417	g134049	i0	75.5	0.798866855524079	94	23	79.9	0	48	329	46	139	HEY5725160.1 cytochrome c oxidase subunit 3 family protein [Candidatus Methylomirabilota bacterium]	diamond	282	144	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
14044699	14044699	PRJEB11748_P_NODE_23892_length_928_cov_12.484429_g22258_i0	PRJEB11748	23892	928	12.484429	115.85550112	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	211	3.37e-63	NR	MBI4571690.1	2072417	g22258	i0	47.2	0.74676724137931	231	122	74.7	0	26	718	35	265	MBI4571690.1 carbohydrate ABC transporter permease [Candidatus Methylomirabilota bacterium]	diamond	693	211	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26811414	26811414	PRJEB11748_P_NODE_311001_length_214_cov_5.052288_g308818_i0	PRJEB11748	311001	214	5.052288	10.81189632	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	45.4	0.00276	NR	HEX2440700.1	2072417	g308818	i0	38.6	2.52336448598131	57	35	79.9	0	212	42	46	102	HEX2440700.1 polysaccharide biosynthesis C-terminal domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	540	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27948927	27948927	PRJEB11748_P_NODE_293145_length_223_cov_1.419753_g290962_i0	PRJEB11748	293145	223	1.419753	3.16604919	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	63.9	1.97e-11	NR	HSB40508.1	2072417	g290962	i0	44.8	0.780269058295964	58	32	78	0	48	221	1	58	HSB40508.1 acyl carrier protein [Candidatus Methylomirabilota bacterium]	diamond	174	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28138565	28138565	PRJEB11748_P_NODE_224585_length_264_cov_2.842365_g222402_i0	PRJEB11748	224585	264	2.842365	7.5038436	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.5	0.009	NR	MCH7896023.1	2072417	g222402	i0	40	0.568181818181818	50	30	56.8	0	155	6	72	121	MCH7896023.1 single-stranded DNA-binding protein [Candidatus Methylomirabilota bacterium]	diamond	150	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28169857	28169857	PRJEB11748_P_NODE_198246_length_285_cov_3.611607_g196063_i0	PRJEB11748	198246	285	3.611607	10.29307995	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	73.2	1.22e-12	NR	HKZ08028.1	2072417	g196063	i0	93.5	0.968421052631579	31	2	32.6	0	283	191	832	862	HKZ08028.1 glucosidase [Candidatus Methylomirabilota bacterium]	diamond	276	73.2	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28327702	28327702	PRJEB11748_P_NODE_341206_length_202_cov_1.794326_g339023_i0	PRJEB11748	341206	202	1.794326	3.62453852	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	94.4	1.35e-20	NR	HXG21693.1	2072417	g339023	i0	89.8	2.91089108910891	49	5	72.8	0	18	164	161	209	HXG21693.1 amidohydrolase family protein [Candidatus Methylomirabilota bacterium]	diamond	588	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28794971	28794971	PRJEB11748_P_NODE_343987_length_201_cov_1.685714_g341804_i0	PRJEB11748	343987	201	1.685714	3.38828514	Pseudomonadati	3379134	Bacteria	Bacteria	76.3	1.8e-15	NR	HEX3175445.1	2072417	g341804	i0	64.2	3.44776119402985	67	23	98.5	1	4	201	95	161	HEX3175445.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	693	76.6	0.996083550913838	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29047884	29047884	PRJEB11748_P_NODE_188208_length_294_cov_3.866953_g186025_i0	PRJEB11748	188208	294	3.866953	11.36884182	Bacillati	1783272	Bacteria	Bacteria	65.5	6.44e-11	NR	HSB78825.1	2032687	g186025	i0	43.7	2.89795918367347	71	40	72.4	0	273	61	74	144	HSB78825.1 sulfite exporter TauE/SafE family protein [Candidatus Methylomirabilis sp.]	diamond	852	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
29079422	29079422	PRJEB11748_P_NODE_147108_length_339_cov_1.697842_g144927_i0	PRJEB11748	147108	339	1.697842	5.75568438	Pseudomonadati	3379134	Bacteria	Bacteria	159	5.51e-43	NR	HXG48803.1	2072417	g144927	i0	79.6	2.85840707964602	108	22	95.6	0	3	326	120	227	HXG48803.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	969	159	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29432496	29432496	PRJEB11748_P_NODE_160770_length_322_cov_6.992337_g158588_i0	PRJEB11748	160770	322	6.992337	22.51532514	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	119	1.7899999999999995e-31	NR	HXJ85077.1	2032687	g158588	i0	71.8	0.726708074534162	78	22	72.7	0	298	65	57	134	HXJ85077.1 PIN domain-containing protein [Candidatus Methylomirabilis sp.]	diamond	234	119	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
29495965	29495965	PRJEB11748_P_NODE_219930_length_267_cov_10.665049_g217747_i0	PRJEB11748	219930	267	10.665049	28.47568083	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	89	2.18e-18	NR	HWP76727.1	2072417	g217747	i0	97.6	1.38202247191011	41	1	46.1	0	124	246	41	81	HWP76727.1 alpha-amylase/4-alpha-glucanotransferase domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	369	89	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
30032948	30032948	PRJEB11748_P_NODE_238811_length_254_cov_2.746114_g236628_i0	PRJEB11748	238811	254	2.746114	6.97512956	candidate division NC1	1640516	Bacteria	Bacteria	68.2	8.46e-13	NR	KRT68626.1	1640516	g236628	i0	67.4	1.61811023622047	46	15	54.3	0	27	164	40	85	KRT68626.1 MAG: hypothetical protein XU15_C0018G0003 [candidate division NC10 bacterium CSP1-5]	diamond	411	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					candidate division NC10 bacterium CSP1-5
31201385	31201385	PRJEB11748_P_NODE_116775_length_384_cov_7.659443_g114601_i0	PRJEB11748	116775	384	7.659443	29.41226112	candidate division NC1	1640516	Bacteria	Bacteria	122	5.78e-31	NR	KRT68789.1	1640516	g114601	i0	49.1	3.5	114	58	89.1	0	365	24	17	130	KRT68789.1 MAG: dTDP-4-dehydrorhamnose reductase [candidate division NC10 bacterium CSP1-5]	diamond	1344	122	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					candidate division NC10 bacterium CSP1-5

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