metadata: contig_metadata: 6 rows where bioproject = "PRJNA408129", tax_phylum = "Armatimonadota" and tax

6 rows where bioproject = "PRJNA408129", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"

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
11897247	11897247	PRJNA408129_S_NODE_20690_length_177_cov_2.257143_g20672_i0	PRJNA408129	20690	177	2.257143	3.99514311	Capsulimonas corticalis	2219043	Bacteria	Bacteria	171	3.96e-38	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g20672	i0	85.119	2.84745762711864	168	23	94	2	11	177	593454	593288	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	504	171	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
14447377	14447377	PRJNA408129_S_NODE_32272_length_155_cov_1.279661_g32254_i0	PRJNA408129	32272	155	1.279661	1.98347455	Capsulimonas	2494209	Bacteria	Bacteria	74.3	1.86e-14	NR	WP_119322870.1	2219043	g32254	i0	78.6	1.6258064516129	42	9	81.3	0	23	148	1	42	WP_119322870.1 J domain-containing protein [Capsulimonas corticalis]	diamond	252	74.3	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
22094741	22094741	PRJNA408129_S_NODE_13238_length_203_cov_4.518072_g13220_i0	PRJNA408129	13238	203	4.518072	9.17168616	Capsulimonas corticalis	2219043	Bacteria	Bacteria	211	2.76e-50	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g13220	i0	86.598	253.137931034483	194	23	95	3	1	193	595377	595568	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	51387	211	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
29492097	29492097	PRJNA408129_S_NODE_26030_length_165_cov_1.687500_g26012_i0	PRJNA408129	26030	165	1.6875	2.784375	Capsulimonas	2494209	Bacteria	Bacteria	87.8	1.58e-18	NR	MDQ2800501.1	2033014	g26012	i0	75.5	2.83636363636364	53	13	96.4	0	5	163	117	169	MDQ2800501.1 peptide ABC transporter substrate-binding protein [Armatimonadota bacterium]	diamond	468	87.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32225360	32225360	PRJNA408129_S_NODE_25958_length_165_cov_2.179688_g25940_i0	PRJNA408129	25958	165	2.179688	3.5964852	Armatimonadota bacterium	2033014	Bacteria	Bacteria	40.4	0.0163	NR	MFO7946551.1	2033014	g25940	i0	48.4	0.563636363636364	31	16	56.4	0	26	118	31	61	MFO7946551.1 hypothetical protein [Armatimonadota bacterium]	diamond	93	40.4	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32400266	32400266	PRJNA408129_S_NODE_12179_length_209_cov_2.819767_g12161_i0	PRJNA408129	12179	209	2.819767	5.89331303	Bacteria	2	Bacteria	Bacteria	132	2.14e-35	NR	MCX6382239.1	2033014	g12161	i0	94.2	4.88038277511962	69	4	99	0	209	3	290	358	MCX6382239.1 dehypoxanthine futalosine cyclase [Armatimonadota bacterium]	diamond	1020	133	0.992481203007519	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);;