metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1066877" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1066877" and tax_phylum = "Actinomycetota"

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
27446618	27446618	PRJNA1066877_S_NODE_7423_length_198_cov_0.899329_g7388_i0	PRJNA1066877	7423	198	0.899329	1.78067142	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	139	3.65e-38	NR	WP_304161486.1	1528099	g7388	i0	100	0.984848484848485	65	0	98.5	0	3	197	32	96	WP_304161486.1 zinc-binding dehydrogenase [Lawsonella clevelandensis]	diamond	195	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30161697	30161697	PRJNA1066877_S_NODE_5492_length_220_cov_1.187135_g5457_i0	PRJNA1066877	5492	220	1.187135	2.611697	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	59.3	2.58e-8	NR	WP_394268123.1	1528099	g5457	i0	100	0.354545454545455	26	0	35.5	0	78	1	1	26	WP_394268123.1 PspA/IM30 family protein [Lawsonella clevelandensis]	diamond	78	59.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31868681	31868681	PRJNA1066877_S_NODE_6757_length_204_cov_1.316129_g6722_i0	PRJNA1066877	6757	204	1.316129	2.68490316	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	135	3.05e-35	NR	WP_304136041.1	1528099	g6722	i0	100	0.985294117647059	67	0	98.5	0	203	3	262	328	WP_304136041.1 hypothetical protein [Lawsonella clevelandensis]	diamond	201	135	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32153606	32153606	PRJNA1066877_S_NODE_5078_length_227_cov_1.061798_g5043_i0	PRJNA1066877	5078	227	1.061798	2.41028146	Amycolatopsis dongchuanensis	1070866	Bacteria	Bacteria	43.1	0.0216	NR	WP_346056675.1	1070866	g5043	i0	36.7	0.79295154185022	60	33	72.7	2	35	199	99	158	WP_346056675.1 sensor histidine kinase [Amycolatopsis dongchuanensis]	diamond	180	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis dongchuanensis
32280351	32280351	PRJNA1066877_S_NODE_10919_length_170_cov_0.867769_g10884_i0	PRJNA1066877	10919	170	0.867769	1.4752073	Corynebacterium sp. KPL4	1720	Bacteria	Bacteria	115	4.75e-29	NR	WP_340440546.1	3135440	g10884	i0	100	0.988235294117647	56	0	98.8	0	1	168	108	163	WP_340440546.1 glycoside hydrolase family 26 protein [Corynebacterium sp. KPL4072]	diamond	168	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. KPL4072

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