metadata: contig_metadata: 7 rows where bioproject = "PRJNA904835" and tax

7 rows where bioproject = "PRJNA904835" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
14911442	14911442	PRJNA904835_P_NODE_49752_length_254_cov_1.276243_g49496_i0	PRJNA904835	49752	254	1.276243	3.24165722	archaeon	1906665	Archaea	Archaea	143	9.709999999999997e-43	NR	RYG59364.1	1906665	g49496	i0	81.3	0.94488188976378	80	15	94.5	0	8	247	1	80	RYG59364.1 MAG: hypothetical protein EON64_20305, partial [archaeon]	diamond	240	143	1	Archaea								archaeon
27435372	27435372	PRJNA904835_P_NODE_49683_length_254_cov_1.690608_g49427_i0	PRJNA904835	49683	254	1.6906080000000001	4.29414432	Promethearchaeota archaeon	2053489	Archaea	Archaea	47.4	9.61e-4	NR	MBD3253957.1	2053489	g49427	i0	35.8	1.90157480314961	81	51	94.5	1	10	249	171	251	MBD3253957.1 hypothetical protein [Promethearchaeota archaeon]	diamond	483	47.4	1	Archaea		Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
27940412	27940412	PRJNA904835_P_NODE_59245_length_241_cov_0.916667_g58989_i0	PRJNA904835	59245	241	0.916667	2.20916747	archaeon	1906665	Archaea	Archaea	76.3	2.77e-14	NR	RYG68174.1	1906665	g58989	i0	39.2	0.983402489626556	79	48	98.3	0	239	3	52	130	RYG68174.1 MAG: hypothetical protein EON64_05775 [archaeon]	diamond	237	76.3	1	Archaea								archaeon
28477090	28477090	PRJNA904835_P_NODE_51606_length_250_cov_0.870056_g51350_i0	PRJNA904835	51606	250	0.870056	2.17514	archaeon	1906665	Archaea	Archaea	114	1.1e-29	NR	RYH30159.1	1906665	g51350	i0	65.4	0.972	81	28	97.2	0	250	8	26	106	RYH30159.1 MAG: hypothetical protein EON65_06080 [archaeon]	diamond	243	114	1	Archaea								archaeon
30751060	30751060	PRJNA904835_P_NODE_54214_length_247_cov_0.885057_g53958_i0	PRJNA904835	54214	247	0.885057	2.18609079	Haloarchaeobius amylolyticus	1198296	Archaea	Archaea	45.4	0.00427	NR	WP_267639183.1	1198296	g53958	i0	52.6	0.461538461538462	38	18	46.2	0	193	80	341	378	WP_267639183.1 DUF3179 domain-containing protein [Haloarchaeobius amylolyticus]	diamond	114	45.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halorubellaceae	Haloarchaeobius	Haloarchaeobius amylolyticus
32142346	32142346	PRJNA904835_P_NODE_23998_length_408_cov_0.865672_g23743_i0	PRJNA904835	23998	408	0.865672	3.53194176	archaeon	1906665	Archaea	Archaea	152	3.95e-45	NR	RYH18874.1	1906665	g23743	i0	65.5	1.75	110	36	80.9	2	55	384	1	108	RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon]	diamond	714	152	1	Archaea								archaeon
32844549	32844549	PRJNA904835_P_NODE_55720_length_245_cov_0.895349_g55464_i0	PRJNA904835	55720	245	0.895349	2.19360505	Methanoculleus	45989	Archaea	Archaea	56.6	4.32e-7	NR	MCK9298840.1	90427	g55464	i0	40.8	2.4	76	31	93.1	2	245	18	172	233	MCK9298840.1 exo-alpha-sialidase [Methanoculleus sp.]	diamond	588	56.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.

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