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

16 rows where analysis = "diamond", bioproject = "PRJNA951412" 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
2210086	2210086	PRJNA951412_P_NODE_4082_length_253_cov_0.866667_g3997_i0	PRJNA951412	4082	253	0.866667	2.19266751	Bacilli	91061	Bacteria	Bacteria	62	2.74e-10	NR	WP_340085477.1	1292	g3997	i0	85.7	2.07509881422925	35	5	41.5	0	148	252	31	65	WP_340085477.1 reverse transcriptase family protein, partial [Staphylococcus warneri]	diamond	525	62	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
14962625	14962625	PRJNA951412_P_NODE_1852_length_337_cov_1.060606_g1767_i0	PRJNA951412	1852	337	1.060606	3.57424222	Streptococcus thermophilus	1308	Bacteria	Bacteria	201	4.96e-58	NR	TKW62483.1	1308	g1767	i0	84.7	0.98813056379822	111	17	98.8	0	3	335	606	716	TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus]	diamond	333	201	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
27221545	27221545	PRJNA951412_P_NODE_7382_length_243_cov_0.917647_g7297_i0	PRJNA951412	7382	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	56.6	4.75e-7	NR	MDE7334292.1	1898203	g7297	i0	50.9	4.35802469135802	57	28	70.4	0	68	238	462	518	MDE7334292.1 carboxypeptidase regulatory-like domain-containing protein [Lachnospiraceae bacterium]	diamond	1059	57	0.992982456140351	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27436674	27436674	PRJNA951412_P_NODE_7723_length_242_cov_0.923077_g7638_i0	PRJNA951412	7723	242	0.923077	2.23384634	Bacillales bacterium	1904864	Bacteria	Bacteria	144	1.91e-42	NR	HET7629728.1	1904864	g7638	i0	92.2	0.954545454545455	77	6	95.5	0	11	241	1	77	HET7629728.1 transcriptional regulator SpxA [Bacillales bacterium]	diamond	231	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales bacterium
27499674	27499674	PRJNA951412_P_NODE_5083_length_250_cov_0.870056_g4998_i0	PRJNA951412	5083	250	0.870056	2.17514	Jeotgalicoccus aerolatus	709510	Bacteria	Bacteria	166	1.57e-45	NR	WP_186089890.1	709510	g4998	i0	100	0.984	82	0	98.4	0	3	248	918	999	WP_186089890.1 DNA polymerase III subunit alpha [Jeotgalicoccus aerolatus]	diamond	246	166	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus aerolatus
28667976	28667976	PRJNA951412_P_NODE_5387_length_249_cov_0.875000_g5302_i0	PRJNA951412	5387	249	0.875	2.17875	Halanaerobacter jeridensis	706427	Bacteria	Bacteria	136	3.3899999999999995e-35	NR	WP_204702437.1	706427	g5302	i0	81.7	0.987951807228916	82	15	98.8	0	247	2	543	624	WP_204702437.1 IGHMBP2 family helicase [Halanaerobacter jeridensis]	diamond	246	136	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halobacteroidaceae	Halanaerobacter	Halanaerobacter jeridensis
28888760	28888760	PRJNA951412_P_NODE_7028_length_244_cov_0.912281_g6943_i0	PRJNA951412	7028	244	0.912281	2.22596564	Jeotgalicoccus halotolerans	157227	Bacteria	Bacteria	112	4.75e-29	NR	WP_115884264.1	157227	g6943	i0	92.2	0.786885245901639	64	5	78.7	0	240	49	144	207	WP_115884264.1 phosphatase PAP2 family protein [Jeotgalicoccus halotolerans]	diamond	192	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus halotolerans
29053399	29053399	PRJNA951412_P_NODE_4988_length_250_cov_0.875706_g4903_i0	PRJNA951412	4988	250	0.875706	2.189265	Lactobacillales	186826	Bacteria	Bacteria	139	2.48e-40	NR	WP_411412503.1	1351	g4903	i0	72.3	16.908	83	23	99.6	0	249	1	12	94	WP_411412503.1 replication initiation protein, partial [Enterococcus faecalis]	diamond	4227	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
29141652	29141652	PRJNA951412_P_NODE_7269_length_244_cov_0.894737_g7184_i0	PRJNA951412	7269	244	0.894737	2.18315828	Halanaerobium congolense	54121	Bacteria	Bacteria	119	6.03e-31	NR	WP_089717047.1	54121	g7184	i0	90.9	0.811475409836066	66	6	81.1	0	45	242	95	160	WP_089717047.1 type II TA system antitoxin MqsA family protein [Halanaerobium congolense]	diamond	198	119	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium congolense
29425388	29425388	PRJNA951412_P_NODE_4369_length_252_cov_0.865922_g4284_i0	PRJNA951412	4369	252	0.865922	2.18212344	Paenibacillus fonticola	379896	Bacteria	Bacteria	100	1.53e-22	NR	WP_019639859.1	379896	g4284	i0	100	0.619047619047619	52	0	61.9	0	192	37	955	1006	WP_019639859.1 hypothetical protein, partial [Paenibacillus fonticola]	diamond	156	100	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus fonticola
29520268	29520268	PRJNA951412_P_NODE_7710_length_242_cov_0.923077_g7625_i0	PRJNA951412	7710	242	0.923077	2.23384634	Dialister invisus	218538	Bacteria	Bacteria	103	2.9299999999999998e-24	NR	WP_007069861.1	218538	g7625	i0	100	0.607438016528926	49	0	60.7	0	95	241	1	49	WP_007069861.1 FAD:protein FMN transferase [Dialister invisus]	diamond	147	103	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Dialister	Dialister invisus
29677849	29677849	PRJNA951412_P_NODE_6610_length_245_cov_0.906977_g6525_i0	PRJNA951412	6610	245	0.906977	2.22209365	Clostridia	186801	Bacteria	Bacteria	70.9	3.71e-12	NR	WP_173734999.1	186801	g6525	i0	43.5	0.844897959183673	69	38	83.3	1	204	1	90	158	WP_173734999.1 MULTISPECIES: hypothetical protein [Clostridia]	diamond	207	70.9	1	Bacteria	Bacillati	Bacillota	Clostridia
29709349	29709349	PRJNA951412_P_NODE_4570_length_251_cov_0.876404_g4485_i0	PRJNA951412	4570	251	0.876404	2.19977404	Bacillus	1386	Bacteria	Bacteria	97.1	2.44e-21	NR	WP_019243377.1	1386	g4485	i0	62.5	4.1593625498008	72	27	86.1	0	32	247	271	342	WP_019243377.1 MULTISPECIES: polysaccharide deacetylase family protein [Bacillus]	diamond	1044	97.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
29842590	29842590	PRJNA951412_P_NODE_5211_length_249_cov_0.886364_g5126_i0	PRJNA951412	5211	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	115	3.45e-29	NR	MBQ7885699.1	2044939	g5126	i0	67.1	15.8072289156626	82	27	98.8	0	3	248	149	230	MBQ7885699.1 bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Clostridia bacterium]	diamond	3936	116	0.991379310344828	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32206940	32206940	PRJNA951412_P_NODE_4978_length_250_cov_0.875706_g4893_i0	PRJNA951412	4978	250	0.875706	2.189265	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	174	3.38e-51	NR	MBZ4670016.1	2485925	g4893	i0	98.8	0.984	82	1	98.4	0	248	3	132	213	MBZ4670016.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	246	174	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32586663	32586663	PRJNA951412_P_NODE_5779_length_248_cov_0.868571_g5694_i0	PRJNA951412	5779	248	0.868571	2.15405608	Anaerococcus	165779	Bacteria	Bacteria	75.1	2.24e-14	NR	WP_117520756.1	165779	g5694	i0	100	0.483870967741935	40	0	48.4	0	127	246	1	40	WP_117520756.1 MULTISPECIES: CPBP family intramembrane glutamic endopeptidase [Anaerococcus]	diamond	120	75.1	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus

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