metadata: contig_metadata: 8 rows where bioproject = "PRJNA1180292", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA1180292", tax_kingdom = "Bacillati" 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
28354581	28354581	PRJNA1180292_P_NODE_9886_length_249_cov_0.886364_g9754_i0	PRJNA1180292	9886	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	52.8	1.13e-5	NR	MCA1997409.1	2033014	g9754	i0	50	6.85542168674699	60	29	71.1	1	73	249	160	219	MCA1997409.1 LacI family transcriptional regulator [Armatimonadota bacterium]	diamond	1707	53.1	0.994350282485876	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29061871	29061871	PRJNA1180292_P_NODE_11168_length_246_cov_0.901734_g11036_i0	PRJNA1180292	11168	246	0.901734	2.21826564	Armatimonadota bacterium	2033014	Bacteria	Bacteria	47.8	5.83e-4	NR	MBP6964407.1	2033014	g11036	i0	58.8	0.621951219512195	51	20	61	1	245	96	219	269	MBP6964407.1 zf-HC2 domain-containing protein [Armatimonadota bacterium]	diamond	153	47.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29756181	29756181	PRJNA1180292_P_NODE_12351_length_243_cov_0.917647_g12219_i0	PRJNA1180292	12351	243	0.917647	2.22988221	Armatimonadota bacterium	2033014	Bacteria	Bacteria	120	2.01e-29	NR	MCJ7750108.1	2033014	g12219	i0	70	0.987654320987654	80	24	98.8	0	241	2	301	380	MCJ7750108.1 S9 family peptidase [Armatimonadota bacterium]	diamond	240	120	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30135077	30135077	PRJNA1180292_P_NODE_9812_length_249_cov_0.886364_g9680_i0	PRJNA1180292	9812	249	0.886364	2.20704636	Armatimonadota bacterium	2033014	Bacteria	Bacteria	82	1.06e-16	NR	MFB3880414.1	2033014	g9680	i0	60.3	0.759036144578313	63	25	75.9	0	248	60	187	249	MFB3880414.1 sensor histidine kinase [Armatimonadota bacterium]	diamond	189	82	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30262019	30262019	PRJNA1180292_P_NODE_11892_length_244_cov_0.912281_g11760_i0	PRJNA1180292	11892	244	0.912281	2.22596564	Armatimonadota bacterium	2033014	Bacteria	Bacteria	87.8	1.55e-18	NR	NLC56377.1	2033014	g11760	i0	53.1	0.995901639344262	81	38	99.6	0	243	1	213	293	NLC56377.1 hypothetical protein [Armatimonadota bacterium]	diamond	243	87.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30420110	30420110	PRJNA1180292_P_NODE_9753_length_249_cov_0.886364_g9621_i0	PRJNA1180292	9753	249	0.886364	2.20704636	Armatimonas rosea	685828	Bacteria	Bacteria	138	4.82e-36	NR	WP_343075972.1	685828	g9621	i0	69.9	1	83	25	100	0	249	1	131	213	WP_343075972.1 LamG-like jellyroll fold domain-containing protein [Armatimonas rosea]	diamond	249	138	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas rosea
31368017	31368017	PRJNA1180292_P_NODE_8016_length_253_cov_0.866667_g7884_i0	PRJNA1180292	8016	253	0.866667	2.19266751	Capsulimonas sp.	2494211	Bacteria	Bacteria	47	0.00103	NR	MCW3059556.1	2494211	g7884	i0	40	1.30434782608696	55	33	65.2	0	11	175	165	219	MCW3059556.1 hypothetical protein [Capsulimonas sp.]	diamond	330	47	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas sp.
32632689	32632689	PRJNA1180292_P_NODE_12440_length_243_cov_0.917647_g12308_i0	PRJNA1180292	12440	243	0.917647	2.22988221	Armatimonadetes bacterium CG_4_1	2033014	Bacteria	Bacteria	125	2.3599999999999998e-31	NR	PIY48071.1	1973909	g12308	i0	72.5	0.987654320987654	80	22	98.8	0	2	241	161	240	PIY48071.1 MAG: hypothetical protein COZ05_04190, partial [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10]	diamond	240	125	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10

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