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

5 rows where analysis = "diamond", bioproject = "PRJNA485080" 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_order	tax_family	tax_species
27771454	27771454	PRJNA485080_P_NODE_29464_length_248_cov_0.880000_g29370_i0	PRJNA485080	29464	248	0.88	2.1824	Candidatus Micrarchaeota archaeon CG1	2250274	Archaea	Archaea	42.7	0.0388	NR	PIT84036.1	1974417	g29370	i0	32.5	0.931451612903226	77	48	93.1	1	232	2	126	198	PIT84036.1 MAG: argininosuccinate lyase [Candidatus Micrarchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_45_29]	diamond	231	42.7	1	Archaea	Nanobdellati	Candidatus Micrarchaeota				Candidatus Micrarchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_45_29
28402771	28402771	PRJNA485080_P_NODE_21146_length_252_cov_1.458101_g21052_i0	PRJNA485080	21146	252	1.458101	3.67441452	archaeon	1906665	Archaea	Archaea	102	7.45e-25	NR	MDP2437414.1	1906665	g21052	i0	67.7	0.773809523809524	65	21	77.4	0	235	41	138	202	MDP2437414.1 hypothetical protein [archaeon]	diamond	195	102	1	Archaea						archaeon
29097484	29097484	PRJNA485080_P_NODE_37768_length_244_cov_0.900585_g37674_i0	PRJNA485080	37768	244	0.900585	2.1974274	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	42.4	0.0276	NR	MBR4504575.1	2517205	g37674	i0	32.4	0.836065573770492	68	41	81.1	2	34	231	6	70	MBR4504575.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon]	diamond	204	42.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Candidatus Methanomethylophilaceae archaeon
29539296	29539296	PRJNA485080_P_NODE_19590_length_262_cov_2.264550_g19496_i0	PRJNA485080	19590	262	2.26455	5.933121	archaeon	1906665	Archaea	Archaea	43.9	0.00939	NR	RYH31259.1	1906665	g19496	i0	41.5	0.469465648854962	41	24	46.9	0	123	1	1	41	RYH31259.1 MAG: hypothetical protein EON65_02965 [archaeon]	diamond	123	43.9	1	Archaea						archaeon
31561846	31561846	PRJNA485080_P_NODE_38576_length_243_cov_0.905882_g38482_i0	PRJNA485080	38576	243	0.905882	2.20129326	Promethearchaeati archaeon SRVP18_Atabeyarchaeia-1	3126527	Archaea	Archaea	40	0.0435	NR	WXG42801.1	3126527	g38482	i0	42.5	0.493827160493827	40	22	49.4	1	138	19	1	39	WXG42801.1 MAG: hypothetical protein WED04_01665 [Promethearchaeati archaeon SRVP18_Atabeyarchaeia-1]	diamond	120	40	1	Archaea	Promethearchaeati					Promethearchaeati archaeon SRVP18_Atabeyarchaeia-1

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