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

7 rows where bioproject = "PRJNA577580", 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_species
3114923	3114923	PRJNA577580_P_NODE_15963_length_243_cov_2.364706_g15885_i0	PRJNA577580	15963	243	2.364706	5.74623558	root	1	Root_unresolved	Root_unresolved	121	1.19e-30	NR	MEM4728177.1	1906666	g15885	i0	76.5	3	81	17	97.5	1	243	7	343	423	MEM4728177.1 ATP citrate lyase citrate-binding domain-containing protein [Thermoplasmata archaeon]	diamond	729	121	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
21540079	21540079	PRJNA577580_P_NODE_897_length_929_cov_3.040888_g836_i0	PRJNA577580	897	929	3.040888	28.24984952	root	1	Root_unresolved	Root_unresolved	342	7.37e-114	NR	KYK34550.1	1803818	g836	i0	58.4	8.43810548977395	291	117	92.7	1	927	67	29	319	KYK34550.1 MAG: hydroxyacid dehydrogenase [Thermoplasmatales archaeon SG8-52-3]	diamond	7839	342	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales		Thermoplasmatales archaeon SG8-52-3
27900730	27900730	PRJNA577580_P_NODE_1965_length_648_cov_2.113043_g1888_i0	PRJNA577580	1965	648	2.113043	13.69251864	Thermoplasmata archaeon	1906666	Archaea	Archaea	65.9	1.61e-8	NR	MEA3198700.1	1906666	g1888	i0	24.2	1.8287037037037	194	131	86.1	6	560	3	539	724	MEA3198700.1 hypothetical protein [Thermoplasmata archaeon]	diamond	1185	65.9	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
27995721	27995721	PRJNA577580_P_NODE_10885_length_279_cov_1.029126_g10807_i0	PRJNA577580	10885	279	1.029126	2.87126154	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	139	4.9199999999999996e-40	NR	MDP7000721.1	2666346	g10807	i0	75.8	1.95698924731183	91	22	97.8	0	3	275	47	137	MDP7000721.1 5-(carboxyamino)imidazole ribonucleotide mutase [Candidatus Poseidoniaceae archaeon]	diamond	546	139	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae	Candidatus Poseidoniaceae archaeon
29858451	29858451	PRJNA577580_P_NODE_4911_length_404_cov_2.595166_g4833_i0	PRJNA577580	4911	404	2.595166	10.48447064	Thermoplasmata archaeon	1906666	Archaea	Archaea	49.7	7.99e-4	NR	MCK4613490.1	1906666	g4833	i0	33.6	0.839108910891089	113	62	83.2	3	392	57	47	147	MCK4613490.1 right-handed parallel beta-helix repeat-containing protein [Thermoplasmata archaeon]	diamond	339	49.7	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
32148016	32148016	PRJNA577580_P_NODE_15738_length_244_cov_1.520468_g15660_i0	PRJNA577580	15738	244	1.520468	3.70994192	Methanobacteriati	3366610	Archaea	Archaea	143	1.87e-38	NR	OIR22186.1	1888996	g15660	i0	82.3	10.5737704918033	79	14	97.1	0	4	240	127	205	OIR22186.1 MAG: 2-hydroxymuconic semialdehyde dehydrogenase [Marine Group III euryarchaeote CG-Epi2]	diamond	2580	143	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Thermoprofundales		Marine Group III euryarchaeote CG-Epi2
32766224	32766224	PRJNA577580_P_NODE_7260_length_334_cov_1.195402_g7182_i0	PRJNA577580	7260	334	1.195402	3.99264268	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	47.8	0.00172	NR	DAC35658.1	2163009	g7182	i0	34	1.9940119760479	106	62	88	5	308	15	148	253	DAC35658.1 MAG TPA: hypothetical protein D7H96_04910, partial [Candidatus Poseidoniales archaeon]	diamond	666	47.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales		Candidatus Poseidoniales 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);;