metadata: contig_metadata: 10 rows where bioproject = "PRJNA1047749" and tax

10 rows where bioproject = "PRJNA1047749" and tax_phylum = "Armatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11653734	11653734	PRJNA1047749_P_NODE_37650_length_257_cov_2.516304_g37383_i0	PRJNA1047749	37650	257	2.516304	6.46690128	Armatimonadota bacterium	2033014	Bacteria	Bacteria	105	1.21e-26	NR	MFN3649789.1	2033014	g37383	i0	57.5	1.01556420233463	87	35	99.2	1	256	2	55	141	MFN3649789.1 DUF1579 domain-containing protein [Armatimonadota bacterium]	diamond	261	105	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
21852271	21852271	PRJNA1047749_P_NODE_51978_length_197_cov_5.500000_g51711_i0	PRJNA1047749	51978	197	5.5	10.835	Capsulimonas corticalis	2219043	Bacteria	Bacteria	135	1.65e-27	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g51711	i0	81.928	2.63451776649746	166	24	83	5	25	187	3219766	3219928	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	519	135	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
25236535	25236535	PRJNA1047749_P_NODE_29780_length_288_cov_4.711628_g29513_i0	PRJNA1047749	29780	288	4.711628	13.56948864	Armatimonadota bacterium	2033014	Bacteria	Bacteria	155	5.59e-44	NR	MFN3652792.1	2033014	g29513	i0	73.3	1.09375	105	15	95.8	1	286	11	92	196	MFN3652792.1 TIM barrel protein [Armatimonadota bacterium]	diamond	315	155	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
26615497	26615497	PRJNA1047749_P_NODE_2381_length_708_cov_4.537008_g2183_i0	PRJNA1047749	2381	708	4.537008	32.12201664	Bacillati	1783272	Bacteria	Bacteria	98.6	4.89e-20	NR	MFN7830007.1	2033014	g2183	i0	86.5	1.10169491525424	52	7	22	0	506	351	79	130	MFN7830007.1 ISAs1 family transposase [Armatimonadota bacterium]	diamond	780	99.4	0.991951710261569	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28195644	28195644	PRJNA1047749_P_NODE_23886_length_301_cov_4.201754_g23619_i0	PRJNA1047749	23886	301	4.201754	12.64727954	Bacteria	2	Bacteria	Bacteria	82	3.7e-16	NR	MBI3925164.1	2033014	g23619	i0	70	6.72757475083056	50	15	49.8	0	150	1	60	109	MBI3925164.1 VanW family protein [Armatimonadota bacterium]	diamond	2025	82.8	0.990338164251208	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29206397	29206397	PRJNA1047749_P_NODE_3549_length_611_cov_10.197026_g3311_i0	PRJNA1047749	3549	611	10.197026	62.30382886	Bacteria	2	Bacteria	Bacteria	122	2.91e-31	NR	MCW3052539.1	2282151	g3311	i0	84.4	1.2569558101473	64	10	31.4	0	418	609	1	64	MCW3052539.1 chromate transporter [Chthonomonadales bacterium]	diamond	768	122	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
30698714	30698714	PRJNA1047749_P_NODE_17774_length_312_cov_4.351464_g17507_i0	PRJNA1047749	17774	312	4.351464	13.57656768	Armatimonadota bacterium	2033014	Bacteria	Bacteria	77.8	4.12e-14	NR	HTE16972.1	2033014	g17507	i0	77.1	1.38461538461538	48	11	46.2	0	7	150	146	193	HTE16972.1 IS1182 family transposase [Armatimonadota bacterium]	diamond	432	77.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31140728	31140728	PRJNA1047749_P_NODE_44535_length_236_cov_3.325153_g44268_i0	PRJNA1047749	44535	236	3.325153	7.84736108	Armatimonadetes bacterium CG_4_1	2033014	Bacteria	Bacteria	84	1.02e-16	NR	PIY44557.1	1973909	g44268	i0	55.4	0.826271186440678	65	28	82.6	1	19	213	486	549	PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10]	diamond	195	84	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10
31836727	31836727	PRJNA1047749_P_NODE_34357_length_269_cov_7.816327_g34090_i0	PRJNA1047749	34357	269	7.816327	21.02591963	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	139	5.08e-39	NR	HZO87675.1	2739509	g34090	i0	86.2	2.92193308550186	87	12	97	0	266	6	94	180	HZO87675.1 aquaporin [Chthonomonadaceae bacterium]	diamond	786	139	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
32493423	32493423	PRJNA1047749_P_NODE_33839_length_271_cov_6.141414_g33572_i0	PRJNA1047749	33839	271	6.141414	16.64323194	Bacillati	1783272	Bacteria	Bacteria	102	2.96e-25	NR	MBV9850253.1	2033014	g33572	i0	61.6	3.73062730627306	86	33	95.2	0	271	14	83	168	MBV9850253.1 chromate transporter [Armatimonadota bacterium]	diamond	1011	102	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium

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