metadata: contig_metadata: 5 rows where bioproject = "PRJEB64798" and tax

5 rows where bioproject = "PRJEB64798" and tax_phylum = "Promethearchaeota"

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
27121356	27121356	PRJEB64798_P_NODE_141222_length_193_cov_1.555556_g139456_i0	PRJEB64798	141222	193	1.555556	3.00222308	root	1	Root_unresolved	Root_unresolved	48.1	2.33e-4	NR	MEJ2251072.1	2053489	g139456	i0	38.2	1.72538860103627	55	34	85.5	0	185	21	584	638	MEJ2251072.1 VWA domain-containing protein [Promethearchaeota archaeon]	diamond	333	48.5	0.991752577319588	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
27191718	27191718	PRJEB64798_P_NODE_232762_length_157_cov_18.546296_g230996_i0	PRJEB64798	232762	157	18.546296	29.11768472	Promethearchaeum syntrophicum	2594042	Archaea	Archaea	57	5.37e-9	NR	WP_147664455.1	2594042	g230996	i0	70	2.46496815286624	30	9	57.3	0	151	62	42	71	WP_147664455.1 30S ribosomal protein S27ae [Promethearchaeum syntrophicum]	diamond	387	57	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Promethearchaeum	Promethearchaeum syntrophicum
30602297	30602297	PRJEB64798_P_NODE_160793_length_183_cov_2.776119_g159027_i0	PRJEB64798	160793	183	2.776119	5.08029777	Promethearchaeota archaeon	2053489	Archaea	Archaea	69.3	6.04e-12	NR	TXT66091.1	2053489	g159027	i0	58.2	0.901639344262295	55	22	88.5	1	183	22	195	249	TXT66091.1 MAG: hypothetical protein BAJALOKI3v1_50091 [Promethearchaeota archaeon]	diamond	165	69.3	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
31107840	31107840	PRJEB64798_P_NODE_165795_length_180_cov_18.129771_g164029_i0	PRJEB64798	165795	180	18.129771	32.6335878	Promethearchaeota archaeon	2053489	Archaea	Archaea	41.6	0.0408	NR	MBN2151918.1	2053489	g164029	i0	55.6	0.45	27	12	45	0	133	53	38	64	MBN2151918.1 hypothetical protein [Promethearchaeota archaeon]	diamond	81	41.6	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32183483	32183483	PRJEB64798_P_NODE_157478_length_184_cov_18.059259_g155712_i0	PRJEB64798	157478	184	18.059259	33.22903656	Promethearchaeia archaeon	3067280	Archaea	Archaea	43.5	0.00914	NR	HMF32030.1	3067280	g155712	i0	66.7	0.440217391304348	27	9	44	0	178	98	384	410	HMF32030.1 acetyl-CoA C-acyltransferase [Promethearchaeia archaeon]	diamond	81	43.5	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia				Promethearchaeia 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);;