metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax

10 rows where analysis = "diamond", 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
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);;