metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
6146626	6146626	PRJNA1198392_P_NODE_9325_length_285_cov_2.018868_g9184_i0	PRJNA1198392	9325	285	2.018868	5.7537738	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	154	5.249999999999998e-41	NR	MEM3247236.1	2953041	g9184	i0	97.6	1.72631578947368	82	2	86.3	0	248	3	86	167	MEM3247236.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	492	154	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
26692633	26692633	PRJNA1198392_P_NODE_6821_length_311_cov_1.861345_g6680_i0	PRJNA1198392	6821	311	1.861345	5.78878295	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	196	8.86e-59	NR	MEM3247439.1	2953041	g6680	i0	100	0.993569131832797	103	0	99.4	0	2	310	93	195	MEM3247439.1 AAA family ATPase [Candidatus Micrarchaeaceae archaeon]	diamond	309	196	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
29756516	29756516	PRJNA1198392_P_NODE_17911_length_247_cov_1.327586_g17770_i0	PRJNA1198392	17911	247	1.327586	3.27913742	archaeon	1906665	Archaea	Archaea	81.3	1.94e-17	NR	RYG59257.1	1906665	g17770	i0	53.7	0.995951417004049	82	38	99.6	0	1	246	32	113	RYG59257.1 MAG: hypothetical protein EON64_20430, partial [archaeon]	diamond	246	81.3	1	Archaea								archaeon
29819591	29819591	PRJNA1198392_P_NODE_21611_length_237_cov_2.390244_g21470_i0	PRJNA1198392	21611	237	2.390244	5.66487828	archaeon	1906665	Archaea	Archaea	75.9	2.11e-14	NR	MDP2437012.1	1906665	g21470	i0	63.6	0.974683544303797	77	28	97.5	0	236	6	167	243	MDP2437012.1 S6e family ribosomal protein [archaeon]	diamond	231	75.9	1	Archaea								archaeon
30407724	30407724	PRJNA1198392_P_NODE_3573_length_404_cov_1.861027_g3432_i0	PRJNA1198392	3573	404	1.861027	7.51854908	Candidatus Heimdallarchaeum	3053649	Archaea	Archaea	139	4.41e-35	NR	MCE7741215.1	2026747	g3432	i0	51.5	8.81435643564356	132	60	98	1	404	9	638	765	MCE7741215.1 MMPL family transporter [Candidatus Heimdallarchaeota archaeon]	diamond	3561	139	1	Archaea		Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
30691690	30691690	PRJNA1198392_P_NODE_13013_length_267_cov_1.587629_g12872_i0	PRJNA1198392	13013	267	1.587629	4.23896943	root	1	Root_unresolved	Root_unresolved	81.3	5.57e-16	NR	WP_292538662.1	90426	g12872	i0	87.8	1.84269662921348	41	5	46.1	0	123	1	1	41	WP_292538662.1 glycosyltransferase family 2 protein [Methanothrix sp.]	diamond	492	81.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
30704386	30704386	PRJNA1198392_P_NODE_8494_length_289_cov_1.425926_g8353_i0	PRJNA1198392	8494	289	1.425926	4.12092614	archaeon	1906665	Archaea	Archaea	102	1.43e-25	NR	MDP2436180.1	1906665	g8353	i0	67.1	0.757785467128028	73	22	73.7	1	2	214	45	117	MDP2436180.1 hypothetical protein [archaeon]	diamond	219	102	1	Archaea								archaeon
31114947	31114947	PRJNA1198392_P_NODE_10875_length_278_cov_1.502439_g10734_i0	PRJNA1198392	10875	278	1.502439	4.17678042	Thermoprotei archaeon	2250277	Archaea	Archaea	43.1	0.00643	NR	RLE84555.1	2250277	g10734	i0	35.6	0.787769784172662	73	37	78.8	1	60	278	7	69	RLE84555.1 MAG: hypothetical protein DRJ67_10385, partial [Thermoprotei archaeon]	diamond	219	43.1	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei archaeon
32349049	32349049	PRJNA1198392_P_NODE_4479_length_369_cov_1.273649_g4338_i0	PRJNA1198392	4479	369	1.273649	4.69976481	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	202	3.91e-58	NR	MEM3247234.1	2953041	g4338	i0	92.8	0.902439024390244	111	8	90.2	0	333	1	1	111	MEM3247234.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	333	202	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
32538877	32538877	PRJNA1198392_P_NODE_2559_length_465_cov_1.033163_g2418_i0	PRJNA1198392	2559	465	1.033163	4.80420795	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	308	1.4999999999999999e-96	NR	MEM3247236.1	2953041	g2418	i0	97.4	0.993548387096774	154	4	99.4	0	2	463	654	807	MEM3247236.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	462	308	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae 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);;