metadata: contig_metadata: 9 rows where bioproject = "PRJNA789095" and tax

9 rows where bioproject = "PRJNA789095" 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
770189	770189	PRJNA789095_P_NODE_27921_length_411_cov_1.647929_g26589_i0	PRJNA789095	27921	411	1.647929	6.77298819	Thermoplasmatales archaeon	2268204	Archaea	Archaea	56.5	0.003	NTclustered	gi\|2108144344\|gb\|CP070724.1\|	2268204	g26589	i0	94.595	0.0900243309002433	37	1	9	1	230	266	1371777	1371812	MAG: Thermoplasmatales archaeon isolate bin45 chromosome	blastn	37	56.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
2047303	2047303	PRJNA789095_P_NODE_66242_length_251_cov_0.865169_g64908_i0	PRJNA789095	66242	251	0.865169	2.17157419	archaeon	1906665	Archaea	Archaea	117	2.3899999999999995e-32	NR	RYH07384.1	1906665	g64908	i0	68.8	0.920318725099602	77	23	92	1	231	1	7	82	RYH07384.1 MAG: methyltransferase domain-containing protein [archaeon]	diamond	231	117	1	Archaea								archaeon
13525289	13525289	PRJNA789095_P_NODE_71911_length_245_cov_0.895349_g70577_i0	PRJNA789095	71911	245	0.895349	2.19360505	archaeon	1906665	Archaea	Archaea	135	8.73e-39	NR	MCQ2817513.1	1906665	g70577	i0	79	0.991836734693878	81	17	99.2	0	244	2	7	87	MCQ2817513.1 30S ribosomal protein S8 [archaeon]	diamond	243	135	1	Archaea								archaeon
27306718	27306718	PRJNA789095_P_NODE_67663_length_249_cov_1.437500_g66329_i0	PRJNA789095	67663	249	1.4375	3.579375	archaeon	1906665	Archaea	Archaea	52.4	1.65e-5	NR	MDP2437634.1	1906665	g66329	i0	43.8	0.963855421686747	80	36	89.2	5	240	19	540	616	MDP2437634.1 SPRY domain-containing protein [archaeon]	diamond	240	52.4	1	Archaea								archaeon
27812066	27812066	PRJNA789095_P_NODE_69324_length_247_cov_3.471264_g67990_i0	PRJNA789095	69324	247	3.471264	8.57402208	archaeon	1906665	Archaea	Archaea	41.2	0.0291	NR	NCQ51540.1	1906665	g67990	i0	29.2	0.874493927125506	72	50	87.4	1	1	216	17	87	NCQ51540.1 BspA family leucine-rich repeat surface protein [archaeon]	diamond	216	41.2	1	Archaea								archaeon
30085212	30085212	PRJNA789095_P_NODE_64292_length_254_cov_1.563536_g62958_i0	PRJNA789095	64292	254	1.563536	3.97138144	archaeon	1906665	Archaea	Archaea	92	1.41e-19	NR	NCQ52296.1	1906665	g62958	i0	57.1	0.909448818897638	77	33	90.9	0	252	22	143	219	NCQ52296.1 ATP-binding protein [archaeon]	diamond	231	92	1	Archaea								archaeon
32465959	32465959	PRJNA789095_P_NODE_52979_length_279_cov_1.330097_g51645_i0	PRJNA789095	52979	279	1.330097	3.71097063	root	1	Root_unresolved	Root_unresolved	60.8	2.28e-8	NR	MCX6684510.1	2052170	g51645	i0	47.9	3.80645161290323	73	34	74.2	1	72	278	35	107	MCX6684510.1 NADP-dependent malic enzyme [Methanoregula sp.]	diamond	1062	61.2	0.993464052287582	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
32834851	32834851	PRJNA789095_P_NODE_67020_length_250_cov_0.870056_g65686_i0	PRJNA789095	67020	250	0.870056	2.17514	archaeon	1906665	Archaea	Archaea	162	1.26e-48	NR	RYG63187.1	1906665	g65686	i0	94	1.992	83	5	99.6	0	1	249	34	116	RYG63187.1 MAG: NAD-dependent epimerase/dehydratase family protein, partial [archaeon]	diamond	498	162	1	Archaea								archaeon
32897724	32897724	PRJNA789095_P_NODE_50280_length_285_cov_1.452830_g48946_i0	PRJNA789095	50280	285	1.45283	4.1405655	archaeon	1906665	Archaea	Archaea	48.9	2.62e-4	NR	NCP98223.1	1906665	g48946	i0	88.5	0.273684210526316	26	3	27.4	0	208	285	24	49	NCP98223.1 ribonuclease HII [archaeon]	diamond	78	48.9	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);;