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

5 rows where bioproject = "PRJEB14803", 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_species
27475533	27475533	PRJEB14803_P_NODE_5783_length_572_cov_2.702048_g5361_i0	PRJEB14803	5783	572	2.702048	15.45571456	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	79.7	2.3e-15	NR	OLS12533.1	1849166	g5361	i0	33.6	0.671328671328671	128	83	67.1	2	437	54	7	132	OLS12533.1 MAG: hypothetical protein RBG13Loki_3844 [Promethearchaeota archaeon CR_4]	diamond	384	79.7	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon CR_4
28170193	28170193	PRJEB14803_P_NODE_9066_length_435_cov_1.717500_g8603_i0	PRJEB14803	9066	435	1.7175	7.471125	Promethearchaeota archaeon	2053489	Archaea	Archaea	62.4	3.97e-8	NR	MBY8981431.1	2053489	g8603	i0	30.5	0.813793103448276	118	80	81.4	1	79	432	68	183	MBY8981431.1 tetratricopeptide repeat protein [Promethearchaeota archaeon]	diamond	354	62.4	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
28580707	28580707	PRJEB14803_P_NODE_24207_length_228_cov_1.243523_g23741_i0	PRJEB14803	24207	228	1.243523	2.83523244	Promethearchaeota archaeon	2053489	Archaea	Archaea	67.8	4.12e-11	NR	MBN1215315.1	2053489	g23741	i0	48.5	1.82894736842105	68	34	89.5	1	217	14	286	352	MBN1215315.1 tetratricopeptide repeat protein [Promethearchaeota archaeon]	diamond	417	67.8	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
30728146	30728146	PRJEB14803_P_NODE_23214_length_234_cov_1.572864_g22748_i0	PRJEB14803	23214	234	1.572864	3.68050176	Promethearchaeia archaeon	3067280	Archaea	Archaea	87.8	4.47e-18	NR	HME52151.1	3067280	g22748	i0	51.3	1.93589743589744	76	37	97.4	0	233	6	787	862	HME52151.1 SIR2 family protein [Promethearchaeia archaeon]	diamond	453	87.8	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
32024664	32024664	PRJEB14803_P_NODE_7458_length_489_cov_5.427313_g7003_i0	PRJEB14803	7458	489	5.427313	26.53956057	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	78.2	4.21e-15	NR	OLS12533.1	1849166	g7003	i0	32.8	0.785276073619632	128	84	78.5	2	442	59	7	132	OLS12533.1 MAG: hypothetical protein RBG13Loki_3844 [Promethearchaeota archaeon CR_4]	diamond	384	78.2	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon CR_4

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