metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_clade = "Stenosarchaea 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
22558871	22558871	PRJNA902848_P_NODE_17618_length_246_cov_0.901734_g17568_i0	PRJNA902848	17618	246	0.901734	2.21826564	Methanothrix sp.	90426	Archaea	Archaea	142	4.69e-40	NR	MDD4162723.1	90426	g17568	i0	88.9	2.96341463414634	81	9	98.8	0	245	3	107	187	MDD4162723.1 arsenite methyltransferase [Methanothrix sp.]	diamond	729	142	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
27529788	27529788	PRJNA902848_P_NODE_18843_length_244_cov_0.912281_g18793_i0	PRJNA902848	18843	244	0.912281	2.22596564	Methanoregulaceae archaeon	2485498	Archaea	Archaea	52.4	1.48e-5	NR	HNW81227.1	2485498	g18793	i0	39.4	5.23770491803279	71	40	87.3	1	224	12	76	143	HNW81227.1 PKD domain-containing protein [Methanoregulaceae archaeon]	diamond	1278	52.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
27845379	27845379	PRJNA902848_P_NODE_20424_length_242_cov_0.911243_g20374_i0	PRJNA902848	20424	242	0.911243	2.20520806	Methanospirillum sp. J.3.6.1-F.2.7.3	2834276	Archaea	Archaea	147	2.88e-39	NR	WP_372238735.1	2834276	g20374	i0	91.3	0.991735537190083	80	7	99.2	0	1	240	97	176	WP_372238735.1 DNA-directed RNA polymerase subunit A'' [Methanospirillum purgamenti]	diamond	240	147	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum purgamenti
28382307	28382307	PRJNA902848_P_NODE_14546_length_251_cov_0.876404_g14496_i0	PRJNA902848	14546	251	0.876404	2.19977404	Methanosarcinales archaeon	2250255	Archaea	Archaea	159	5.29e-47	NR	NYT10178.1	2250255	g14496	i0	91.6	2.97609561752988	83	7	99.2	0	249	1	6	88	NYT10178.1 class I SAM-dependent methyltransferase [Methanosarcinales archaeon]	diamond	747	159	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
29581779	29581779	PRJNA902848_P_NODE_20370_length_242_cov_0.923077_g20320_i0	PRJNA902848	20370	242	0.923077	2.23384634	Methanoregula sp.	2052170	Archaea	Archaea	75.1	8.35e-14	NR	MFA4826370.1	2052170	g20320	i0	85.7	0.520661157024793	42	6	52.1	0	117	242	42	83	MFA4826370.1 type II CAAX endopeptidase family protein [Methanoregula sp.]	diamond	126	75.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
30782539	30782539	PRJNA902848_P_NODE_20134_length_242_cov_0.923077_g20084_i0	PRJNA902848	20134	242	0.923077	2.23384634	Methanothrix sp.	90426	Archaea	Archaea	147	8.07e-40	NR	MBP7071201.1	90426	g20084	i0	96.3	1.98347107438017	80	3	99.2	0	1	240	291	370	MBP7071201.1 potassium/proton antiporter [Methanothrix sp.]	diamond	480	147	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
31035626	31035626	PRJNA902848_P_NODE_15515_length_249_cov_0.886364_g15465_i0	PRJNA902848	15515	249	0.886364	2.20704636	Methanofollis ethanolicus	488124	Archaea	Archaea	44.7	0.00847	NR	WP_067051216.1	488124	g15465	i0	35.5	0.91566265060241	76	42	91.6	1	21	248	148	216	WP_067051216.1 bifunctional RecB family nuclease/DEAD/DEAH box helicase [Methanofollis ethanolicus]	diamond	228	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanofollis	Methanofollis ethanolicus
31383178	31383178	PRJNA902848_P_NODE_15536_length_249_cov_0.886364_g15486_i0	PRJNA902848	15536	249	0.886364	2.20704636	Methanofastidiosum sp.	2666341	Archaea	Archaea	159	7.189999999999998e-47	NR	MFA5559172.1	2666341	g15486	i0	93.8	2.92771084337349	81	5	97.6	0	245	3	61	141	MFA5559172.1 HD domain-containing protein [Methanofastidiosum sp.]	diamond	729	159	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia	Candidatus Methanofastidiosales	Candidatus Methanofastidiosaceae	Candidatus Methanofastidiosum	Methanofastidiosum sp.
32269010	32269010	PRJNA902848_P_NODE_17818_length_246_cov_0.901734_g17768_i0	PRJNA902848	17818	246	0.901734	2.21826564	Methanoregula sp.	2052170	Archaea	Archaea	159	5.09e-46	NR	HSQ93991.1	2052170	g17768	i0	97.6	2	82	2	100	0	246	1	70	151	HSQ93991.1 tRNA(Ile2) 2-agmatinylcytidine synthetase [Methanoregula sp.]	diamond	492	159	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula 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);;