metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax

13 rows where analysis = "diamond", bioproject = "PRJEB2368" 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
26875268	26875268	PRJEB2368_P_NODE_7081_length_287_cov_3.000000_g6763_i0	PRJEB2368	7081	287	3	8.61	Peptoniphilus lacrimalis	33031	Bacteria	Bacteria	55.1	2.97e-6	NR	WP_019034237.1	33031	g6763	i0	100	0.261324041811847	25	0	26.1	0	286	212	331	355	WP_019034237.1 metallophosphoesterase family protein [Peptoniphilus lacrimalis]	diamond	75	55.1	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus lacrimalis
27823075	27823075	PRJEB2368_P_NODE_10864_length_286_cov_1.646586_g10546_i0	PRJEB2368	10864	286	1.646586	4.70923596	Clostridiales bacterium	1898207	Bacteria	Bacteria	53.1	8.77e-6	NR	MBO6194690.1	1898207	g10546	i0	38.3	0.986013986013986	94	56	98.6	1	3	284	10	101	MBO6194690.1 hypothetical protein [Clostridiales bacterium]	diamond	282	53.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28833226	28833226	PRJEB2368_P_NODE_10188_length_287_cov_1.288000_g9870_i0	PRJEB2368	10188	287	1.288	3.69656	Clostridiales bacterium	1898207	Bacteria	Bacteria	47	2.5e-4	NR	MBE7081568.1	1898207	g9870	i0	80	0.261324041811847	25	5	26.1	0	287	213	34	58	MBE7081568.1 hypothetical protein [Clostridiales bacterium]	diamond	75	47	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29180777	29180777	PRJEB2368_P_NODE_8929_length_287_cov_1.496000_g8611_i0	PRJEB2368	8929	287	1.496	4.29352	Clostridium sp. CAG:356	1262800	Bacteria	Bacteria	43.5	0.0117	NR	CDD36472.1	1262800	g8611	i0	84	0.261324041811847	25	4	26.1	0	212	286	49	73	CDD36472.1 stage III sporulation protein AD [Clostridium sp. CAG:356]	diamond	75	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. CAG:356
29332020	29332020	PRJEB2368_P_NODE_9289_length_287_cov_1.428000_g8971_i0	PRJEB2368	9289	287	1.428	4.09836	Bacillati	1783272	Bacteria	Bacteria	47.8	0.001	NR	WP_025022107.1	396716	g8971	i0	84	1.30662020905923	25	4	26.1	0	286	212	293	317	WP_025022107.1 GMP reductase [Ligilactobacillus hayakitensis]	diamond	375	47.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus hayakitensis
29401599	29401599	PRJEB2368_P_NODE_9449_length_287_cov_1.408000_g9131_i0	PRJEB2368	9449	287	1.408	4.04096	Clostridia bacterium	2044939	Bacteria	Bacteria	59.7	7.18e-8	NR	MBR2468122.1	2044939	g9131	i0	38.9	0.993031358885017	95	38	99.3	1	2	286	1305	1379	MBR2468122.1 hypothetical protein [Clostridia bacterium]	diamond	285	59.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29875310	29875310	PRJEB2368_P_NODE_9271_length_287_cov_1.432000_g8953_i0	PRJEB2368	9271	287	1.432	4.10984	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	49.3	2.95e-4	NR	MDD3368828.1	1898203	g8953	i0	95.8	0.250871080139373	24	1	25.1	0	212	283	13	36	MDD3368828.1 glycosyltransferase [Lachnospiraceae bacterium]	diamond	72	49.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30854610	30854610	PRJEB2368_P_NODE_7394_length_287_cov_2.120000_g7076_i0	PRJEB2368	7394	287	2.12	6.0844	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	52.4	5.05e-6	NR	MDE5966426.1	1898203	g7076	i0	76	0.261324041811847	25	6	26.1	0	2	76	58	82	MDE5966426.1 transcriptional repressor [Lachnospiraceae bacterium]	diamond	75	52.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31012630	31012630	PRJEB2368_P_NODE_9755_length_287_cov_1.364000_g9437_i0	PRJEB2368	9755	287	1.364	3.91468	Marinilactibacillus piezotolerans	258723	Bacteria	Bacteria	68.6	5.1e-11	NR	WP_080146610.1	258723	g9437	i0	46.3	0.993031358885017	95	42	99.3	1	285	1	141	226	WP_080146610.1 flagellar filament capping protein FliD [Marinilactibacillus piezotolerans]	diamond	285	68.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Marinilactibacillus	Marinilactibacillus piezotolerans
31297056	31297056	PRJEB2368_P_NODE_9175_length_287_cov_1.448000_g8857_i0	PRJEB2368	9175	287	1.448	4.15576	Finegoldia magna	1260	Bacteria	Bacteria	51.2	6.49e-5	NR	WP_316515256.1	1260	g8857	i0	100	0.261324041811847	25	0	26.1	0	286	212	569	593	WP_316515256.1 relaxase/mobilization nuclease domain-containing protein [Finegoldia magna]	diamond	75	51.2	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
31328705	31328705	PRJEB2368_P_NODE_15796_length_152_cov_1.095652_g15477_i0	PRJEB2368	15796	152	1.095652	1.66539104	Lactococcus garvieae	1363	Bacteria	Bacteria	61.2	1.92e-10	NR	WP_270228497.1	1363	g15477	i0	96.9	0.631578947368421	32	1	63.2	0	152	57	70	101	WP_270228497.1 ArdC-like ssDNA-binding domain-containing protein [Lactococcus garvieae]	diamond	96	61.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
32024690	32024690	PRJEB2368_P_NODE_8038_length_287_cov_1.760000_g7720_i0	PRJEB2368	8038	287	1.76	5.0512	Streptococcus oralis	1303	Bacteria	Bacteria	48.5	5.82e-4	NR	WP_049504401.1	1303	g7720	i0	95.8	0.250871080139373	24	1	25.1	0	213	284	103	126	WP_049504401.1 glycosyltransferase [Streptococcus oralis]	diamond	72	48.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
32309715	32309715	PRJEB2368_P_NODE_11039_length_286_cov_1.393574_g10721_i0	PRJEB2368	11039	286	1.393574	3.98562164	Mogibacterium sp.	2049035	Bacteria	Bacteria	68.9	1.59e-11	NR	MBR1986842.1	2049035	g10721	i0	38.3	1.20629370629371	115	50	98.6	1	284	3	140	254	MBR1986842.1 pseudouridine-5'-phosphate glycosidase [Mogibacterium sp.]	diamond	345	68.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Mogibacterium	Mogibacterium sp.

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