metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA881257" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA881257" 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
12337663	12337663	PRJNA881257_P_NODE_13850_length_171_cov_1.278689_g13605_i0	PRJNA881257	13850	171	1.278689	2.18655819	Bacillus cereus	1396	Bacteria	Bacteria	69.3	7.89e-14	NR	WP_367153085.1	1396	g13605	i0	100	0.56140350877193	32	0	56.1	0	171	76	46	77	WP_367153085.1 hypothetical protein, partial [Bacillus cereus]	diamond	96	69.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27284566	27284566	PRJNA881257_P_NODE_13323_length_175_cov_1.500000_g13078_i0	PRJNA881257	13323	175	1.5	2.625	FCB group	1783270	Bacteria	Bacteria	53.1	2.36e-6	NR	WP_187770574.1	1405	g13078	i0	48.2	5.67428571428571	56	29	96	0	171	4	2	57	WP_187770574.1 HNH endonuclease [Bacillus mycoides]	diamond	993	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
27339934	27339934	PRJNA881257_P_NODE_11143_length_196_cov_0.809524_g10898_i0	PRJNA881257	11143	196	0.809524	1.58666704	Melissococcus plutonius	33970	Bacteria	Bacteria	39.7	0.0257	NR	WP_263615054.1	33970	g10898	i0	100	0.229591836734694	15	0	23	0	2	46	4	18	WP_263615054.1 hypothetical protein [Melissococcus plutonius]	diamond	45	39.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius
27403098	27403098	PRJNA881257_P_NODE_18003_length_162_cov_0.920354_g17758_i0	PRJNA881257	18003	162	0.920354	1.49097348	Anaerococcus hydrogenalis	33029	Bacteria	Bacteria	109	2.53e-28	NR	WP_102197840.1	33029	g17758	i0	92.5	0.981481481481482	53	4	98.1	0	3	161	97	149	WP_102197840.1 TVP38/TMEM64 family protein [Anaerococcus hydrogenalis]	diamond	159	109	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus hydrogenalis
27907875	27907875	PRJNA881257_P_NODE_15645_length_166_cov_1.777778_g15400_i0	PRJNA881257	15645	166	1.777778	2.95111148	Ruminococcus sp.	41978	Bacteria	Bacteria	55.5	4.12e-7	NR	MBQ7385171.1	41978	g15400	i0	55.6	0.975903614457831	54	22	97.6	1	164	3	315	366	MBQ7385171.1 ATP-dependent DNA helicase RecG [Ruminococcus sp.]	diamond	162	55.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
29076564	29076564	PRJNA881257_P_NODE_7788_length_253_cov_1.019608_g7543_i0	PRJNA881257	7788	253	1.019608	2.57960824	Roseburia hominis	301301	Bacteria	Bacteria	44.7	0.00203	NR	MCF2641895.1	301301	g7543	i0	38.2	1.19762845849802	55	28	61.7	2	166	11	6	57	MCF2641895.1 thioredoxin fold domain-containing protein [Roseburia hominis]	diamond	303	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia hominis
29202837	29202837	PRJNA881257_P_NODE_17389_length_163_cov_0.912281_g17144_i0	PRJNA881257	17389	163	0.912281	1.48701803	Streptococcus sanguinis	1305	Bacteria	Bacteria	110	1.86e-28	NR	WP_268685714.1	1305	g17144	i0	100	0.993865030674847	54	0	99.4	0	1	162	152	205	WP_268685714.1 HNH endonuclease family protein [Streptococcus sanguinis]	diamond	162	110	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
29368602	29368602	PRJNA881257_P_NODE_12749_length_180_cov_1.587786_g12504_i0	PRJNA881257	12749	180	1.587786	2.8580148	Anaerococcus	165779	Bacteria	Bacteria	100	3.3300000000000003e-26	NR	MDD6918474.1	1891242	g12504	i0	81.4	1.96666666666667	59	11	98.3	0	177	1	20	78	MDD6918474.1 redoxin family protein [Peptoniphilaceae bacterium]	diamond	354	101	0.99009900990099	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae		Peptoniphilaceae bacterium
29929132	29929132	PRJNA881257_P_NODE_18131_length_162_cov_0.920354_g17886_i0	PRJNA881257	18131	162	0.920354	1.49097348	Staphylococcus caprae	29380	Bacteria	Bacteria	69.3	2.95e-12	NR	WP_103212566.1	29380	g17886	i0	68.5	1	54	17	100	0	1	162	177	230	WP_103212566.1 hypothetical protein [Staphylococcus caprae]	diamond	162	69.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus caprae
30000263	30000263	PRJNA881257_P_NODE_12891_length_179_cov_1.338462_g12646_i0	PRJNA881257	12891	179	1.338462	2.39584698	Anaerococcus	165779	Bacteria	Bacteria	102	4.61e-24	NR	WP_115594860.1	165779	g12646	i0	72.9	5.93296089385475	59	16	98.9	0	178	2	242	300	WP_115594860.1 MULTISPECIES: hemolysin family protein [Anaerococcus]	diamond	1062	103	0.990291262135922	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus
30284881	30284881	PRJNA881257_P_NODE_14312_length_169_cov_0.866667_g14067_i0	PRJNA881257	14312	169	0.866667	1.46466723	Candidatus Faecimorpha	2840586	Bacteria	Bacteria	106	2.33e-25	NR	MBQ7915177.1	1879010	g14067	i0	83.6	1.95266272189349	55	9	97.6	0	167	3	251	305	MBQ7915177.1 glycoside hydrolase family 28 protein [Bacillota bacterium]	diamond	330	106	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
30308577	30308577	PRJNA881257_P_NODE_12152_length_186_cov_1.204380_g11907_i0	PRJNA881257	12152	186	1.20438	2.2401468	Clostridia bacterium	2044939	Bacteria	Bacteria	103	6.73e-26	NR	MBR5271034.1	2044939	g11907	i0	80.6	1	62	12	100	0	1	186	98	159	MBR5271034.1 helix-turn-helix domain-containing protein [Clostridia bacterium]	diamond	186	103	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30940146	30940146	PRJNA881257_P_NODE_14934_length_168_cov_0.873950_g14689_i0	PRJNA881257	14934	168	0.87395	1.468236	Bacillota bacterium	1879010	Bacteria	Bacteria	40.8	0.0489	NR	MFO7291371.1	1879010	g14689	i0	57.1	0.625	35	14	60.7	1	126	25	131	165	MFO7291371.1 hypothetical protein [Bacillota bacterium]	diamond	105	40.8	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31066624	31066624	PRJNA881257_P_NODE_16075_length_166_cov_0.888889_g15830_i0	PRJNA881257	16075	166	0.888889	1.47555574	Acutalibacteraceae bacterium	3077420	Bacteria	Bacteria	104	1.0999999999999998e-24	NR	MEE1076817.1	3077420	g15830	i0	98.2	0.993975903614458	55	1	99.4	0	166	2	361	415	MEE1076817.1 signal recognition particle protein [Acutalibacteraceae bacterium]	diamond	165	104	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae		Acutalibacteraceae bacterium
31825151	31825151	PRJNA881257_P_NODE_16477_length_165_cov_0.896552_g16232_i0	PRJNA881257	16477	165	0.896552	1.4793108	Bacillus cereus	1396	Bacteria	Bacteria	47	4.08e-4	NR	MEC2463362.1	1396	g16232	i0	46.9	0.890909090909091	49	25	89.1	1	164	18	361	408	MEC2463362.1 hypothetical protein [Bacillus cereus]	diamond	147	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
32149811	32149811	PRJNA881257_P_NODE_7778_length_253_cov_1.338235_g7533_i0	PRJNA881257	7778	253	1.338235	3.38573455	Bacteria	2	Bacteria	Bacteria	52	2.23e-5	NR	WP_412433729.1	1550024	g7533	i0	38.8	6.58102766798419	67	41	79.4	0	37	237	181	247	WP_412433729.1 ISL3 family transposase [Ruthenibacterium lactatiformans]	diamond	1665	52	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruthenibacterium	Ruthenibacterium lactatiformans
32647242	32647242	PRJNA881257_P_NODE_16020_length_166_cov_0.888889_g15775_i0	PRJNA881257	16020	166	0.888889	1.47555574	Peptoniphilus rhinitidis	1175452	Bacteria	Bacteria	117	1.55e-29	NR	WP_010246929.1	1175452	g15775	i0	100	0.993975903614458	55	0	99.4	0	165	1	195	249	WP_010246929.1 NAD(P)H-dependent oxidoreductase [Peptoniphilus rhinitidis]	diamond	165	117	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus rhinitidis

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