metadata: contig_metadata: 25 rows where bioproject = "PRJNA1122875" and tax

25 rows where bioproject = "PRJNA1122875" 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
277827	277827	PRJNA1122875_P_NODE_44661_length_250_cov_0.870056_g44437_i0	PRJNA1122875	44661	250	0.870056	2.17514	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	102	3.89e-23	NR	HET9039722.1	2448054	g44437	i0	83.8	1.632	68	11	81.6	0	206	3	1	68	HET9039722.1 potassium/proton antiporter [Gemmatimonadales bacterium]	diamond	408	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
13031461	13031461	PRJNA1122875_P_NODE_45711_length_249_cov_0.875000_g45487_i0	PRJNA1122875	45711	249	0.875	2.17875	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g45487	i0	91.968	1.81927710843373	249	20	100	0	1	249	4297796	4298044	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	453	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14306626	14306626	PRJNA1122875_P_NODE_41592_length_256_cov_1.426230_g41368_i0	PRJNA1122875	41592	256	1.42623	3.6511488	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	58.4	5e-4	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g41368	i0	91.111	0.17578125	45	0	17	4	48	91	2210618	2210577	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	45	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18129525	18129525	PRJNA1122875_P_NODE_43575_length_251_cov_0.865169_g43351_i0	PRJNA1122875	43575	251	0.865169	2.17157419	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	259	1.25e-64	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g43351	i0	85.259	1.9601593625498	251	37	100	0	1	251	7350528	7350278	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	492	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26658415	26658415	PRJNA1122875_P_NODE_47001_length_247_cov_1.798851_g46777_i0	PRJNA1122875	47001	247	1.798851	4.44316197	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	73.2	1.26e-13	NR	MEE8061390.1	2448054	g46777	i0	62.3	3.36437246963563	53	20	64.4	0	87	245	2	54	MEE8061390.1 aquaporin [Gemmatimonadales bacterium]	diamond	831	73.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26690293	26690293	PRJNA1122875_P_NODE_43101_length_251_cov_0.865169_g42877_i0	PRJNA1122875	43101	251	0.865169	2.17157419	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	98.2	1.28e-21	NR	HUF66556.1	2026741	g42877	i0	57.8	1.9840637450199201	83	35	99.2	0	250	2	22	104	HUF66556.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonadaceae bacterium]	diamond	498	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28301843	28301843	PRJNA1122875_P_NODE_43146_length_251_cov_0.865169_g42922_i0	PRJNA1122875	43146	251	0.865169	2.17157419	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	134	1.69e-38	NR	MEX2283210.1	2026742	g42922	i0	80.7	0.99203187250996006	83	16	99.2	0	251	3	9	91	MEX2283210.1 30S ribosome-binding factor RbfA [Gemmatimonadota bacterium]	diamond	249	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28480559	28480559	PRJNA1122875_P_NODE_1066_length_1184_cov_3.408641_g974_i0	PRJNA1122875	1066	1184	3.408641	40.35830944	Bacteria	2	Bacteria	Bacteria	101	3.5000000000000005e-22	NR	MCY4352252.1	2026742	g974	i0	49.5	2.11570945945946	93	45	23.6	1	727	449	4	94	MCY4352252.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium]	diamond	2505	102	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28523002	28523002	PRJNA1122875_P_NODE_29347_length_302_cov_2.947598_g29123_i0	PRJNA1122875	29347	302	2.947598	8.90174596	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	54.7	3.66e-6	NR	HEU5050793.1	2448054	g29123	i0	40.9	0.874172185430464	88	47	84.4	3	39	293	13	98	HEU5050793.1 PDZ domain-containing protein [Gemmatimonadales bacterium]	diamond	264	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29217715	29217715	PRJNA1122875_P_NODE_34589_length_281_cov_1.548077_g34365_i0	PRJNA1122875	34589	281	1.548077	4.35009637	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	67	1.64e-10	NR	HZO20834.1	2026741	g34365	i0	63.4	3.55516014234875	41	15	43.8	0	277	155	415	455	HZO20834.1 aspartate aminotransferase family protein [Gemmatimonadaceae bacterium]	diamond	999	67	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30923453	30923453	PRJNA1122875_P_NODE_38654_length_267_cov_1.335052_g38430_i0	PRJNA1122875	38654	267	1.335052	3.56458884	Gemmatimonas sp.	1962908	Bacteria	Bacteria	116	3.05e-29	NR	MBA3853270.1	1962908	g38430	i0	62.5	0.98876404494382	88	33	98.9	0	264	1	116	203	MBA3853270.1 hypothetical protein [Gemmatimonas sp.]	diamond	264	116	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
30955024	30955024	PRJNA1122875_P_NODE_24714_length_334_cov_1.318008_g24490_i0	PRJNA1122875	24714	334	1.318008	4.40214672	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	52.4	3.47e-5	NR	MBA2669005.1	2026742	g24490	i0	27	0.997005988023952	111	76	97	4	3	326	82	190	MBA2669005.1 fused MFS/spermidine synthase [Gemmatimonadota bacterium]	diamond	333	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31333985	31333985	PRJNA1122875_P_NODE_45836_length_249_cov_0.875000_g45612_i0	PRJNA1122875	45836	249	0.875	2.17875	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	68.9	5.44e-12	NR	HXE60633.1	2026741	g45612	i0	58.6	4.89156626506024	58	20	69.9	1	74	247	5	58	HXE60633.1 aquaporin [Gemmatimonadaceae bacterium]	diamond	1218	68.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31397517	31397517	PRJNA1122875_P_NODE_50556_length_244_cov_0.900585_g50332_i0	PRJNA1122875	50556	244	0.900585	2.1974274	Longimicrobium sp.	2029185	Bacteria	Bacteria	42.4	0.049	NR	HEX8432517.1	2029185	g50332	i0	39.4	0.811475409836066	66	27	81.1	2	43	240	106	158	HEX8432517.1 hypothetical protein [Longimicrobium sp.]	diamond	198	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31428928	31428928	PRJNA1122875_P_NODE_35456_length_278_cov_1.551220_g35232_i0	PRJNA1122875	35456	278	1.55122	4.3123916	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	80.9	1.92e-15	NR	HET9275007.1	2448054	g35232	i0	55.4	0.798561151079137	74	33	79.9	0	227	6	132	205	HET9275007.1 NAD(P)/FAD-dependent oxidoreductase [Gemmatimonadales bacterium]	diamond	222	80.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31460810	31460810	PRJNA1122875_P_NODE_11756_length_485_cov_2.024272_g11534_i0	PRJNA1122875	11756	485	2.024272	9.8177192	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	65.9	4.23e-9	NR	MBT3342109.1	2026742	g11534	i0	52.8	1.08247422680412	53	25	32.8	0	412	254	782	834	MBT3342109.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	525	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31587336	31587336	PRJNA1122875_P_NODE_48316_length_246_cov_0.890173_g48092_i0	PRJNA1122875	48316	246	0.890173	2.18982558	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	127	5.28e-34	NR	MBI4512471.1	2026742	g48092	i0	78.8	0.975609756097561	80	17	97.6	0	245	6	53	132	MBI4512471.1 RimK family alpha-L-glutamate ligase [Gemmatimonadota bacterium]	diamond	240	127	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31618751	31618751	PRJNA1122875_P_NODE_42356_length_253_cov_1.627778_g42132_i0	PRJNA1122875	42356	253	1.627778	4.11827834	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	60.8	1.46e-8	NR	HEY8063064.1	2448054	g42132	i0	84.8	6.93675889328063	33	5	39.1	0	2	100	281	313	HEY8063064.1 cysteine synthase A [Gemmatimonadales bacterium]	diamond	1755	60.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31776902	31776902	PRJNA1122875_P_NODE_877_length_1259_cov_16.463744_g791_i0	PRJNA1122875	877	1259	16.463744	207.27853696	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	118	1.2900000000000002e-27	NR	HEX6050719.1	2026741	g791	i0	35.5	0.509928514694202	214	91	50.5	4	32	667	7	175	HEX6050719.1 Hsp20/alpha crystallin family protein [Gemmatimonadaceae bacterium]	diamond	642	118	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32093273	32093273	PRJNA1122875_P_NODE_46718_length_248_cov_0.880000_g46494_i0	PRJNA1122875	46718	248	0.88	2.1824	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	90.1	8.56e-19	NR	MDX1660188.1	2026742	g46494	i0	58.3	1.45161290322581	60	25	72.6	0	67	246	12	71	MDX1660188.1 PAS domain S-box protein [Gemmatimonadota bacterium]	diamond	360	90.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32093275	32093275	PRJNA1122875_P_NODE_47418_length_247_cov_0.885057_g47194_i0	PRJNA1122875	47418	247	0.885057	2.18609079	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	70.1	8.86e-12	NR	MEO8032601.1	2026742	g47194	i0	53.3	5.11336032388664	60	24	72.9	1	246	67	401	456	MEO8032601.1 M28 family metallopeptidase [Gemmatimonadota bacterium]	diamond	1263	70.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32125092	32125092	PRJNA1122875_P_NODE_15258_length_427_cov_2.477401_g15034_i0	PRJNA1122875	15258	427	2.477401	10.57850227	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	98.2	1.1200000000000002e-21	NR	HUF69364.1	2910168	g15034	i0	53.5	1.88992974238876	86	39	59.7	1	420	166	190	275	HUF69364.1 D-amino acid aminotransferase [Longimicrobiales bacterium]	diamond	807	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32125141	32125141	PRJNA1122875_P_NODE_52838_length_242_cov_0.911243_g52614_i0	PRJNA1122875	52838	242	0.911243	2.20520806	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	134	1.68e-34	NR	HSA54891.1	2026741	g52614	i0	88.6	0.979338842975207	79	9	97.9	0	4	240	313	391	HSA54891.1 ATP-binding protein [Gemmatimonadaceae bacterium]	diamond	237	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32219906	32219906	PRJNA1122875_P_NODE_24578_length_335_cov_1.530534_g24354_i0	PRJNA1122875	24578	335	1.530534	5.1272889	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	73.2	5.65e-13	NR	HEX5724175.1	3047548	g24354	i0	41	0.895522388059702	100	53	84.2	2	283	2	66	165	HEX5724175.1 hypothetical protein [Longimicrobiaceae bacterium]	diamond	300	73.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
32725355	32725355	PRJNA1122875_P_NODE_2540_length_896_cov_2.523694_g2381_i0	PRJNA1122875	2540	896	2.523694	22.61229824	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57	6.97e-6	NR	MDH3291704.1	2026742	g2381	i0	34.2	1.16183035714286	114	66	38.2	2	514	173	54	158	MDH3291704.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium]	diamond	1041	57	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);;