metadata: contig_metadata: 16 rows where bioproject = "PRJNA1020641" and tax

16 rows where bioproject = "PRJNA1020641" 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
10363790	10363790	PRJNA1020641_P_NODE_7309_length_242_cov_0.881657_g7266_i0	PRJNA1020641	7309	242	0.881657	2.13360994	Methanobrevibacter sp. UBA188	1915473	Archaea	Archaea	117	2.7000000000000003e-28	NR	WP_292883709.1	1915473	g7266	i0	72.5	0.991735537190083	80	20	99.2	1	242	3	235	312	WP_292883709.1 ThiF family adenylyltransferase, partial [Methanobrevibacter sp. UBA188]	diamond	240	117	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. UBA188
16305471	16305471	PRJNA1020641_P_NODE_6753_length_245_cov_0.895349_g6710_i0	PRJNA1020641	6753	245	0.895349	2.19360505	Methanobrevibacter	2172	Archaea	Archaea	324	4.24e-84	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g6710	i0	91.489	6.71428571428571	235	20	96	0	1	235	678426	678192	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	1645	324	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
27098035	27098035	PRJNA1020641_P_NODE_6462_length_246_cov_0.890173_g6419_i0	PRJNA1020641	6462	246	0.890173	2.18982558	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	108	1.94e-25	NR	WP_295723618.1	253161	g6419	i0	63	0.98780487804878	81	30	98.8	0	245	3	526	606	WP_295723618.1 cyclic nucleotide-binding serine/threonine-protein kinase [uncultured Methanobrevibacter sp.]	diamond	243	108	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
27287720	27287720	PRJNA1020641_P_NODE_2063_length_427_cov_0.782486_g2020_i0	PRJNA1020641	2063	427	0.782486	3.34121522	Methanobrevibacter sp.	66852	Archaea	Archaea	183	1.76e-50	NR	WP_405274167.1	66852	g2020	i0	64.3	1.9672131147541	140	49	98.4	1	6	425	835	973	WP_405274167.1 hypothetical protein, partial [Methanobrevibacter sp.]	diamond	840	183	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27477265	27477265	PRJNA1020641_P_NODE_7243_length_242_cov_0.911243_g7200_i0	PRJNA1020641	7243	242	0.911243	2.20520806	Methanosphaera sp.	2666342	Archaea	Archaea	161	5.41e-44	NR	MEE3325325.1	2666342	g7200	i0	87.3	0.979338842975207	79	10	97.9	0	3	239	605	683	MEE3325325.1 hypothetical protein [Methanosphaera sp.]	diamond	237	161	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
27571993	27571993	PRJNA1020641_P_NODE_6144_length_248_cov_0.880000_g6101_i0	PRJNA1020641	6144	248	0.88	2.1824	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	61.6	9e-9	NR	WP_295723641.1	253161	g6101	i0	34.2	0.955645161290323	79	52	95.6	0	4	240	373	451	WP_295723641.1 ATP-binding cassette domain-containing protein [uncultured Methanobrevibacter sp.]	diamond	237	61.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
27950954	27950954	PRJNA1020641_P_NODE_4045_length_303_cov_0.926087_g4002_i0	PRJNA1020641	4045	303	0.926087	2.80604361	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	189	1.55e-53	NR	WP_295723615.1	253161	g4002	i0	96	0.99009900990099	100	4	99	0	301	2	69	168	WP_295723615.1 AP-1 complex subunit gamma [uncultured Methanobrevibacter sp.]	diamond	300	189	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
28014243	28014243	PRJNA1020641_P_NODE_3505_length_327_cov_0.751969_g3462_i0	PRJNA1020641	3505	327	0.751969	2.45893863	Methanosphaera sp.	2666342	Archaea	Archaea	82	1.71e-15	NR	HIH35438.1	2666342	g3462	i0	42.1	1.87155963302752	95	54	87.2	1	291	7	921	1014	HIH35438.1 hypothetical protein [Methanosphaera sp.]	diamond	612	82	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
28171876	28171876	PRJNA1020641_P_NODE_2906_length_359_cov_1.513986_g2863_i0	PRJNA1020641	2906	359	1.513986	5.43520974	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	201	4.5899999999999994e-57	NR	WP_298503090.1	253161	g2863	i0	82.5	1.00278551532033	120	20	99.4	1	359	3	763	882	WP_298503090.1 hypothetical protein, partial [uncultured Methanobrevibacter sp.]	diamond	360	201	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
28361260	28361260	PRJNA1020641_P_NODE_2166_length_417_cov_1.116279_g2123_i0	PRJNA1020641	2166	417	1.116279	4.65488343	Methanobrevibacter sp.	66852	Archaea	Archaea	100	1.29e-22	NR	MBO7734943.1	66852	g2123	i0	39.5	0.892086330935252	124	75	89.2	0	5	376	115	238	MBO7734943.1 hypothetical protein [Methanobrevibacter sp.]	diamond	372	100	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28574515	28574515	PRJNA1020641_P_NODE_7447_length_241_cov_0.916667_g7404_i0	PRJNA1020641	7447	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	75.1	8.28e-14	NR	MEE3444316.1	66852	g7404	i0	66	1.86721991701245	50	17	62.2	0	151	2	79	128	MEE3444316.1 C1 family peptidase [Methanobrevibacter sp.]	diamond	450	75.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30224380	30224380	PRJNA1020641_P_NODE_4432_length_287_cov_1.079439_g4389_i0	PRJNA1020641	4432	287	1.079439	3.09798993	Methanobrevibacter sp.	66852	Archaea	Archaea	98.2	2.11e-21	NR	WP_292800363.1	66852	g4389	i0	76.4	0.574912891986063	55	13	57.5	0	285	121	346	400	WP_292800363.1 hypothetical protein [Methanobrevibacter sp.]	diamond	165	98.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30477356	30477356	PRJNA1020641_P_NODE_3233_length_341_cov_1.048507_g3190_i0	PRJNA1020641	3233	341	1.048507	3.57540887	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	127	3.22e-31	NR	WP_297980104.1	253161	g3190	i0	63.5	0.844574780058651	96	28	78.3	1	73	339	669	764	WP_297980104.1 HAD family hydrolase [uncultured Methanobrevibacter sp.]	diamond	288	127	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
30824733	30824733	PRJNA1020641_P_NODE_4974_length_268_cov_1.020513_g4931_i0	PRJNA1020641	4974	268	1.020513	2.73497484	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	154	3.25e-41	NR	WP_295723641.1	253161	g4931	i0	86.5	0.996268656716418	89	12	99.6	0	2	268	391	479	WP_295723641.1 ATP-binding cassette domain-containing protein [uncultured Methanobrevibacter sp.]	diamond	267	154	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32121469	32121469	PRJNA1020641_P_NODE_2358_length_398_cov_0.987692_g2315_i0	PRJNA1020641	2358	398	0.987692	3.93101416	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	203	1.4699999999999997e-57	NR	WP_295723641.1	253161	g2315	i0	72.7	0.994974874371859	132	36	99.5	0	398	3	648	779	WP_295723641.1 ATP-binding cassette domain-containing protein [uncultured Methanobrevibacter sp.]	diamond	396	203	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32366779	32366779	PRJNA1020641_P_NODE_6959_length_243_cov_1.811765_g6916_i0	PRJNA1020641	6959	243	1.811765	4.40258895	root	1	Root_unresolved	Root_unresolved	145	1.67e-38	NR	WP_405306311.1	66852	g6916	i0	86.3	1.97530864197531	80	11	98.8	0	2	241	285	364	WP_405306311.1 HAD-IC family P-type ATPase, partial [Methanobrevibacter sp.]	diamond	480	145	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	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);;