metadata: contig_metadata: 28 rows where bioproject = "PRJNA1247234" and tax

28 rows where bioproject = "PRJNA1247234" and tax_clade = "Methanomada group"

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_family	tax_genus	tax_species
11830282	11830282	PRJNA1247234_P_NODE_90_length_2119_cov_4.514663_g69_i0	PRJNA1247234	90	2119	4.514663	95.66570897	Methanobrevibacter sp.	66852	Archaea	Archaea	330	1.39e-93	NR	WP_407378952.1	66852	g69	i0	69.3	1.07881075979235	257	74	36.4	1	2114	1344	2142	2393	WP_407378952.1 Ig-like domain repeat protein [Methanobrevibacter sp.]	diamond	2286	330	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
26598468	26598468	PRJNA1247234_P_NODE_19761_length_255_cov_0.989011_g19605_i0	PRJNA1247234	19761	255	0.989011	2.52197805	Methanobrevibacter sp.	66852	Archaea	Archaea	46.6	4.97e-4	NR	MBO7697020.1	66852	g19605	i0	63.2	0.447058823529412	38	14	44.7	0	244	131	86	123	MBO7697020.1 helix-turn-helix transcriptional regulator [Methanobrevibacter sp.]	diamond	114	46.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
26661771	26661771	PRJNA1247234_P_NODE_22261_length_250_cov_0.881356_g22105_i0	PRJNA1247234	22261	250	0.881356	2.20339	Methanobrevibacter sp.	66852	Archaea	Archaea	65.9	2.86e-10	NR	WP_330048412.1	66852	g22105	i0	43.8	0.876	73	40	86.4	1	248	33	180	252	WP_330048412.1 hypothetical protein [Methanobrevibacter sp.]	diamond	219	65.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
26756905	26756905	PRJNA1247234_P_NODE_16741_length_277_cov_1.147059_g16585_i0	PRJNA1247234	16741	277	1.147059	3.17735343	Methanobrevibacter sp.	66852	Archaea	Archaea	90.9	1.02e-20	NR	MBO7518211.1	66852	g16585	i0	61.3	0.866425992779783	80	29	84.5	1	8	241	44	123	MBO7518211.1 hypothetical protein [Methanobrevibacter sp.]	diamond	240	90.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27010192	27010192	PRJNA1247234_P_NODE_22602_length_250_cov_0.881356_g22446_i0	PRJNA1247234	22602	250	0.881356	2.20339	Methanobrevibacter sp. UBA188	1915473	Archaea	Archaea	145	5.81e-41	NR	WP_292609825.1	1915473	g22446	i0	90.4	1.992	83	8	99.6	0	1	249	200	282	WP_292609825.1 hypothetical protein, partial [Methanobrevibacter sp. UBA188]	diamond	498	145	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. UBA188
27028444	27028444	PRJNA1247234_P_NODE_20122_length_253_cov_0.866667_g19966_i0	PRJNA1247234	20122	253	0.866667	2.19266751	Methanosphaera	2316	Archaea	Archaea	123	5.54e-33	NR	MBE6485823.1	2317	g19966	i0	65.1	2.96442687747036	83	29	98.4	0	2	250	49	131	MBE6485823.1 class I SAM-dependent methyltransferase [Methanosphaera stadtmanae]	diamond	750	123	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera stadtmanae
27199782	27199782	PRJNA1247234_P_NODE_7522_length_382_cov_5.799353_g7366_i0	PRJNA1247234	7522	382	5.799353	22.15352846	Methanobrevibacter sp.	66852	Archaea	Archaea	146	3.95e-42	NR	MEE3444538.1	66852	g7366	i0	74.4	0.706806282722513	90	23	70.7	0	353	84	1	90	MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.]	diamond	270	146	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27407993	27407993	PRJNA1247234_P_NODE_27963_length_242_cov_0.923077_g27807_i0	PRJNA1247234	27963	242	0.923077	2.23384634	Methanobrevibacter	2172	Archaea	Archaea	78.6	1.17e-15	NR	WP_405297679.1	66852	g27807	i0	71	3.07438016528926	62	14	71.9	1	64	237	21	82	WP_405297679.1 ion channel, partial [Methanobrevibacter sp.]	diamond	744	78.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27737276	27737276	PRJNA1247234_P_NODE_18644_length_263_cov_1.231579_g18488_i0	PRJNA1247234	18644	263	1.231579	3.23905277	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	65.9	1.52e-10	NR	MCC7554396.1	2099680	g18488	i0	43.8	2.21292775665399	64	36	73	0	72	263	1	64	MCC7554396.1 hypothetical protein [Methanobacteriaceae archaeon]	diamond	582	65.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
27768798	27768798	PRJNA1247234_P_NODE_8524_length_364_cov_1.704467_g8368_i0	PRJNA1247234	8524	364	1.704467	6.20425988	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	114	1.09e-30	NR	WP_295162069.1	253161	g8368	i0	100	0.502747252747253	61	0	50.3	0	1	183	6	66	WP_295162069.1 hypothetical protein [uncultured Methanobrevibacter sp.]	diamond	183	114	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
27818400	27818400	PRJNA1247234_P_NODE_27684_length_242_cov_0.923077_g27528_i0	PRJNA1247234	27684	242	0.923077	2.23384634	root	1	Root_unresolved	Root_unresolved	73.9	1.08e-13	NR	MBQ6345193.1	66852	g27528	i0	65	2.23140495867769	60	21	74.4	0	33	212	166	225	MBQ6345193.1 peptidoglycan-binding protein [Methanobrevibacter sp.]	diamond	540	74.3	0.994616419919246	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27957985	27957985	PRJNA1247234_P_NODE_17305_length_273_cov_1.015000_g17149_i0	PRJNA1247234	17305	273	1.015	2.77095	Methanosphaera sp. rholeuAM27	2666342	Archaea	Archaea	81.6	8.12e-16	NR	RAP49669.1	1945577	g17149	i0	48.1	0.846153846153846	77	40	84.6	0	233	3	41	117	RAP49669.1 MAG: hypothetical protein BZ138_07400 [Methanosphaera sp. rholeuAM270]	diamond	231	81.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. rholeuAM270
28621200	28621200	PRJNA1247234_P_NODE_24867_length_246_cov_0.901734_g24711_i0	PRJNA1247234	24867	246	0.901734	2.21826564	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	112	1.58e-26	NR	WP_295603788.1	253161	g24711	i0	66.7	0.98780487804878	81	27	98.8	0	3	245	83	163	WP_295603788.1 bifunctional glycosyltransferase/CDP-glycerol:glycerophosphate glycerophosphotransferase [uncultured Methanobrevibacter sp.]	diamond	243	112	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
28810152	28810152	PRJNA1247234_P_NODE_8368_length_367_cov_0.921769_g8212_i0	PRJNA1247234	8368	367	0.921769	3.38289223	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	208	1.02e-63	NR	WP_296887607.1	253161	g8212	i0	81.6	1.02179836512262	125	20	99.7	1	1	366	236	360	WP_296887607.1 tyrosine-type recombinase/integrase [uncultured Methanobrevibacter sp.]	diamond	375	208	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29031736	29031736	PRJNA1247234_P_NODE_25688_length_245_cov_0.906977_g25532_i0	PRJNA1247234	25688	245	0.906977	2.22209365	Methanobrevibacter sp.	66852	Archaea	Archaea	120	3.78e-32	NR	MBE6492947.1	66852	g25532	i0	100	2.27755102040816	62	0	75.9	0	186	1	1	62	MBE6492947.1 threonylcarbamoyladenosine tRNA methylthiotransferase [Methanobrevibacter sp.]	diamond	558	120	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29283920	29283920	PRJNA1247234_P_NODE_16189_length_281_cov_1.168269_g16033_i0	PRJNA1247234	16189	281	1.168269	3.28283589	Methanobrevibacter sp.	66852	Archaea	Archaea	112	2.73e-30	NR	MBO7518658.1	66852	g16033	i0	80.6	0.661921708185053	62	12	66.2	0	80	265	1	62	MBO7518658.1 hypothetical protein [Methanobrevibacter sp.]	diamond	186	112	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29631112	29631112	PRJNA1247234_P_NODE_22250_length_250_cov_0.881356_g22094_i0	PRJNA1247234	22250	250	0.881356	2.20339	Methanobrevibacter sp.	66852	Archaea	Archaea	142	2.0999999999999999e-38	NR	MBO6274206.1	66852	g22094	i0	84.1	0.984	82	13	98.4	0	249	4	42	123	MBO6274206.1 hypothetical protein [Methanobrevibacter sp.]	diamond	246	142	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29807252	29807252	PRJNA1247234_P_NODE_5271_length_442_cov_8.390244_g5117_i0	PRJNA1247234	5271	442	8.390244	37.08487848	Methanobrevibacter	2172	Archaea	Archaea	87.8	5.74e-17	NR	WP_329976379.1	66852	g5117	i0	37.6	4.08597285067873	149	89	99.1	4	440	3	225	372	WP_329976379.1 Ig-like domain repeat protein, partial [Methanobrevibacter sp.]	diamond	1806	88.6	0.99097065462754	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29933893	29933893	PRJNA1247234_P_NODE_26851_length_243_cov_0.917647_g26695_i0	PRJNA1247234	26851	243	0.917647	2.22988221	Methanobrevibacter	2172	Archaea	Archaea	113	4.46e-29	NR	WP_405273291.1	66852	g26695	i0	98.2	1.40740740740741	57	1	70.4	0	72	242	36	92	WP_405273291.1 ion channel [Methanobrevibacter sp.]	diamond	342	113	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30389947	30389947	PRJNA1247234_P_NODE_21973_length_250_cov_1.875706_g21817_i0	PRJNA1247234	21973	250	1.875706	4.689265	Methanobrevibacter sp.	66852	Archaea	Archaea	72.4	1.43e-12	NR	MBR1610529.1	66852	g21817	i0	52.8	2.496	72	32	86.4	2	239	24	437	506	MBR1610529.1 phage tail family protein [Methanobrevibacter sp.]	diamond	624	72.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30642147	30642147	PRJNA1247234_P_NODE_23253_length_249_cov_0.886364_g23097_i0	PRJNA1247234	23253	249	0.886364	2.20704636	Methanobrevibacter sp.	66852	Archaea	Archaea	107	1.37e-27	NR	WP_405288905.1	66852	g23097	i0	65.3	0.867469879518072	72	25	86.7	0	228	13	1	72	WP_405288905.1 hypothetical protein [Methanobrevibacter sp.]	diamond	216	107	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30736976	30736976	PRJNA1247234_P_NODE_23814_length_248_cov_0.891429_g23658_i0	PRJNA1247234	23814	248	0.891429	2.21074392	Methanobrevibacter sp.	66852	Archaea	Archaea	112	1.97e-27	NR	MBO6274172.1	66852	g23658	i0	62.2	0.991935483870968	82	31	99.2	0	248	3	245	326	MBO6274172.1 hypothetical protein [Methanobrevibacter sp.]	diamond	246	112	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31559154	31559154	PRJNA1247234_P_NODE_25576_length_245_cov_0.906977_g25420_i0	PRJNA1247234	25576	245	0.906977	2.22209365	Methanobrevibacter sp.	66852	Archaea	Archaea	97.8	1.61e-21	NR	MBR2558605.1	66852	g25420	i0	54.4	0.96734693877551	79	36	96.7	0	238	2	883	961	MBR2558605.1 hypothetical protein [Methanobrevibacter sp.]	diamond	237	97.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31938379	31938379	PRJNA1247234_P_NODE_2497_length_607_cov_4.548689_g2348_i0	PRJNA1247234	2497	607	4.548689	27.61054223	Methanosphaera stadtmanae	2317	Archaea	Archaea	76.6	5.58e-14	NR	MBE6494369.1	2317	g2348	i0	68.6	0.449752883031302	51	16	25.2	0	483	331	89	139	MBE6494369.1 site-specific DNA-methyltransferase [Methanosphaera stadtmanae]	diamond	273	76.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera stadtmanae
32128572	32128572	PRJNA1247234_P_NODE_21798_length_251_cov_0.876404_g21642_i0	PRJNA1247234	21798	251	0.876404	2.19977404	Methanobrevibacter sp.	66852	Archaea	Archaea	57.8	3.74e-8	NR	WP_407433072.1	66852	g21642	i0	78.1	0.932270916334661	32	6	38.2	1	7	102	118	148	WP_407433072.1 M15 family metallopeptidase [Methanobrevibacter sp.]	diamond	234	57.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32255303	32255303	PRJNA1247234_P_NODE_8178_length_370_cov_0.855219_g8022_i0	PRJNA1247234	8178	370	0.855219	3.1643103	Methanosphaera sp.	2666342	Archaea	Archaea	61.2	2.17e-9	NR	MBR3213489.1	2666342	g8022	i0	45.6	0.551351351351351	68	37	55.1	0	101	304	29	96	MBR3213489.1 zinc-ribbon domain-containing protein [Methanosphaera sp.]	diamond	204	61.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
32539936	32539936	PRJNA1247234_P_NODE_25839_length_245_cov_0.906977_g25683_i0	PRJNA1247234	25839	245	0.906977	2.22209365	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	90.9	2.5e-20	NR	WP_296804371.1	253161	g25683	i0	82.8	0.783673469387755	64	11	78.4	0	2	193	160	223	WP_296804371.1 hypothetical protein [uncultured Methanobrevibacter sp.]	diamond	192	90.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32791528	32791528	PRJNA1247234_P_NODE_1160_length_836_cov_1.644823_g1054_i0	PRJNA1247234	1160	836	1.644823	13.75072028	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	76.3	1.38e-12	NR	WP_295000840.1	253161	g1054	i0	46	0.358851674641148	100	46	35.9	2	792	493	16	107	WP_295000840.1 BspA family leucine-rich repeat surface protein [uncultured Methanobrevibacter sp.]	diamond	300	76.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.

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