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

18 rows where bioproject = "PRJEB20058" and tax_phylum = "Candidatus Omnitrophota"

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_species
25517600	25517600	PRJEB20058_P_NODE_211937_length_248_cov_1.058824_g209113_i0	PRJEB20058	211937	248	1.058824	2.62588352	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	148	3.21e-39	NR	MCG3177289.1	2035772	g209113	i0	93.3	2.70967741935484	75	5	90.7	0	246	22	62	136	MCG3177289.1 DNA gyrase subunit A [Candidatus Omnitrophota bacterium]	diamond	672	148	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
25654013	25654013	PRJEB20058_P_NODE_224866_length_238_cov_5.282486_g222041_i0	PRJEB20058	224866	238	5.282486	12.57231668	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	202	2.01e-47	NTclustered	gi\|2107742610\|gb\|CP070837.1\|	2035772	g222041	i0	86.813	18.7521008403361	182	23	76	1	12	193	127313	127493	MAG: Candidatus Omnitrophota bacterium isolate bin103 chromosome	blastn	4463	202	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
25748680	25748680	PRJEB20058_P_NODE_136938_length_334_cov_1.637363_g134118_i0	PRJEB20058	136938	334	1.637363	5.46879242	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	195	1.44e-59	NR	MCG3177172.1	2035772	g134118	i0	91.4	0.94311377245509	105	9	94.3	0	323	9	1	105	MCG3177172.1 Dihydroorotate dehydrogenase B (NAD(+)), catalytic subunit [Candidatus Omnitrophota bacterium]	diamond	315	195	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
25785535	25785535	PRJEB20058_P_NODE_115363_length_373_cov_15.288462_g112548_i0	PRJEB20058	115363	373	15.288462000000001	57.02596326	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	339	2.43e-88	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g112548	i0	84.928	637.554959785523	345	41	90	8	4	337	2373032	2372688	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	237808	339	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
25790740	25790740	PRJEB20058_P_NODE_242539_length_210_cov_4.295302_g239714_i0	PRJEB20058	242539	210	4.295302	9.0201342	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	187	4.8399999999999984e-43	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g239714	i0	83.173	1.6047619047619	208	32	98	3	1	206	2372193	2371987	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	337	187	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
25885223	25885223	PRJEB20058_P_NODE_189003_length_266_cov_2.863415_g186179_i0	PRJEB20058	189003	266	2.863415	7.6166839	Candidatus Omnitrophica bacterium CG1_	2035772	Bacteria	Bacteria	107	1.22e-24	NR	OIO38887.1	1805290	g186179	i0	92.6	1.88345864661654	54	4	60.9	0	105	266	6	59	OIO38887.1 MAG: DNA gyrase subunit A [Candidatus Omnitrophica bacterium CG1_02_49_16]	diamond	501	107	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophica bacterium CG1_02_49_16
26336318	26336318	PRJEB20058_P_NODE_43463_length_638_cov_3.866551_g40795_i0	PRJEB20058	43463	638	3.866551	24.66859538	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	293	2.08e-98	NR	MCG3175255.1	2035772	g40795	i0	91.3	0.705329153605016	150	13	70.5	0	617	168	40	189	MCG3175255.1 putative peptidyl-prolyl cis-trans isomerase [Candidatus Omnitrophota bacterium]	diamond	450	293	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
26337694	26337694	PRJEB20058_P_NODE_68535_length_504_cov_1.670429_g65765_i0	PRJEB20058	68535	504	1.670429	8.41896216	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	268	1.7999999999999997e-88	NR	MBF0489620.1	2035772	g65765	i0	83.5	0.976190476190476	164	27	97.6	0	502	11	71	234	MBF0489620.1 ABC transporter ATP-binding protein [Candidatus Omnitrophota bacterium]	diamond	492	268	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
32927784	32927784	PRJEB20058_P_NODE_149873_length_314_cov_1.430830_g147051_i0	PRJEB20058	149873	314	1.43083	4.4928062	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	172	1.7699999999999996e-47	NR	MBU3759546.1	2035772	g147051	i0	81.7	0.993630573248408	104	19	99.4	0	1	312	430	533	MBU3759546.1 DUF3536 domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	312	172	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
32979698	32979698	PRJEB20058_P_NODE_225755_length_237_cov_3.636364_g222930_i0	PRJEB20058	225755	237	3.636364	8.61818268	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	137	2.39e-35	NR	MBI4323538.1	2035772	g222930	i0	90	0.886075949367089	70	7	88.6	0	5	214	815	884	MBI4323538.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	210	137	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
32991501	32991501	PRJEB20058_P_NODE_29891_length_767_cov_12.635977_g27433_i0	PRJEB20058	29891	767	12.635977	96.91794359	Bacteria	2	Bacteria	Bacteria	203	5.930000000000001e-59	NR	OGX06092.1	1801834	g27433	i0	49.5	6.8096479791395	206	103	80.6	1	762	145	23	227	OGX06092.1 MAG: hypothetical protein A3G87_02585 [Omnitrophica bacterium RIFCSPLOWO2_12_FULL_50_11]	diamond	5223	203	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Omnitrophica bacterium RIFCSPLOWO2_12_FULL_50_11
32991532	32991532	PRJEB20058_P_NODE_56387_length_559_cov_4.186747_g53636_i0	PRJEB20058	56387	559	4.186747	23.40391573	Bacteria	2	Bacteria	Bacteria	117	6.8699999999999996e-31	NR	OIO38630.1	1805290	g53636	i0	66.7	0.869409660107335	81	27	43.5	0	211	453	1	81	OIO38630.1 MAG: hypothetical protein AUJ71_02590 [Candidatus Omnitrophica bacterium CG1_02_49_16]	diamond	486	117	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophica bacterium CG1_02_49_16
33013535	33013535	PRJEB20058_P_NODE_208908_length_250_cov_1.354497_g206084_i0	PRJEB20058	208908	250	1.354497	3.3862425	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	113	1.46e-27	NR	MBP9733676.1	2035772	g206084	i0	65.9	0.984	82	28	98.4	0	249	4	291	372	MBP9733676.1 DNA polymerase IV [Candidatus Omnitrophota bacterium]	diamond	246	113	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
33031224	33031224	PRJEB20058_P_NODE_80988_length_460_cov_2.140351_g78204_i0	PRJEB20058	80988	460	2.140351	9.8456146	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.8	0.015	NR	RKY45258.1	2035772	g78204	i0	39.4	0.430434782608696	66	38	41.7	1	188	379	52	117	RKY45258.1 MAG: acyl-phosphate glycerol 3-phosphate acyltransferase [Candidatus Omnitrophota bacterium]	diamond	198	45.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
33065200	33065200	PRJEB20058_P_NODE_75677_length_477_cov_16.245192_g72899_i0	PRJEB20058	75677	477	16.245192	77.48956584	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	96.7	4.1700000000000006e-21	NR	MBI4430113.1	2035772	g72899	i0	69.1	0.427672955974843	68	21	42.8	0	214	11	42	109	MBI4430113.1 exosortase-associated EpsI family protein [Candidatus Omnitrophota bacterium]	diamond	204	96.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
33115686	33115686	PRJEB20058_P_NODE_177871_length_278_cov_5.728111_g175048_i0	PRJEB20058	177871	278	5.728111	15.92414858	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	40.8	0.0476	NR	HDZ77113.1	2035772	g175048	i0	51.4	0.399280575539568	37	18	39.9	0	55	165	16	52	HDZ77113.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	111	40.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
33144905	33144905	PRJEB20058_P_NODE_230167_length_231_cov_23.329412_g227342_i0	PRJEB20058	230167	231	23.329412	53.89094172	Pseudomonadati	3379134	Bacteria	Bacteria	47	9.75e-4	NR	PIQ81538.1	1974750	g227342	i0	61.1	3.88311688311688	36	14	46.8	0	169	62	346	381	PIQ81538.1 MAG: cell filamentation protein Fic [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_64_10]	diamond	897	47.4	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_64_10
33149555	33149555	PRJEB20058_P_NODE_132888_length_341_cov_1.178571_g130068_i0	PRJEB20058	132888	341	1.178571	4.01892711	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	80.9	5.16e-15	NR	MBF0385597.1	2035772	g130068	i0	39.3	1.02932551319648	117	65	98.5	3	3	338	743	858	MBF0385597.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	351	80.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota 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);;