metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA760904" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA760904" and tax_kingdom = "Methanobacteriati"

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
5845783	5845783	PRJNA760904_P_NODE_12265_length_269_cov_1.290816_g12208_i0	PRJNA760904	12265	269	1.290816	3.47229504	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	126	2.24e-31	NR	WP_295614768.1	253161	g12208	i0	68.5	0.992565055762082	89	28	99.3	0	2	268	681	769	WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.]	diamond	267	126	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
9670721	9670721	PRJNA760904_P_NODE_9688_length_290_cov_1.142857_g9631_i0	PRJNA760904	9688	290	1.142857	3.3142853	Methanobacteriati	3366610	Archaea	Archaea	144	4.41e-38	NR	MDB3855351.1	2026739	g9631	i0	71.9	7.9448275862069	96	27	99.3	0	290	3	300	395	MDB3855351.1 CTP synthase (glutamine hydrolyzing) [Methanobacteriota archaeon]	diamond	2304	144	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28231124	28231124	PRJNA760904_P_NODE_13086_length_263_cov_1.078947_g13029_i0	PRJNA760904	13086	263	1.078947	2.83763061	Methanobacteriati	3366610	Archaea	Archaea	64.3	7.98e-10	NR	OIR22150.1	1888996	g13029	i0	39.1	7.97338403041825	87	35	99.2	2	3	263	30	98	OIR22150.1 MAG: hypothetical protein BET99_01285 [Marine Group III euryarchaeote CG-Epi2]	diamond	2097	64.3	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Thermoprofundales			Marine Group III euryarchaeote CG-Epi2
28421028	28421028	PRJNA760904_P_NODE_14966_length_251_cov_0.865169_g14909_i0	PRJNA760904	14966	251	0.865169	2.17157419	Methanobacteriati	3366610	Archaea	Archaea	76.6	2.52e-14	NR	RAH17199.1	2026739	g14909	i0	48.8	4.57768924302789	84	40	99.2	2	2	250	3	84	RAH17199.1 MAG: hypothetical protein CMB58_000735 [Methanobacteriota archaeon]	diamond	1149	76.6	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29273141	29273141	PRJNA760904_P_NODE_20309_length_241_cov_6.345238_g20252_i0	PRJNA760904	20309	241	6.345238	15.29202358	Archaea	2157	Archaea	Archaea	105	1.3399999999999999e-24	NR	KYK26992.1	1803821	g20252	i0	70.3	4.92946058091286	64	19	79.7	0	194	3	8	71	KYK26992.1 MAG: proline--tRNA ligase [Euryarchaeota archaeon SM23-78]	diamond	1188	106	0.990566037735849	Archaea		Methanobacteriati	Methanobacteriota					Euryarchaeota archaeon SM23-78
29336534	29336534	PRJNA760904_P_NODE_13749_length_257_cov_2.250000_g13692_i0	PRJNA760904	13749	257	2.25	5.7825	Methanobacteriaceae	2159	Archaea	Archaea	44.7	0.00955	NR	WP_066973734.1	55758	g13692	i0	46.2	1.52918287937743	39	21	45.5	0	235	119	184	222	WP_066973734.1 beta strand repeat-containing protein [Methanobrevibacter filiformis]	diamond	393	44.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter filiformis
29809959	29809959	PRJNA760904_P_NODE_8991_length_299_cov_1.238938_g8934_i0	PRJNA760904	8991	299	1.238938	3.70442462	Archaea	2157	Archaea	Archaea	46.2	0.00397	NR	MCX6664660.1	2026739	g8934	i0	27.5	2.57859531772575	102	67	95.3	2	290	6	61	162	MCX6664660.1 hypothetical protein [Methanobacteriota archaeon]	diamond	771	46.2	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30242811	30242811	PRJNA760904_P_NODE_912_length_792_cov_3.588317_g862_i0	PRJNA760904	912	792	3.588317	28.41947064	Methanobacteriota archaeon	2026739	Archaea	Archaea	49.7	0.00712	NR	RMG21782.1	2026739	g862	i0	24	0.821969696969697	217	136	78.4	8	1	621	118	315	RMG21782.1 MAG: hypothetical protein D6732_26870 [Methanobacteriota archaeon]	diamond	651	49.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30947675	30947675	PRJNA760904_P_NODE_16234_length_248_cov_1.748571_g16177_i0	PRJNA760904	16234	248	1.748571	4.33645608	root	1	Root_unresolved	Root_unresolved	75.5	9.06e-14	NR	MDR0335267.1	2052168	g16177	i0	57.1	7.92338709677419	63	25	76.2	1	190	2	2	62	MDR0335267.1 molecular chaperone DnaJ [Methanomassiliicoccaceae archaeon]	diamond	1965	75.9	0.994729907773386	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon
32329707	32329707	PRJNA760904_P_NODE_2959_length_475_cov_1.703980_g2902_i0	PRJNA760904	2959	475	1.70398	8.093905	Methanobacterium sp. MZD13	2164	Archaea	Archaea	57	4.67e-6	NR	WP_416111484.1	3394378	g2902	i0	33.9	0.783157894736842	124	72	77.1	4	420	55	12	127	WP_416111484.1 Ig-like domain repeat protein, partial [Methanobacterium sp. MZD130B]	diamond	372	57	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. MZD130B
32708309	32708309	PRJNA760904_P_NODE_8840_length_301_cov_2.802632_g8783_i0	PRJNA760904	8840	301	2.802632	8.43592232	Halopenitus persicus	1048396	Archaea	Archaea	46.2	0.00405	NR	WP_096390081.1	1048396	g8783	i0	41.4	0.578073089700997	58	33	57.8	1	174	1	1	57	WP_096390081.1 alpha/beta fold hydrolase [Halopenitus persicus]	diamond	174	46.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus persicus

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