metadata: contig_metadata: 5 rows where bioproject = "PRJNA983848", tax_kingdom = "Methanobacteriati" and tax

5 rows where bioproject = "PRJNA983848", 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
27784715	27784715	PRJNA983848_P_NODE_132424_length_258_cov_3.443243_g126541_i0	PRJNA983848	132424	258	3.443243	8.88356694	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	67	5.85e-11	NR	MDP6845262.1	2670411	g126541	i0	59.6	1.09302325581395	47	19	54.7	0	10	150	181	227	MDP6845262.1 hypothetical protein [Candidatus Thalassarchaeaceae archaeon]	diamond	282	67	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae	Candidatus Thalassarchaeaceae archaeon
28447740	28447740	PRJNA983848_P_NODE_94206_length_313_cov_3.333333_g88323_i0	PRJNA983848	94206	313	3.333333	10.43333229	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	115	1.71e-27	NR	HIE81916.1	2163009	g88323	i0	63.5	0.814696485623003	85	24	74.8	1	234	1	99	183	HIE81916.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	255	115	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales		Candidatus Poseidoniales archaeon
30311224	30311224	PRJNA983848_P_NODE_165512_length_228_cov_2.735484_g159629_i0	PRJNA983848	165512	228	2.735484	6.23690352	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	73.6	1.34e-13	NR	MDP6845262.1	2670411	g159629	i0	41.9	1.96052631578947	74	43	97.4	0	226	5	159	232	MDP6845262.1 hypothetical protein [Candidatus Thalassarchaeaceae archaeon]	diamond	447	73.6	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae	Candidatus Thalassarchaeaceae archaeon
31448501	31448501	PRJNA983848_P_NODE_64096_length_402_cov_1.364742_g58214_i0	PRJNA983848	64096	402	1.364742	5.48626284	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	49.7	5.58e-4	NR	MDP6845262.1	2670411	g58214	i0	60.9	0.343283582089552	46	17	34.3	1	343	206	113	157	MDP6845262.1 hypothetical protein [Candidatus Thalassarchaeaceae archaeon]	diamond	138	49.7	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae	Candidatus Thalassarchaeaceae archaeon
31891205	31891205	PRJNA983848_P_NODE_126177_length_266_cov_1.362694_g120294_i0	PRJNA983848	126177	266	1.362694	3.62476604	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	74.3	1.14e-13	NR	MDP6845262.1	2670411	g120294	i0	59.3	0.609022556390977	54	22	60.9	0	266	105	173	226	MDP6845262.1 hypothetical protein [Candidatus Thalassarchaeaceae archaeon]	diamond	162	74.3	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae	Candidatus Thalassarchaeaceae 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);;