metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA669701" 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
4462920	4462920	PRJNA669701_P_NODE_113384_length_249_cov_1.909091_g112989_i0	PRJNA669701	113384	249	1.909091	4.75363659	root	1	Root_unresolved	Root_unresolved	84.7	6.99e-17	NR	RYE85496.1	2250255	g112989	i0	53.2	6.62650602409639	79	34	95.2	1	1	237	127	202	RYE85496.1 MAG: hypothetical protein EOO65_00260 [Methanosarcinales archaeon]	diamond	1650	84.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
26986604	26986604	PRJNA669701_P_NODE_81682_length_280_cov_1.202899_g81287_i0	PRJNA669701	81682	280	1.202899	3.3681172	Halolamina pelagica	699431	Archaea	Archaea	43.1	0.0414	NR	KPN29342.1	699431	g81287	i0	47.4	1.01785714285714	95	38	94.3	4	2	265	111	200	KPN29342.1 hypothetical protein SY89_00055 [Halolamina pelagica]	diamond	285	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halolamina	Halolamina pelagica
27018330	27018330	PRJNA669701_P_NODE_111302_length_250_cov_0.870056_g110907_i0	PRJNA669701	111302	250	0.870056	2.17514	Methanomethylovorans sp.	2758717	Archaea	Archaea	166	1.07e-45	NR	MBC7085956.1	2758717	g110907	i0	100	0.996	83	0	99.6	0	1	249	244	326	MBC7085956.1 type II secretion system F family protein [Methanomethylovorans sp.]	diamond	249	166	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	Methanomethylovorans sp.
27050110	27050110	PRJNA669701_P_NODE_106882_length_251_cov_2.544944_g106487_i0	PRJNA669701	106882	251	2.544944	6.38780944	Thermoplasmata archaeon	1906666	Archaea	Archaea	45.1	0.00134	NR	HID25561.1	1906666	g106487	i0	51.1	0.561752988047809	47	23	56.2	0	2	142	8	54	HID25561.1 50S ribosomal protein P1 [Thermoplasmata archaeon]	diamond	141	45.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
27144462	27144462	PRJNA669701_P_NODE_90802_length_269_cov_1.566327_g90407_i0	PRJNA669701	90802	269	1.566327	4.21341963	Candidatus Methanophagales archaeon	2056316	Archaea	Archaea	70.1	1.16e-11	NR	MCK4734193.1	2056316	g90407	i0	41.4	0.970260223048327	87	46	92.6	2	251	3	92	177	MCK4734193.1 hypothetical protein [Candidatus Methanophagales archaeon]	diamond	261	70.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales			Candidatus Methanophagales archaeon
28704376	28704376	PRJNA669701_P_NODE_133587_length_243_cov_1.700000_g133192_i0	PRJNA669701	133587	243	1.7	4.131	root	1	Root_unresolved	Root_unresolved	88.2	3.92e-18	NR	MBI19537.1	2026739	g133192	i0	58.6	3.62962962962963	70	29	86.4	0	210	1	166	235	MBI19537.1 hypothetical protein [Methanobacteriota archaeon]	diamond	882	88.2	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28818204	28818204	PRJNA669701_P_NODE_147288_length_228_cov_2.464516_g146893_i0	PRJNA669701	147288	228	2.464516	5.61909648	Methanobacterium sp.	2164	Archaea	Archaea	57.8	1.58e-7	NR	MEN6293636.1	2164	g146893	i0	38.2	3.81578947368421	76	46	98.7	1	1	225	187	262	MEN6293636.1 GEVED domain-containing protein [Methanobacterium sp.]	diamond	870	57.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
29765613	29765613	PRJNA669701_P_NODE_95971_length_263_cov_2.163158_g95576_i0	PRJNA669701	95971	263	2.163158	5.68910554	Thermoplasmatales archaeon	2268204	Archaea	Archaea	62	7.77e-9	NR	MEM0135853.1	2268204	g95576	i0	64	0.570342205323194	50	15	55.9	2	262	116	548	595	MEM0135853.1 RNase H-like domain-containing protein [Thermoplasmatales archaeon]	diamond	150	62	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
29892301	29892301	PRJNA669701_P_NODE_7171_length_912_cov_4.983313_g6836_i0	PRJNA669701	7171	912	4.983313	45.44781456	Candidatus Methanophagaceae archaeon	3386247	Archaea	Archaea	79.7	1.41e-12	NR	KAF5437882.1	3386247	g6836	i0	27.5	1.86184210526316	273	165	87.2	13	20	814	222	469	KAF5437882.1 Kazal-type serine protease inhibitor domain-containing protein [Candidatus Methanophagaceae archaeon]	diamond	1698	79.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales	Candidatus Methanophagaceae		Candidatus Methanophagaceae archaeon
30966506	30966506	PRJNA669701_P_NODE_81114_length_280_cov_3.439614_g80719_i0	PRJNA669701	81114	280	3.439614	9.6309192	Candidatus Hydrothermarchaeota archaeon	2250275	Archaea	Archaea	70.1	9.22e-13	NR	MFQ6050670.1	2250275	g80719	i0	60.3	1.83214285714286	58	21	62.1	1	8	181	21	76	MFQ6050670.1 NUDIX domain-containing protein [Candidatus Hydrothermarchaeota archaeon]	diamond	513	70.1	1	Archaea		Methanobacteriati	Candidatus Hydrothermarchaeota					Candidatus Hydrothermarchaeota archaeon
31313927	31313927	PRJNA669701_P_NODE_123075_length_246_cov_2.508671_g122680_i0	PRJNA669701	123075	246	2.508671	6.17133066	Halodesulfurarchaeum sp.	1980530	Archaea	Archaea	125	2.22e-33	NR	WP_332321601.1	1980530	g122680	i0	76.5	1.97560975609756	81	19	98.8	0	3	245	23	103	WP_332321601.1 hypothetical protein [Halodesulfurarchaeum sp.]	diamond	486	125	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum sp.
32358205	32358205	PRJNA669701_P_NODE_27059_length_451_cov_14.124339_g26664_i0	PRJNA669701	27059	451	14.124339	63.70076889	Thermoplasmata archaeon	1906666	Archaea	Archaea	59.3	5.12e-7	NR	RLF29100.1	1906666	g26664	i0	34	2.06208425720621	103	67	68.5	1	55	363	57	158	RLF29100.1 MAG: hypothetical protein DRN05_02420 [Thermoplasmata archaeon]	diamond	930	59.3	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32433449	32433449	PRJNA669701_P_NODE_106319_length_252_cov_1.625698_g105924_i0	PRJNA669701	106319	252	1.625698	4.09675896	root	1	Root_unresolved	Root_unresolved	44.7	0.00678	NR	MFQ6127443.1	1906666	g105924	i0	43.1	2.47619047619048	58	29	69	2	64	237	61	114	MFQ6127443.1 adenylate kinase [Thermoplasmata archaeon]	diamond	624	44.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon

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