metadata: contig_metadata: 5 rows where bioproject = "PRJNA594101", tax_kingdom = "Promethearchaeati" and tax

5 rows where bioproject = "PRJNA594101", tax_kingdom = "Promethearchaeati" 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
26763244	26763244	PRJNA594101_S_NODE_40281_length_274_cov_1.532338_g39979_i0	PRJNA594101	40281	274	1.532338	4.19860612	Candidatus Lokiarchaeum sp. GC14_75	1538547	Archaea	Archaea	48.1	3.75e-4	NR	KKK45081.1	1538547	g39979	i0	48.8	0.470802919708029	43	22	47.1	0	70	198	140	182	KKK45081.1 MAG: small GTP-binding domain protein [Candidatus Lokiarchaeum sp. GC14_75]	diamond	129	48.1	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Lokiarchaeum	Candidatus Lokiarchaeum sp. GC14_75
27806479	27806479	PRJNA594101_S_NODE_19124_length_382_cov_1.718447_g18822_i0	PRJNA594101	19124	382	1.718447	6.56446754	Promethearchaeota archaeon	2053489	Archaea	Archaea	44.7	0.0336	NR	MBY8984010.1	2053489	g18822	i0	29.3	0.643979057591623	82	52	59.7	1	247	20	164	245	MBY8984010.1 orotidine 5'-phosphate decarboxylase [Promethearchaeota archaeon]	diamond	246	44.7	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
29006495	29006495	PRJNA594101_S_NODE_11368_length_488_cov_1.559036_g11067_i0	PRJNA594101	11368	488	1.559036	7.60809568	Promethearchaeota archaeon	2053489	Archaea	Archaea	89.7	9.34e-19	NR	MBD3254099.1	2053489	g11067	i0	33.3	1.88114754098361	153	98	94.1	1	460	2	25	173	MBD3254099.1 TATA-box-binding protein [Promethearchaeota archaeon]	diamond	918	89.7	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
29890367	29890367	PRJNA594101_S_NODE_31731_length_305_cov_1.327586_g31429_i0	PRJNA594101	31731	305	1.327586	4.0491373	Promethearchaeota archaeon	2053489	Archaea	Archaea	42	0.0225	NR	MEJ2295707.1	2053489	g31429	i0	47.1	0.334426229508197	34	18	33.4	0	11	112	39	72	MEJ2295707.1 hypothetical protein [Promethearchaeota archaeon]	diamond	102	42	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32071275	32071275	PRJNA594101_S_NODE_51598_length_248_cov_0.880000_g51296_i0	PRJNA594101	51598	248	0.88	2.1824	Promethearchaeota archaeon	2053489	Archaea	Archaea	54.3	3.22e-6	NR	TFF94460.1	2053489	g51296	i0	50	2.78225806451613	54	27	65.3	0	219	58	90	143	TFF94460.1 MAG: MFS transporter [Promethearchaeota archaeon]	diamond	690	54.3	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota 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);;