metadata: contig_metadata: 11 rows where bioproject = "PRJNA1160211", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA1160211", 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
4866389	4866389	PRJNA1160211_S_NODE_173764_length_342_cov_6.152416_g172531_i0	PRJNA1160211	173764	342	6.152416	21.04126272	Fimbriimonas	1005038	Bacteria	Bacteria	278	4.9e-70	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g172531	i0	83.784	178.824561403509	296	45	86	3	36	329	29785	29491	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	61158	278	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
6688241	6688241	PRJNA1160211_S_NODE_289986_length_231_cov_14.544304_g288753_i0	PRJNA1160211	289986	231	14.544304	33.59734224	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	206	1.5e-48	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g288753	i0	85.149	24.4978354978355	202	28	87	2	2	202	895838	896038	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	5659	206	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
12516938	12516938	PRJNA1160211_S_NODE_143410_length_384_cov_4.292605_g142177_i0	PRJNA1160211	143410	384	4.292605	16.4836032	Fimbriimonas	1005038	Bacteria	Bacteria	470	8.54e-128	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g142177	i0	88.889	22.4947916666667	387	35	100	6	1	384	27960	28341	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	8638	470	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
13062926	13062926	PRJNA1160211_S_NODE_147311_length_378_cov_10.957377_g146078_i0	PRJNA1160211	147311	378	10.957377	41.41888506	PVC group	1783257	Bacteria	Bacteria	236	3.7699999999999997e-69	NR	MCA1997470.1	2033014	g146078	i0	91	2.93650793650794	122	11	96.8	0	366	1	204	325	MCA1997470.1 preprotein translocase subunit SecA [Armatimonadota bacterium]	diamond	1110	236	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
20710489	20710489	PRJNA1160211_S_NODE_12397_length_781_cov_5.730226_g11548_i0	PRJNA1160211	12397	781	5.730226	44.75306506	Armatimonadota bacterium	2033014	Bacteria	Bacteria	427	3.87e-137	NR	MCA1997470.1	2033014	g11548	i0	82.9	1.97439180537772	258	44	99.1	0	8	781	384	641	MCA1997470.1 preprotein translocase subunit SecA [Armatimonadota bacterium]	diamond	1542	427	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28777228	28777228	PRJNA1160211_S_NODE_116447_length_427_cov_5.838983_g115218_i0	PRJNA1160211	116447	427	5.838983	24.93245741	Armatimonadota bacterium	2033014	Bacteria	Bacteria	155	1.0099999999999999e-46	NR	MCL6532333.1	2033014	g115218	i0	100	0.51288056206089	73	0	51.3	0	138	356	1	73	MCL6532333.1 hypothetical protein [Armatimonadota bacterium]	diamond	219	155	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28966964	28966964	PRJNA1160211_S_NODE_268908_length_248_cov_1.760000_g267675_i0	PRJNA1160211	268908	248	1.76	4.3648	Armatimonadota bacterium	2033014	Bacteria	Bacteria	73.2	7.5e-13	NR	MDQ2798255.1	2033014	g267675	i0	55.2	0.810483870967742	67	29	79.8	1	28	225	140	206	MDQ2798255.1 malectin domain-containing carbohydrate-binding protein [Armatimonadota bacterium]	diamond	201	73.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29188020	29188020	PRJNA1160211_S_NODE_129429_length_406_cov_2.003003_g128197_i0	PRJNA1160211	129429	406	2.003003	8.13219218	Armatimonadetes bacterium CG_4_1	2033014	Bacteria	Bacteria	255	4.92e-80	NR	PIY44557.1	1973909	g128197	i0	98.5	0.997536945812808	135	2	99.8	0	2	406	42	176	PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10]	diamond	405	255	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10
30198177	30198177	PRJNA1160211_S_NODE_245092_length_266_cov_1.544041_g243859_i0	PRJNA1160211	245092	266	1.544041	4.10714906	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	107	4.61e-25	NR	MEA2554327.1	2682144	g243859	i0	65.9	0.924812030075188	82	28	92.5	0	2	247	141	222	MEA2554327.1 dihydrofolate synthase / folylpolyglutamate synthase [Fimbriimonadaceae bacterium]	diamond	246	107	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
30640577	30640577	PRJNA1160211_S_NODE_218533_length_291_cov_1.412844_g217300_i0	PRJNA1160211	218533	291	1.412844	4.11137604	Armatimonadota bacterium	2033014	Bacteria	Bacteria	56.6	9.19e-7	NR	HEY3283062.1	2033014	g217300	i0	41.4	0.896907216494845	87	51	89.7	0	288	28	941	1027	HEY3283062.1 DUF2793 domain-containing protein [Armatimonadota bacterium]	diamond	261	56.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30767133	30767133	PRJNA1160211_S_NODE_301014_length_198_cov_5.784000_g299781_i0	PRJNA1160211	301014	198	5.784	11.45232	Armatimonadota bacterium	2033014	Bacteria	Bacteria	77	1.67e-14	NR	MBN9503489.1	2033014	g299781	i0	62.1	0.878787878787879	58	22	87.9	0	178	5	745	802	MBN9503489.1 PD40 domain-containing protein [Armatimonadota bacterium]	diamond	174	77	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);;