metadata: contig_metadata: 12 rows where bioproject = "PRJNA669701", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA669701", 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
4993022	4993022	PRJNA669701_P_NODE_85824_length_275_cov_1.500000_g85429_i0	PRJNA669701	85824	275	1.5	4.125	Fimbriimonas	1005038	Bacteria	Bacteria	390	4.72e-104	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g85429	i0	92.364	169.552727272727	275	20	100	1	1	275	28640	28913	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	46627	390	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
9563925	9563925	PRJNA669701_P_NODE_144568_length_236_cov_2.797546_g144173_i0	PRJNA669701	144568	236	2.797546	6.60220856	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	117	1.83e-29	NR	WP_025227031.1	1005039	g144173	i0	71.8	0.991525423728814	78	22	99.2	0	234	1	285	362	WP_025227031.1 mannose-1-phosphate guanylyltransferase [Fimbriimonas ginsengisoli]	diamond	234	117	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
14664291	14664291	PRJNA669701_P_NODE_136932_length_242_cov_1.721893_g136537_i0	PRJNA669701	136932	242	1.721893	4.16698106	Chthonomonadales bacterium	2282151	Bacteria	Bacteria	106	7.65e-25	NR	MCW3055386.1	2282151	g136537	i0	66.7	0.855371900826446	69	23	85.5	0	34	240	324	392	MCW3055386.1 hypothetical protein [Chthonomonadales bacterium]	diamond	207	106	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
27113066	27113066	PRJNA669701_P_NODE_133382_length_243_cov_1.976471_g132987_i0	PRJNA669701	133382	243	1.976471	4.80282453	Armatimonadota bacterium	2033014	Bacteria	Bacteria	104	2.15e-26	NR	MBI5830785.1	2033014	g132987	i0	69.2	0.962962962962963	78	23	95.1	1	8	238	18	95	MBI5830785.1 hypothetical protein [Armatimonadota bacterium]	diamond	234	104	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27346680	27346680	PRJNA669701_P_NODE_75423_length_287_cov_2.476636_g75028_i0	PRJNA669701	75423	287	2.476636	7.10794532	Bacteria	2	Bacteria	Bacteria	149	1.75e-39	NR	MBW3637661.1	2033014	g75028	i0	70.5	22.7770034843206	95	28	99.3	0	1	285	104	198	MBW3637661.1 sugar nucleotide-binding protein [Armatimonadota bacterium]	diamond	6537	150	0.993333333333333	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27965974	27965974	PRJNA669701_P_NODE_144625_length_236_cov_2.552147_g144230_i0	PRJNA669701	144625	236	2.552147	6.02306692	Armatimonadota bacterium	2033014	Bacteria	Bacteria	121	4.34e-30	NR	MDQ3814618.1	2033014	g144230	i0	75.6	0.991525423728814	78	19	99.2	0	234	1	123	200	MDQ3814618.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium]	diamond	234	121	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28092339	28092339	PRJNA669701_P_NODE_95945_length_263_cov_2.247368_g95550_i0	PRJNA669701	95945	263	2.247368	5.91057784	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	100	4.819999999999999e-23	NR	HZO91052.1	2739509	g95550	i0	57.5	1.98479087452471	87	37	99.2	0	2	262	143	229	HZO91052.1 D-alanine--D-alanine ligase [Chthonomonadaceae bacterium]	diamond	522	100	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
28818229	28818229	PRJNA669701_P_NODE_80528_length_281_cov_1.663462_g80133_i0	PRJNA669701	80528	281	1.663462	4.67432822	Armatimonadetes bacterium Cent15-Ar3	1987502	Bacteria	Bacteria	78.6	7.75e-15	NR	OWU65761.1	1987502	g80133	i0	56.9	0.768683274021352	72	31	76.9	0	233	18	1	72	OWU65761.1 MAG: hypothetical protein CBB60_003030 [Armatimonadetes bacterium Cent15-Ar3]	diamond	216	78.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Cent15-Ar3
29481250	29481250	PRJNA669701_P_NODE_122690_length_247_cov_0.885057_g122295_i0	PRJNA669701	122690	247	0.885057	2.18609079	Armatimonadota bacterium	2033014	Bacteria	Bacteria	160	2.5e-46	NR	MBC8104839.1	2033014	g122295	i0	86.4	0.983805668016194	81	11	98.4	0	3	245	147	227	MBC8104839.1 sugar phosphate isomerase/epimerase [Armatimonadota bacterium]	diamond	243	160	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30492452	30492452	PRJNA669701_P_NODE_76353_length_286_cov_2.150235_g75958_i0	PRJNA669701	76353	286	2.150235	6.1496721	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	115	4.4e-29	NR	HZP82602.1	2739509	g75958	i0	65.5	0.881118881118881	84	29	88.1	0	2	253	199	282	HZP82602.1 HDOD domain-containing protein [Chthonomonadaceae bacterium]	diamond	252	115	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
31851535	31851535	PRJNA669701_P_NODE_149437_length_203_cov_4.123077_g149042_i0	PRJNA669701	149437	203	4.123077	8.36984631	Armatimonadota bacterium	2033014	Bacteria	Bacteria	76.6	1.54e-14	NR	MBI3928987.1	2033014	g149042	i0	58.2	0.990147783251232	67	27	99	1	202	2	216	281	MBI3928987.1 hypothetical protein [Armatimonadota bacterium]	diamond	201	76.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32231593	32231593	PRJNA669701_P_NODE_120178_length_247_cov_1.505747_g119783_i0	PRJNA669701	120178	247	1.505747	3.71919509	Armatimonadota bacterium	2033014	Bacteria	Bacteria	110	3.91e-26	NR	MDQ2799549.1	2033014	g119783	i0	67.5	0.97165991902834	80	26	97.2	0	3	242	582	661	MDQ2799549.1 polynucleotide kinase-phosphatase [Armatimonadota bacterium]	diamond	240	110	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);;