metadata: contig_metadata: 19 rows where bioproject = "PRJNA493244", tax_clade = "FCB group" and tax

19 rows where bioproject = "PRJNA493244", tax_clade = "FCB group" 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
4283123	4283123	PRJNA493244_P_NODE_1608944_length_218_cov_3.133758_g1585819_i0	PRJNA493244	1608944	218	3.133758	6.83159244	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	63.9	8.9e-6	NTclustered	gi\|2108314823\|gb\|CP070670.1\|	2026742	g1585819	i0	90	0.871559633027523	50	4	22	1	169	217	907223	907174	MAG: Gemmatimonadetes bacterium isolate bin741 chromosome	blastn	190	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
5559110	5559110	PRJNA493244_P_NODE_1391725_length_270_cov_4.779904_g1368600_i0	PRJNA493244	1391725	270	4.779904	12.9057408	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	276	1.35e-69	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g1368600	i0	88.066	132.237037037037	243	16	87	10	1	236	173231	172995	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	35704	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8110986	8110986	PRJNA493244_P_NODE_998467_length_407_cov_7.468208_g975382_i0	PRJNA493244	998467	407	7.468208	30.39560656	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	331	4.48e-86	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g975382	i0	82.487	65.3660933660934	394	53	95	14	17	402	3042420	3042805	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	26604	331	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10659140	10659140	PRJNA493244_P_NODE_1331109_length_287_cov_10.057522_g1307985_i0	PRJNA493244	1331109	287	10.057522	28.86508814	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	350	8.400000000000001e-92	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g1307985	i0	90.53	95.7839721254355	264	25	92	0	24	287	3132722	3132459	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	27490	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13208963	13208963	PRJNA493244_P_NODE_1253571_length_311_cov_2.264000_g1230447_i0	PRJNA493244	1253571	311	2.264	7.04104	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	357	5.5e-94	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1230447	i0	87.46	107.389067524116	311	37	99	2	2	311	3649367	3649058	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	33398	357	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15758844	15758844	PRJNA493244_P_NODE_1642393_length_211_cov_4.100000_g1619268_i0	PRJNA493244	1642393	211	4.1	8.651	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	143	1.07e-29	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g1619268	i0	81.818	1.61137440758294	176	26	82	5	3	175	363592	363764	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	340	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15759045	15759045	PRJNA493244_P_NODE_1707073_length_203_cov_0.901408_g1683948_i0	PRJNA493244	1707073	203	0.901408	1.82985824	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	84.2	6.27e-12	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1683948	i0	86.667	0.881773399014778	75	10	37	0	10	84	1880161	1880087	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	179	84.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15760414	15760414	PRJNA493244_P_NODE_908253_length_449_cov_10.353093_g885282_i0	PRJNA493244	908253	449	10.353093	46.48538757	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	387	1.05e-102	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g885282	i0	84.119	4.07349665924276	403	61	90	3	43	444	1090623	1091023	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1829	387	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18951455	18951455	PRJNA493244_P_NODE_1648635_length_210_cov_1.778523_g1625510_i0	PRJNA493244	1648635	210	1.778523	3.7348983	Gemmatimonas	173479	Bacteria	Bacteria	320	4.58e-83	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g1625510	i0	97.34	43.6857142857143	188	5	90	0	23	210	1	188	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	9174	322	0.993788819875776	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
20857178	20857178	PRJNA493244_P_NODE_1393677_length_270_cov_1.545455_g1370552_i0	PRJNA493244	1393677	270	1.545455	4.1727285	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	305	1.72e-78	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g1370552	i0	90.254	61.7222222222222	236	20	87	2	1	235	423501	423734	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	16665	305	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23407314	23407314	PRJNA493244_P_NODE_1172639_length_338_cov_3.592058_g1149515_i0	PRJNA493244	1172639	338	3.592058	12.14115604	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	92.4	3.69e-21	NR	HJR67343.1	2026741	g1149515	i0	62.7	2.01479289940828	75	25	63.9	1	336	121	72	146	HJR67343.1 DUF2214 family protein [Gemmatimonadaceae bacterium]	diamond	681	92.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27282137	27282137	PRJNA493244_P_NODE_1023223_length_397_cov_1.440476_g1000120_i0	PRJNA493244	1023223	397	1.440476	5.71868972	Longimicrobium	1804994	Bacteria	Bacteria	99	4.63e-21	NR	WP_170034484.1	1639882	g1000120	i0	90	0.906801007556675	60	6	45.3	0	196	17	1	60	WP_170034484.1 SusC/RagA family TonB-linked outer membrane protein [Longimicrobium terrae]	diamond	360	100	0.99	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium terrae
27803166	27803166	PRJNA493244_P_NODE_1700144_length_204_cov_0.895105_g1677019_i0	PRJNA493244	1700144	204	0.895105	1.8260142	Longimicrobium sp.	2029185	Bacteria	Bacteria	92	5.55e-20	NR	HLM69020.1	2029185	g1677019	i0	70.3	1.88235294117647	64	16	94.1	1	204	13	126	186	HLM69020.1 asparagine synthase C-terminal domain-containing protein [Longimicrobium sp.]	diamond	384	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29176819	29176819	PRJNA493244_P_NODE_1167329_length_340_cov_2.913978_g1144205_i0	PRJNA493244	1167329	340	2.913978	9.9075252	Pseudomonadati	3379134	Bacteria	Bacteria	144	2.65e-39	NR	MBA2684767.1	2026741	g1144205	i0	60	6.48529411764706	105	42	92.6	0	1	315	150	254	MBA2684767.1 class I SAM-dependent methyltransferase [Gemmatimonadaceae bacterium]	diamond	2205	144	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30139253	30139253	PRJNA493244_P_NODE_1525792_length_237_cov_1.454545_g1502667_i0	PRJNA493244	1525792	237	1.454545	3.44727165	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.00721	NR	HET7599887.1	2448054	g1502667	i0	72.4	0.367088607594937	29	8	36.7	0	151	237	13	41	HET7599887.1 translation initiation factor IF-3 [Gemmatimonadales bacterium]	diamond	87	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30171147	30171147	PRJNA493244_P_NODE_1677352_length_206_cov_2.510345_g1654227_i0	PRJNA493244	1677352	206	2.510345	5.1713107	Longimicrobium sp.	2029185	Bacteria	Bacteria	46.6	1.87e-4	NR	HYR12146.1	2029185	g1654227	i0	53.8	0.567961165048544	39	18	56.8	0	148	32	23	61	HYR12146.1 hypothetical protein [Longimicrobium sp.]	diamond	117	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30550292	30550292	PRJNA493244_P_NODE_1275013_length_304_cov_3.687243_g1251889_i0	PRJNA493244	1275013	304	3.687243	11.20921872	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	74.3	5.93e-13	NR	MDP2957823.1	2910168	g1251889	i0	48.5	0.671052631578947	68	35	67.1	0	6	209	351	418	MDP2957823.1 hypothetical protein [Longimicrobiales bacterium]	diamond	204	74.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31783069	31783069	PRJNA493244_P_NODE_1619837_length_216_cov_1.722581_g1596712_i0	PRJNA493244	1619837	216	1.722581	3.72077496	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	77.4	1.55e-14	NR	HEX8274646.1	3047548	g1596712	i0	68.3	3.45833333333333	63	18	87.5	2	27	215	238	298	HEX8274646.1 asparagine synthase-related protein [Longimicrobiaceae bacterium]	diamond	747	77.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
32731692	32731692	PRJNA493244_P_NODE_1028260_length_394_cov_11.534535_g1005154_i0	PRJNA493244	1028260	394	11.534535	45.4460679	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	198	1.61e-61	NR	HEX5725253.1	3047548	g1005154	i0	77.6	5.70304568527919	125	28	95.2	0	19	393	1	125	HEX5725253.1 NAD(P)H-dependent oxidoreductase subunit E [Longimicrobiaceae bacterium]	diamond	2247	198	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae 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);;