metadata: contig_metadata: 2 rows where bioproject = "PRJNA630162", tax_kingdom = "Promethearchaeati" and tax

2 rows where bioproject = "PRJNA630162", tax_kingdom = "Promethearchaeati" and tax_superkingdom = "Archaea"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	lowcoverage_flag	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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
23554126	23554126	PRJNA630162_P_NODE_125899_length_171_cov_2.311475_g124376_i0	PRJNA630162	125899	171	2.311475	3.95262225	Promethearchaeum syntrophicum	2594042	Archaea	Archaea	122	1.0799999999999999e-23		NTclustered	gi\|2778339399\|gb\|CP042905.2\|	2594042	g124376	i0	87.156	2.37426900584795	109	13	64	1	57	165	82959	83066	Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome	blastn	406	122	1	Archaea		Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Promethearchaeum	Promethearchaeum syntrophicum
27522935	27522935	PRJNA630162_P_NODE_104623_length_183_cov_1.276119_g103100_i0	PRJNA630162	104623	183	1.276119	2.33529777	Candidatus Asgardarchaeum californiense	3067292	Archaea	Archaea	55.1	2.97e-8		NR	RLI62949.1	3067292	g103100	i0	73.3	0.983606557377049	30	8	49.2	0	91	180	1	30	RLI62949.1 MAG: hypothetical protein DRO67_06530 [Candidatus Asgardarchaeum californiense]	diamond	180	55.1	1	Archaea		Promethearchaeati		Candidatus Asgardarchaeia (ex Tamarit et al. 2024)	Candidatus Asgardarchaeales (ex Tamarit et al. 2024)	Candidatus Asgardarchaeaceae	Candidatus Asgardarchaeum (ex Tamarit et al. 2024)	Candidatus Asgardarchaeum californiense

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