metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB49404" 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
18842738	18842738	PRJEB49404_P_NODE_576515_length_164_cov_1.312000_g562714_i0	PRJEB49404	576515	164	1.312	2.15168	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	93.6	1.57e-20	NR	HET6763538.1	3047548	g562714	i0	81.5	8.85365853658537	54	10	98.8	0	2	163	702	755	HET6763538.1 heavy metal translocating P-type ATPase [Longimicrobiaceae bacterium]	diamond	1452	93.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
26653380	26653380	PRJEB49404_P_NODE_515441_length_178_cov_1.179856_g501640_i0	PRJEB49404	515441	178	1.179856	2.10014368	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	104	1.19e-25	NR	MBC7843561.1	2026741	g501640	i0	76.3	0.99438202247191	59	14	99.4	0	2	178	22	80	MBC7843561.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	177	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26837089	26837089	PRJEB49404_P_NODE_493501_length_183_cov_2.888889_g479700_i0	PRJEB49404	493501	183	2.888889	5.28666687	Pseudomonadati	3379134	Bacteria	Bacteria	42	0.0255	NR	MEE2899207.1	2026742	g479700	i0	41.4	1.9344262295082	58	31	93.4	2	9	179	13	68	MEE2899207.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	354	42	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27437900	27437900	PRJEB49404_P_NODE_347203_length_237_cov_2.212121_g333402_i0	PRJEB49404	347203	237	2.212121	5.24272677	Pseudomonadati	3379134	Bacteria	Bacteria	139	4.18e-37	NR	HEX6748314.1	2029185	g333402	i0	76.9	3.9493670886076	78	18	98.7	0	2	235	369	446	HEX6748314.1 epoxide hydrolase [Longimicrobium sp.]	diamond	936	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27911013	27911013	PRJEB49404_P_NODE_271525_length_283_cov_2.196721_g257724_i0	PRJEB49404	271525	283	2.196721	6.21672043	Bacteria	2	Bacteria	Bacteria	47.4	0.00129	NR	MBA3406070.1	2026741	g257724	i0	46.3	0.795053003533569	41	22	43.5	0	131	9	1	41	MBA3406070.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	225	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28044247	28044247	PRJEB49404_P_NODE_502625_length_181_cov_1.591549_g488824_i0	PRJEB49404	502625	181	1.591549	2.88070369	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	60.5	9.08e-9	NR	MCC6430334.1	2026741	g488824	i0	56.7	1.95580110497238	60	26	99.4	0	2	181	56	115	MCC6430334.1 IS66 family transposase [Gemmatimonadaceae bacterium]	diamond	354	60.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29149770	29149770	PRJEB49404_P_NODE_616849_length_156_cov_1.589744_g603048_i0	PRJEB49404	616849	156	1.589744	2.48000064	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	92	1.14e-22	NR	HZD84984.1	2026741	g603048	i0	90.2	0.980769230769231	51	5	98.1	0	2	154	43	93	HZD84984.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium]	diamond	153	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31423941	31423941	PRJEB49404_P_NODE_613076_length_157_cov_1.322034_g599275_i0	PRJEB49404	613076	157	1.322034	2.07559338	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	53.1	2.47e-6	NR	HXI32920.1	2448054	g599275	i0	50	1.98726114649682	52	26	99.4	0	157	2	444	495	HXI32920.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	312	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31740100	31740100	PRJEB49404_P_NODE_585057_length_162_cov_1.764228_g571256_i0	PRJEB49404	585057	162	1.764228	2.85804936	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52.8	3.25e-6	NR	HXW96391.1	2448054	g571256	i0	52.1	0.888888888888889	48	23	88.9	0	17	160	57	104	HXW96391.1 class I SAM-dependent methyltransferase [Gemmatimonadales bacterium]	diamond	144	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31834964	31834964	PRJEB49404_P_NODE_381337_length_221_cov_2.653846_g367536_i0	PRJEB49404	381337	221	2.653846	5.86499966	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	79.3	2.69e-15	NR	HEX6535207.1	2026741	g367536	i0	66.1	0.841628959276018	62	20	84.2	1	189	4	168	228	HEX6535207.1 OmpA family protein [Gemmatimonadaceae bacterium]	diamond	186	79.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31891672	31891672	PRJEB49404_P_NODE_473297_length_189_cov_1.760000_g459496_i0	PRJEB49404	473297	189	1.76	3.3264	Bacteria	2	Bacteria	Bacteria	84.3	4.13e-17	NR	WP_331876069.1	2029185	g459496	i0	65.1	9	63	22	100	0	189	1	532	594	WP_331876069.1 toxin TcdB middle/N-terminal domain-containing protein, partial [Longimicrobium sp.]	diamond	1701	85.1	0.990599294947121	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);;