metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB65329" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB65329" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
15432637	15432637	PRJEB65329_S_NODE_7133_length_276_cov_4.562753_g6971_i0	PRJEB65329	7133	276	4.562753	12.59319828	root	1	Root_unresolved	Root_unresolved	174	1.16e-52	NR	WP_321130271.1	1496	g6971	i0	92.4	2	92	7	100	0	276	1	99	190	WP_321130271.1 GTP-binding protein, partial [Clostridioides difficile]	diamond	552	174	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
27058514	27058514	PRJEB65329_S_NODE_18302_length_151_cov_2.934426_g18140_i0	PRJEB65329	18302	151	2.934426	4.43098326	root	1	Root_unresolved	Root_unresolved	90.1	8.480000000000001e-21	NR	MCJ0157548.1	1496	g18140	i0	76	13.8675496688742	50	12	99.3	0	150	1	99	148	MCJ0157548.1 40S ribosomal protein S3a/S1 [Clostridioides difficile]	diamond	2094	90.9	0.991199119911991	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
27508117	27508117	PRJEB65329_S_NODE_17743_length_154_cov_2.016000_g17581_i0	PRJEB65329	17743	154	2.016	3.10464	Cyanobium sp. ELA507	3064509	Bacteria	Bacteria	38.5	0.0448	NR	MEI6617027.1	3064509	g17581	i0	50	0.701298701298701	36	15	64.3	1	123	25	1	36	MEI6617027.1 MBL fold metallo-hydrolase [Cyanobium sp. ELA507]	diamond	108	38.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ELA507
28613012	28613012	PRJEB65329_S_NODE_13247_length_182_cov_2.784314_g13085_i0	PRJEB65329	13247	182	2.784314	5.06745148	Thermogemmatispora sp.	1968838	Bacteria	Bacteria	41.6	0.0419	NR	WP_376797019.1	1968838	g13085	i0	38.2	0.906593406593407	55	18	87.4	2	24	182	82	122	WP_376797019.1 zinc-binding alcohol dehydrogenase family protein [Thermogemmatispora sp.]	diamond	165	41.6	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Thermogemmatisporales	Thermogemmatisporaceae	Thermogemmatispora	Thermogemmatispora sp.
29654525	29654525	PRJEB65329_S_NODE_12650_length_188_cov_1.886792_g12488_i0	PRJEB65329	12650	188	1.886792	3.54716896	Streptomyces caniscabiei	2746961	Bacteria	Bacteria	41.2	0.0372	NR	WP_319106296.1	2746961	g12488	i0	47.2	0.574468085106383	36	19	57.4	0	171	64	37	72	WP_319106296.1 peptidase inhibitor family I36 protein [Streptomyces caniscabiei]	diamond	108	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces caniscabiei
30855383	30855383	PRJEB65329_S_NODE_9034_length_234_cov_2.702439_g8872_i0	PRJEB65329	9034	234	2.702439	6.32370726	Streptomyces sp. KM77-8	3074435	Bacteria	Bacteria	44.3	0.00927	NR	BFO18157.1	3074435	g8872	i0	40	0.897435897435897	70	39	89.7	1	211	2	421	487	BFO18157.1 hypothetical protein SHKM778_45450 [Streptomyces sp. KM77-8]	diamond	210	44.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces haneummycinicus
32846572	32846572	PRJEB65329_S_NODE_12060_length_193_cov_4.310976_g11898_i0	PRJEB65329	12060	193	4.310976	8.32018368	Paenibacillus woosongensis	307580	Bacteria	Bacteria	40	0.0299	NR	WP_306422036.1	307580	g11898	i0	44.2	0.808290155440414	52	26	77.7	2	26	175	1	51	WP_306422036.1 hypothetical protein [Paenibacillus woosongensis]	diamond	156	40	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus woosongensis

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