metadata: contig_metadata: 7 rows where bioproject = "PRJDB4941", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJDB4941", 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
3836401	3836401	PRJDB4941_P_NODE_21984_length_216_cov_2.203593_g21216_i0	PRJDB4941	21984	216	2.203593	4.75976088	Armatimonadota bacterium	2033014	Bacteria	Bacteria	103	7.68e-24	NR	MCC2668200.1	2033014	g21216	i0	73.2	0.986111111111111	71	19	98.6	0	214	2	72	142	MCC2668200.1 heme transporter ATP-binding protein [Armatimonadota bacterium]	diamond	213	103	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
8937066	8937066	PRJDB4941_P_NODE_1548_length_1583_cov_10.599087_g1063_i0	PRJDB4941	1548	1583	10.599087	167.78354721	Armatimonadetes bacterium RBG_16_67_12	1797288	Bacteria	Bacteria	261	3.05e-73	NR	OFX28072.1	1797288	g1063	i0	48.1	0.55527479469362	293	131	55.1	2	16	888	400	673	OFX28072.1 MAG: hypothetical protein A2Z07_05320 [Armatimonadetes bacterium RBG_16_67_12]	diamond	879	261	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium RBG_16_67_12
28200895	28200895	PRJDB4941_P_NODE_20366_length_226_cov_2.056497_g19598_i0	PRJDB4941	20366	226	2.056497	4.64768322	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	74.7	1.27e-13	NR	MCW3100499.1	2739509	g19598	i0	49.4	1.04867256637168	79	36	99.6	1	225	1	85	163	MCW3100499.1 ligase, RnlA [Chthonomonadaceae bacterium]	diamond	237	74.7	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
29116943	29116943	PRJDB4941_P_NODE_41949_length_154_cov_2.133333_g41181_i0	PRJDB4941	41949	154	2.133333	3.28533282	Armatimonadota bacterium	2033014	Bacteria	Bacteria	53.9	1.2e-6	NR	MCC2669454.1	2033014	g41181	i0	50	0.974025974025974	50	25	97.4	0	3	152	100	149	MCC2669454.1 hypothetical protein [Armatimonadota bacterium]	diamond	150	53.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29811252	29811252	PRJDB4941_P_NODE_24871_length_202_cov_1.359477_g24103_i0	PRJDB4941	24871	202	1.359477	2.74614354	Capsulimonas corticalis	2219043	Bacteria	Bacteria	97.8	1.57e-22	NR	WP_218025794.1	2219043	g24103	i0	67.2	1.9752475247524801	67	22	99.5	0	201	1	94	160	WP_218025794.1 hypothetical protein [Capsulimonas corticalis]	diamond	399	97.8	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
31770835	31770835	PRJDB4941_P_NODE_4037_length_708_cov_4.163885_g3298_i0	PRJDB4941	4037	708	4.163885	29.4803058	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	62.4	2.16e-7	NR	HZP83626.1	2739509	g3298	i0	30.7	0.758474576271186	179	113	74.2	5	183	707	5	176	HZP83626.1 TIGR04222 domain-containing membrane protein [Chthonomonadaceae bacterium]	diamond	537	62.4	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
32687700	32687700	PRJDB4941_P_NODE_31780_length_175_cov_3.666667_g31012_i0	PRJDB4941	31780	175	3.666667	6.41666725	Armatimonadota bacterium	2033014	Bacteria	Bacteria	72	4.89e-13	NR	HEU4753497.1	2033014	g31012	i0	59.6	1.93714285714286	57	23	97.7	0	3	173	111	167	HEU4753497.1 DUF5693 family protein [Armatimonadota bacterium]	diamond	339	72	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);;