metadata: contig_metadata: 7 rows where bioproject = "PRJNA796753", tax_kingdom = "Methanobacteriati" and tax

7 rows where bioproject = "PRJNA796753", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18632069	18632069	PRJNA796753_P_NODE_14275_length_376_cov_0.910891_g13963_i0	PRJNA796753	14275	376	0.910891	3.42495016	root	1	Root_unresolved	Root_unresolved	194	1.5699999999999998e-57	NR	MBE6527559.1	1906666	g13963	i0	71.2	11.968085106383	125	35	98.9	1	374	3	146	270	MBE6527559.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Thermoplasmata archaeon]	diamond	4500	194	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
27536971	27536971	PRJNA796753_P_NODE_27003_length_290_cov_1.230415_g26691_i0	PRJNA796753	27003	290	1.230415	3.5682035	root	1	Root_unresolved	Root_unresolved	47.8	0.00118	NR	WP_019178328.1	1080712	g26691	i0	30.3	1.37586206896552	66	46	68.3	0	202	5	521	586	WP_019178328.1 RHS repeat domain-containing protein [Methanomassiliicoccus luminyensis]	diamond	399	48.1	0.993762993762994	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae	Methanomassiliicoccus	Methanomassiliicoccus luminyensis
28348733	28348733	PRJNA796753_P_NODE_39666_length_251_cov_0.865169_g39354_i0	PRJNA796753	39666	251	0.865169	2.17157419	Thermoplasmata archaeon	1906666	Archaea	Archaea	50.8	5.96e-5	NR	MCK4456249.1	1906666	g39354	i0	42	1.88844621513944	69	36	77.7	1	248	54	1760	1828	MCK4456249.1 FG-GAP repeat protein [Thermoplasmata archaeon]	diamond	474	50.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28475072	28475072	PRJNA796753_P_NODE_22346_length_315_cov_1.272727_g22034_i0	PRJNA796753	22346	315	1.272727	4.00909005	Thermoplasmata archaeon	1906666	Archaea	Archaea	51.2	9.3e-5	NR	MEM4293694.1	1906666	g22034	i0	34.1	0.866666666666667	91	56	84.8	3	20	286	1158	1246	MEM4293694.1 kelch repeat-containing protein [Thermoplasmata archaeon]	diamond	273	51.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29201356	29201356	PRJNA796753_P_NODE_10509_length_428_cov_1.301408_g10197_i0	PRJNA796753	10509	428	1.301408	5.57002624	Candidatus Sysuiplasma superficiale	2823368	Archaea	Archaea	52.4	5.14e-5	NR	MBX8643925.1	2823368	g10197	i0	28	1.71028037383178	132	84	84.8	3	408	46	7	138	MBX8643925.1 hypothetical protein [Candidatus Sysuiplasma superficiale]	diamond	732	52.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Sysuiplasmatales	Candidatus Sysuiplasmataceae	Candidatus Sysuiplasma	Candidatus Sysuiplasma superficiale
32298835	32298835	PRJNA796753_P_NODE_17339_length_348_cov_0.825455_g17027_i0	PRJNA796753	17339	348	0.825455	2.8725834	Thermoplasmata archaeon	1906666	Archaea	Archaea	44.3	0.016	NR	RLF55226.1	1906666	g17027	i0	29.9	2.03448275862069	117	63	96.6	3	13	348	14	116	RLF55226.1 MAG: hypothetical protein DRN13_00785 [Thermoplasmata archaeon]	diamond	708	44.3	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32330464	32330464	PRJNA796753_P_NODE_36799_length_257_cov_1.673913_g36487_i0	PRJNA796753	36799	257	1.673913	4.30195641	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	43.1	0.0312	NR	MDP7374755.1	2666346	g36487	i0	34.9	1.00389105058366	86	44	88.7	2	230	3	289	372	MDP7374755.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	258	43.1	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae 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);;