metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Candidatus Microgenomatota"

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
26631598	26631598	PRJNA340009_P_NODE_67981_length_164_cov_3.669565_g67674_i0	PRJNA340009	67981	164	3.669565	6.0180866	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	65.5	1.11e-10	NR	RJQ36039.1	2093373	g67674	i0	76.3	0.695121951219512	38	9	69.5	0	34	147	151	188	RJQ36039.1 MAG: AI-2E family transporter [Candidatus Microgenomates bacterium]	diamond	114	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
27485516	27485516	PRJNA340009_P_NODE_23103_length_253_cov_26.117647_g22796_i0	PRJNA340009	23103	253	26.117647	66.07764691	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	95.1	1.62e-20	NR	RJQ38245.1	2093373	g22796	i0	59.8	2.89328063241107	82	33	97.2	0	252	7	339	420	RJQ38245.1 MAG: hypothetical protein C4559_02110 [Candidatus Microgenomates bacterium]	diamond	732	95.1	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
27517076	27517076	PRJNA340009_P_NODE_26243_length_240_cov_8.895288_g25936_i0	PRJNA340009	26243	240	8.895288	21.3486912	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	99.4	9.86e-23	NR	RJR15558.1	2093373	g25936	i0	73.8	4.9	61	16	76.3	0	235	53	281	341	RJR15558.1 MAG: hypothetical protein C4579_01945 [Candidatus Microgenomates bacterium]	diamond	1176	99.4	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
28716953	28716953	PRJNA340009_P_NODE_15387_length_302_cov_5.818182_g15080_i0	PRJNA340009	15387	302	5.818182	17.57090964	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	158	1.05e-45	NR	RJQ38506.1	2093373	g15080	i0	78	0.993377483443709	100	22	99.3	0	2	301	61	160	RJQ38506.1 MAG: aldo/keto reductase [Candidatus Microgenomates bacterium]	diamond	300	158	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
28734184	28734184	PRJNA340009_P_NODE_4407_length_504_cov_109.008791_g4105_i0	PRJNA340009	4407	504	109.008791	549.40430664	Bacteria	2	Bacteria	Bacteria	129	3.12e-32	NR	MBL7159714.1	2093373	g4105	i0	43.5	4.69047619047619	161	83	95.2	3	23	502	159	312	MBL7159714.1 glycosyltransferase family 39 protein [Candidatus Microgenomates bacterium]	diamond	2364	129	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
29285059	29285059	PRJNA340009_P_NODE_42249_length_196_cov_18.074830_g41942_i0	PRJNA340009	42249	196	18.07483	35.4266668	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	52.8	5.79e-6	NR	MCJ7740414.1	2093373	g41942	i0	45.8	0.903061224489796	59	30	90.3	1	7	183	341	397	MCJ7740414.1 glycosyltransferase family 39 protein [Candidatus Microgenomates bacterium]	diamond	177	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
29663743	29663743	PRJNA340009_P_NODE_45970_length_189_cov_21.342857_g45663_i0	PRJNA340009	45970	189	21.342857	40.33799973	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	71.6	9.12e-13	NR	RJQ38223.1	2093373	g45663	i0	68	0.793650793650794	50	16	79.4	0	39	188	246	295	RJQ38223.1 MAG: NAD-dependent epimerase/dehydratase family protein [Candidatus Microgenomates bacterium]	diamond	150	71.6	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
30250143	30250143	PRJNA340009_P_NODE_63692_length_166_cov_1.743590_g63385_i0	PRJNA340009	63692	166	1.74359	2.8943594	Bacteria	2	Bacteria	Bacteria	106	3.09e-26	NR	MBI2036731.1	2093373	g63385	i0	83.6	3.97590361445783	55	9	99.4	0	165	1	62	116	MBI2036731.1 hypothetical protein [Candidatus Microgenomates bacterium]	diamond	660	106	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates bacterium
31071548	31071548	PRJNA340009_P_NODE_78715_length_157_cov_14.564815_g78408_i0	PRJNA340009	78715	157	14.564815	22.86675955	Bacteria	2	Bacteria	Bacteria	71.6	5.19e-15	NR	KXK09067.1	1617428	g78408	i0	87.9	10.0891719745223	33	4	63.1	0	124	26	29	61	KXK09067.1 MAG: 30S ribosomal protein S14 [Microgenomates bacterium OLB22]	diamond	1584	72	0.994444444444444	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Microgenomates bacterium OLB22
31433501	31433501	PRJNA340009_P_NODE_72736_length_162_cov_5.867257_g72429_i0	PRJNA340009	72736	162	5.867257	9.50495634	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	90.1	3.45e-20	NR	MBI4100437.1	2093373	g72429	i0	77.8	1	54	12	100	0	162	1	181	234	MBI4100437.1 S-methyl-5'-thioadenosine phosphorylase [Candidatus Microgenomates bacterium]	diamond	162	90.1	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota	Candidatus Microgenomates 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);;