metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA473799" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA473799" and tax_clade = "Stenosarchaea group"

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
5549132	5549132	PRJNA473799_P_NODE_20465_length_277_cov_1.828431_g20191_i0	PRJNA473799	20465	277	1.828431	5.06475387	Halococcus	2249	Archaea	Archaea	145	1.2899999999999999e-39	NR	WP_004053181.1	2250	g20191	i0	86.4	2.87003610108303	88	12	95.3	0	3	266	300	387	WP_004053181.1 DNA polymerase IV [Halococcus morrhuae]	diamond	795	146	0.993150684931507	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus morrhuae
18297439	18297439	PRJNA473799_P_NODE_44595_length_246_cov_0.890173_g44321_i0	PRJNA473799	44595	246	0.890173	2.18982558	Haladaptatus paucihalophilus	367189	Archaea	Archaea	134	2.32e-35	NR	WP_007977179.1	367189	g44321	i0	86.4	5.92682926829268	81	11	98.8	0	244	2	181	261	WP_007977179.1 ABC transporter ATP-binding protein [Haladaptatus paucihalophilus]	diamond	1458	134	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus paucihalophilus
26823181	26823181	PRJNA473799_P_NODE_54421_length_241_cov_0.916667_g54147_i0	PRJNA473799	54421	241	0.916667	2.20916747	Methanocorpusculum sp.	2058474	Archaea	Archaea	130	6.02e-37	NR	MBO5368031.1	2058474	g54147	i0	100	0.809128630705394	65	0	80.9	0	2	196	80	144	MBO5368031.1 GxxExxY protein [Methanocorpusculum sp.]	diamond	195	130	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
29239783	29239783	PRJNA473799_P_NODE_55169_length_239_cov_2.493976_g54895_i0	PRJNA473799	55169	239	2.493976	5.96060264	Halococcus	2249	Archaea	Archaea	110	1.19e-29	NR	WP_244706887.1	179637	g54895	i0	68.4	1.92050209205021	79	23	99.2	1	1	237	21	97	WP_244706887.1 hypothetical protein [Halococcus dombrowskii]	diamond	459	111	0.990990990990991	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
30044502	30044502	PRJNA473799_P_NODE_27691_length_263_cov_1.489474_g27417_i0	PRJNA473799	27691	263	1.489474	3.91731662	Halococcus thailandensis	335952	Archaea	Archaea	134	7.23e-39	NR	WP_007736898.1	335952	g27417	i0	92.8	0.787072243346008	69	5	78.7	0	262	56	36	104	WP_007736898.1 hypothetical protein [Halococcus thailandensis]	diamond	207	134	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus thailandensis
31530109	31530109	PRJNA473799_P_NODE_27776_length_263_cov_1.294737_g27502_i0	PRJNA473799	27776	263	1.294737	3.40515831	Halobacteriaceae archaeon	1931997	Archaea	Archaea	114	1.87e-28	NR	MFB6120523.1	1931997	g27502	i0	58.8	0.96958174904943	85	35	97	0	9	263	32	116	MFB6120523.1 ADP-ribosylglycohydrolase family protein [Halobacteriaceae archaeon]	diamond	255	114	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae		Halobacteriaceae archaeon
31719724	31719724	PRJNA473799_P_NODE_37157_length_250_cov_0.870056_g36883_i0	PRJNA473799	37157	250	0.870056	2.17514	Halococcus sediminicola	1264579	Archaea	Archaea	73.9	1.59e-13	NR	WP_049998096.1	1264579	g36883	i0	68.5	0.648	54	17	64.8	0	87	248	1	54	WP_049998096.1 hypothetical protein [Halococcus sediminicola]	diamond	162	73.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sediminicola
31909524	31909524	PRJNA473799_P_NODE_49097_length_243_cov_2.247059_g48823_i0	PRJNA473799	49097	243	2.247059	5.46035337	Halobacteriales archaeon QS_8_65_32	1919186	Archaea	Archaea	149	5.59e-40	NR	PSQ21896.1	1919186	g48823	i0	96.2	0.962962962962963	78	3	96.3	0	236	3	398	475	PSQ21896.1 MAG: formate dehydrogenase subunit alpha [Halobacteriales archaeon QS_8_65_32]	diamond	234	149	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon QS_8_65_32

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