metadata: contig_metadata: 10 rows where bioproject = "PRJNA1063685", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA1063685", 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
4839799	4839799	PRJNA1063685_S_NODE_12684_length_591_cov_2.137066_g12166_i0	PRJNA1063685	12684	591	2.137066	12.63006006	Fimbriimonas	1005038	Bacteria	Bacteria	584	4.659999999999998e-162	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g12166	i0	84.983	15.4957698815567	586	77	98	7	1	582	27940	28518	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	9158	584	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7832533	7832533	PRJNA1063685_S_NODE_9087_length_643_cov_8.842105_g8578_i0	PRJNA1063685	9087	643	8.842105	56.85473515	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	861	0	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g8578	i0	90.853	157.359253499222	645	55	100	4	1	643	2201314	2201956	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	101182	861	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
26963765	26963765	PRJNA1063685_S_NODE_10142_length_626_cov_23.171790_g9628_i0	PRJNA1063685	10142	626	23.17179	145.0554054	FCB group	1783270	Bacteria	Bacteria	126	4.38e-33	NR	WP_075166323.1	454171	g9628	i0	50	4.02076677316294	142	68	67.6	3	89	511	1	140	WP_075166323.1 GNAT family N-acetyltransferase [Chthonomonas calidirosea]	diamond	2517	127	0.992125984251969	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
27343594	27343594	PRJNA1063685_S_NODE_5463_length_719_cov_27.116099_g5012_i0	PRJNA1063685	5463	719	27.116099	194.96475181	FCB group	1783270	Bacteria	Bacteria	192	1.34e-58	NR	MBI1333644.1	2033014	g5012	i0	83.5	1.43949930458971	115	19	48	0	717	373	21	135	MBI1333644.1 OsmC family peroxiredoxin [Armatimonadota bacterium]	diamond	1035	192	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30193388	30193388	PRJNA1063685_S_NODE_24472_length_470_cov_4.871537_g23932_i0	PRJNA1063685	24472	470	4.871537	22.8962239	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	133	1.85e-35	NR	MCW3098465.1	2739509	g23932	i0	60.9	0.734042553191489	115	44	73.4	1	470	126	136	249	MCW3098465.1 oxidoreductase [Chthonomonadaceae bacterium]	diamond	345	133	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
30225070	30225070	PRJNA1063685_S_NODE_9372_length_639_cov_3.310954_g8862_i0	PRJNA1063685	9372	639	3.310954	21.15699606	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	99	6.89e-20	NR	MBX7134401.1	2682144	g8862	i0	32.5	1.08450704225352	231	124	97.2	11	11	631	442	664	MBX7134401.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	693	99	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
30541021	30541021	PRJNA1063685_S_NODE_66713_length_259_cov_2.107527_g66170_i0	PRJNA1063685	66713	259	2.107527	5.45849493	Armatimonadota bacterium	2033014	Bacteria	Bacteria	75.9	1.02e-13	NR	MCA1997470.1	2033014	g66170	i0	69.8	1.21621621621622	53	16	61.4	0	259	101	33	85	MCA1997470.1 preprotein translocase subunit SecA [Armatimonadota bacterium]	diamond	315	75.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30572385	30572385	PRJNA1063685_S_NODE_18373_length_526_cov_2.788079_g17837_i0	PRJNA1063685	18373	526	2.788079	14.66529554	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	60.5	4.5e-7	NR	MFN8220239.1	2682145	g17837	i0	36.2	0.724334600760456	127	69	70.2	3	387	19	7	125	MFN8220239.1 hypothetical protein [Fimbriimonadales bacterium]	diamond	381	60.5	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
30604145	30604145	PRJNA1063685_S_NODE_73933_length_242_cov_1.366864_g73390_i0	PRJNA1063685	73933	242	1.366864	3.30781088	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	43.9	0.00145	NR	MCX7799073.1	2682145	g73390	i0	48.9	0.557851239669422	45	17	55.8	1	75	209	8	46	MCX7799073.1 hypothetical protein [Fimbriimonadales bacterium]	diamond	135	43.9	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
32659063	32659063	PRJNA1063685_S_NODE_28520_length_440_cov_2.495913_g27979_i0	PRJNA1063685	28520	440	2.495913	10.9820172	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	54.7	1.77e-6	NR	HLK57827.1	2739509	g27979	i0	35.4	1.32954545454545	82	45	55.9	3	115	360	25	98	HLK57827.1 carbohydrate-binding module family 20 domain-containing protein [Chthonomonadaceae bacterium]	diamond	585	54.7	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);;