metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB49404" 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
16691609	16691609	PRJEB49404_P_NODE_587454_length_162_cov_1.211382_g573653_i0	PRJEB49404	587454	162	1.211382	1.96243884	Bacteria	2	Bacteria	Bacteria	119	1.12e-33	NR	WP_367153089.1	1396	g573653	i0	98.1	3	54	1	100	0	162	1	26	79	WP_367153089.1 3-keto-5-aminohexanoate cleavage protein, partial [Bacillus cereus]	diamond	486	120	0.991666666666667	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
26653384	26653384	PRJEB49404_P_NODE_556181_length_168_cov_1.868217_g542380_i0	PRJEB49404	556181	168	1.868217	3.13860456	Weissella cibaria	137591	Bacteria	Bacteria	114	9.07e-31	NR	WP_168249942.1	137591	g542380	i0	100	0.982142857142857	55	0	98.2	0	2	166	84	138	WP_168249942.1 condensation domain-containing protein, partial [Weissella cibaria]	diamond	165	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
27065057	27065057	PRJEB49404_P_NODE_483702_length_186_cov_1.829932_g469901_i0	PRJEB49404	483702	186	1.829932	3.40367352	Paenibacillus sacheonensis	742054	Bacteria	Bacteria	57	1.66e-7	NR	WP_161699432.1	742054	g469901	i0	51	0.82258064516129	51	23	82.3	1	156	4	169	217	WP_161699432.1 discoidin domain-containing protein [Paenibacillus sacheonensis]	diamond	153	57	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sacheonensis
28517962	28517962	PRJEB49404_P_NODE_539827_length_172_cov_1.353383_g526026_i0	PRJEB49404	539827	172	1.353383	2.32781876	Streptococcus thermophilus CNCM I-163	1308	Bacteria	Bacteria	77.4	1.88e-16	NR	EHE95058.1	1042404	g526026	i0	97.5	0.697674418604651	40	1	69.8	0	120	1	33	72	EHE95058.1 hypothetical protein STHE1630_00027, partial [Streptococcus thermophilus CNCM I-1630]	diamond	120	77.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
28549660	28549660	PRJEB49404_P_NODE_551267_length_169_cov_1.900000_g537466_i0	PRJEB49404	551267	169	1.9	3.211	Clostridioides difficile	1496	Bacteria	Bacteria	112	3.33e-30	NR	WP_198104585.1	1496	g537466	i0	96.4	0.976331360946746	55	2	97.6	0	167	3	70	124	WP_198104585.1 IS66 family transposase, partial [Clostridioides difficile]	diamond	165	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
28637680	28637680	PRJEB49404_P_NODE_553447_length_169_cov_1.261538_g539646_i0	PRJEB49404	553447	169	1.261538	2.13199922	Bacteria	2	Bacteria	Bacteria	91.3	7.09e-23	NR	WP_369122590.1	1496	g539646	i0	100	2.34319526627219	44	0	78.1	0	168	37	3	46	WP_369122590.1 hypothetical protein [Clostridioides difficile]	diamond	396	91.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29970320	29970320	PRJEB49404_P_NODE_490071_length_184_cov_2.517241_g476270_i0	PRJEB49404	490071	184	2.517241	4.63172344	Cohnella abietis	2507935	Bacteria	Bacteria	51.2	1.76e-5	NR	WP_130610497.1	2507935	g476270	i0	43.5	0.75	46	26	75	0	1	138	841	886	WP_130610497.1 alpha-L-rhamnosidase [Cohnella abietis]	diamond	138	51.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella abietis
30469432	30469432	PRJEB49404_P_NODE_606193_length_158_cov_1.571429_g592392_i0	PRJEB49404	606193	158	1.571429	2.48285782	Bacteria	2	Bacteria	Bacteria	107	3.45e-28	NR	WP_202854023.1	260554	g592392	i0	98.1	1.9746835443038	52	1	98.7	0	156	1	69	120	WP_202854023.1 hypothetical protein, partial [Bacillus halotolerans]	diamond	312	108	0.990740740740741	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus halotolerans
32208170	32208170	PRJEB49404_P_NODE_211098_length_339_cov_1.640000_g197299_i0	PRJEB49404	211098	339	1.64	5.5596	Bacteria	2	Bacteria	Bacteria	224	1.66e-71	NR	WP_211182124.1	29388	g197299	i0	100	1.98230088495575	112	0	99.1	0	337	2	153	264	WP_211182124.1 TniQ family protein, partial [Staphylococcus capitis]	diamond	672	224	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
32720357	32720357	PRJEB49404_P_NODE_297800_length_265_cov_2.061947_g283999_i0	PRJEB49404	297800	265	2.061947	5.46415955	Bacillota bacterium	1879010	Bacteria	Bacteria	43.1	0.0355	NR	MFO8059428.1	1879010	g283999	i0	32.3	0.735849056603774	65	42	73.6	1	46	240	317	379	MFO8059428.1 penicillin-binding transpeptidase domain-containing protein [Bacillota bacterium]	diamond	195	43.1	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium

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