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

8 rows where bioproject = "PRJNA393181", 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_species
8064165	8064165	PRJNA393181_S_NODE_44387_length_158_cov_1.157025_g44281_i0	PRJNA393181	44387	158	1.157025	1.8280995	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	100	4.6e-17	NTclustered	gi\|2874253971\|emb\|OY970296.1\|	157466	g44281	i0	80.142	40.1455696202532	141	23	87	4	6	143	2234741	2234603	MAG: uncultured Armatimonadetes bacterium isolate MFD04408.bin.1.1 genome assembly, chromosome: 1	blastn	6343	100	1	Bacteria	Bacillati	Armatimonadota	uncultured Armatimonadetes bacterium
22086556	22086556	PRJNA393181_S_NODE_14138_length_320_cov_4.233216_g14032_i0	PRJNA393181	14138	320	4.233216	13.5462912	Bacteria	2	Bacteria	Bacteria	112	4.21e-28	NR	MBI4278377.1	2033014	g14032	i0	64.9	3.525	74	26	69.4	0	12	233	166	239	MBI4278377.1 ribonuclease activity regulator RraA [Armatimonadota bacterium]	diamond	1128	112	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
27296570	27296570	PRJNA393181_S_NODE_39163_length_171_cov_3.194030_g39057_i0	PRJNA393181	39163	171	3.19403	5.4617913	Armatimonadota bacterium	2033014	Bacteria	Bacteria	48.1	1.11e-4	NR	MBM3501164.1	2033014	g39057	i0	48.1	0.947368421052632	54	28	94.7	0	164	3	129	182	MBM3501164.1 response regulator [Armatimonadota bacterium]	diamond	162	48.1	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
27612531	27612531	PRJNA393181_S_NODE_16704_length_292_cov_3.760784_g16598_i0	PRJNA393181	16704	292	3.760784	10.98148928	Armatimonadota bacterium	2033014	Bacteria	Bacteria	75.1	6.8e-14	NR	MBI4279463.1	2033014	g16598	i0	46.2	0.934931506849315	91	48	92.5	1	2	271	10	100	MBI4279463.1 cysteine hydrolase [Armatimonadota bacterium]	diamond	273	75.1	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
28433360	28433360	PRJNA393181_S_NODE_15526_length_304_cov_4.187266_g15420_i0	PRJNA393181	15526	304	4.187266	12.72928864	Armatimonadota bacterium	2033014	Bacteria	Bacteria	47.8	0.00131	NR	HQK95221.1	2033014	g15420	i0	33.3	0.976973684210526	99	60	92.8	3	286	5	363	460	HQK95221.1 hypothetical protein [Armatimonadota bacterium]	diamond	297	47.8	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
30296969	30296969	PRJNA393181_S_NODE_6352_length_466_cov_3.186480_g6246_i0	PRJNA393181	6352	466	3.18648	14.8489968	Armatimonadota bacterium	2033014	Bacteria	Bacteria	124	1.19e-29	NR	HEU4755005.1	2033014	g6246	i0	64.8	1.12017167381974	88	31	56.7	0	365	102	149	236	HEU4755005.1 glycerol-3-phosphate acyltransferase [Armatimonadota bacterium]	diamond	522	124	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
31750309	31750309	PRJNA393181_S_NODE_34577_length_186_cov_2.812081_g34471_i0	PRJNA393181	34577	186	2.812081	5.23047066	Armatimonadota bacterium	2033014	Bacteria	Bacteria	56.2	2.92e-7	NR	MFM7322715.1	2033014	g34471	i0	70.3	0.596774193548387	37	11	59.7	0	111	1	34	70	MFM7322715.1 YHYH protein [Armatimonadota bacterium]	diamond	111	56.2	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
32003600	32003600	PRJNA393181_S_NODE_3798_length_566_cov_3.359168_g3701_i0	PRJNA393181	3798	566	3.359168	19.01289088	Armatimonadota bacterium	2033014	Bacteria	Bacteria	55.1	3.85e-5	NR	MBI4279911.1	2033014	g3701	i0	86.2	0.312720848056537	29	4	15.4	0	90	4	25	53	MBI4279911.1 cysteine hydrolase [Armatimonadota bacterium]	diamond	177	55.1	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);;