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

16 rows where analysis = "diamond", bioproject = "PRJEB30004" 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
26741469	26741469	PRJEB30004_P_NODE_674801_length_152_cov_2.460177_g659174_i0	PRJEB30004	674801	152	2.460177	3.73946904	Brotocaccenecus	3064194	Bacteria	Bacteria	48.1	1.34e-4	NR	MFQ9103436.1	2485925	g659174	i0	64.7	2.01315789473684	34	12	67.1	0	109	8	1740	1773	MFQ9103436.1 SNF2-related protein [Oscillospiraceae bacterium]	diamond	306	48.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27917597	27917597	PRJEB30004_P_NODE_434625_length_213_cov_1.632184_g418998_i0	PRJEB30004	434625	213	1.632184	3.47655192	Weissella cibaria	137591	Bacteria	Bacteria	144	3.389999999999999e-42	NR	WP_168249942.1	137591	g418998	i0	100	0.971830985915493	69	0	97.2	0	2	208	84	152	WP_168249942.1 condensation domain-containing protein, partial [Weissella cibaria]	diamond	207	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
28580911	28580911	PRJEB30004_P_NODE_477487_length_198_cov_1.867925_g461860_i0	PRJEB30004	477487	198	1.867925	3.6984915	Paenibacillus sacheonensis	742054	Bacteria	Bacteria	57	1.96e-7	NR	WP_161699432.1	742054	g461860	i0	56.4	0.590909090909091	39	17	59.1	0	168	52	169	207	WP_161699432.1 discoidin domain-containing protein [Paenibacillus sacheonensis]	diamond	117	57	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sacheonensis
29243892	29243892	PRJEB30004_P_NODE_637829_length_159_cov_1.708333_g622202_i0	PRJEB30004	637829	159	1.708333	2.71624947	Staphylococcus aureus	1280	Bacteria	Bacteria	60.8	1.79e-10	NR	WP_159314305.1	1280	g622202	i0	100	0.547169811320755	29	0	54.7	0	71	157	1	29	WP_159314305.1 DUF433 domain-containing protein [Staphylococcus aureus]	diamond	87	60.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29685523	29685523	PRJEB30004_P_NODE_366850_length_242_cov_2.807882_g351223_i0	PRJEB30004	366850	242	2.807882	6.79507444	Cohnella abietis	2507935	Bacteria	Bacteria	51.6	2.78e-5	NR	WP_130610497.1	2507935	g351223	i0	43.5	0.570247933884298	46	26	57	0	1	138	841	886	WP_130610497.1 alpha-L-rhamnosidase [Cohnella abietis]	diamond	138	51.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella abietis
30286474	30286474	PRJEB30004_P_NODE_576152_length_172_cov_1.353383_g560525_i0	PRJEB30004	576152	172	1.353383	2.32781876	Streptococcus thermophilus CNCM I-163	1308	Bacteria	Bacteria	77.4	1.88e-16	NR	EHE95058.1	1042404	g560525	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
30665200	30665200	PRJEB30004_P_NODE_658053_length_155_cov_2.534483_g642426_i0	PRJEB30004	658053	155	2.534483	3.92844865	Paenibacillus sacheonensis	742054	Bacteria	Bacteria	52.8	3.25e-6	NR	WP_161693920.1	742054	g642426	i0	61.5	4.29677419354839	52	18	98.7	2	1	153	651	701	WP_161693920.1 DUF642 domain-containing protein [Paenibacillus sacheonensis]	diamond	666	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sacheonensis
31417206	31417206	PRJEB30004_P_NODE_643716_length_158_cov_1.571429_g628089_i0	PRJEB30004	643716	158	1.571429	2.48285782	Bacteria	2	Bacteria	Bacteria	107	3.45e-28	NR	WP_202854023.1	260554	g628089	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
31796541	31796541	PRJEB30004_P_NODE_232977_length_339_cov_1.886667_g217350_i0	PRJEB30004	232977	339	1.886667	6.39580113	Bacteria	2	Bacteria	Bacteria	224	1.66e-71	NR	WP_211182124.1	29388	g217350	i0	100	1.98230088495575	112	0	99.1	0	3	338	153	264	WP_211182124.1 TniQ family protein, partial [Staphylococcus capitis]	diamond	672	224	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
31929765	31929765	PRJEB30004_P_NODE_539277_length_181_cov_1.154930_g523650_i0	PRJEB30004	539277	181	1.15493	2.0904233	Bacillus sp. RHFS1	2804501	Bacteria	Bacteria	114	6.649999999999999e-31	NR	WP_313886385.1	2804501	g523650	i0	100	0.977900552486188	59	0	97.8	0	179	3	42	100	WP_313886385.1 SDR family oxidoreductase, partial [Bacillus sp. RHFS10]	diamond	177	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. RHFS10
32088027	32088027	PRJEB30004_P_NODE_690438_length_150_cov_1.108108_g674811_i0	PRJEB30004	690438	150	1.108108	1.662162	Bacillus halotolerans	260554	Bacteria	Bacteria	98.2	7.18e-25	NR	WP_202853988.1	260554	g674811	i0	100	2	50	0	100	0	1	150	2	51	WP_202853988.1 EAL domain-containing protein, partial [Bacillus halotolerans]	diamond	300	98.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus halotolerans
32341352	32341352	PRJEB30004_P_NODE_207759_length_368_cov_2.151976_g192133_i0	PRJEB30004	207759	368	2.151976	7.91927168	Weissella cibaria	137591	Bacteria	Bacteria	166	2.49e-50	NR	WP_196777297.1	137591	g192133	i0	100	0.676630434782609	83	0	67.7	0	118	366	1	83	WP_196777297.1 hypothetical protein, partial [Weissella cibaria]	diamond	249	166	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
32625525	32625525	PRJEB30004_P_NODE_689780_length_150_cov_1.441441_g674153_i0	PRJEB30004	689780	150	1.441441	2.1621615	Staphylococcus capitis	29388	Bacteria	Bacteria	102	4.55e-26	NR	WP_168993586.1	29388	g674153	i0	100	1	50	0	100	0	150	1	3	52	WP_168993586.1 ISAs1 family transposase, partial [Staphylococcus capitis]	diamond	150	102	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
32650311	32650311	PRJEB30004_P_NODE_590120_length_169_cov_1.261538_g574493_i0	PRJEB30004	590120	169	1.261538	2.13199922	Bacteria	2	Bacteria	Bacteria	91.3	7.09e-23	NR	WP_369122590.1	1496	g574493	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
32656786	32656786	PRJEB30004_P_NODE_682120_length_151_cov_1.767857_g666493_i0	PRJEB30004	682120	151	1.767857	2.66946407	Clostridium perfringens	1502	Bacteria	Bacteria	52.4	4.13e-7	NR	WP_395251611.1	1502	g666493	i0	82.1	1.17218543046358	28	5	55.6	0	150	67	65	92	WP_395251611.1 UDP-3-O-acyl-N-acetylglucosamine deacetylase, partial [Clostridium perfringens]	diamond	177	52.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
32713523	32713523	PRJEB30004_P_NODE_204280_length_373_cov_1.299401_g188656_i0	PRJEB30004	204280	373	1.299401	4.84676573	Bacteria	2	Bacteria	Bacteria	83.6	1.89e-16	NR	MCL5258706.1	1879010	g188656	i0	49.4	2.54959785522788	89	44	70.8	1	29	292	33	121	MCL5258706.1 lactonase family protein [Bacillota bacterium]	diamond	951	83.6	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);;