metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1120586" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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
18127541	18127541	PRJNA1120586_P_NODE_19315_length_303_cov_1.230769_g19124_i0	PRJNA1120586	19315	303	1.230769	3.72923007	Halorubrum sp. JWXQ-INN 858	2690782	Archaea	Archaea	93.6	9.56e-20	NR	WP_159487179.1	2690782	g19124	i0	62.2	0.97029702970297	98	37	97	0	294	1	193	290	WP_159487179.1 stage II sporulation protein M [Halorubrum sp. JWXQ-INN 858]	diamond	294	93.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. JWXQ-INN 858
21952552	21952552	PRJNA1120586_P_NODE_13518_length_342_cov_1.318681_g13327_i0	PRJNA1120586	13518	342	1.318681	4.50988902	archaeon	1906665	Archaea	Archaea	223	4.649999999999999e-72	NR	RYH25290.1	1906665	g13327	i0	95.6	1	114	5	100	0	1	342	61	174	RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon]	diamond	342	223	1	Archaea								archaeon
26848755	26848755	PRJNA1120586_P_NODE_32041_length_255_cov_0.924731_g31850_i0	PRJNA1120586	32041	255	0.924731	2.35806405	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.1	0.0308	NR	MED6346029.1	2806419	g31850	i0	35.4	0.564705882352941	48	31	56.5	0	180	37	231	278	MED6346029.1 PQQ-binding-like beta-propeller repeat protein [Thermoplasmatota archaeon]	diamond	144	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
28301784	28301784	PRJNA1120586_P_NODE_44946_length_231_cov_1.333333_g44755_i0	PRJNA1120586	44946	231	1.333333	3.07999923	archaeon	1906665	Archaea	Archaea	70.9	2.44e-12	NR	RYG65019.1	1906665	g44755	i0	43.4	0.987012987012987	76	43	98.7	0	230	3	168	243	RYG65019.1 MAG: hypothetical protein EON64_12790 [archaeon]	diamond	228	70.9	1	Archaea								archaeon
29533231	29533231	PRJNA1120586_P_NODE_54990_length_206_cov_4.204380_g54799_i0	PRJNA1120586	54990	206	4.20438	8.6610228	archaeon	1906665	Archaea	Archaea	77.4	1.36e-16	NR	RYH00022.1	1906665	g54799	i0	60.3	0.844660194174757	58	23	84.5	0	31	204	14	71	RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon]	diamond	174	77.4	1	Archaea								archaeon
29912314	29912314	PRJNA1120586_P_NODE_44451_length_232_cov_0.883436_g44260_i0	PRJNA1120586	44451	232	0.883436	2.04957152	Halobacteriales archaeon	1904752	Archaea	Archaea	46.2	0.00161	NR	MFP4590188.1	1904752	g44260	i0	62.5	1.25431034482759	32	12	41.4	0	1	96	200	231	MFP4590188.1 sugar phosphate nucleotidyltransferase [Halobacteriales archaeon]	diamond	291	46.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon
31049846	31049846	PRJNA1120586_P_NODE_41295_length_234_cov_0.872727_g41104_i0	PRJNA1120586	41295	234	0.872727	2.04218118	archaeon	1906665	Archaea	Archaea	86.7	2.97e-18	NR	RYH11026.1	1906665	g41104	i0	54.7	0.961538461538462	75	34	96.2	0	9	233	98	172	RYH11026.1 MAG: hypothetical protein EON65_39105 [archaeon]	diamond	225	86.7	1	Archaea								archaeon
31397452	31397452	PRJNA1120586_P_NODE_45076_length_231_cov_0.888889_g44885_i0	PRJNA1120586	45076	231	0.888889	2.05333359	archaeon	1906665	Archaea	Archaea	97.4	1.5799999999999998e-23	NR	RYG69081.1	1906665	g44885	i0	54.3	0.909090909090909	70	32	90.9	0	210	1	7	76	RYG69081.1 MAG: hypothetical protein EON64_03635, partial [archaeon]	diamond	210	97.4	1	Archaea								archaeon
31839964	31839964	PRJNA1120586_P_NODE_33237_length_251_cov_1.824176_g33046_i0	PRJNA1120586	33237	251	1.824176	4.57868176	archaeon	1906665	Archaea	Archaea	115	7.700000000000001e-28	NR	RYH23131.1	1906665	g33046	i0	65.1	0.99203187250996006	83	29	99.2	0	1	249	352	434	RYH23131.1 MAG: hypothetical protein EON65_18260 [archaeon]	diamond	249	115	1	Archaea								archaeon
32409734	32409734	PRJNA1120586_P_NODE_40239_length_235_cov_0.867470_g40048_i0	PRJNA1120586	40239	235	0.86747	2.0385545	archaeon	1906665	Archaea	Archaea	60.1	2.58e-8	NR	RYH13809.1	1906665	g40048	i0	43.2	0.94468085106383	74	40	94.5	2	229	8	55	126	RYH13809.1 MAG: VWA domain-containing protein [archaeon]	diamond	222	60.1	1	Archaea								archaeon
32568077	32568077	PRJNA1120586_P_NODE_40119_length_235_cov_0.867470_g39928_i0	PRJNA1120586	40119	235	0.86747	2.0385545	Halolamina sp.	1940283	Archaea	Archaea	131	1.56e-33	NR	WP_332326263.1	1940283	g39928	i0	78.7	0.957446808510638	75	16	95.7	0	4	228	437	511	WP_332326263.1 S9 family peptidase [Halolamina sp.]	diamond	225	131	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halolamina	Halolamina 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);;