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

10 rows where analysis = "diamond", bioproject = "PRJNA806354" 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
27252609	27252609	PRJNA806354_P_NODE_35783_length_250_cov_0.870056_g35674_i0	PRJNA806354	35783	250	0.870056	2.17514	Methylophilus	16	Bacteria	Bacteria	145	1.76e-38	NR	WP_245652615.1	492660	g35674	i0	88.9	10.692	81	9	97.2	0	3	245	362	442	WP_245652615.1 methyl-accepting chemotaxis protein, partial [Methylophilus rhizosphaerae]	diamond	2673	145	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylophilus	Methylophilus rhizosphaerae
27505608	27505608	PRJNA806354_P_NODE_39423_length_244_cov_0.900585_g39314_i0	PRJNA806354	39423	244	0.900585	2.1974274	FCB group	1783270	Bacteria	Bacteria	139	2.6299999999999996e-37	NR	MEI7669962.1	1977087	g39314	i0	81.3	2.95081967213115	80	15	98.4	0	242	3	32	111	MEI7669962.1 AAA family ATPase [Pseudomonadota bacterium]	diamond	720	140	0.992857142857143	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27528071	27528071	PRJNA806354_P_NODE_33663_length_256_cov_2.349727_g33554_i0	PRJNA806354	33663	256	2.349727	6.01530112	Marinobacter sp. OP 3.4	3076501	Bacteria	Bacteria	41.6	0.0301	NR	WP_328189798.1	3076501	g33554	i0	42.3	0.609375	52	29	60.9	1	71	226	27	77	WP_328189798.1 hypothetical protein [Marinobacter sp. OP 3.4]	diamond	156	41.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter	Marinobacter sp. OP 3.4
28412273	28412273	PRJNA806354_P_NODE_27706_length_281_cov_1.086538_g27597_i0	PRJNA806354	27706	281	1.086538	3.05317178	Methylophilus sp. QUAN	2781020	Bacteria	Bacteria	188	6.629999999999999e-56	NR	WP_194752973.1	2781020	g27597	i0	97.8	0.98220640569395	92	2	98.2	0	4	279	54	145	WP_194752973.1 SAM-dependent methyltransferase [Methylophilus sp. QUAN]	diamond	276	188	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylophilus	Methylophilus sp. QUAN
29359505	29359505	PRJNA806354_P_NODE_40689_length_242_cov_0.911243_g40580_i0	PRJNA806354	40689	242	0.911243	2.20520806	Massilia sp. YIM B	1882437	Bacteria	Bacteria	86.7	1.49e-18	NR	WP_290413997.1	3050130	g40580	i0	100	0.433884297520661	35	0	43.4	0	240	136	211	245	WP_290413997.1 DNA-formamidopyrimidine glycosylase family protein [Massilia sp. YIM B02763]	diamond	105	86.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. YIM B02763
29422350	29422350	PRJNA806354_P_NODE_39909_length_243_cov_0.905882_g39800_i0	PRJNA806354	39909	243	0.905882	2.20129326	Leclercia adecarboxylata	83655	Bacteria	Bacteria	131	8.319999999999999e-37	NR	WP_272714667.1	83655	g39800	i0	84	0.925925925925926	75	12	92.6	0	227	3	1	75	WP_272714667.1 c-type cytochrome, partial [Leclercia adecarboxylata]	diamond	225	131	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Leclercia	Leclercia adecarboxylata
29683685	29683685	PRJNA806354_P_NODE_36290_length_249_cov_0.875000_g36181_i0	PRJNA806354	36290	249	0.875	2.17875	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	6.76e-7	NR	MEN9845474.1	1977087	g36181	i0	76.5	2.04819277108434	34	8	41	0	144	245	1	34	MEN9845474.1 hypothetical protein [Pseudomonadota bacterium]	diamond	510	56.6	0.992932862190813	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
30370573	30370573	PRJNA806354_P_NODE_36312_length_249_cov_0.875000_g36203_i0	PRJNA806354	36312	249	0.875	2.17875	uncultured Paraglaciecola sp.	1765024	Bacteria	Bacteria	43.1	0.00378	NR	WP_299078862.1	1765024	g36203	i0	48.6	0.421686746987952	35	18	42.2	0	113	9	2	36	WP_299078862.1 hypothetical protein, partial [uncultured Paraglaciecola sp.]	diamond	105	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Paraglaciecola	uncultured Paraglaciecola sp.
30694908	30694908	PRJNA806354_P_NODE_33313_length_258_cov_0.832432_g33204_i0	PRJNA806354	33313	258	0.832432	2.14767456	Salmonella	590	Bacteria	Bacteria	154	3.23e-44	NR	ECB2966014.1	28147	g33204	i0	96.5	10.8488372093023	85	3	98.8	0	2	256	50	134	ECB2966014.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Oranienburg]	diamond	2799	154	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
32172423	32172423	PRJNA806354_P_NODE_41258_length_241_cov_0.916667_g41149_i0	PRJNA806354	41258	241	0.916667	2.20916747	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	86.3	4.1e-18	NR	MFH0900681.1	1977087	g41149	i0	55.4	0.921161825726141	74	33	92.1	0	16	237	156	229	MFH0900681.1 hypothetical protein [Pseudomonadota bacterium]	diamond	222	86.3	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota 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);;