metadata: contig_metadata: 8 rows where bioproject = "PRJNA1214993", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA1214993", 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
1045416	1045416	PRJNA1214993_P_NODE_18061_length_263_cov_2.457895_g17875_i0	PRJNA1214993	18061	263	2.457895	6.46426385	Pseudomonadati	3379134	Bacteria	Bacteria	103	1.68e-23	NR	MDB4886273.1	2026742	g17875	i0	65.9	2.03041825095057	88	26	95.8	1	254	3	305	392	MDB4886273.1 Peptidase, (Subtilisin) subfamily [Gemmatimonadota bacterium]	diamond	534	103	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
2881230	2881230	PRJNA1214993_P_NODE_20103_length_252_cov_0.871508_g19917_i0	PRJNA1214993	20103	252	0.871508	2.19620016	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	145	3.13e-39	NR	MBC8086721.1	2026741	g19917	i0	82.1	1	84	15	100	0	252	1	192	275	MBC8086721.1 TIGR01777 family protein [Gemmatimonadaceae bacterium]	diamond	252	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26660834	26660834	PRJNA1214993_P_NODE_10041_length_346_cov_1.128205_g9855_i0	PRJNA1214993	10041	346	1.128205	3.9035893	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	100	6.7e-23	NR	HEX2217275.1	2448054	g9855	i0	47	1.01445086705202	117	59	98.8	3	342	1	114	230	HEX2217275.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium]	diamond	351	100	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26755936	26755936	PRJNA1214993_P_NODE_15781_length_281_cov_1.110577_g15595_i0	PRJNA1214993	15781	281	1.110577	3.12072137	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	70.9	7.34e-12	NR	MEX2111304.1	2026741	g15595	i0	36.6	5.0711743772242	93	59	99.3	0	2	280	301	393	MEX2111304.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadaceae bacterium]	diamond	1425	70.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28683438	28683438	PRJNA1214993_P_NODE_17847_length_265_cov_1.598958_g17661_i0	PRJNA1214993	17847	265	1.598958	4.2372387	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	127	2.6799999999999996e-32	NR	MBI1808675.1	2026742	g17661	i0	62.8	2.92075471698113	86	32	97.4	0	263	6	241	326	MBI1808675.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadota bacterium]	diamond	774	127	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32000881	32000881	PRJNA1214993_P_NODE_17478_length_268_cov_1.323077_g17292_i0	PRJNA1214993	17478	268	1.323077	3.54584636	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	46.2	0.00279	NR	MEO8881749.1	2026741	g17292	i0	60.5	0.425373134328358	38	15	42.5	0	155	268	1	38	MEO8881749.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium]	diamond	114	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32095753	32095753	PRJNA1214993_P_NODE_17338_length_269_cov_1.306122_g17152_i0	PRJNA1214993	17338	269	1.306122	3.51346818	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	65.5	1.57e-10	NR	HKG94009.1	2026741	g17152	i0	40	1.00371747211896	90	53	99.3	1	2	268	32	121	HKG94009.1 NAD(P)H-binding protein [Gemmatimonadaceae bacterium]	diamond	270	65.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32159285	32159285	PRJNA1214993_P_NODE_9378_length_357_cov_0.992958_g9192_i0	PRJNA1214993	9378	357	0.992958	3.54486006	Longimicrobium sp.	2029185	Bacteria	Bacteria	84.7	5.72e-17	NR	HEX8432154.1	2029185	g9192	i0	42.2	4.20168067226891	128	63	99.2	4	356	3	64	190	HEX8432154.1 leishmanolysin-related zinc metalloendopeptidase [Longimicrobium sp.]	diamond	1500	84.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.

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);;