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

14 rows where bioproject = "PRJNA473824", 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
7474734	7474734	PRJNA473824_P_NODE_95446_length_173_cov_2.860294_g94808_i0	PRJNA473824	95446	173	2.860294	4.94830862	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	83.6	5.9e-17	NR	HUF36126.1	2448054	g94808	i0	66.7	1.2485549132948	72	9	98.8	1	3	173	171	242	HUF36126.1 UvrD-helicase domain-containing protein [Gemmatimonadales bacterium]	diamond	216	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
11924919	11924919	PRJNA473824_P_NODE_128370_length_160_cov_1.658537_g127732_i0	PRJNA473824	128370	160	1.658537	2.6536592	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	230	5.71e-56	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g127732	i0	92.547	129.1	161	10	100	2	1	160	3042656	3042815	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	20656	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13850089	13850089	PRJNA473824_P_NODE_32931_length_209_cov_1.976744_g32293_i0	PRJNA473824	32931	209	1.976744	4.13139496	Pseudomonadati	3379134	Bacteria	Bacteria	231	2.19e-56	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g32293	i0	86.603	102.244019138756	209	28	100	0	1	209	161198	161406	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	21369	233	0.991416309012876	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14475738	14475738	PRJNA473824_P_NODE_67172_length_173_cov_4.125000_g66534_i0	PRJNA473824	67172	173	4.125	7.13625	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g66534	i0	100	0.161849710982659	28	0	16	0	118	145	378248	378275	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
18947598	18947598	PRJNA473824_P_NODE_107615_length_173_cov_2.617647_g106977_i0	PRJNA473824	107615	173	2.617647	4.52852931	Pseudomonadati	3379134	Bacteria	Bacteria	89.8	1.11e-13	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g106977	i0	91.045	28.3699421965318	67	4	38	2	6	71	4413414	4413349	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	4908	89.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26633059	26633059	PRJNA473824_P_NODE_19541_length_267_cov_3.960870_g18903_i0	PRJNA473824	19541	267	3.96087	10.5755229	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	44.3	0.012	NR	MDE2808462.1	2026742	g18903	i0	33.3	0.640449438202247	57	38	64	0	75	245	21	77	MDE2808462.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	171	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
26759591	26759591	PRJNA473824_P_NODE_22661_length_248_cov_4.345972_g22023_i0	PRJNA473824	22661	248	4.345972	10.77801056	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57.4	2.71e-7	NR	MBN63744.1	2026742	g22023	i0	44.4	0.870967741935484	72	40	87.1	0	240	25	534	605	MBN63744.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	216	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27581715	27581715	PRJNA473824_P_NODE_93784_length_173_cov_2.897059_g93146_i0	PRJNA473824	93784	173	2.897059	5.01191207	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	46.6	6.34e-4	NR	HMU61204.1	2448054	g93146	i0	60.5	0.745664739884393	43	15	71.1	1	171	49	185	227	HMU61204.1 cation-translocating P-type ATPase [Gemmatimonadales bacterium]	diamond	129	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28339562	28339562	PRJNA473824_P_NODE_73506_length_173_cov_3.713235_g72868_i0	PRJNA473824	73506	173	3.713235	6.42389655	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	47.8	2.39e-4	NR	MEJ2504437.1	2026742	g72868	i0	47.1	0.884393063583815	51	22	79.8	1	36	173	184	234	MEJ2504437.1 alpha-E domain-containing protein [Gemmatimonadota bacterium]	diamond	153	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28434289	28434289	PRJNA473824_P_NODE_144166_length_151_cov_4.526316_g143528_i0	PRJNA473824	144166	151	4.526316	6.83473716	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.8	1.42e-5	NR	MEW5917283.1	2026742	g143528	i0	80.8	1.01324503311258	26	5	51.7	0	3	80	224	249	MEW5917283.1 multicopper oxidase family protein [Gemmatimonadota bacterium]	diamond	153	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29034392	29034392	PRJNA473824_P_NODE_171348_length_150_cov_2.938053_g170710_i0	PRJNA473824	171348	150	2.938053	4.4070795	Gemmatimonas sp.	1962908	Bacteria	Bacteria	47.4	2.48e-4	NR	MEO7521361.1	1962908	g170710	i0	42.5	1.46	73	19	100	1	150	1	10	82	MEO7521361.1 hypothetical protein [Gemmatimonas sp.]	diamond	219	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
29318228	29318228	PRJNA473824_P_NODE_159309_length_151_cov_2.973684_g158671_i0	PRJNA473824	159309	151	2.973684	4.49026284	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	48.5	3.67e-5	NR	MEO7965276.1	2026741	g158671	i0	75.9	2.86092715231788	29	7	57.6	0	87	1	107	135	MEO7965276.1 glycosyltransferase [Gemmatimonadaceae bacterium]	diamond	432	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30613203	30613203	PRJNA473824_P_NODE_109353_length_173_cov_2.580882_g108715_i0	PRJNA473824	109353	173	2.580882	4.46492586	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52.8	3.11e-6	NR	HXE57277.1	2448054	g108715	i0	88	0.433526011560694	25	3	43.4	0	99	173	171	195	HXE57277.1 7-cyano-7-deazaguanine synthase QueC [Gemmatimonadales bacterium]	diamond	75	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31340198	31340198	PRJNA473824_P_NODE_68096_length_173_cov_4.066176_g67458_i0	PRJNA473824	68096	173	4.066176	7.03448448	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.1	1.85e-7	NR	HIC16017.1	2026742	g67458	i0	57.4	12.7976878612717	47	18	78	1	38	172	7	53	HIC16017.1 AAA family ATPase [Gemmatimonadota bacterium]	diamond	2214	53.1	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);;