metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA951388" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA951388" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16237564	16237564	PRJNA951388_S_NODE_2773_length_462_cov_11.519280_g2646_i0	PRJNA951388	2773	462	11.51928	53.2190736	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	176	1.4e-51	NR	MDO9628701.1	1898209	g2646	i0	63.5	1.59090909090909	126	45	81.2	1	4	378	149	274	MDO9628701.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	735	176	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
27474541	27474541	PRJNA951388_S_NODE_10103_length_260_cov_1.390374_g9976_i0	PRJNA951388	10103	260	1.390374	3.6149724	root	1	Root_unresolved	Root_unresolved	81.6	5.62e-16	NR	ACV20892.1	1396	g9976	i0	74.2	3.04615384615385	66	17	76.2	0	19	216	107	172	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	792	81.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27531127	27531127	PRJNA951388_S_NODE_5923_length_348_cov_3.080000_g5796_i0	PRJNA951388	5923	348	3.08	10.7184	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	114	1.05e-26	NR	WP_187150740.1	432608	g5796	i0	75.7	0.603448275862069	70	17	60.3	0	252	43	1152	1221	WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	210	114	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
27664190	27664190	PRJNA951388_S_NODE_4144_length_403_cov_3.696970_g4017_i0	PRJNA951388	4144	403	3.69697	14.8987891	Bacteria	2	Bacteria	Bacteria	58.9	4.18e-7	NR	WP_021800335.1	36845	g4017	i0	34.5	4.68982630272953	113	73	84.1	1	3	341	277	388	WP_021800335.1 threonine ammonia-lyase [Clostridium intestinale]	diamond	1890	58.9	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
27790429	27790429	PRJNA951388_S_NODE_9264_length_274_cov_5.139303_g9137_i0	PRJNA951388	9264	274	5.139303	14.08169022	Bacteria	2	Bacteria	Bacteria	141	1.7e-39	NR	RCK76304.1	2052143	g9137	i0	75.6	21.5583941605839	90	22	98.5	0	4	273	159	248	RCK76304.1 MAG: Phosphoglycerate mutase [Anaerolineae bacterium]	diamond	5907	142	0.992957746478873	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27822071	27822071	PRJNA951388_S_NODE_11284_length_243_cov_2.264706_g11157_i0	PRJNA951388	11284	243	2.264706	5.50323558	root	1	Root_unresolved	Root_unresolved	61.2	1.06e-8	NR	ACV20892.1	1396	g11157	i0	54.4	4.76543209876543	79	36	97.5	0	1	237	153	231	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	1158	61.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
28573050	28573050	PRJNA951388_S_NODE_5487_length_360_cov_5.540070_g5360_i0	PRJNA951388	5487	360	5.54007	19.944252	Salinibacillus aidingensis	237684	Bacteria	Bacteria	44.3	0.0379	NR	WP_343844082.1	237684	g5360	i0	28.9	0.75	90	55	71.7	3	3	260	394	478	WP_343844082.1 hypothetical protein [Salinibacillus aidingensis]	diamond	270	44.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salinibacillus	Salinibacillus aidingensis
28762440	28762440	PRJNA951388_S_NODE_11707_length_236_cov_3.306748_g11580_i0	PRJNA951388	11707	236	3.306748	7.80392528	Mycoplasma wenyonii	65123	Bacteria	Bacteria	74.7	2.94e-14	NR	WP_014849648.1	65123	g11580	i0	49.4	1.02966101694915	81	38	99.2	2	236	3	116	196	WP_014849648.1 hypothetical protein [Mycoplasma wenyonii]	diamond	243	74.7	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
29741045	29741045	PRJNA951388_S_NODE_6890_length_324_cov_2.645418_g6763_i0	PRJNA951388	6890	324	2.645418	8.57115432	Synechococcaceae cyanobacterium SM2_3_2	2720471	Bacteria	Bacteria	43.9	0.00699	NR	NJL98639.1	2720471	g6763	i0	50	0.37037037037037	40	20	37	0	297	178	29	68	NJL98639.1 hypothetical protein [Synechococcaceae cyanobacterium SM2_3_2]	diamond	120	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium SM2_3_2
30405145	30405145	PRJNA951388_S_NODE_1933_length_519_cov_7.130045_g1810_i0	PRJNA951388	1933	519	7.130045	37.00493355	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	78.2	1.37e-13	NR	MBO5113168.1	1898203	g1810	i0	46.7	3.65895953757225	92	46	51.4	1	518	252	222	313	MBO5113168.1 DnaJ domain-containing protein [Lachnospiraceae bacterium]	diamond	1899	78.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30910416	30910416	PRJNA951388_S_NODE_2434_length_482_cov_8.092910_g2308_i0	PRJNA951388	2434	482	8.09291	39.0078262	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	88.2	2.28e-19	NR	MBQ5561215.1	1898203	g2308	i0	40.7	1.1701244813278	86	51	53.5	0	322	65	16	101	MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium]	diamond	564	88.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31352841	31352841	PRJNA951388_S_NODE_8796_length_283_cov_2.200000_g8669_i0	PRJNA951388	8796	283	2.2	6.226	Pseudonocardia nigra	1921578	Bacteria	Bacteria	44.7	0.0122	NR	WP_246632054.1	1921578	g8669	i0	35.2	0.752650176678445	71	44	73.1	1	16	222	91	161	WP_246632054.1 MFS transporter [Pseudonocardia nigra]	diamond	213	44.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia nigra
31352843	31352843	PRJNA951388_S_NODE_9456_length_271_cov_1.555556_g9329_i0	PRJNA951388	9456	271	1.555556	4.21555676	Acutalibacteraceae bacterium	3077420	Bacteria	Bacteria	189	4.5399999999999995e-57	NR	MEE1353258.1	3077420	g9329	i0	100	0.996309963099631	90	0	99.6	0	271	2	57	146	MEE1353258.1 nickel insertion protein [Acutalibacteraceae bacterium]	diamond	270	189	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae		Acutalibacteraceae bacterium
31890424	31890424	PRJNA951388_S_NODE_2897_length_456_cov_2.355091_g2770_i0	PRJNA951388	2897	456	2.355091	10.73921496	Allobacillus	1400133	Bacteria	Bacteria	46.6	0.0148	NR	WP_186279493.1	1400133	g2770	i0	37	0.480263157894737	73	42	45.4	1	182	388	4	76	WP_186279493.1 MULTISPECIES: ATP-dependent DNA helicase DinG [Allobacillus]	diamond	219	46.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Allobacillus
32238807	32238807	PRJNA951388_S_NODE_11498_length_240_cov_2.706587_g11371_i0	PRJNA951388	11498	240	2.706587	6.4958088	Mycoplasma wenyonii	65123	Bacteria	Bacteria	98.2	1.14e-21	NR	WP_112665124.1	65123	g11371	i0	62.7	1.0375	83	28	100	1	240	1	921	1003	WP_112665124.1 DUF3713 domain-containing protein [Mycoplasma wenyonii]	diamond	249	98.2	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32245420	32245420	PRJNA951388_S_NODE_6118_length_343_cov_2.777778_g5991_i0	PRJNA951388	6118	343	2.777778	9.52777854	root	1	Root_unresolved	Root_unresolved	58.5	3.01e-7	NR	WP_013859697.1	1398	g5991	i0	43.3	3.6997084548105	97	27	83.1	2	341	57	35	105	WP_013859697.1 molecular chaperone DnaJ [Heyndrickxia coagulans]	diamond	1269	58.9	0.99320882852292	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia coagulans

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