metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax_phylum = "Gemmatimonadota"

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
717400	717400	PRJNA734348_P_NODE_138021_length_235_cov_2.777778_g137323_i0	PRJNA734348	138021	235	2.777778	6.5277783	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	139	1.57e-28	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g137323	i0	87.097	1.96595744680851	124	14	52	2	108	230	4100933	4101055	Gemmatimonas phototrophica strain AP64, complete genome	blastn	462	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
718871	718871	PRJNA734348_P_NODE_76301_length_264_cov_1.246073_g75603_i0	PRJNA734348	76301	264	1.246073	3.28963272	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	252	2.22e-62	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g75603	i0	84.706	4.43560606060606	255	36	95	3	4	255	3861108	3860854	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	1171	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
1994321	1994321	PRJNA734348_P_NODE_46062_length_297_cov_1.892857_g45365_i0	PRJNA734348	46062	297	1.892857	5.62178529	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	333	8.8e-87	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g45365	i0	86.957	32.0808080808081	299	36	100	3	1	297	1554767	1555064	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	9528	333	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
3268316	3268316	PRJNA734348_P_NODE_115583_length_245_cov_0.895349_g114885_i0	PRJNA734348	115583	245	0.895349	2.19360505	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	75	4.72e-9	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g114885	i0	85.135	0.302040816326531	74	9	30	2	28	100	2127472	2127544	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	74	75	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4545237	4545237	PRJNA734348_P_NODE_101544_length_249_cov_0.875000_g100846_i0	PRJNA734348	101544	249	0.875	2.17875	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	141	4.68e-29	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g100846	i0	85.211	1.10441767068273	142	15	56	6	111	249	3170095	3169957	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	275	141	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5820920	5820920	PRJNA734348_P_NODE_13345_length_602_cov_3.134216_g12673_i0	PRJNA734348	13345	602	3.134216	18.86798032	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	505	3.809999999999998e-138	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g12673	i0	82.372	22.9667774086379	607	81	100	18	1	602	3044128	3043543	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	13826	505	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5821618	5821618	PRJNA734348_P_NODE_31145_length_348_cov_2.967273_g30449_i0	PRJNA734348	31145	348	2.967273	10.32611004	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	442	1.6699999999999993e-119	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g30449	i0	90.202	105.344827586207	347	23	99	5	3	348	1903371	1903707	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	36660	442	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5822174	5822174	PRJNA734348_P_NODE_60105_length_279_cov_2.669903_g59408_i0	PRJNA734348	60105	279	2.669903	7.44902937	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	248	3.0499999999999997e-61	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g59408	i0	83.094	1.12903225806452	278	41	99	6	4	278	585415	585689	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	315	248	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8850196	8850196	PRJNA734348_P_NODE_32927_length_339_cov_2.906015_g32231_i0	PRJNA734348	32927	339	2.906015	9.85139085	Gemmatimonadaceae	219687	Bacteria	Bacteria	435	2.7200000000000003e-117	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g32231	i0	89.826	377.710914454277	344	27	100	7	1	339	343225	342885	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	128044	438	0.993150684931507	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9646483	9646483	PRJNA734348_P_NODE_32368_length_342_cov_1.743494_g31672_i0	PRJNA734348	32368	342	1.743494	5.96274948	uncultured Gemmatimonadota bacterium	203437	Bacteria	Bacteria	625	1.5199999999999998e-174	NTclustered	gi\|60266676\|gb\|AY922130.1\|	203437	g31672	i0	99.707	99.312865497076	341	1	99	0	1	341	323	663	Uncultured Gemmatimonadetes bacterium clone AKYH466 16S ribosomal RNA gene, partial sequence	blastn	33965	625	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
9647404	9647404	PRJNA734348_P_NODE_81448_length_259_cov_2.306452_g80750_i0	PRJNA734348	81448	259	2.306452	5.97371068	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	102	2.31e-17	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g80750	i0	86.813	0.351351351351351	91	12	35	0	1	91	5866143	5866233	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	91	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12196905	12196905	PRJNA734348_P_NODE_147130_length_211_cov_4.210145_g146432_i0	PRJNA734348	147130	211	4.210145	8.88340595	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	152	1.78e-32	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g146432	i0	89.831	53.2843601895735	118	12	56	0	2	119	2184749	2184632	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	11243	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13471293	13471293	PRJNA734348_P_NODE_14271_length_572_cov_3.961924_g13591_i0	PRJNA734348	14271	572	3.961924	22.66220528	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	640	9.469999999999998e-179	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g13591	i0	89.412	24.3496503496504	510	51	89	3	1	508	801627	801119	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	13928	640	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13471309	13471309	PRJNA734348_P_NODE_143871_length_227_cov_2.194805_g143173_i0	PRJNA734348	143871	227	2.194805	4.98220735	uncultured Gemmatimonadota bacterium	203437	Bacteria	Bacteria	414	2.2399999999999998e-111	NTclustered	gi\|184198991\|gb\|EU447635.1\|	203437	g143173	i0	99.559	100.47577092511	227	1	100	0	1	227	334	108	Uncultured Gemmatimonadetes bacterium clone 35 WD85 16S ribosomal RNA gene, partial sequence	blastn	22808	414	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
14747588	14747588	PRJNA734348_P_NODE_65492_length_274_cov_1.532338_g64795_i0	PRJNA734348	65492	274	1.532338	4.19860612	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	193	1.4200000000000001e-44	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g64795	i0	85.106	15.7518248175182	188	28	69	0	5	192	1537680	1537493	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	4316	193	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16020052	16020052	PRJNA734348_P_NODE_143393_length_227_cov_3.506494_g142695_i0	PRJNA734348	143393	227	3.506494	7.95974138	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	91.6	4.28e-14	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g142695	i0	81.356	2.98678414096916	118	17	52	5	14	130	52734	52847	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	678	91.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
17297082	17297082	PRJNA734348_P_NODE_83534_length_257_cov_2.896739_g82836_i0	PRJNA734348	83534	257	2.896739	7.44461923	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	163	1.04e-35	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g82836	i0	84.211	0.840466926070039	171	23	66	4	74	242	1218945	1219113	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	216	163	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17297273	17297273	PRJNA734348_P_NODE_93934_length_251_cov_0.865169_g93236_i0	PRJNA734348	93934	251	0.865169	2.17157419	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	270	5.77e-68	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g93236	i0	86.166	25.003984063745	253	31	100	4	1	251	2430084	2430334	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	6276	270	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18570623	18570623	PRJNA734348_P_NODE_7435_length_924_cov_3.341951_g6877_i0	PRJNA734348	7435	924	3.341951	30.87962724	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1273	0	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g6877	i0	91.839	621.40367965368	919	65	99	8	1	917	801670	802580	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	574177	1273	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19049107	19049107	PRJNA734348_P_NODE_53015_length_287_cov_1.154206_g52318_i0	PRJNA734348	53015	287	1.154206	3.31257122	FCB group	1783270	Bacteria	Bacteria	99	3.36e-16	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g52318	i0	90.541	23.6306620209059	74	7	26	0	159	232	3979918	3979845	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	6782	100	0.99	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19844188	19844188	PRJNA734348_P_NODE_129696_length_242_cov_0.911243_g128998_i0	PRJNA734348	129696	242	0.911243	2.20520806	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	180	9.58e-41	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g128998	i0	92.742	57.6115702479339	124	9	53	0	84	207	3722350	3722473	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	13942	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19844620	19844620	PRJNA734348_P_NODE_17076_length_504_cov_2.626450_g16387_i0	PRJNA734348	17076	504	2.62645	13.237308	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	494	6.809999999999998e-135	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g16387	i0	84.449	316.708333333333	508	72	100	7	1	504	173317	172813	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	159621	494	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19844751	19844751	PRJNA734348_P_NODE_2236_length_1831_cov_4.654721_g2009_i0	PRJNA734348	2236	1831	4.654721	85.22794151	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1831	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g2009	i0	85.054	123.697979246313	1840	227	99	47	1	1818	3044138	3042325	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	226491	1831	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
23670320	23670320	PRJNA734348_P_NODE_130539_length_241_cov_2.672619_g129841_i0	PRJNA734348	130539	241	2.672619	6.44101179	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	185	2.0499999999999998e-42	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g129841	i0	86.747	0.688796680497925	166	22	69	0	3	168	1910499	1910664	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	166	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23670508	23670508	PRJNA734348_P_NODE_141339_length_230_cov_2.936306_g140641_i0	PRJNA734348	141339	230	2.936306	6.7535038	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	292	1.11e-74	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g140641	i0	90.625	24.104347826087	224	15	96	6	10	230	1904745	1904525	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	5544	292	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24945102	24945102	PRJNA734348_P_NODE_6460_length_1013_cov_2.502128_g5953_i0	PRJNA734348	6460	1013	2.502128	25.34655664	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1273	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g5953	i0	89.362	112.439289239882	1034	80	100	16	1	1013	3486148	3485124	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	113901	1273	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales 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);;