metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA493244" 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
23407314	23407314	PRJNA493244_P_NODE_1172639_length_338_cov_3.592058_g1149515_i0	PRJNA493244	1172639	338	3.592058	12.14115604	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	92.4	3.69e-21	NR	HJR67343.1	2026741	g1149515	i0	62.7	2.01479289940828	75	25	63.9	1	336	121	72	146	HJR67343.1 DUF2214 family protein [Gemmatimonadaceae bacterium]	diamond	681	92.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27282137	27282137	PRJNA493244_P_NODE_1023223_length_397_cov_1.440476_g1000120_i0	PRJNA493244	1023223	397	1.440476	5.71868972	Longimicrobium	1804994	Bacteria	Bacteria	99	4.63e-21	NR	WP_170034484.1	1639882	g1000120	i0	90	0.906801007556675	60	6	45.3	0	196	17	1	60	WP_170034484.1 SusC/RagA family TonB-linked outer membrane protein [Longimicrobium terrae]	diamond	360	100	0.99	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium terrae
27803166	27803166	PRJNA493244_P_NODE_1700144_length_204_cov_0.895105_g1677019_i0	PRJNA493244	1700144	204	0.895105	1.8260142	Longimicrobium sp.	2029185	Bacteria	Bacteria	92	5.55e-20	NR	HLM69020.1	2029185	g1677019	i0	70.3	1.88235294117647	64	16	94.1	1	204	13	126	186	HLM69020.1 asparagine synthase C-terminal domain-containing protein [Longimicrobium sp.]	diamond	384	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29176819	29176819	PRJNA493244_P_NODE_1167329_length_340_cov_2.913978_g1144205_i0	PRJNA493244	1167329	340	2.913978	9.9075252	Pseudomonadati	3379134	Bacteria	Bacteria	144	2.65e-39	NR	MBA2684767.1	2026741	g1144205	i0	60	6.48529411764706	105	42	92.6	0	1	315	150	254	MBA2684767.1 class I SAM-dependent methyltransferase [Gemmatimonadaceae bacterium]	diamond	2205	144	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30139253	30139253	PRJNA493244_P_NODE_1525792_length_237_cov_1.454545_g1502667_i0	PRJNA493244	1525792	237	1.454545	3.44727165	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.00721	NR	HET7599887.1	2448054	g1502667	i0	72.4	0.367088607594937	29	8	36.7	0	151	237	13	41	HET7599887.1 translation initiation factor IF-3 [Gemmatimonadales bacterium]	diamond	87	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30171147	30171147	PRJNA493244_P_NODE_1677352_length_206_cov_2.510345_g1654227_i0	PRJNA493244	1677352	206	2.510345	5.1713107	Longimicrobium sp.	2029185	Bacteria	Bacteria	46.6	1.87e-4	NR	HYR12146.1	2029185	g1654227	i0	53.8	0.567961165048544	39	18	56.8	0	148	32	23	61	HYR12146.1 hypothetical protein [Longimicrobium sp.]	diamond	117	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30550292	30550292	PRJNA493244_P_NODE_1275013_length_304_cov_3.687243_g1251889_i0	PRJNA493244	1275013	304	3.687243	11.20921872	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	74.3	5.93e-13	NR	MDP2957823.1	2910168	g1251889	i0	48.5	0.671052631578947	68	35	67.1	0	6	209	351	418	MDP2957823.1 hypothetical protein [Longimicrobiales bacterium]	diamond	204	74.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31783069	31783069	PRJNA493244_P_NODE_1619837_length_216_cov_1.722581_g1596712_i0	PRJNA493244	1619837	216	1.722581	3.72077496	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	77.4	1.55e-14	NR	HEX8274646.1	3047548	g1596712	i0	68.3	3.45833333333333	63	18	87.5	2	27	215	238	298	HEX8274646.1 asparagine synthase-related protein [Longimicrobiaceae bacterium]	diamond	747	77.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
32731692	32731692	PRJNA493244_P_NODE_1028260_length_394_cov_11.534535_g1005154_i0	PRJNA493244	1028260	394	11.534535	45.4460679	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	198	1.61e-61	NR	HEX5725253.1	3047548	g1005154	i0	77.6	5.70304568527919	125	28	95.2	0	19	393	1	125	HEX5725253.1 NAD(P)H-dependent oxidoreductase subunit E [Longimicrobiaceae bacterium]	diamond	2247	198	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae 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);;