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

7 rows where bioproject = "PRJNA505329", 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
3034297	3034297	PRJNA505329_P_NODE_15623_length_233_cov_2.581522_g15152_i0	PRJNA505329	15623	233	2.581522	6.01494626	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	148	2.5899999999999997e-31	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g15152	i0	93.939	184.708154506438	99	4	42	2	4	101	667394	667491	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	43037	148	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15785961	15785961	PRJNA505329_P_NODE_22533_length_200_cov_3.192053_g22062_i0	PRJNA505329	22533	200	3.192053	6.384106	Armatimonas rosea	685828	Bacteria	Bacteria	64.3	4.32e-10	NR	WP_184200871.1	685828	g22062	i0	81.8	0.99	33	6	49.5	0	199	101	32	64	WP_184200871.1 TlpA family protein disulfide reductase [Armatimonas rosea]	diamond	198	64.3	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas rosea
21512121	21512121	PRJNA505329_P_NODE_10877_length_233_cov_3.777174_g10406_i0	PRJNA505329	10877	233	3.777174	8.80081542	Fimbriimonas	1005038	Bacteria	Bacteria	171	5.519999999999999e-38	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g10406	i0	97.03	16.9399141630901	101	3	85	0	133	233	27735	27635	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	3947	172	0.994186046511628	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
28245426	28245426	PRJNA505329_P_NODE_42266_length_169_cov_0.866667_g41795_i0	PRJNA505329	42266	169	0.866667	1.46466723	Armatimonadota bacterium	2033014	Bacteria	Bacteria	111	5.3500000000000006e-27	NR	MBW3637162.1	2033014	g41795	i0	92.7	0.976331360946746	55	4	97.6	0	4	168	261	315	MBW3637162.1 3-isopropylmalate dehydratase large subunit [Armatimonadota bacterium]	diamond	165	111	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30645595	30645595	PRJNA505329_P_NODE_36393_length_177_cov_3.093750_g35922_i0	PRJNA505329	36393	177	3.09375	5.4759375	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	81.6	1.08e-16	NR	MCS6777422.1	2739509	g35922	i0	56.9	0.983050847457627	58	25	98.3	0	4	177	121	178	MCS6777422.1 class I SAM-dependent methyltransferase [Chthonomonadaceae bacterium]	diamond	174	81.6	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
31056884	31056884	PRJNA505329_P_NODE_30755_length_186_cov_1.569343_g30284_i0	PRJNA505329	30755	186	1.569343	2.91897798	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	58.2	6.17e-8	NR	HMS56618.1	2682144	g30284	i0	53.2	3	62	29	100	0	1	186	107	168	HMS56618.1 RNA 3'-terminal phosphate cyclase [Fimbriimonadaceae bacterium]	diamond	558	58.2	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
32763681	32763681	PRJNA505329_P_NODE_19740_length_201_cov_4.546053_g19269_i0	PRJNA505329	19740	201	4.546053	9.13756653	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	61.2	6.26e-9	NR	MCS6777125.1	2739509	g19269	i0	84.4	0.477611940298507	32	5	47.8	0	3	98	270	301	MCS6777125.1 hypothetical protein [Chthonomonadaceae bacterium]	diamond	96	61.2	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);;