metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA358209" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA358209" and tax_phylum = "Pseudomonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
10602655	10602655	PRJNA358209_P_NODE_889_length_163_cov_1.456140_g887_i0	PRJNA358209	889	163	1.45614	2.3735082	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	105	9.9e-26	NR	WP_105736151.1	28101	g887	i0	100	2.98159509202454	54	0	99.4	0	163	2	78	131	WP_105736151.1 carboxylating nicotinate-nucleotide diphosphorylase [Phyllobacterium myrsinacearum]	diamond	486	105	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
20800397	20800397	PRJNA358209_P_NODE_677_length_165_cov_0.879310_g675_i0	PRJNA358209	677	165	0.87931	1.4508615	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	107	2.48e-25	NR	MEW6596987.1	1977087	g675	i0	100	0.945454545454545	52	0	94.5	0	3	158	137	188	MEW6596987.1 ATP-binding cassette domain-containing protein [Pseudomonadota bacterium]	diamond	156	107	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
26870833	26870833	PRJNA358209_P_NODE_1061_length_162_cov_0.902655_g1059_i0	PRJNA358209	1061	162	0.902655	1.4623011	Halomonadaceae	28256	Bacteria	Bacteria	97.4	6.67e-22	NR	WP_077529624.1	86177	g1059	i0	88.2	3.77777777777778	51	6	94.4	0	6	158	724	774	WP_077529624.1 DUF1631 family protein [Vreelandella utahensis]	diamond	612	98.2	0.991853360488798	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Vreelandella	Vreelandella halophila
26916668	26916668	PRJNA358209_P_NODE_1242_length_161_cov_0.910714_g1240_i0	PRJNA358209	1242	161	0.910714	1.46624954	Marinobacter sp.	50741	Bacteria	Bacteria	81.6	3.99e-18	NR	HEV8078339.1	50741	g1240	i0	90.9	1.6583850931677	44	4	82	0	1	132	8	51	HEV8078339.1 MFS transporter [Marinobacter sp.]	diamond	267	81.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter	Marinobacter sp.
28102536	28102536	PRJNA358209_P_NODE_665_length_165_cov_0.956897_g663_i0	PRJNA358209	665	165	0.956897	1.57888005	Gammaproteobacteria	1236	Bacteria	Bacteria	39.7	0.049	NR	MBN0217501.1	287	g663	i0	41.7	1.74545454545455	48	25	85.5	2	2	142	10	55	MBN0217501.1 MFS transporter [Pseudomonas aeruginosa]	diamond	288	39.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
29285226	29285226	PRJNA358209_P_NODE_1109_length_162_cov_0.902655_g1107_i0	PRJNA358209	1109	162	0.902655	1.4623011	Salicola sp. Rm-C-2C1-2	3141321	Bacteria	Bacteria	72.8	3.19e-13	NR	WP_349750058.1	3141321	g1107	i0	81	0.777777777777778	42	8	77.8	0	156	31	235	276	WP_349750058.1 bifunctional 23S rRNA (guanine(2069)-N(7))-methyltransferase RlmK/23S rRNA (guanine(2445)-N(2))-methyltransferase RlmL [Salicola sp. Rm-C-2C1-2]	diamond	126	72.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Salicola	Salicola sp. Rm-C-2C1-2
29460050	29460050	PRJNA358209_P_NODE_490_length_167_cov_0.864407_g488_i0	PRJNA358209	490	167	0.864407	1.44355969	Nevskia	64001	Bacteria	Bacteria	112	2.79e-27	NR	WP_051748936.1	418856	g488	i0	90.9	1.97604790419162	55	5	98.8	0	165	1	570	624	WP_051748936.1 S46 family peptidase [Nevskia soli]	diamond	330	112	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales	Nevskiaceae	Nevskia	Nevskia soli
30706692	30706692	PRJNA358209_P_NODE_1094_length_162_cov_0.902655_g1092_i0	PRJNA358209	1094	162	0.902655	1.4623011	Caulobacter sp. CCUG 6	78	Bacteria	Bacteria	108	1.09e-25	NR	WP_242918357.1	2100090	g1092	i0	98.1	0.981481481481482	53	1	98.1	0	160	2	1623	1675	WP_242918357.1 filamentous haemagglutinin family protein [Caulobacter sp. CCUG 60055]	diamond	159	108	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Caulobacter	Caulobacter sp. CCUG 60055
31054608	31054608	PRJNA358209_P_NODE_975_length_163_cov_0.894737_g973_i0	PRJNA358209	975	163	0.894737	1.45842131	Rhodovibrio salinarum	1087	Bacteria	Bacteria	87	3.12e-18	NR	MBK1697528.1	1087	g973	i0	79.2	1.76687116564417	48	10	88.3	0	145	2	316	363	MBK1697528.1 aspartate--tRNA ligase [Rhodovibrio salinarum]	diamond	288	87	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Rhodovibrionaceae	Rhodovibrio	Rhodovibrio salinarum
31465580	31465580	PRJNA358209_P_NODE_676_length_165_cov_0.879310_g674_i0	PRJNA358209	676	165	0.87931	1.4508615	Rickettsiales bacterium	2026788	Bacteria	Bacteria	64.7	2.28e-10	NR	MBK67232.1	2026788	g674	i0	59.3	0.981818181818182	54	22	98.2	0	163	2	394	447	MBK67232.1 hypothetical protein [Rickettsiales bacterium]	diamond	162	64.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales			Rickettsiales bacterium
32431659	32431659	PRJNA358209_P_NODE_679_length_165_cov_0.879310_g677_i0	PRJNA358209	679	165	0.87931	1.4508615	Pseudomonas	286	Bacteria	Bacteria	47.8	2.16e-4	NR	MEW6597180.1	1977087	g677	i0	100	0.727272727272727	20	0	36.4	0	164	105	444	463	MEW6597180.1 glutamine synthetase family protein [Pseudomonadota bacterium]	diamond	120	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
32541239	32541239	PRJNA358209_P_NODE_779_length_164_cov_0.886957_g777_i0	PRJNA358209	779	164	0.886957	1.45460948	Thiohalorhabdaceae bacterium	3107638	Bacteria	Bacteria	68.9	5.36e-12	NR	MFB6259944.1	3107638	g777	i0	93.9	0.603658536585366	33	2	60.4	0	162	64	289	321	MFB6259944.1 ABC transporter ATP-binding protein [Thiohalorhabdaceae bacterium]	diamond	99	68.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiohalorhabdales	Thiohalorhabdaceae		Thiohalorhabdaceae 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);;