metadata: contig_metadata: 15 rows where bioproject = "PRJNA743294", tax_clade = "FCB group" and tax

15 rows where bioproject = "PRJNA743294", 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
722093	722093	PRJNA743294_P_NODE_42521_length_262_cov_1.386243_g42065_i0	PRJNA743294	42521	262	1.386243	3.63195666	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g42065	i0	100	0.106870229007634	28	0	11	0	231	258	621305	621332	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
1198337	1198337	PRJNA743294_P_NODE_45821_length_253_cov_14.477778_g45365_i0	PRJNA743294	45821	253	14.477778	36.62877834	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	115	3.95e-30	NR	HEX3868160.1	2026741	g45365	i0	68.8	6.6403162055336	80	25	94.9	0	240	1	1	80	HEX3868160.1 superoxide dismutase [Gemmatimonadaceae bacterium]	diamond	1680	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
16024819	16024819	PRJNA743294_P_NODE_59153_length_229_cov_2.461538_g58697_i0	PRJNA743294	59153	229	2.461538	5.63692202	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	92	1.14e-20	NR	HTO73517.1	2448054	g58697	i0	55.3	0.995633187772926	76	34	99.6	0	229	2	64	139	HTO73517.1 SDR family NAD(P)-dependent oxidoreductase [Gemmatimonadales bacterium]	diamond	228	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26609191	26609191	PRJNA743294_P_NODE_22741_length_343_cov_1.581481_g22285_i0	PRJNA743294	22741	343	1.581481	5.42447983	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	75.5	3.6e-13	NR	HEX3232558.1	2448054	g22285	i0	56.6	0.463556851311953	53	23	46.4	0	273	115	10	62	HEX3232558.1 aspartate aminotransferase family protein [Gemmatimonadales bacterium]	diamond	159	75.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27115616	27115616	PRJNA743294_P_NODE_51202_length_247_cov_2.114943_g50746_i0	PRJNA743294	51202	247	2.114943	5.22390921	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	80.1	2.79e-15	NR	HZI99703.1	2026741	g50746	i0	46.4	2.05263157894737	84	42	98.4	2	246	4	472	555	HZI99703.1 response regulator [Gemmatimonadaceae bacterium]	diamond	507	80.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28231025	28231025	PRJNA743294_P_NODE_7306_length_578_cov_5.063366_g6854_i0	PRJNA743294	7306	578	5.063366	29.26625548	Bacteria	2	Bacteria	Bacteria	115	7.99e-26	NR	MEA2763824.1	2026741	g6854	i0	57	9.29584775086505	93	38	48.3	1	4	282	611	701	MEA2763824.1 beta-glucosidase [Gemmatimonadaceae bacterium]	diamond	5373	116	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28505320	28505320	PRJNA743294_P_NODE_27687_length_315_cov_0.966942_g27231_i0	PRJNA743294	27687	315	0.966942	3.0458673	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52	4.75e-5	NR	TFG52714.1	2448054	g27231	i0	44.8	0.552380952380952	58	32	55.2	0	179	6	465	522	TFG52714.1 MAG: hypothetical protein E4H37_05180 [Gemmatimonadales bacterium]	diamond	174	52	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28884150	28884150	PRJNA743294_P_NODE_17288_length_388_cov_0.939683_g16832_i0	PRJNA743294	17288	388	0.939683	3.64597004	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.5	0.0402	NR	MDP1858387.1	2026741	g16832	i0	41.2	0.525773195876289	68	38	52.6	1	48	251	2	67	MDP1858387.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	204	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29262956	29262956	PRJNA743294_P_NODE_48949_length_250_cov_0.881356_g48493_i0	PRJNA743294	48949	250	0.881356	2.20339	Candidatus Palauibacterales bacterium	2994973	Bacteria	Bacteria	45.8	0.00316	NR	MDP2469681.1	2994973	g48493	i0	32.5	0.96	80	50	96	1	249	10	43	118	MDP2469681.1 hypothetical protein [Candidatus Palauibacterales bacterium]	diamond	240	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Candidatus Palauibacterales			Candidatus Palauibacterales bacterium
30147128	30147128	PRJNA743294_P_NODE_48272_length_251_cov_0.876404_g47816_i0	PRJNA743294	48272	251	0.876404	2.19977404	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	52.4	1.28e-5	NR	MBL0171369.1	2026741	g47816	i0	44.1	0.812749003984064	68	38	81.3	0	207	4	99	166	MBL0171369.1 4'-phosphopantetheinyl transferase superfamily protein [Gemmatimonadaceae bacterium]	diamond	204	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30210367	30210367	PRJNA743294_P_NODE_39292_length_271_cov_1.212121_g38836_i0	PRJNA743294	39292	271	1.212121	3.28484791	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	44.3	0.0107	NR	MCJ7629911.1	2910168	g38836	i0	50	0.44280442804428	40	20	44.3	0	1	120	14	53	MCJ7629911.1 tetratricopeptide repeat protein [Longimicrobiales bacterium]	diamond	120	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30842602	30842602	PRJNA743294_P_NODE_44574_length_257_cov_1.119565_g44118_i0	PRJNA743294	44574	257	1.119565	2.87728205	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	57.8	2.1e-7	NR	HEX5724514.1	3047548	g44118	i0	42.9	0.817120622568093	70	37	78.2	2	247	47	180	249	HEX5724514.1 serine/threonine-protein kinase [Longimicrobiaceae bacterium]	diamond	210	57.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
30947537	30947537	PRJNA743294_P_NODE_24154_length_334_cov_2.363985_g23698_i0	PRJNA743294	24154	334	2.363985	7.8957099	Bacteria	2	Bacteria	Bacteria	138	2.87e-36	NR	ODS99984.1	1660163	g23698	i0	47.7	4.98502994011976	111	58	99.7	0	2	334	80	190	ODS99984.1 MAG: amine oxidase [Gemmatimonadetes bacterium SCN 70-22]	diamond	1665	138	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium SCN 70-22
31706161	31706161	PRJNA743294_P_NODE_41337_length_265_cov_1.614583_g40881_i0	PRJNA743294	41337	265	1.614583	4.27864495	Pseudomonadati	3379134	Bacteria	Bacteria	125	5.359999999999999e-31	NR	MBT7552826.1	2026742	g40881	i0	67.1	3.90566037735849	85	28	96.2	0	258	4	245	329	MBT7552826.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	1035	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32202335	32202335	PRJNA743294_P_NODE_2598_length_915_cov_4.097387_g2266_i0	PRJNA743294	2598	915	4.097387	37.49109105	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	122	8.93e-27	NR	NIM49516.1	2448054	g2266	i0	43.2	0.99344262295082	148	80	47.5	2	915	481	550	696	NIM49516.1 tandem-95 repeat protein [Gemmatimonadales bacterium]	diamond	909	122	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);;