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

8 rows where bioproject = "PRJNA993416", 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
4803752	4803752	PRJNA993416_P_NODE_15644_length_242_cov_1.568047_g15539_i0	PRJNA993416	15644	242	1.568047	3.79467374	Fimbriimonas sp.	1936159	Bacteria	Bacteria	125	1.55e-33	NR	MDR3692815.1	1936159	g15539	i0	75.9	0.979338842975207	79	19	97.9	0	237	1	120	198	MDR3692815.1 diacylglycerol kinase [Fimbriimonas sp.]	diamond	237	125	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
19124224	19124224	PRJNA993416_P_NODE_15375_length_243_cov_0.905882_g15270_i0	PRJNA993416	15375	243	0.905882	2.20129326	Fimbriimonas sp.	1936159	Bacteria	Bacteria	124	1.7599999999999998e-31	NR	MDR3692816.1	1936159	g15270	i0	79	1	81	17	100	0	1	243	334	414	MDR3692816.1 hemolysin family protein [Fimbriimonas sp.]	diamond	243	124	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
26773316	26773316	PRJNA993416_P_NODE_1621_length_670_cov_1.301508_g1523_i0	PRJNA993416	1621	670	1.301508	8.7201036	Armatimonadota bacterium	2033014	Bacteria	Bacteria	114	2.09e-28	NR	MBS1722500.1	2033014	g1523	i0	56.4	0.452238805970149	101	41	43.9	2	313	20	1	101	MBS1722500.1 hypothetical protein [Armatimonadota bacterium]	diamond	303	114	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27879362	27879362	PRJNA993416_P_NODE_16425_length_237_cov_2.347561_g16320_i0	PRJNA993416	16425	237	2.347561	5.56371957	Armatimonadota bacterium	2033014	Bacteria	Bacteria	85.9	2.22e-17	NR	MBI3920286.1	2033014	g16320	i0	61.5	1.63291139240506	65	25	82.3	0	39	233	565	629	MBI3920286.1 isoleucine--tRNA ligase [Armatimonadota bacterium]	diamond	387	85.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27974093	27974093	PRJNA993416_P_NODE_9965_length_274_cov_2.149254_g9860_i0	PRJNA993416	9965	274	2.149254	5.88895596	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	135	4.31e-36	NR	MCC7230816.1	2682144	g9860	i0	74.7	1.90510948905109	87	22	95.3	0	1	261	286	372	MCC7230816.1 sigma-54-dependent Fis family transcriptional regulator [Fimbriimonadaceae bacterium]	diamond	522	135	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
28289645	28289645	PRJNA993416_P_NODE_1886_length_628_cov_2.084685_g1785_i0	PRJNA993416	1886	628	2.084685	13.0918218	Armatimonadota bacterium	2033014	Bacteria	Bacteria	52.8	2.84e-4	NR	MBS1722733.1	2033014	g1785	i0	62.2	0.176751592356688	37	14	17.7	0	60	170	216	252	MBS1722733.1 hypothetical protein [Armatimonadota bacterium]	diamond	111	52.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28763322	28763322	PRJNA993416_P_NODE_15887_length_242_cov_0.911243_g15782_i0	PRJNA993416	15887	242	0.911243	2.20520806	Fimbriimonas sp.	1936159	Bacteria	Bacteria	91.3	1.95e-19	NR	MDR3688621.1	1936159	g15782	i0	67.8	0.731404958677686	59	19	73.1	0	65	241	1	59	MDR3688621.1 type IV pilus twitching motility protein PilT [Fimbriimonas sp.]	diamond	177	91.3	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
31132026	31132026	PRJNA993416_P_NODE_12215_length_252_cov_1.625698_g12110_i0	PRJNA993416	12215	252	1.625698	4.09675896	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	50.8	1.86e-5	NR	MCB8932851.1	2739509	g12110	i0	54.3	0.547619047619048	46	21	54.8	0	252	115	106	151	MCB8932851.1 hypothetical protein [Chthonomonadaceae bacterium]	diamond	138	50.8	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae 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);;