metadata: contig_metadata: 14 rows where bioproject = "PRJNA976345" and tax

14 rows where bioproject = "PRJNA976345" 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
7326812	7326812	PRJNA976345_P_NODE_96986_length_192_cov_1.515924_g95378_i0	PRJNA976345	96986	192	1.515924	2.91057408	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g95378	i0	100	0.151041666666667	29	0	15	0	59	87	751333	751361	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9876078	9876078	PRJNA976345_P_NODE_150728_length_166_cov_1.519084_g149120_i0	PRJNA976345	150728	166	1.519084	2.52167944	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	67.6	4.96e-7	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g149120	i0	85.714	3.55421686746988	63	9	38	0	3	65	5056304	5056366	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	590	67.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12428091	12428091	PRJNA976345_P_NODE_79830_length_206_cov_1.730994_g78222_i0	PRJNA976345	79830	206	1.730994	3.56584764	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	165	2.22e-36	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g78222	i0	81.773	10.9126213592233	203	31	97	6	1	200	760692	760493	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	2248	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13701683	13701683	PRJNA976345_P_NODE_164491_length_161_cov_0.976190_g162883_i0	PRJNA976345	164491	161	0.97619	1.5716659	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	150	4.61e-32	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g162883	i0	83.75	43.3354037267081	160	24	99	2	1	159	1337710	1337552	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	6977	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
27721531	27721531	PRJNA976345_P_NODE_36464_length_283_cov_1.911290_g34857_i0	PRJNA976345	36464	283	1.91129	5.4089507	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	96.3	6.180000000000001e-21	NR	MCR4338773.1	2026741	g34857	i0	57.1	0.890459363957597	84	29	89	2	30	281	52	128	MCR4338773.1 site-specific DNA-methyltransferase [Gemmatimonadaceae bacterium]	diamond	252	96.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27815980	27815980	PRJNA976345_P_NODE_199324_length_150_cov_1.382609_g197716_i0	PRJNA976345	199324	150	1.382609	2.0739135	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	75.5	2.16e-14	NR	MEJ2218503.1	2026742	g197716	i0	68.1	1.88	47	15	94	0	8	148	170	216	MEJ2218503.1 HNH endonuclease domain-containing protein [Gemmatimonadota bacterium]	diamond	282	75.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28731504	28731504	PRJNA976345_P_NODE_73647_length_212_cov_2.242938_g72039_i0	PRJNA976345	73647	212	2.242938	4.75502856	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	57	2.31e-7	NR	TVP45187.1	2448054	g72039	i0	42	1.9811320754717	69	40	97.6	0	3	209	67	135	TVP45187.1 MAG: NAD-dependent DNA ligase LigA [Gemmatimonadales bacterium]	diamond	420	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29053486	29053486	PRJNA976345_P_NODE_111828_length_182_cov_2.170068_g110220_i0	PRJNA976345	111828	182	2.170068	3.94952376	Pseudomonadati	3379134	Bacteria	Bacteria	117	1.49e-29	NR	HEX6058158.1	2026741	g110220	i0	83.3	8.88461538461539	60	10	98.9	0	181	2	330	389	HEX6058158.1 serine hydrolase [Gemmatimonadaceae bacterium]	diamond	1617	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29173610	29173610	PRJNA976345_P_NODE_144149_length_169_cov_1.194030_g142541_i0	PRJNA976345	144149	169	1.19403	2.0179107	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	107	2.9e-25	NR	MEX2583338.1	2026742	g142541	i0	87.5	1.98816568047337	56	7	99.4	0	169	2	393	448	MEX2583338.1 translation elongation factor 4 [Gemmatimonadota bacterium]	diamond	336	107	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30089145	30089145	PRJNA976345_P_NODE_123752_length_178_cov_2.069930_g122144_i0	PRJNA976345	123752	178	2.06993	3.6844754	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.4	0.0017	NR	MEO6529155.1	2026741	g122144	i0	84	0.825842696629214	25	4	42.1	0	104	178	135	159	MEO6529155.1 dihydropteroate synthase [Gemmatimonadaceae bacterium]	diamond	147	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30474716	30474716	PRJNA976345_P_NODE_120773_length_178_cov_2.510490_g119165_i0	PRJNA976345	120773	178	2.51049	4.4686722	Bacteria	2	Bacteria	Bacteria	48.5	1.12e-4	NR	HKV50085.1	2026741	g119165	i0	91.7	2.42696629213483	24	2	40.4	0	73	2	72	95	HKV50085.1 DUF305 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	432	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31037411	31037411	PRJNA976345_P_NODE_149895_length_166_cov_2.160305_g148287_i0	PRJNA976345	149895	166	2.160305	3.5861063	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	57	2.08e-8	NR	HJP60985.1	2026741	g148287	i0	71.4	10.1024096385542	35	10	63.3	0	1	105	10	44	HJP60985.1 VOC family protein [Gemmatimonadaceae bacterium]	diamond	1677	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31669507	31669507	PRJNA976345_P_NODE_77137_length_209_cov_1.120690_g75529_i0	PRJNA976345	77137	209	1.12069	2.3422421	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	115	8.3e-30	NR	HEY8196907.1	2448054	g75529	i0	75.4	0.990430622009569	69	17	99	0	207	1	63	131	HEY8196907.1 DUF2490 domain-containing protein [Gemmatimonadales bacterium]	diamond	207	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32649538	32649538	PRJNA976345_P_NODE_104400_length_187_cov_1.401316_g102792_i0	PRJNA976345	104400	187	1.401316	2.62046092	Longimicrobium sp.	2029185	Bacteria	Bacteria	94	1.62e-20	NR	HEU0299428.1	2029185	g102792	i0	64.5	0.994652406417112	62	22	99.5	0	187	2	458	519	HEU0299428.1 S8 family serine peptidase [Longimicrobium sp.]	diamond	186	94	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);;