metadata: contig_metadata: 15 rows where bioproject = "PRJNA615351" and tax

15 rows where bioproject = "PRJNA615351" 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
3146788	3146788	PRJNA615351_P_NODE_77883_length_440_cov_1.580247_g63862_i0	PRJNA615351	77883	440	1.580247	6.9530868	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	147	6.37e-38	NR	WP_295614776.1	253161	g63862	i0	60.4	1.51363636363636	111	42	75.7	1	333	1	611	719	WP_295614776.1 cyclic nucleotide-binding serine/threonine-protein kinase, partial [uncultured Methanobrevibacter sp.]	diamond	666	147	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
3701621	3701621	PRJNA615351_P_NODE_181623_length_154_cov_2.991597_g167523_i0	PRJNA615351	181623	154	2.991597	4.60705938	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	97.4	5.84e-22	NR	WP_295614768.1	253161	g167523	i0	86	0.974025974025974	50	7	97.4	0	152	3	731	780	WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.]	diamond	150	97.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
24821765	24821765	PRJNA615351_P_NODE_144380_length_199_cov_0.975610_g130280_i0	PRJNA615351	144380	199	0.97561	1.9414639	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	56.5	0.001	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g130280	i0	100	0.587939698492462	30	0	15	0	168	197	1389617	1389588	Methanobrevibacter sp. YE315, complete genome	blastn	117	56.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
27080337	27080337	PRJNA615351_P_NODE_114362_length_266_cov_2.333333_g100263_i0	PRJNA615351	114362	266	2.333333	6.20666578	Methanobrevibacter sp.	66852	Archaea	Archaea	43.5	0.0155	NR	MBO7212627.1	66852	g100263	i0	38.2	1.80451127819549	76	22	84.6	3	232	8	4	55	MBO7212627.1 hypothetical protein [Methanobrevibacter sp.]	diamond	480	43.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27459818	27459818	PRJNA615351_P_NODE_34543_length_1018_cov_1.600203_g25439_i0	PRJNA615351	34543	1018	1.600203	16.29006654	Methanosphaera sp.	2666342	Archaea	Archaea	56.2	1.05e-4	NR	MEE3419417.1	2666342	g25439	i0	19.3	0.671905697445973	228	178	66.3	4	754	80	104	328	MEE3419417.1 PX and WD40 repeat domain-containing protein [Methanosphaera sp.]	diamond	684	56.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
27712634	27712634	PRJNA615351_P_NODE_16924_length_1599_cov_16.347826_g5147_i1	PRJNA615351	16924	1599	16.347826	261.40173774	Methanothermobacter sp. THM-1	2606911	Archaea	Archaea	53.5	0.00196	NR	WP_191216576.1	2606911	g5147	i1	32.6	0.418386491557223	89	50	16.5	3	1114	851	71	150	WP_191216576.1 DUF7411 family protein [Methanothermobacter sp. THM-1]	diamond	669	53.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanothermobacter	Methanothermobacter sp. THM-1
28185697	28185697	PRJNA615351_P_NODE_7306_length_2321_cov_17.716973_g5194_i0	PRJNA615351	7306	2321	17.716973	411.21094333	Methanobrevibacter sp.	66852	Archaea	Archaea	50.4	0.0445	NR	WP_292749283.1	66852	g5194	i0	29	0.178371391641534	138	81	15.9	5	1215	847	268	403	WP_292749283.1 C1 family peptidase [Methanobrevibacter sp.]	diamond	414	50.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29272065	29272065	PRJNA615351_P_NODE_61369_length_582_cov_1.775137_g48019_i0	PRJNA615351	61369	582	1.775137	10.33129734	root	1	Root_unresolved	Root_unresolved	292	1.01e-90	NR	WP_295614768.1	253161	g48019	i0	72.8	2.95360824742268	191	52	98.5	0	581	9	310	500	WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.]	diamond	1719	292	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29303816	29303816	PRJNA615351_P_NODE_38009_length_939_cov_17.869469_g28147_i0	PRJNA615351	38009	939	17.869469	167.79431391	Methanobrevibacter	2172	Archaea	Archaea	103	4.19e-22	NR	WP_303739603.1	190975	g28147	i0	31.1	3.04472843450479	238	141	69.3	6	50	700	9	244	WP_303739603.1 MIP/aquaporin family protein [Methanobrevibacter thaueri]	diamond	2859	103	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter thaueri
29543348	29543348	PRJNA615351_P_NODE_123610_length_241_cov_1.359223_g109510_i0	PRJNA615351	123610	241	1.359223	3.27572743	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	61.6	2.74e-9	NR	WP_296892731.1	253161	g109510	i0	45.7	1.84232365145228	70	37	87.1	1	2	211	1	69	WP_296892731.1 ABC transporter ATP-binding protein [uncultured Methanobrevibacter sp.]	diamond	444	61.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
30396803	30396803	PRJNA615351_P_NODE_145113_length_197_cov_2.537037_g131013_i0	PRJNA615351	145113	197	2.537037	4.99796289	Methanotorris igneus	2189	Archaea	Archaea	75.5	5.78e-14	NR	WP_013799761.1	2189	g131013	i0	61.9	0.959390862944162	63	23	95.9	1	8	196	582	643	WP_013799761.1 methionine--tRNA ligase [Methanotorris igneus]	diamond	189	75.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanotorris	Methanotorris igneus
30428390	30428390	PRJNA615351_P_NODE_35113_length_1004_cov_4.098039_g25878_i0	PRJNA615351	35113	1004	4.098039	41.14431156	Methanobrevibacter sp.	66852	Archaea	Archaea	233	1.49e-70	NR	WP_292806969.1	66852	g25878	i0	39.5	0.99800796812749	334	185	95.3	4	3	959	11	342	WP_292806969.1 WD40 repeat domain-containing protein [Methanobrevibacter sp.]	diamond	1002	233	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31312816	31312816	PRJNA615351_P_NODE_80735_length_421_cov_1.642487_g66693_i0	PRJNA615351	80735	421	1.642487	6.91487027	Methanosphaera sp. ISO3-F5	1452353	Archaea	Archaea	60.8	1.18e-7	NR	WP_323735470.1	1452353	g66693	i0	34.2	1.67458432304038	111	69	78.4	2	412	83	69	176	WP_323735470.1 AAA domain-containing protein [Methanosphaera sp. ISO3-F5]	diamond	705	60.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. ISO3-F5
31452399	31452399	PRJNA615351_P_NODE_94776_length_341_cov_3.127451_g80687_i0	PRJNA615351	94776	341	3.127451	10.66460791	root	1	Root_unresolved	Root_unresolved	92.8	3.22e-19	NR	WP_295614768.1	253161	g80687	i0	55.6	1.24926686217009	72	32	63.3	0	220	5	172	243	WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.]	diamond	426	92.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32021631	32021631	PRJNA615351_P_NODE_38538_length_929_cov_2.223714_g28558_i0	PRJNA615351	38538	929	2.223714	20.65830306	root	1	Root_unresolved	Root_unresolved	59.7	2.18e-6	NR	WP_181501616.1	39152	g28558	i0	40	1.56620021528525	65	39	21	0	369	563	26	90	WP_181501616.1 DUF4326 domain-containing protein [Methanococcus maripaludis]	diamond	1455	60.1	0.993344425956739	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanococcaceae	Methanococcus	Methanococcus maripaludis

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