metadata: contig_metadata: 4 rows where bioproject = "PRJNA906294", tax_kingdom = "Methanobacteriati" and tax

4 rows where bioproject = "PRJNA906294", 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
27688181	27688181	PRJNA906294_P_NODE_224504_length_243_cov_0.905882_g220388_i0	PRJNA906294	224504	243	0.905882	2.20129326	Thermoplasmata archaeon	1906666	Archaea	Archaea	66.6	3.56e-12	NR	RLF66471.1	1906666	g220388	i0	43.8	0.987654320987654	80	39	91.4	2	243	22	2	81	RLF66471.1 MAG: hypothetical protein DRN30_02075 [Thermoplasmata archaeon]	diamond	240	66.6	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
27853084	27853084	PRJNA906294_P_NODE_85564_length_468_cov_1.154430_g81450_i0	PRJNA906294	85564	468	1.15443	5.4027324	root	1	Root_unresolved	Root_unresolved	46.6	0.0169	NR	MCI4330747.1	1906666	g81450	i0	32.9	2.82051282051282	140	76	79.5	4	392	21	1124	1261	MCI4330747.1 hypothetical protein [Thermoplasmata archaeon]	diamond	1320	47	0.991489361702128	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28035187	28035187	PRJNA906294_P_NODE_166565_length_290_cov_1.543779_g162449_i0	PRJNA906294	166565	290	1.543779	4.4769591	Candidatus Poseidoniia archaeon	2666348	Archaea	Archaea	166	2.79e-49	NR	MEO2179638.1	2666348	g162449	i0	83.3	10.9241379310345	96	16	99.3	0	290	3	29	124	MEO2179638.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Candidatus Poseidoniia archaeon]	diamond	3168	166	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia				Candidatus Poseidoniia archaeon
28445680	28445680	PRJNA906294_P_NODE_154246_length_306_cov_0.978541_g150130_i0	PRJNA906294	154246	306	0.978541	2.99433546	Candidatus Sysuiplasma superficiale	2823368	Archaea	Archaea	71.2	3.22e-12	NR	MBX8644967.1	2823368	g150130	i0	41.8	0.96078431372549	98	57	96.1	0	304	11	145	242	MBX8644967.1 hypothetical protein [Candidatus Sysuiplasma superficiale]	diamond	294	71.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Sysuiplasmatales	Candidatus Sysuiplasmataceae	Candidatus Sysuiplasma	Candidatus Sysuiplasma superficiale

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