metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA929924" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA929924" 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
29337324	29337324	PRJNA929924_P_NODE_14369_length_175_cov_1.531746_g14206_i0	PRJNA929924	14369	175	1.531746	2.6805555	Mesobacillus	2675231	Bacteria	Bacteria	79	9.33e-18	NR	WP_046523009.1	1408103	g14206	i0	83.7	1.68	49	8	84	0	2	148	17	65	WP_046523009.1 CsbD family protein [Mesobacillus campisalis]	diamond	294	79	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus campisalis
29898688	29898688	PRJNA929924_P_NODE_17271_length_164_cov_0.904348_g17108_i0	PRJNA929924	17271	164	0.904348	1.48313072	Chloroflexota bacterium	2026724	Bacteria	Bacteria	48.9	5.15e-5	NR	MDY7040159.1	2026724	g17108	i0	48.9	2.43292682926829	47	23	84.1	1	148	11	128	174	MDY7040159.1 DUF5519 family protein [Chloroflexota bacterium]	diamond	399	48.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30435986	30435986	PRJNA929924_P_NODE_16173_length_166_cov_1.521368_g16010_i0	PRJNA929924	16173	166	1.521368	2.52547088	Prauserella rugosa	43354	Bacteria	Bacteria	105	4.11e-25	NR	WP_030531514.1	43354	g16010	i0	89.1	0.993975903614458	55	6	99.4	0	1	165	162	216	WP_030531514.1 hypothetical protein [Prauserella rugosa]	diamond	165	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Prauserella	Prauserella rugosa
30593553	30593553	PRJNA929924_S_NODE_5513_length_180_cov_1.300699_g5469_i0	PRJNA929924	5513	180	1.300699	2.3412582	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	86.3	1.58e-20	NR	WP_229963743.1	1590	g5469	i0	95.9	0.816666666666667	49	2	81.7	0	180	34	2	50	WP_229963743.1 hypothetical protein [Lactiplantibacillus plantarum]	diamond	147	86.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
32111355	32111355	PRJNA929924_P_NODE_14078_length_178_cov_1.519380_g13915_i0	PRJNA929924	14078	178	1.51938	2.7044964	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	112	1.35e-27	NR	WP_288812924.1	159447	g13915	i0	98.3	0.97752808988764	58	1	97.8	0	3	176	292	349	WP_288812924.1 alpha/beta hydrolase [uncultured Corynebacterium sp.]	diamond	174	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
32269698	32269698	PRJNA929924_P_NODE_17678_length_163_cov_0.912281_g17515_i0	PRJNA929924	17678	163	0.912281	1.48701803	Caldilinea sp. CFX5	2293554	Bacteria	Bacteria	105	2.0800000000000004e-27	NR	MCE7982606.1	2293554	g17515	i0	84.9	1.95092024539877	53	8	97.5	0	3	161	49	101	MCE7982606.1 cytochrome B6 [Caldilinea sp. CFX5]	diamond	318	105	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp. CFX5

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