metadata: contig_metadata: 28 rows where bioproject = "PRJNA1180292", tax_clade = "FCB group" and tax

28 rows where bioproject = "PRJNA1180292", 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
1592564	1592564	PRJNA1180292_P_NODE_6302_length_280_cov_1.130435_g6170_i0	PRJNA1180292	6302	280	1.130435	3.165218	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	390	4.809999999999999e-104	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g6170	i0	91.844	229.564285714286	282	20	100	3	1	280	173394	173114	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	64278	390	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4144724	4144724	PRJNA1180292_P_NODE_10224_length_248_cov_0.891429_g10092_i0	PRJNA1180292	10224	248	0.891429	2.21074392	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	113	1.01e-20	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g10092	i0	84.483	0.467741935483871	116	16	46	2	36	150	2557201	2557087	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	116	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5420926	5420926	PRJNA1180292_P_NODE_11745_length_245_cov_0.906977_g11613_i0	PRJNA1180292	11745	245	0.906977	2.22209365	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	265	2.61e-66	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g11613	i0	87.946	43.5918367346939	224	27	91	0	4	227	1058936	1058713	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	10680	265	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5420965	5420965	PRJNA1180292_P_NODE_4405_length_330_cov_1.206226_g4273_i0	PRJNA1180292	4405	330	1.206226	3.9805458	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	449	9.43e-122	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g4273	i0	91.541	144.248484848485	331	21	99	5	1	329	8176137	8175812	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	47602	449	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6695717	6695717	PRJNA1180292_P_NODE_12946_length_242_cov_0.923077_g12814_i0	PRJNA1180292	12946	242	0.923077	2.23384634	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g12814	i0	89.919	135.669421487603	248	13	100	7	1	242	5916994	5916753	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	32832	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11244536	11244536	PRJNA1180292_P_NODE_11929_length_244_cov_0.912281_g11797_i0	PRJNA1180292	11929	244	0.912281	2.22596564	Gemmatimonadaceae	219687	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g11797	i0	94.76	431.954918032787	229	7	93	5	1	226	672	898	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	105397	353	0.994334277620397	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
14346882	14346882	PRJNA1180292_P_NODE_12972_length_242_cov_0.923077_g12840_i0	PRJNA1180292	12972	242	0.923077	2.23384634	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	153	6.579999999999999e-46	NR	HRZ09802.1	2448054	g12840	i0	97.5	0.991735537190083	80	2	99.2	0	2	241	33	112	HRZ09802.1 ATP-binding cassette domain-containing protein [Gemmatimonadales bacterium]	diamond	240	153	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
18169561	18169561	PRJNA1180292_P_NODE_9455_length_250_cov_0.881356_g9323_i0	PRJNA1180292	9455	250	0.881356	2.20339	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	160	1.72e-44	NR	MBM3907024.1	2026742	g9323	i0	94	2.988	83	5	99.6	0	1	249	82	164	MBM3907024.1 L-serine ammonia-lyase, iron-sulfur-dependent, subunit alpha [Gemmatimonadota bacterium]	diamond	747	160	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
19443916	19443916	PRJNA1180292_P_NODE_8116_length_253_cov_0.866667_g7984_i0	PRJNA1180292	8116	253	0.866667	2.19266751	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	228	3.549999999999999e-55	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g7984	i0	84.1	51.9209486166008	239	34	94	4	1	237	187899	188135	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	13136	228	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20719270	20719270	PRJNA1180292_P_NODE_8377_length_252_cov_0.871508_g8245_i0	PRJNA1180292	8377	252	0.871508	2.19620016	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	149	6.21e-40	NR	HEY3286728.1	2026741	g8245	i0	82.9	4.89285714285714	82	14	97.6	0	251	6	114	195	HEY3286728.1 glutamine-hydrolyzing GMP synthase [Gemmatimonadaceae bacterium]	diamond	1233	149	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
20719277	20719277	PRJNA1180292_P_NODE_8977_length_251_cov_0.876404_g8845_i0	PRJNA1180292	8977	251	0.876404	2.19977404	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	246	9.72e-61	NTclustered	gi\|2557482281\|gb\|CP130612.1\|	3062599	g8845	i0	84.836	3.07569721115538	244	37	97	0	8	251	2517013	2516770	Pseudogemmatithrix spongiicola strain 138 chromosome, complete genome	blastn	772	246	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
27028111	27028111	PRJNA1180292_P_NODE_11262_length_246_cov_0.901734_g11130_i0	PRJNA1180292	11262	246	0.901734	2.21826564	Bacteria	2	Bacteria	Bacteria	134	1.4599999999999998e-35	NR	HVF40851.1	2026741	g11130	i0	76.8	3.97560975609756	82	19	100	0	246	1	96	177	HVF40851.1 glycosyltransferase [Gemmatimonadaceae bacterium]	diamond	978	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27230204	27230204	PRJNA1180292_P_NODE_8823_length_251_cov_0.876404_g8691_i0	PRJNA1180292	8823	251	0.876404	2.19977404	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	101	1.09e-22	NR	HEY7685027.1	2448054	g8691	i0	69.9	0.99203187250996006	83	25	99.2	0	2	250	1577	1659	HEY7685027.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	249	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27483015	27483015	PRJNA1180292_P_NODE_11023_length_246_cov_0.901734_g10891_i0	PRJNA1180292	11023	246	0.901734	2.21826564	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	159	8.929999999999999e-47	NR	TFG45894.1	2448054	g10891	i0	97.6	1	82	2	100	0	246	1	126	207	TFG45894.1 MAG: ABC transporter ATP-binding protein [Gemmatimonadales bacterium]	diamond	246	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27546193	27546193	PRJNA1180292_P_NODE_9964_length_249_cov_0.886364_g9832_i0	PRJNA1180292	9964	249	0.886364	2.20704636	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	110	6.51e-29	NR	MDH4349161.1	2026742	g9832	i0	86.9	0.734939759036145	61	8	73.5	0	66	248	20	80	MDH4349161.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	183	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28133766	28133766	PRJNA1180292_P_NODE_8805_length_251_cov_0.876404_g8673_i0	PRJNA1180292	8805	251	0.876404	2.19977404	Bacteria	2	Bacteria	Bacteria	102	7.72e-24	NR	HEX6967160.1	2026741	g8673	i0	62.2	2.9402390438247	82	31	98	0	4	249	130	211	HEX6967160.1 glycosyltransferase [Gemmatimonadaceae bacterium]	diamond	738	103	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28418006	28418006	PRJNA1180292_P_NODE_10806_length_247_cov_0.896552_g10674_i0	PRJNA1180292	10806	247	0.896552	2.21448344	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	1.92e-7	NR	HEU5217239.1	2448054	g10674	i0	40.3	2.25910931174089	62	37	75.3	0	195	10	35	96	HEU5217239.1 DUF1772 domain-containing protein [Gemmatimonadales bacterium]	diamond	558	55.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28651282	28651282	PRJNA1180292_P_NODE_10747_length_247_cov_0.896552_g10615_i0	PRJNA1180292	10747	247	0.896552	2.21448344	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	61.6	8.79e-9	NR	HYN80394.1	2026741	g10615	i0	53.6	2.91497975708502	56	26	68	0	80	247	240	295	HYN80394.1 IS4 family transposase [Gemmatimonadaceae bacterium]	diamond	720	61.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29503610	29503610	PRJNA1180292_P_NODE_10490_length_247_cov_0.896552_g10358_i0	PRJNA1180292	10490	247	0.896552	2.21448344	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	130	3.36e-33	NR	HSG08075.1	2910168	g10358	i0	84.1	0.995951417004049	82	13	99.6	0	2	247	456	537	HSG08075.1 hypothetical protein [Longimicrobiales bacterium]	diamond	246	130	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
29617259	29617259	PRJNA1180292_P_NODE_12350_length_243_cov_0.917647_g12218_i0	PRJNA1180292	12350	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	93.2	5.23e-20	NR	HEY3286054.1	2026741	g12218	i0	66.2	3.19753086419753	65	22	80.2	0	242	48	408	472	HEY3286054.1 nitronate monooxygenase [Gemmatimonadaceae bacterium]	diamond	777	93.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29692852	29692852	PRJNA1180292_P_NODE_12190_length_244_cov_0.912281_g12058_i0	PRJNA1180292	12190	244	0.912281	2.22596564	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	162	3.22e-44	NR	MBK8250428.1	2026742	g12058	i0	91.3	1.9672131147541	80	7	98.4	0	3	242	266	345	MBK8250428.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonadota bacterium]	diamond	480	162	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30420108	30420108	PRJNA1180292_P_NODE_9093_length_251_cov_0.870787_g8961_i0	PRJNA1180292	9093	251	0.870787	2.18567537	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	154	2.21e-42	NR	HEX9166684.1	2448054	g8961	i0	89	0.9800796812749	82	9	98	0	246	1	434	515	HEX9166684.1 chemotaxis protein CheA [Gemmatimonadales bacterium]	diamond	246	154	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31209172	31209172	PRJNA1180292_P_NODE_12575_length_243_cov_0.917647_g12443_i0	PRJNA1180292	12575	243	0.917647	2.22988221	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	122	4.6799999999999996e-34	NR	HEX9166637.1	2448054	g12443	i0	70	0.987654320987654	80	24	98.8	0	243	4	18	97	HEX9166637.1 four helix bundle protein [Gemmatimonadales bacterium]	diamond	240	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31715724	31715724	PRJNA1180292_P_NODE_12657_length_243_cov_0.917647_g12525_i0	PRJNA1180292	12657	243	0.917647	2.22988221	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	112	4.270000000000001e-27	NR	MDH4352033.1	2026742	g12525	i0	74.3	0.91358024691358	74	19	91.4	0	232	11	162	235	MDH4352033.1 lysophospholipid acyltransferase family protein [Gemmatimonadota bacterium]	diamond	222	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32253885	32253885	PRJNA1180292_P_NODE_8418_length_252_cov_0.871508_g8286_i0	PRJNA1180292	8418	252	0.871508	2.19620016	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	124	8.94e-32	NR	HEU4700592.1	2448054	g8286	i0	73.8	1	84	22	100	0	1	252	215	298	HEU4700592.1 amidase [Gemmatimonadales bacterium]	diamond	252	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32506934	32506934	PRJNA1180292_P_NODE_2019_length_479_cov_7.209360_g1887_i0	PRJNA1180292	2019	479	7.20936	34.5328344	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	115	1.54e-28	NR	HEX8718619.1	2026741	g1887	i0	39.3	1.89770354906054	150	83	88.9	1	37	462	82	231	HEX8718619.1 Hsp20/alpha crystallin family protein [Gemmatimonadaceae bacterium]	diamond	909	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32758873	32758873	PRJNA1180292_P_NODE_10500_length_247_cov_0.896552_g10368_i0	PRJNA1180292	10500	247	0.896552	2.21448344	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	162	4.799999999999998e-44	NR	MDX2261316.1	2448054	g10368	i0	100	0.995951417004049	82	0	99.6	0	1	246	650	731	MDX2261316.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Gemmatimonadales bacterium]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32853257	32853257	PRJNA1180292_P_NODE_11260_length_246_cov_0.901734_g11128_i0	PRJNA1180292	11260	246	0.901734	2.21826564	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	107	9.19e-25	NR	MBK8004611.1	2026742	g11128	i0	66.7	0.98780487804878	81	27	98.8	0	245	3	673	753	MBK8004611.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	243	107	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;