metadata: contig_metadata: 15 rows where bioproject = "PRJNA326068", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA326068", 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
1069218	1069218	PRJNA326068_P_NODE_7461_length_388_cov_23.484680_g6523_i0	PRJNA326068	7461	388	23.48468	91.1205584	Fimbriimonas	1005038	Bacteria	Bacteria	540	6.49e-149	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g6523	i0	91.99	122.95618556701	387	27	99	4	4	388	29207	28823	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	47707	540	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
2344445	2344445	PRJNA326068_P_NODE_11062_length_290_cov_24.091954_g10101_i0	PRJNA326068	11062	290	24.091954	69.8666666	Fimbriimonas	1005038	Bacteria	Bacteria	407	4.969999999999999e-109	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g10101	i0	92.096	227.310344827586	291	20	100	3	1	290	28563	28851	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	65920	407	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
2344446	2344446	PRJNA326068_P_NODE_11342_length_284_cov_5.035294_g10380_i0	PRJNA326068	11342	284	5.035294	14.30023496	Fimbriimonas	1005038	Bacteria	Bacteria	263	1.11e-65	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g10380	i0	83.737	2.9612676056338	289	36	100	7	1	284	28035	28317	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	841	263	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
2344447	2344447	PRJNA326068_P_NODE_11442_length_282_cov_8.553360_g10480_i0	PRJNA326068	11442	282	8.55336	24.1204752	Chthonomonas	1077265	Bacteria	Bacteria	320	6.46e-83	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g10480	i0	87.368	317.510638297872	285	29	100	7	1	282	2193	1913	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	89538	320	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
2344472	2344472	PRJNA326068_P_NODE_4562_length_517_cov_15.739754_g3776_i0	PRJNA326068	4562	517	15.739754	81.37452818	Fimbriimonas	1005038	Bacteria	Bacteria	621	3.0799999999999995e-173	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g3776	i0	88.462	56.3500967117988	520	52	100	6	1	517	28411	27897	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	29133	621	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
2940028	2940028	PRJNA326068_P_NODE_10843_length_295_cov_9.233083_g9882_i0	PRJNA326068	10843	295	9.233083	27.23759485	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	207	5.52e-49	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g9882	i0	82.833	187.776271186441	233	38	79	2	63	295	1304056	1304286	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	55394	207	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
4897045	4897045	PRJNA326068_P_NODE_13164_length_248_cov_10.566210_g12201_i0	PRJNA326068	13164	248	10.56621	26.2042008	Chthonomonas	1077265	Bacteria	Bacteria	248	2.67e-61	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g12201	i0	84.861	285.326612903226	251	32	100	5	1	248	733	486	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	70761	248	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
6172070	6172070	PRJNA326068_P_NODE_16285_length_206_cov_4.536723_g15322_i0	PRJNA326068	16285	206	4.536723	9.34564938	Fimbriimonas	1005038	Bacteria	Bacteria	193	1.02e-44	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g15322	i0	83.575	49.2718446601942	207	32	100	2	1	206	29780	29575	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	10150	193	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7447070	7447070	PRJNA326068_P_NODE_17726_length_185_cov_7.141026_g16763_i0	PRJNA326068	17726	185	7.141026	13.2108981	Fimbriimonas	1005038	Bacteria	Bacteria	187	4.15e-43	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g16763	i0	84.865	104.762162162162	185	28	100	0	1	185	29767	29583	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	19381	187	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8042732	8042732	PRJNA326068_P_NODE_7667_length_381_cov_37.329545_g6724_i0	PRJNA326068	7667	381	37.329545	142.22556645	Fimbriimonas sp.	1936159	Bacteria	Bacteria	556	6.31e-154	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g6724	i0	93.369	456.997375328084	377	24	99	1	5	381	1689949	1689574	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	174116	556	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
8721760	8721760	PRJNA326068_P_NODE_7427_length_389_cov_37.230556_g6491_i0	PRJNA326068	7427	389	37.230556	144.82686284	Fimbriimonas	1005038	Bacteria	Bacteria	536	8.419999999999997e-148	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g6491	i0	91.56	126.071979434447	391	29	100	4	1	389	29211	28823	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	49042	536	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11868046	11868046	PRJNA326068_P_NODE_2390_length_706_cov_20.660266_g1828_i0	PRJNA326068	2390	706	20.660266	145.86147796	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	411	1.0100000000000001e-109	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g1828	i0	79.698	240.596317280453	596	99	82	19	1	581	1306129	1305541	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	169861	411	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
19515320	19515320	PRJNA326068_P_NODE_6636_length_420_cov_33.567775_g5721_i0	PRJNA326068	6636	420	33.567775	140.984655	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	346	1.66e-90	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g5721	i0	81.839	211.559523809524	435	58	100	16	1	420	1306058	1306486	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	88855	346	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
20195259	20195259	PRJNA326068_P_NODE_2716_length_666_cov_13.913658_g2117_i0	PRJNA326068	2716	666	13.913658	92.66496228	Fimbriimonas	1005038	Bacteria	Bacteria	811	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g2117	i0	88.955	43.7192192192192	670	57	100	11	1	666	27897	28553	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	29117	811	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
22746091	22746091	PRJNA326068_P_NODE_5038_length_491_cov_653.463203_g4223_i0	PRJNA326068	5038	491	653.463203	3208.50432673	Fimbriimonas	1005038	Bacteria	Bacteria	595	1.7599999999999994e-165	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g4223	i0	89.353	751.44399185336	479	44	97	6	16	491	26810	27284	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	368959	595	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli

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);;