metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax_kingdom = "Thermoproteati"

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
28687784	28687784	PRJNA493828_P_NODE_42767_length_230_cov_4.407643_g42348_i0	PRJNA493828	42767	230	4.407643	10.1375789	Nitrososphaerota archaeon	2026795	Archaea	Archaea	50.4	5.48e-5	NR	RZD32614.1	2026795	g42348	i0	45.1	0.665217391304348	51	25	66.5	1	228	76	82	129	RZD32614.1 MAG: hypothetical protein CXT79_05995 [Nitrososphaerota archaeon]	diamond	153	50.4	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28813508	28813508	PRJNA493828_P_NODE_30228_length_255_cov_3.060440_g29809_i0	PRJNA493828	30228	255	3.06044	7.804122	Nitrososphaeria archaeon	2268198	Archaea	Archaea	55.1	5.35e-8	NR	MEM3385410.1	2268198	g29809	i0	46.8	2.68235294117647	47	25	55.3	0	251	111	5	51	MEM3385410.1 DUF2283 domain-containing protein [Nitrososphaeria archaeon]	diamond	684	55.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
30393294	30393294	PRJNA493828_P_NODE_25793_length_268_cov_1.897436_g25374_i0	PRJNA493828	25793	268	1.897436	5.08512848	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	127	5.65e-32	NR	HKI07328.1	2169593	g25374	i0	65.6	1.00746268656716	90	30	99.6	1	268	2	81	170	HKI07328.1 HYR domain-containing protein [Nitrososphaeraceae archaeon]	diamond	270	127	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30645393	30645393	PRJNA493828_P_NODE_20733_length_285_cov_1.283019_g20314_i0	PRJNA493828	20733	285	1.283019	3.65660415	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	103	7.3099999999999995e-25	NR	WP_148685841.1	1826872	g20314	i0	61.7	0.989473684210526	94	34	98.9	1	3	284	64	155	WP_148685841.1 hypothetical protein [Candidatus Nitrosocosmicus hydrocola]	diamond	282	103	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
31277504	31277504	PRJNA493828_P_NODE_40995_length_237_cov_2.640244_g40576_i0	PRJNA493828	40995	237	2.640244	6.25737828	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	150	2.8299999999999998e-43	NR	HEX7257879.1	2169593	g40576	i0	89.9	1	79	8	100	0	1	237	64	142	HEX7257879.1 LamG domain-containing protein [Nitrososphaeraceae archaeon]	diamond	237	150	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae 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);;