metadata: contig_metadata: 22 rows where bioproject = "PRJNA577226" and tax

22 rows where bioproject = "PRJNA577226" 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
1137744	1137744	PRJNA577226_S_NODE_7161_length_505_cov_9.848291_g6233_i0	PRJNA577226	7161	505	9.848291	49.73386955	Gemmatimonas	173479	Bacteria	Bacteria	521	3.1299999999999992e-143	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g6233	i0	85.63	74.3049504950495	508	60	99	13	1	503	49	548	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	37524	521	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
4388582	4388582	PRJNA577226_S_NODE_11164_length_390_cov_4.538244_g10227_i0	PRJNA577226	11164	390	4.538244	17.6991516	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	398	4.1599999999999977e-106	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g10227	i0	85.279	70.6358974358974	394	49	100	7	1	390	233019	232631	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	27548	398	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
8215908	8215908	PRJNA577226_S_NODE_8527_length_458_cov_5.762470_g7593_i0	PRJNA577226	8527	458	5.76247	26.3921126	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	808	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g7593	i0	98.478	132.397379912664	460	3	100	4	1	458	1102892	1102435	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	60638	808	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
14589928	14589928	PRJNA577226_S_NODE_11772_length_379_cov_11.213450_g10834_i0	PRJNA577226	11772	379	11.21345	42.4989755	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	468	3.03e-127	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g10834	i0	89.062	207.828496042216	384	32	100	8	1	379	3043151	3042773	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	78767	468	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14591153	14591153	PRJNA577226_S_NODE_5632_length_586_cov_16.697632_g4719_i0	PRJNA577226	5632	586	16.697632	97.84812352	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	612	2.1199999999999993e-170	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g4719	i0	88.645	123.682593856655	502	57	86	0	1	502	1103803	1104304	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	72478	612	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
15864029	15864029	PRJNA577226_S_NODE_19393_length_289_cov_1.682540_g18454_i0	PRJNA577226	19393	289	1.68254	4.8625406	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	422	1.77e-113	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g18454	i0	95.131	101.76124567474	267	13	92	0	23	289	804096	803830	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	29409	422	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16440181	16440181	PRJNA577226_S_NODE_5013_length_629_cov_28.079392_g4115_i0	PRJNA577226	5013	629	28.079392	176.61937568	Pseudogemmatithrix	3237678	Bacteria	Bacteria	887	0	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g4115	i0	92.222	164.06200317965	630	43	99	5	3	628	231858	232485	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	103195	887	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
17139810	17139810	PRJNA577226_S_NODE_5014_length_629_cov_26.440878_g4116_i0	PRJNA577226	5014	629	26.440878	166.31312262	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	917	0	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g4116	i0	93.038	278.090620031797	632	36	99	7	1	628	342546	343173	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	174919	917	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17139868	17139868	PRJNA577226_S_NODE_5254_length_611_cov_33.341463_g4353_i0	PRJNA577226	5254	611	33.341463	203.71633893	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	699	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g4353	i0	87.56	201.474631751227	627	49	100	20	1	611	1103451	1102838	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	123101	699	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
17139992	17139992	PRJNA577226_S_NODE_5674_length_583_cov_24.785714_g4760_i0	PRJNA577226	5674	583	24.785714	144.50071262	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	665	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g4760	i0	87.585	213.442538593482	588	55	100	13	1	583	1102877	1103451	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	124437	665	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
18414165	18414165	PRJNA577226_S_NODE_52035_length_173_cov_1.705882_g51096_i0	PRJNA577226	52035	173	1.705882	2.95117586	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	244	2.23e-60	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g51096	i0	93.827	147.086705202312	162	10	94	0	12	173	1605002	1605163	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	25446	244	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18989095	18989095	PRJNA577226_S_NODE_71095_length_151_cov_1.026316_g70156_i0	PRJNA577226	71095	151	1.026316	1.54973716	Pseudomonadati	3379134	Bacteria	Bacteria	91.6	2.61e-14	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g70156	i0	82.692	1.47019867549669	104	16	68	2	11	113	5056786	5056888	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	222	91.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20264022	20264022	PRJNA577226_S_NODE_5196_length_615_cov_16.219723_g4295_i0	PRJNA577226	5196	615	16.219723	99.75129645	Gemmatimonas	173479	Bacteria	Bacteria	597	6.239999999999999e-166	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g4295	i0	88.142	949.414634146341	506	55	82	5	112	615	423607	423105	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	583890	597	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20963718	20963718	PRJNA577226_S_NODE_2737_length_988_cov_25.340694_g1952_i0	PRJNA577226	2737	988	25.340694	250.36605672	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	1116	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g1952	i0	87.226	187.607287449393	1002	101	100	26	1	988	1102463	1103451	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	185356	1116	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
20964973	20964973	PRJNA577226_S_NODE_9457_length_430_cov_31.648855_g8522_i0	PRJNA577226	9457	430	31.648855	136.0900765	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	612	1.5199999999999999e-170	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8522	i0	92.343	130.688372093023	431	31	100	2	1	430	3043742	3043313	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	56196	612	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22238131	22238131	PRJNA577226_S_NODE_10038_length_415_cov_22.597884_g9102_i0	PRJNA577226	10038	415	22.597884	93.7812186	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	608	1.8899999999999995e-169	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g9102	i0	93.112	207.665060240964	421	19	100	9	1	415	231727	232143	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	86181	608	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
22238652	22238652	PRJNA577226_S_NODE_27978_length_236_cov_3.572864_g27039_i0	PRJNA577226	27978	236	3.572864	8.43195904	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	315	2.45e-81	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g27039	i0	91.064	12.5932203389831	235	18	100	3	4	236	1103071	1102838	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	2972	315	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
22239685	22239685	PRJNA577226_S_NODE_6658_length_528_cov_20.189409_g5732_i0	PRJNA577226	6658	528	20.189409	106.60007952	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	597	5.309999999999998e-166	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g5732	i0	87.194	74.3371212121212	531	60	99	8	3	528	1467679	1468206	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	39250	597	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
23515119	23515119	PRJNA577226_S_NODE_7139_length_506_cov_9.731343_g6211_i0	PRJNA577226	7139	506	9.731343	49.24059558	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	640	8.299999999999998e-179	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g6211	i0	89.723	159.636363636364	506	44	99	8	1	504	1468178	1467679	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	80776	640	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
28469383	28469383	PRJNA577226_S_NODE_42066_length_192_cov_1.258065_g41127_i0	PRJNA577226	42066	192	1.258065	2.4154848	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	50.8	6.05e-6	NR	HLQ22961.1	2448054	g41127	i0	51	3.21875	51	25	79.7	0	30	182	24	74	HLQ22961.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Gemmatimonadales bacterium]	diamond	618	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30774861	30774861	PRJNA577226_S_NODE_31434_length_223_cov_1.258065_g30495_i0	PRJNA577226	31434	223	1.258065	2.80548495	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	79	6.03e-17	NR	HXG70346.1	2026741	g30495	i0	74.1	0.726457399103139	54	13	71.3	1	159	1	2	55	HXG70346.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	162	79	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31723053	31723053	PRJNA577226_S_NODE_4477_length_680_cov_2.734059_g3599_i0	PRJNA577226	4477	680	2.734059	18.5916012	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	47	0.0362	NR	MEP6688940.1	2448054	g3599	i0	39.4	0.313235294117647	71	43	31.3	0	71	283	37	107	MEP6688940.1 argininosuccinate synthase domain-containing protein [Gemmatimonadales bacterium]	diamond	213	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			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);;