metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA493632" 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
460143	460143	PRJNA493632_P_NODE_233621_length_323_cov_5.124000_g230185_i0	PRJNA493632	233621	323	5.124	16.55052	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	440	5.539999999999997e-119	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g230185	i0	92.834	403.133126934985	307	17	100	4	1	305	1902828	1903131	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	130212	440	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
468552	468552	PRJNA493632_P_NODE_708281_length_222_cov_4.805369_g704840_i0	PRJNA493632	708281	222	4.805369	10.66791918	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	207	3.97e-49	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g704840	i0	85.714	3.32882882882883	196	28	88	0	27	222	1062151	1061956	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	739	207	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1741989	1741989	PRJNA493632_P_NODE_622862_length_243_cov_1.358824_g619421_i0	PRJNA493632	622862	243	1.358824	3.30194232	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	84.2	7.77e-12	NTclustered	gi\|2107953857\|gb\|CP070792.1\|	2026742	g619421	i0	79.365	20.1440329218107	126	21	50	5	82	202	1947123	1947248	MAG: Gemmatimonadetes bacterium isolate bin1440 chromosome	blastn	4895	84.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
4291917	4291917	PRJNA493632_P_NODE_496204_length_252_cov_10.223464_g492765_i0	PRJNA493632	496204	252	10.223464	25.76312928	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	213	9.91e-51	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g492765	i0	82.787	6.44047619047619	244	36	96	6	1	241	2472727	2472967	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	1623	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
4295005	4295005	PRJNA493632_P_NODE_682284_length_234_cov_2.086957_g678843_i0	PRJNA493632	682284	234	2.086957	4.88347938	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	250	6.92e-62	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g678843	i0	86.017	2.01709401709402	236	30	100	3	1	234	1786603	1786837	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	472	250	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
4295445	4295445	PRJNA493632_P_NODE_707264_length_223_cov_5.166667_g703823_i0	PRJNA493632	707264	223	5.166667	11.52166741	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	217	6.629999999999999e-52	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g703823	i0	86.979	0.860986547085202	192	25	86	0	32	223	3335552	3335743	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	192	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5569405	5569405	PRJNA493632_P_NODE_546605_length_248_cov_2.405714_g543166_i0	PRJNA493632	546605	248	2.405714	5.96617072	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g543166	i0	87.866	23.4677419354839	239	29	96	0	6	244	3526479	3526241	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	5820	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6838843	6838843	PRJNA493632_P_NODE_292626_length_298_cov_2.840000_g289189_i0	PRJNA493632	292626	298	2.84	8.4632	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	464	2.9999999999999995e-126	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g289189	i0	97.426	178.651006711409	272	7	91	0	27	298	2075279	2075550	Gemmatimonas phototrophica strain AP64, complete genome	blastn	53238	464	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
6844655	6844655	PRJNA493632_P_NODE_618926_length_243_cov_3.482353_g615485_i0	PRJNA493632	618926	243	3.482353	8.46211779	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	167	7.5e-37	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g615485	i0	79.098	1.88477366255144	244	49	100	2	1	243	3248239	3248481	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	458	167	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6846242	6846242	PRJNA493632_P_NODE_712826_length_217_cov_7.118056_g709384_i0	PRJNA493632	712826	217	7.118056	15.44618152	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	89.8	1.46e-13	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g709384	i0	80.992	0.967741935483871	121	15	54	8	91	207	448294	448410	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	210	89.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8118027	8118027	PRJNA493632_P_NODE_497187_length_252_cov_3.173184_g493748_i0	PRJNA493632	497187	252	3.173184	7.99642368	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	243	1.2600000000000001e-59	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g493748	i0	85.169	3.08730158730159	236	35	94	0	17	252	8003352	8003117	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	778	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9396675	9396675	PRJNA493632_P_NODE_709648_length_220_cov_11.170068_g706206_i0	PRJNA493632	709648	220	11.170068	24.5741496	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	279	8.210000000000001e-71	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g706206	i0	89.593	26.8272727272727	221	21	100	2	1	220	803220	803439	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	5902	279	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9396993	9396993	PRJNA493632_P_NODE_728148_length_202_cov_12.984496_g724705_i0	PRJNA493632	728148	202	12.984496	26.22868192	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	272	1.24e-68	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g724705	i0	93.011	121.19801980198	186	13	92	0	3	188	802392	802577	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	24482	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10669284	10669284	PRJNA493632_P_NODE_530529_length_249_cov_4.772727_g527090_i0	PRJNA493632	530529	249	4.772727	11.88409023	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g527090	i0	85.714	49.425702811245	217	27	86	4	1	215	5629834	5630048	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	12307	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10672420	10672420	PRJNA493632_P_NODE_716929_length_213_cov_7.507143_g713487_i0	PRJNA493632	716929	213	7.507143	15.99021459	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	132	2.34e-26	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g713487	i0	78.537	3.50704225352113	205	40	95	4	3	205	596416	596618	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	747	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
10672643	10672643	PRJNA493632_P_NODE_730029_length_201_cov_4.218750_g726586_i0	PRJNA493632	730029	201	4.21875	8.4796875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	272	1.2299999999999998e-68	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g726586	i0	91.089	1.00497512437811	202	16	100	2	1	201	3894565	3894365	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	202	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15763002	15763002	PRJNA493632_P_NODE_249653_length_314_cov_7.609959_g246217_i0	PRJNA493632	249653	314	7.609959	23.89527126	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	453	6.89e-123	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g246217	i0	92.698	440.550955414013	315	21	100	2	1	314	801799	802112	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	138333	453	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15771436	15771436	PRJNA493632_P_NODE_721673_length_208_cov_52.851852_g718231_i0	PRJNA493632	721673	208	52.851852	109.93185216	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	281	2.13e-71	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g718231	i0	91.262	225.514423076923	206	18	99	0	1	206	1594330	1594125	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	46907	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16403788	16403788	PRJNA493632_P_NODE_227153_length_327_cov_2.822835_g223717_i0	PRJNA493632	227153	327	2.822835	9.23067045	Gemmatimonas	173479	Bacteria	Bacteria	553	6.909999999999998e-153	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g223717	i0	97.239	539.247706422018	326	9	99	0	2	327	1158	833	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	176334	553	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
18320369	18320369	PRJNA493632_P_NODE_719715_length_210_cov_10.824818_g716273_i0	PRJNA493632	719715	210	10.824818	22.7321178	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	135	1.78e-27	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g716273	i0	80.214	5.3952380952381	187	32	87	4	28	210	3327222	3327037	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	1133	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19593984	19593984	PRJNA493632_P_NODE_681256_length_234_cov_2.782609_g677815_i0	PRJNA493632	681256	234	2.782609	6.51130506	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	283	6.829999999999999e-72	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g677815	i0	88.511	7.38034188034188	235	25	100	2	1	234	5440517	5440284	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1727	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20862334	20862334	PRJNA493632_P_NODE_263117_length_310_cov_3.164557_g259681_i0	PRJNA493632	263117	310	3.164557	9.8101267	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	159	1.66e-34	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g259681	i0	86.301	6.86129032258065	146	20	47	0	161	306	6062994	6063139	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2127	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20870348	20870348	PRJNA493632_P_NODE_711957_length_218_cov_5.813793_g708515_i0	PRJNA493632	711957	218	5.813793	12.67406874	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	228	2.979999999999999e-55	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g708515	i0	87.065	1.43577981651376	201	26	92	0	2	202	2971196	2971396	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	313	228	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20870589	20870589	PRJNA493632_P_NODE_725697_length_205_cov_4.356061_g722254_i0	PRJNA493632	725697	205	4.356061	8.92992505	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	185	1.69e-42	NTclustered	gi\|2518596698\|emb\|OX639991.1\|	2910168	g722254	i0	83.333	11.5121951219512	204	30	99	4	1	202	2836587	2836386	MAG: Longimicrobiales bacterium isolate affa3490-31b4-448a-b7fc-cc7950b7f85b genome assembly, chromosome: 1	blastn	2360	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
21502861	21502861	PRJNA493632_P_NODE_189157_length_352_cov_9.376344_g185726_i0	PRJNA493632	189157	352	9.376344	33.00473088	Gemmatimonas	173479	Bacteria	Bacteria	544	4.4999999999999997e-150	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g185726	i0	94.587	15.5170454545455	351	19	99	0	1	351	1153	1503	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	5462	544	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
23410876	23410876	PRJNA493632_P_NODE_140219_length_396_cov_6.207430_g136798_i0	PRJNA493632	140219	396	6.20743	24.5814228	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	604	2.319999999999999e-168	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g136798	i0	94.192	127.570707070707	396	23	100	0	1	396	172171	172566	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	50518	604	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23412966	23412966	PRJNA493632_P_NODE_261799_length_310_cov_3.540084_g258363_i0	PRJNA493632	261799	310	3.540084	10.9742604	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	220	7.499999999999998e-53	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g258363	i0	95	90.1806451612903	140	7	94	0	171	310	1903733	1903594	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	27956	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24055675	24055675	PRJNA493632_P_NODE_6419_length_1400_cov_12.815373_g5051_i0	PRJNA493632	6419	1400	12.815373	179.415222	Gemmatimonas	173479	Bacteria	Bacteria	1559	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g5051	i0	87.365	226.405	1393	134	98	31	1	1377	2076641	2075275	Gemmatimonas phototrophica strain AP64, complete genome	blastn	316967	1574	0.990470139771283	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
24695325	24695325	PRJNA493632_P_NODE_94800_length_464_cov_5.058824_g91411_i0	PRJNA493632	94800	464	5.058824	23.47294336	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	425	2.3e-114	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g91411	i0	83.652	27.6594827586207	471	58	99	15	3	464	231284	231744	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	12834	425	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae 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);;