metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA674048" 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
27207969	27207969	PRJNA674048_P_NODE_24822_length_176_cov_1.834646_g24619_i0	PRJNA674048	24822	176	1.834646	3.22897696	archaeon	1906665	Archaea	Archaea	99	2.1099999999999998e-23	NR	RYG64625.1	1906665	g24619	i0	77.6	0.988636363636364	58	13	98.9	0	175	2	170	227	RYG64625.1 MAG: 50S ribosomal protein L3, partial [archaeon]	diamond	174	99	1	Archaea								archaeon
27883289	27883289	PRJNA674048_P_NODE_29805_length_165_cov_1.793103_g29602_i0	PRJNA674048	29805	165	1.793103	2.95861995	root	1	Root_unresolved	Root_unresolved	50.4	2.91e-6	NR	WP_048102805.1	2208	g29602	i0	52.2	2.32727272727273	46	22	83.6	0	27	164	3	48	WP_048102805.1 hypothetical protein [Methanosarcina barkeri]	diamond	384	50.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
27934655	27934655	PRJNA674048_P_NODE_27105_length_169_cov_0.866667_g26902_i0	PRJNA674048	27105	169	0.866667	1.46466723	archaeon	1906665	Archaea	Archaea	60.8	2.68e-9	NR	RYG66559.1	1906665	g26902	i0	82.4	1.57988165680473	34	6	60.4	0	102	1	132	165	RYG66559.1 MAG: elongation factor 1-beta/delta [archaeon]	diamond	267	60.8	1	Archaea								archaeon
27997892	27997892	PRJNA674048_P_NODE_31065_length_164_cov_0.904348_g30862_i0	PRJNA674048	31065	164	0.904348	1.48313072	archaeon	1906665	Archaea	Archaea	54.7	7.77e-7	NR	RYG69087.1	1906665	g30862	i0	61.5	0.713414634146341	39	15	71.3	0	39	155	464	502	RYG69087.1 MAG: hypothetical protein EON64_03605, partial [archaeon]	diamond	117	54.7	1	Archaea								archaeon
29229343	29229343	PRJNA674048_P_NODE_22549_length_185_cov_1.529412_g22346_i0	PRJNA674048	22549	185	1.529412	2.8294122	Candidatus Caldarchaeum sp.	2972665	Archaea	Archaea	78.2	5.51e-15	NR	MEM0462111.1	2972665	g22346	i0	63.9	0.989189189189189	61	21	98.9	1	183	1	450	509	MEM0462111.1 hypothetical protein [Candidatus Caldarchaeum sp.]	diamond	183	78.2	1	Archaea		Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum sp.
29923904	29923904	PRJNA674048_P_NODE_30371_length_165_cov_0.896552_g30168_i0	PRJNA674048	30371	165	0.896552	1.4793108	archaeon	1906665	Archaea	Archaea	59.7	1.33e-8	NR	RYH18422.1	1906665	g30168	i0	54	0.909090909090909	50	23	90.9	0	14	163	956	1005	RYH18422.1 MAG: hypothetical protein EON65_27240 [archaeon]	diamond	150	59.7	1	Archaea								archaeon
30713611	30713611	PRJNA674048_P_NODE_28554_length_167_cov_0.881356_g28351_i0	PRJNA674048	28554	167	0.881356	1.47186452	archaeon	1906665	Archaea	Archaea	103	6.77e-24	NR	RYH27824.1	1906665	g28351	i0	87.3	1.97604790419162	55	7	98.8	0	1	165	469	523	RYH27824.1 MAG: acyl-CoA dehydrogenase [archaeon]	diamond	330	103	1	Archaea								archaeon
30745271	30745271	PRJNA674048_P_NODE_31614_length_163_cov_0.912281_g31411_i0	PRJNA674048	31614	163	0.912281	1.48701803	archaeon	1906665	Archaea	Archaea	71.2	3.45e-13	NR	HLD78554.1	1906665	g31411	i0	67.3	0.901840490797546	49	16	90.2	0	162	16	133	181	HLD78554.1 hypothetical protein [archaeon]	diamond	147	71.2	1	Archaea								archaeon
30871594	30871594	PRJNA674048_P_NODE_19494_length_200_cov_1.377483_g19291_i0	PRJNA674048	19494	200	1.377483	2.754966	archaeon	1906665	Archaea	Archaea	82.4	2.09e-17	NR	RYG65124.1	1906665	g19291	i0	84.1	0.66	44	7	66	0	200	69	172	215	RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon]	diamond	132	82.4	1	Archaea								archaeon
31661840	31661840	PRJNA674048_P_NODE_32137_length_163_cov_0.912281_g31934_i0	PRJNA674048	32137	163	0.912281	1.48701803	archaeon	1906665	Archaea	Archaea	44.3	0.00362	NR	MDP2436889.1	1906665	g31934	i0	44.4	0.828220858895706	45	25	82.8	0	11	145	293	337	MDP2436889.1 hypothetical protein [archaeon]	diamond	135	44.3	1	Archaea								archaeon
31946531	31946531	PRJNA674048_P_NODE_29497_length_166_cov_0.888889_g29294_i0	PRJNA674048	29497	166	0.888889	1.47555574	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	94	3.0300000000000003e-21	NR	MEK9694268.1	2163009	g29294	i0	77.8	0.975903614457831	54	12	97.6	0	164	3	277	330	MEK9694268.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	162	94	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
31978279	31978279	PRJNA674048_P_NODE_19418_length_200_cov_2.721854_g19215_i0	PRJNA674048	19418	200	2.721854	5.443708	Methanobacteriota archaeon	2026739	Archaea	Archaea	44.7	0.00452	NR	MAQ04991.1	2026739	g19215	i0	39.6	0.795	53	30	79.5	1	186	28	530	580	MAQ04991.1 hypothetical protein [Methanobacteriota archaeon]	diamond	159	44.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32041677	32041677	PRJNA674048_P_NODE_32838_length_162_cov_0.920354_g32635_i0	PRJNA674048	32838	162	0.920354	1.49097348	Methanobacteriota archaeon	2026739	Archaea	Archaea	100	1.29e-23	NR	MCH7660952.1	2026739	g32635	i0	94.2	0.962962962962963	52	3	96.3	0	160	5	190	241	MCH7660952.1 type II glyceraldehyde-3-phosphate dehydrogenase [Methanobacteriota archaeon]	diamond	156	100	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32484772	32484772	PRJNA674048_P_NODE_31919_length_163_cov_0.912281_g31716_i0	PRJNA674048	31919	163	0.912281	1.48701803	archaeon	1906665	Archaea	Archaea	48.1	1.53e-4	NR	MDP2439624.1	1906665	g31716	i0	39.6	0.975460122699387	53	32	97.5	0	161	3	115	167	MDP2439624.1 hypothetical protein [archaeon]	diamond	159	48.1	1	Archaea								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);;