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

5 rows where analysis = "diamond", bioproject = "PRJNA1193541" and tax_phylum = "Bacillota"

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
16344936	16344936	PRJNA1193541_P_NODE_9993_length_279_cov_0.878641_g9855_i0	PRJNA1193541	9993	279	0.878641	2.45140839	Clostridium botulinum	1491	Bacteria	Bacteria	167	3.67e-51	NR	MBY7057768.1	1491	g9855	i0	91.4	3	93	8	100	0	279	1	21	113	MBY7057768.1 dipeptide ABC transporter permease DppC [Clostridium botulinum]	diamond	837	167	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
27546331	27546331	PRJNA1193541_P_NODE_10104_length_277_cov_1.465686_g9966_i0	PRJNA1193541	10104	277	1.465686	4.05995022	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	84	1.9e-16	NR	MBR5577876.1	1898203	g9966	i0	53.3	0.974729241877256	90	40	97.5	2	7	276	1223	1310	MBR5577876.1 beta-N-acetylglucosaminidase domain-containing protein [Lachnospiraceae bacterium]	diamond	270	84	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28935638	28935638	PRJNA1193541_P_NODE_14008_length_245_cov_0.895349_g13870_i0	PRJNA1193541	14008	245	0.895349	2.19360505	Staphylococcus aureus	1280	Bacteria	Bacteria	93.2	9.33e-23	NR	WP_348968639.1	1280	g13870	i0	100	0.6	49	0	60	0	98	244	1	49	WP_348968639.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	147	93.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30072282	30072282	PRJNA1193541_P_NODE_13632_length_246_cov_0.890173_g13494_i0	PRJNA1193541	13632	246	0.890173	2.18982558	Brevibacillus thermoruber	33942	Bacteria	Bacteria	43.5	0.0195	NR	WP_035297969.1	33942	g13494	i0	36.4	0.670731707317073	55	35	67.1	0	47	211	6	60	WP_035297969.1 hypothetical protein [Brevibacillus thermoruber]	diamond	165	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus thermoruber
30925676	30925676	PRJNA1193541_P_NODE_14054_length_245_cov_0.895349_g13916_i0	PRJNA1193541	14054	245	0.895349	2.19360505	Thermicanus aegyptius	94009	Bacteria	Bacteria	137	3.57e-37	NR	WP_028986596.1	94009	g13916	i0	86.4	0.991836734693878	81	11	99.2	0	245	3	34	114	WP_028986596.1 flavodoxin-dependent (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Thermicanus aegyptius]	diamond	243	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius

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