metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1197996" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1197996" 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
9251754	9251754	PRJNA1197996_S_NODE_13068_length_307_cov_1.303419_g13014_i0	PRJNA1197996	13068	307	1.303419	4.00149633	Enterococcus	1350	Bacteria	Bacteria	169	3.61e-49	NR	WP_413133017.1	37734	g13014	i0	72.5	1.99348534201954	102	28	99.7	0	307	2	168	269	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	612	169	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
20725373	20725373	PRJNA1197996_S_NODE_217_length_1223_cov_6.174783_g197_i0	PRJNA1197996	217	1223	6.174783	75.51759609	Enterococcus casseliflavus	37734	Bacteria	Bacteria	382	1.19e-127	NR	WP_413133017.1	37734	g197	i0	54.2	1.61651676206051	349	147	82.4	2	1088	81	17	365	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	1977	382	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
26755804	26755804	PRJNA1197996_S_NODE_23841_length_250_cov_1.435028_g23787_i0	PRJNA1197996	23841	250	1.435028	3.58757	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	42.4	0.0351	NR	MBS3811332.1	2094029	g23787	i0	37.1	0.744	62	37	73.2	2	31	213	89	149	MBS3811332.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Halanaerobiales bacterium]	diamond	186	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
27198720	27198720	PRJNA1197996_S_NODE_6502_length_382_cov_1.834951_g6448_i0	PRJNA1197996	6502	382	1.834951	7.00951282	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	44.7	0.0338	NR	MDY2879560.1	2054177	g6448	i0	31.2	0.604712041884817	77	48	58.1	3	252	31	385	459	MDY2879560.1 MATE family efflux transporter [Christensenellaceae bacterium]	diamond	231	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
27293763	27293763	PRJNA1197996_S_NODE_7463_length_366_cov_3.464164_g7409_i0	PRJNA1197996	7463	366	3.464164	12.67884024	Clostridium cochlearium	1494	Bacteria	Bacteria	43.1	0.0308	NR	WP_171302903.1	1494	g7409	i0	32.2	0.737704918032787	90	43	68.9	3	34	285	40	117	WP_171302903.1 hypothetical protein [Clostridium cochlearium]	diamond	270	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium cochlearium
28335785	28335785	PRJNA1197996_S_NODE_10026_length_334_cov_1.521073_g9972_i0	PRJNA1197996	10026	334	1.521073	5.08038382	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	44.3	0.0268	NR	MDD2958078.1	1898203	g9972	i0	30	0.988023952095808	110	69	98.8	3	333	4	121	222	MDD2958078.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	330	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30072444	30072444	PRJNA1197996_S_NODE_252_length_1166_cov_4.238792_g230_i0	PRJNA1197996	252	1166	4.238792	49.42431472	Melissococcus plutonius	33970	Bacteria	Bacteria	283	9.31e-89	NR	WP_231849637.1	33970	g230	i0	45.7	0.87221269296741	339	169	83.6	4	1009	35	35	372	WP_231849637.1 pectate lyase family protein [Melissococcus plutonius]	diamond	1017	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius
30925831	30925831	PRJNA1197996_S_NODE_16994_length_282_cov_1.593301_g16940_i0	PRJNA1197996	16994	282	1.593301	4.49310882	Eubacteriales bacterium	2831996	Bacteria	Bacteria	46.6	0.00255	NR	MBS7228452.1	2831996	g16940	i0	39	0.627659574468085	59	35	62.8	1	89	265	506	563	MBS7228452.1 hypothetical protein [Eubacteriales bacterium]	diamond	177	46.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
32412188	32412188	PRJNA1197996_S_NODE_16259_length_286_cov_2.417840_g16205_i0	PRJNA1197996	16259	286	2.41784	6.9150224	Paenibacillus sp. OSY-SE	1196323	Bacteria	Bacteria	139	4.01e-36	NR	WP_036702797.1	1196323	g16205	i0	69.6	0.965034965034965	92	28	96.5	0	285	10	229	320	WP_036702797.1 open beta-sheet domain-containing protein, partial [Paenibacillus sp. OSY-SE]	diamond	276	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. OSY-SE

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