metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax_clade = "FCB group"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
410961	410961	PRJNA393181_S_NODE_6001_length_477_cov_2.086364_g5895_i0	PRJNA393181	6001	477	2.086364	9.95195628	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	122	3.49e-23	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g5895	i0	76.543	0.509433962264151	243	45	50	12	215	451	1851826	1852062	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	243	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
411042	411042	PRJNA393181_S_NODE_9641_length_388_cov_3.076923_g9535_i0	PRJNA393181	9641	388	3.076923	11.93846124	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	148	4.6e-31	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g9535	i0	78.788	1.93814432989691	231	41	59	8	151	377	3244796	3245022	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	752	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1685346	1685346	PRJNA393181_S_NODE_29182_length_209_cov_1.412791_g29076_i0	PRJNA393181	29182	209	1.412791	2.95273319	Hymenobacter monticola	1705399	Bacteria	Bacteria	58.4	3.94e-4	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g29076	i0	100	0.425837320574163	31	0	15	0	163	193	4524766	4524796	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	89	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
1685672	1685672	PRJNA393181_S_NODE_43202_length_160_cov_2.788618_g43096_i0	PRJNA393181	43202	160	2.788618	4.4617888	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	76.8	7.87e-10	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g43096	i0	79.825	0.7125	114	15	69	7	44	153	1881141	1881032	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	114	76.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6787806	6787806	PRJNA393181_S_NODE_1346_length_786_cov_2.962617_g1277_i0	PRJNA393181	1346	786	2.962617	23.28616962	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	337	1.9399999999999993e-87	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g1277	i0	75.126	32.5267175572519	792	159	98	36	16	786	2187124	2187898	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	25566	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
8063337	8063337	PRJNA393181_S_NODE_12167_length_346_cov_2.443366_g12061_i0	PRJNA393181	12167	346	2.443366	8.45404636	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	180	1.44e-40	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g12061	i0	77.612	2.33815028901734	335	49	97	15	10	344	4268535	4268843	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	809	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8063416	8063416	PRJNA393181_S_NODE_15447_length_305_cov_3.067164_g15341_i0	PRJNA393181	15447	305	3.067164	9.3548502	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	165	3.5e-36	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g15341	i0	79.668	9.09508196721312	241	39	77	9	3	238	1880322	1880087	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2774	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10006580	10006580	PRJNA393181_S_NODE_29948_length_205_cov_2.053571_g29842_i0	PRJNA393181	29948	205	2.053571	4.20982055	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g29842	i0	100	1.68292682926829	29	0	14	0	45	73	790932	790960	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	345	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
10614588	10614588	PRJNA393181_S_NODE_39629_length_170_cov_2.015038_g39523_i0	PRJNA393181	39629	170	2.015038	3.4255646	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	215	1.71e-51	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g39523	i0	89.881	99.3470588235294	168	15	98	2	1	167	2957342	2957176	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	16889	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11889758	11889758	PRJNA393181_S_NODE_46750_length_152_cov_2.147826_g46644_i0	PRJNA393181	46750	152	2.147826	3.26469552	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	209	6.97e-50	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g46644	i0	91.447	90.5328947368421	152	13	100	0	1	152	2186607	2186758	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	13761	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
13164774	13164774	PRJNA393181_S_NODE_711_length_938_cov_2.247503_g657_i0	PRJNA393181	711	938	2.247503	21.08157814	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	514	1.01e-140	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g657	i0	78.066	88.9669509594883	848	162	89	16	103	936	705526	704689	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	83451	514	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13831811	13831811	PRJNA393181_S_NODE_16151_length_298_cov_2.053640_g16045_i0	PRJNA393181	16151	298	2.05364	6.1198472	Cloacibacterium	501783	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g16045	i0	100	498.58389261745	298	0	100	0	1	298	130494	130197	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	148578	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14439252	14439252	PRJNA393181_S_NODE_25732_length_225_cov_3.234043_g25626_i0	PRJNA393181	25732	225	3.234043	7.27659675	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g25626	i0	100	0.391111111111111	30	0	13	0	33	62	1078859	1078830	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	88	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15712819	15712819	PRJNA393181_S_NODE_15593_length_304_cov_2.029963_g15487_i0	PRJNA393181	15593	304	2.029963	6.17108752	Hymenobacter monticola	1705399	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g15487	i0	94.444	0.674342105263158	36	2	12	0	131	166	2899871	2899906	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	205	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
15713573	15713573	PRJNA393181_S_NODE_44993_length_156_cov_2.268908_g44887_i0	PRJNA393181	44993	156	2.268908	3.53949648	Hymenobacter sp. PAMC 26628	1484118	Bacteria	Bacteria	244	1.9799999999999998e-60	NTclustered	gi\|996006667\|gb\|CP014304.1\|	1484118	g44887	i0	94.872	282.596153846154	156	8	100	0	1	156	586473	586628	Hymenobacter sp. PAMC 26628 chromosome, complete genome	blastn	44085	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. PAMC 26628
16381145	16381145	PRJNA393181_S_NODE_8053_length_421_cov_2.656250_g7947_i0	PRJNA393181	8053	421	2.65625	11.1828125	Pseudomonadati	3379134	Bacteria	Bacteria	233	1.35e-56	NTclustered	gi\|2893358440\|emb\|OZ220732.1\|	2910168	g7947	i0	83.936	53.6627078384798	249	34	58	6	8	252	3038159	3037913	MAG: Longimicrobiales bacterium isolate 1657d605-667c-4cd4-94fa-5f7303d281ff genome assembly, chromosome: 1	blastn	22592	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
18262241	18262241	PRJNA393181_S_NODE_34375_length_187_cov_2.033333_g34269_i0	PRJNA393181	34375	187	2.033333	3.80233271	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g34269	i0	100	248.625668449198	187	0	100	0	1	187	339013	338827	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	46493	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
18262421	18262421	PRJNA393181_S_NODE_41775_length_164_cov_1.842520_g41669_i0	PRJNA393181	41775	164	1.84252	3.0217328	Ignavibacterium sp.	2651167	Bacteria	Bacteria	60.2	8.18e-5	NTclustered	gi\|2314740639\|dbj\|AP026678.1\|	2651167	g41669	i0	93.023	3.82317073170732	43	0	24	2	114	153	384137	384095	MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome	blastn	627	60.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
21480404	21480404	PRJNA393181_S_NODE_7637_length_431_cov_2.395939_g7531_i0	PRJNA393181	7637	431	2.395939	10.32649709	FCB group	1783270	Bacteria	Bacteria	119	4.04e-22	NTclustered	gi\|193087197\|gb\|CP001100.1\|	517418	g7531	i0	95.89	19.3155452436195	73	3	17	0	251	323	1905152	1905224	Chloroherpeton thalassium ATCC 35110, complete genome	blastn	8325	119	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae	Chloroherpeton	Chloroherpeton thalassium
23362218	23362218	PRJNA393181_S_NODE_14399_length_318_cov_2.032028_g14293_i0	PRJNA393181	14399	318	2.032028	6.46184904	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	58.4	6.41e-4	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g14293	i0	100	0.276729559748428	31	0	10	0	288	318	5651556	5651526	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	88	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24030422	24030422	PRJNA393181_S_NODE_5679_length_487_cov_3.013333_g5573_i0	PRJNA393181	5679	487	3.013333	14.67493171	Pseudomonadati	3379134	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g5573	i0	97.059	0.669404517453799	34	1	7	0	217	250	87462	87495	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	326	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24637194	24637194	PRJNA393181_S_NODE_42400_length_162_cov_2.568000_g42294_i0	PRJNA393181	42400	162	2.568	4.16016	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g42294	i0	100	0.351851851851852	29	0	18	0	3	31	5056202	5056174	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	57	54.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota 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);;