metadata: contig_metadata: 5 rows where bioproject = "PRJNA737474", tax_phylum = "Promethearchaeota" and tax

5 rows where bioproject = "PRJNA737474", tax_phylum = "Promethearchaeota" and tax_superkingdom = "Archaea"

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
32935492	32935492	PRJNA737474b_S_NODE_18513_length_372_cov_4.521739_g17474_i0	PRJNA737474	18513	372	4.521739	16.82086908	Promethearchaeota archaeon	2053489	Archaea	Archaea	101	1.34e-22	NR	MBY8991331.1	2053489	g17474	i0	49.5	2.29032258064516	93	47	75	0	345	67	303	395	MBY8991331.1 CoA transferase [Promethearchaeota archaeon]	diamond	852	101	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32937520	32937520	PRJNA737474g_S_NODE_217673_length_272_cov_1.638191_g216379_i0	PRJNA737474	217673	272	1.638191	4.45587952	Promethearchaeota archaeon	2053489	Archaea	Archaea	70.1	1.19e-11	NR	TXT59832.1	2053489	g216379	i0	48.6	0.794117647058823	72	33	79.4	2	272	57	378	445	TXT59832.1 MAG: Cyclic 2,3-diphosphoglycerate synthetase [Promethearchaeota archaeon]	diamond	216	70.1	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32975921	32975921	PRJNA737474f_S_NODE_108874_length_286_cov_1.521127_g108196_i0	PRJNA737474	108874	286	1.521127	4.35042322	Archaea	2157	Archaea	Archaea	64.7	1.16e-9	NR	MBY8989236.1	2053489	g108196	i0	34.4	3.94405594405594	96	60	99.7	2	285	1	361	454	MBY8989236.1 pyruvate kinase [Promethearchaeota archaeon]	diamond	1128	64.7	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
33004545	33004545	PRJNA737474d_S_NODE_43547_length_226_cov_2.202614_g42953_i0	PRJNA737474	43547	226	2.202614	4.97790764	Promethearchaeia archaeon	3067280	Archaea	Archaea	41.6	0.0103	NR	RLI61562.1	3067280	g42953	i0	35.1	0.756637168141593	57	37	75.7	0	35	205	9	65	RLI61562.1 MAG: thiamine biosynthesis protein ThiS [Promethearchaeia archaeon]	diamond	171	41.6	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia				Promethearchaeia archaeon
33124636	33124636	PRJNA737474f_S_NODE_29583_length_397_cov_1.771605_g28906_i0	PRJNA737474	29583	397	1.771605	7.03327185	Candidatus Lokiarchaeum ossiferum	2951803	Archaea	Archaea	63.9	4.74e-9	NR	UYP46057.1	2951803	g28906	i0	36.9	0.838790931989924	111	64	83.9	2	395	63	181	285	UYP46057.1 hypothetical protein NEF87_002342 [Candidatus Lokiarchaeum ossiferum]	diamond	333	63.9	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Lokiarchaeum	Candidatus Lokiarchaeum ossiferum

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