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

10 rows where analysis = "diamond", bioproject = "PRJNA702290" and tax_kingdom = "Bacillati"

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
23636666	23636666	PRJNA702290_P_NODE_1379_length_175_cov_9.573529_g1371_i0	PRJNA702290	1379	175	9.573529	16.75367575	Lawsonella	1847725	Bacteria	Bacteria	110	2.17e-27	NR	WP_290595264.1	1847725	g1371	i0	100	0.96	56	0	96	0	8	175	197	252	WP_290595264.1 MULTISPECIES: type I glyceraldehyde-3-phosphate dehydrogenase [Lawsonella]	diamond	168	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
27903811	27903811	PRJNA702290_P_NODE_1505_length_159_cov_44.408333_g1497_i0	PRJNA702290	1505	159	44.408333	70.60924947	Actinomycetota bacterium	2900548	Bacteria	Bacteria	55.1	5.39e-7	NR	MEN9962630.1	2900548	g1497	i0	100	0.471698113207547	25	0	47.2	0	7	81	90	114	MEN9962630.1 hypothetical protein [Actinomycetota bacterium]	diamond	75	55.1	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
28282704	28282704	PRJNA702290_P_NODE_2006_length_153_cov_28.385965_g1998_i0	PRJNA702290	2006	153	28.385965	43.43052645	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	99.4	8.809999999999999e-23	NR	WP_304161253.1	1528099	g1998	i0	97.9	0.941176470588235	48	1	94.1	0	145	2	177	224	WP_304161253.1 purple acid phosphatase family protein [Lawsonella clevelandensis]	diamond	144	99.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
28914163	28914163	PRJNA702290_P_NODE_2108_length_151_cov_7.464286_g2100_i0	PRJNA702290	2108	151	7.464286	11.27107186	uncultured Cellulomonas sp.	189682	Bacteria	Bacteria	79.7	2.06e-16	NR	WP_315095514.1	189682	g2100	i0	81.5	2.08609271523179	54	6	99.3	1	1	150	16	69	WP_315095514.1 helix-turn-helix transcriptional regulator [uncultured Cellulomonas sp.]	diamond	315	79.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	uncultured Cellulomonas sp.
28977697	28977697	PRJNA702290_P_NODE_1708_length_158_cov_6.327731_g1700_i0	PRJNA702290	1708	158	6.327731	9.99781498	Leucobacter manosquensis	2810611	Bacteria	Bacteria	50.8	1.09e-5	NR	WP_211648413.1	2810611	g1700	i0	64.4	0.854430379746835	45	11	75.9	1	8	127	163	207	WP_211648413.1 hypothetical protein [Leucobacter manosquensis]	diamond	135	50.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter manosquensis
30809484	30809484	PRJNA702290_P_NODE_1314_length_187_cov_1.250000_g1306_i0	PRJNA702290	1314	187	1.25	2.3375	Brachybacterium fresconis	173363	Bacteria	Bacteria	43.5	6.66e-4	NR	GAA1487249.1	173363	g1306	i0	57.1	0.561497326203209	35	15	56.1	0	115	11	2	36	GAA1487249.1 hypothetical protein GCM10009625_40540 [Brachybacterium fresconis]	diamond	105	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium fresconis
30852178	30852178	PRJNA702290_P_NODE_1134_length_191_cov_4.730263_g1126_i0	PRJNA702290	1134	191	4.730263	9.03480233	Lawsonella	1847725	Bacteria	Bacteria	77	1.17e-15	NR	PZP88504.1	1528099	g1126	i0	78.2	2.59162303664921	55	11	86.4	1	189	25	96	149	PZP88504.1 MAG: nucleotide exchange factor GrpE [Lawsonella clevelandensis]	diamond	495	77	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31726224	31726224	PRJNA702290_P_NODE_777_length_191_cov_13.328947_g769_i0	PRJNA702290	777	191	13.328947	25.45828877	Arthrobacter sp. NPDC	1667	Bacteria	Bacteria	48.1	2.22e-4	NR	WP_400484826.1	3363943	g769	i0	95.8	0.37696335078534	24	1	37.7	0	112	183	115	138	WP_400484826.1 C40 family peptidase [Arthrobacter sp. NPDC092385]	diamond	72	48.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. NPDC092385
32105913	32105913	PRJNA702290_P_NODE_958_length_191_cov_9.151316_g950_i0	PRJNA702290	958	191	9.151316	17.47901356	Actinomyces oris	544580	Bacteria	Bacteria	64.7	1.82e-10	NR	WP_314179067.1	544580	g950	i0	48.3	0.942408376963351	60	27	94.2	1	185	6	64	119	WP_314179067.1 DUF4145 domain-containing protein [Actinomyces oris]	diamond	180	64.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
32685928	32685928	PRJNA702290_P_NODE_1160_length_191_cov_4.131579_g1152_i0	PRJNA702290	1160	191	4.131579	7.8913158900000004	Bacteria	2	Bacteria	Bacteria	85.5	8.6e-20	NR	WP_414057742.1	1280	g1152	i0	72.1	3.83246073298429	61	10	95.8	1	185	3	49	102	WP_414057742.1 Dps family protein, partial [Staphylococcus aureus]	diamond	732	85.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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);;