metadata: contig_metadata: 14 rows where bioproject = "PRJNA744060", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA744060", 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
5827051	5827051	PRJNA744060_P_NODE_43625_length_253_cov_1.900000_g43296_i0	PRJNA744060	43625	253	1.9	4.807	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g43296	i0	100	0.110671936758893	28	0	11	0	211	238	2248123	2248096	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
10927725	10927725	PRJNA744060_P_NODE_8669_length_542_cov_3.597015_g8344_i0	PRJNA744060	8669	542	3.597015	19.4958213	Pseudomonadati	3379134	Bacteria	Bacteria	227	5.23e-71	NR	HEY2065776.1	2026741	g8344	i0	70.5	12.7140221402214	166	44	90.2	4	50	538	1	164	HEY2065776.1 cysteine synthase A [Gemmatimonadaceae bacterium]	diamond	6891	228	0.995614035087719	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27273977	27273977	PRJNA744060_P_NODE_37563_length_270_cov_2.746193_g37234_i0	PRJNA744060	37563	270	2.746193	7.4147211	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.5	0.0279	NR	HLG06190.1	2448054	g37234	i0	46.5	0.477777777777778	43	23	47.8	0	256	128	680	722	HLG06190.1 carboxypeptidase-like regulatory domain-containing protein [Gemmatimonadales bacterium]	diamond	129	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28262685	28262685	PRJNA744060_P_NODE_26106_length_318_cov_3.053061_g25777_i0	PRJNA744060	26106	318	3.053061	9.70873398	Bacteria	2	Bacteria	Bacteria	97.8	2.14e-21	NR	HEX6631285.1	2026741	g25777	i0	56.3	8.49056603773585	87	35	79.2	1	298	47	232	318	HEX6631285.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	2700	98.2	0.995926680244399	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28316089	28316089	PRJNA744060_P_NODE_48366_length_246_cov_1.156069_g48037_i0	PRJNA744060	48366	246	1.156069	2.84392974	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	129	4.06e-33	NR	MBT8335818.1	2026742	g48037	i0	75.3	2.95121951219512	81	20	98.8	0	245	3	155	235	MBT8335818.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadota bacterium]	diamond	726	129	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28705001	28705001	PRJNA744060_P_NODE_44147_length_252_cov_3.106145_g43818_i0	PRJNA744060	44147	252	3.106145	7.8274854	FCB group	1783270	Bacteria	Bacteria	75.5	6.71e-14	NR	HEX8358827.1	2029185	g43818	i0	42	5.76190476190476	81	45	96.4	1	251	9	181	259	HEX8358827.1 FAD-dependent oxidoreductase [Longimicrobium sp.]	diamond	1452	75.9	0.994729907773386	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28726503	28726503	PRJNA744060_P_NODE_40147_length_262_cov_3.068783_g39818_i0	PRJNA744060	40147	262	3.068783	8.04021146	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	132	1.58e-33	NR	MFP4623780.1	2026742	g39818	i0	63.2	2.98854961832061	87	30	99.6	1	262	2	543	627	MFP4623780.1 prolyl oligopeptidase family serine peptidase [Gemmatimonadota bacterium]	diamond	783	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28831083	28831083	PRJNA744060_P_NODE_21528_length_349_cov_1.083333_g21199_i0	PRJNA744060	21528	349	1.083333	3.78083217	Bacteria	2	Bacteria	Bacteria	125	2.05e-31	NR	MCY3548551.1	2026742	g21199	i0	53.9	4.94269340974212	115	52	98.9	1	4	348	208	321	MCY3548551.1 Ig-like domain-containing protein [Gemmatimonadota bacterium]	diamond	1725	126	0.992063492063492	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29294762	29294762	PRJNA744060_P_NODE_24169_length_330_cov_2.373541_g23840_i0	PRJNA744060	24169	330	2.373541	7.8326853	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.9	0.0301	NR	HEX4683988.1	2026741	g23840	i0	36.6	0.745454545454545	82	46	73.6	2	33	275	137	213	HEX4683988.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	246	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29831531	29831531	PRJNA744060_P_NODE_29471_length_301_cov_1.565789_g29142_i0	PRJNA744060	29471	301	1.565789	4.71302489	Longimicrobium sp.	2029185	Bacteria	Bacteria	96.7	5.19e-22	NR	WP_331878696.1	2029185	g29142	i0	46.9	3.80730897009967	98	49	95.7	2	6	293	48	144	WP_331878696.1 leishmanolysin-related zinc metalloendopeptidase, partial [Longimicrobium sp.]	diamond	1146	96.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30178971	30178971	PRJNA744060_P_NODE_28032_length_308_cov_1.829787_g27703_i0	PRJNA744060	28032	308	1.829787	5.63574396	Gemmatimonas sp. SM23_52	1703359	Bacteria	Bacteria	149	4.29e-39	NR	KPK82456.1	1703359	g27703	i0	69.1	2.79545454545455	94	29	91.6	0	283	2	1134	1227	KPK82456.1 MAG: phosphoribosylformylglycinamidine synthase [Gemmatimonas sp. SM23_52]	diamond	861	149	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SM23_52
31917658	31917658	PRJNA744060_P_NODE_5417_length_679_cov_2.214521_g5107_i0	PRJNA744060	5417	679	2.214521	15.03659759	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	78.6	1.31e-13	NR	HEV7992015.1	2026741	g5107	i0	36.8	1.39617083946981	152	93	66.7	3	43	495	2	151	HEV7992015.1 aquaporin [Gemmatimonadaceae bacterium]	diamond	948	78.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32560705	32560705	PRJNA744060_P_NODE_21059_length_352_cov_3.336918_g20730_i0	PRJNA744060	21059	352	3.336918	11.74595136	Pseudomonadati	3379134	Bacteria	Bacteria	134	1.4499999999999999e-34	NR	KPJ83357.1	1703356	g20730	i0	59.6	19.4829545454545	114	44	97.2	1	350	9	108	219	KPJ83357.1 MAG: carboxypeptidase [Gemmatimonas sp. SG8_23]	diamond	6858	135	0.992592592592593	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SG8_23
32833842	32833842	PRJNA744060_P_NODE_21460_length_349_cov_2.391304_g21131_i0	PRJNA744060	21460	349	2.391304	8.34565096	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	79.7	1.34e-14	NR	MBM3907237.1	2026742	g21131	i0	47.3	0.782234957020057	91	45	78.2	1	1	273	456	543	MBM3907237.1 NAD-dependent malic enzyme [Gemmatimonadota bacterium]	diamond	273	79.7	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);;