metadata: contig_metadata: 7 rows where bioproject = "PRJNA438572" and tax

7 rows where bioproject = "PRJNA438572" 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
28812548	28812548	PRJNA438572_P_NODE_12508_length_291_cov_1.568807_g12389_i0	PRJNA438572	12508	291	1.568807	4.56522837	Methanoregula sp. UBA64	1915554	Archaea	Archaea	78.6	1.69e-14	NR	WP_292370680.1	1915554	g12389	i0	45.3	2.95876288659794	95	49	97.9	1	5	289	802	893	WP_292370680.1 magnesium-translocating P-type ATPase [Methanoregula sp. UBA64]	diamond	861	78.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. UBA64
29633411	29633411	PRJNA438572_P_NODE_24490_length_242_cov_0.923077_g24371_i0	PRJNA438572	24490	242	0.923077	2.23384634	Thermoplasmata archaeon	1906666	Archaea	Archaea	62.4	2.36e-9	NR	MFP4000404.1	1906666	g24371	i0	36.3	0.991735537190083	80	47	94.2	1	242	15	16	95	MFP4000404.1 enoyl-CoA hydratase/isomerase family protein [Thermoplasmata archaeon]	diamond	240	62.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
30644556	30644556	PRJNA438572_P_NODE_10673_length_314_cov_1.294606_g10554_i0	PRJNA438572	10673	314	1.294606	4.06506284	Methanomethylophilus sp.	2774294	Archaea	Archaea	45.1	0.0116	NR	MBO4502605.1	2774294	g10554	i0	36.4	1.46178343949045	55	35	52.5	0	114	278	12	66	MBO4502605.1 Mrp/NBP35 family ATP-binding protein [Methanomethylophilus sp.]	diamond	459	45.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus sp.
30819028	30819028	PRJNA438572_P_NODE_12874_length_288_cov_1.409302_g12755_i0	PRJNA438572	12874	288	1.409302	4.05878976	root	1	Root_unresolved	Root_unresolved	127	4.27e-33	NR	WP_089866118.1	553466	g12755	i0	58.5	21.5833333333333	94	39	97.9	0	5	286	54	147	WP_089866118.1 alcohol dehydrogenase [Halogranum rubrum]	diamond	6216	127	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halogranum	Halogranum rubrum
30819036	30819036	PRJNA438572_P_NODE_8774_length_344_cov_1.151292_g8655_i0	PRJNA438572	8774	344	1.151292	3.96044448	root	1	Root_unresolved	Root_unresolved	92.8	2.46e-19	NR	HEX7444945.1	90426	g8655	i0	43.6	4.68313953488372	110	56	94.2	2	18	341	32	137	HEX7444945.1 ATP citrate lyase citrate-binding domain-containing protein [Methanothrix sp.]	diamond	1611	93.6	0.991452991452991	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
32035853	32035853	PRJNA438572_P_NODE_5378_length_430_cov_1.184874_g5259_i0	PRJNA438572	5378	430	1.184874	5.0949582	Thermoplasmata archaeon	1906666	Archaea	Archaea	44.7	0.0474	NR	MCK5292578.1	1906666	g5259	i0	31.8	0.613953488372093	88	57	59.3	1	6	260	211	298	MCK5292578.1 cell division protein FtsZ [Thermoplasmata archaeon]	diamond	264	44.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32810361	32810361	PRJNA438572_P_NODE_3060_length_561_cov_1.684426_g2942_i0	PRJNA438572	3060	561	1.684426	9.44962986	Methanoregula	395331	Archaea	Archaea	50.4	0.00166	NR	WP_292368417.1	1915554	g2942	i0	38.2	0.796791443850267	76	42	40.6	1	334	561	292	362	WP_292368417.1 hypothetical protein [Methanoregula sp. UBA64]	diamond	447	50.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. UBA64

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