metadata: contig_metadata: 17 rows where bioproject = "PRJNA401346" and tax

17 rows where bioproject = "PRJNA401346" 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
2356526	2356526	PRJNA401346_P_NODE_5962_length_215_cov_1.084416_g5941_i0	PRJNA401346	5962	215	1.084416	2.3314944	Staphylococcus	1279	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g5941	i0	98.14	538.413953488372	215	4	100	0	1	215	748752	748538	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	115759	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5517909	5517909	PRJNA401346_P_NODE_1525_length_391_cov_0.969697_g1504_i0	PRJNA401346	1525	391	0.969697	3.79151527	Bacillales	1385	Bacteria	Bacteria	187	2.11e-58	NR	WP_381537221.1	1365606	g1504	i0	73	24.2148337595908	126	34	96.7	0	380	3	2	127	WP_381537221.1 nucleoside-diphosphate kinase [Sporosarcina siberiensis]	diamond	9468	187	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina siberiensis
6792030	6792030	PRJNA401346_P_NODE_6806_length_207_cov_1.746575_g6785_i0	PRJNA401346	6806	207	1.746575	3.61541025	Staphylococcus pasteuri	45972	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g6785	i0	100	20.4154589371981	207	0	100	0	1	207	469796	470002	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	4226	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
12559780	12559780	PRJNA401346_P_NODE_8650_length_201_cov_0.914286_g8629_i0	PRJNA401346	8650	201	0.914286	1.83771486	Finegoldia	150022	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g8629	i0	100	7.52238805970149	201	0	100	0	1	201	578326	578526	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	1512	372	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
13834584	13834584	PRJNA401346_P_NODE_3631_length_274_cov_1.948357_g3610_i0	PRJNA401346	3631	274	1.948357	5.33849818	Exiguobacterium	33986	Bacteria	Bacteria	499	7.48e-137	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g3610	i0	99.635	826.091240875912	274	0	100	1	1	274	40983	40711	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	226349	499	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
15717018	15717018	PRJNA401346_P_NODE_7153_length_206_cov_0.882759_g7132_i0	PRJNA401346	7153	206	0.882759	1.81848354	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	359	9.47e-95	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g7132	i0	98.058	5.36407766990291	206	4	100	0	1	206	1990918	1991123	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	1105	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
25307249	25307249	PRJNA401346_P_NODE_8720_length_201_cov_0.914286_g8699_i0	PRJNA401346	8720	201	0.914286	1.83771486	Staphylococcus	1279	Bacteria	Bacteria	359	9.2e-95	NTclustered	gi\|2006240191\|gb\|CP071508.1\|	1283	g8699	i0	99	51.636815920398	200	2	99	0	2	201	1894593	1894792	Staphylococcus haemolyticus strain 7b chromosome, complete genome	blastn	10379	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
26822415	26822415	PRJNA401346_P_NODE_8701_length_201_cov_0.914286_g8680_i0	PRJNA401346	8701	201	0.914286	1.83771486	Pseudoneobacillus sp.	2946553	Bacteria	Bacteria	49.3	1.19e-5	NR	HYK74822.1	2946553	g8680	i0	54.5	2.01492537313433	44	20	65.7	0	133	2	1	44	HYK74822.1 hypothetical protein [Pseudoneobacillus sp.]	diamond	405	49.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pseudoneobacillus	Pseudoneobacillus sp.
27644316	27644316	PRJNA401346_P_NODE_1644_length_378_cov_1.940063_g1623_i0	PRJNA401346	1644	378	1.940063	7.33343814	Trichococcus patagoniensis	382641	Bacteria	Bacteria	92.4	9.25e-22	NR	WP_108033865.1	382641	g1623	i0	60.3	0.579365079365079	73	29	57.9	0	302	84	11	83	WP_108033865.1 hypothetical protein [Trichococcus patagoniensis]	diamond	219	92.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus patagoniensis
27644317	27644317	PRJNA401346_P_NODE_444_length_692_cov_2.041204_g426_i0	PRJNA401346	444	692	2.041204	14.12513168	Vagococcus fluvialis	2738	Bacteria	Bacteria	64.7	7.93e-10	NR	WP_349738039.1	2738	g426	i0	48.2	0.242774566473988	56	29	24.3	0	690	523	22	77	WP_349738039.1 hypothetical protein [Vagococcus fluvialis]	diamond	168	64.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus fluvialis
29145095	29145095	PRJNA401346_P_NODE_8149_length_203_cov_0.901408_g8128_i0	PRJNA401346	8149	203	0.901408	1.82985824	Clostridia	186801	Bacteria	Bacteria	107	7.11e-26	NR	MDK0888501.1	1502	g8128	i0	79.1	1.98029556650246	67	14	99	0	3	203	195	261	MDK0888501.1 Rep family protein [Clostridium perfringens]	diamond	402	108	0.990740740740741	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
29618028	29618028	PRJNA401346_P_NODE_1250_length_424_cov_1.057851_g1229_i0	PRJNA401346	1250	424	1.057851	4.48528824	Bacilli	91061	Bacteria	Bacteria	63.9	4.4e-9	NR	HBM5487342.1	1352	g1229	i0	55.4	1.51415094339623	56	23	39.6	1	1	168	185	238	HBM5487342.1 hypothetical protein [Enterococcus faecium]	diamond	642	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
30439882	30439882	PRJNA401346_P_NODE_6933_length_207_cov_0.876712_g6912_i0	PRJNA401346	6933	207	0.876712	1.81479384	Bacillota	1239	Bacteria	Bacteria	45.4	0.00267	NR	WP_243739978.1	1508390	g6912	i0	40.4	6.44927536231884	47	28	68.1	0	198	58	407	453	WP_243739978.1 translational GTPase TypA [Aureibacillus halotolerans]	diamond	1335	45.8	0.991266375545852	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Aureibacillus	Aureibacillus halotolerans
30675588	30675588	PRJNA401346_P_NODE_6873_length_207_cov_0.876712_g6852_i0	PRJNA401346	6873	207	0.876712	1.81479384	Clostridia bacterium	2044939	Bacteria	Bacteria	53.5	3.54e-6	NR	MBO5954696.1	2044939	g6852	i0	53.1	0.710144927536232	49	19	71	1	206	60	207	251	MBO5954696.1 phage capsid protein [Clostridia bacterium]	diamond	147	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32225239	32225239	PRJNA401346_P_NODE_678_length_558_cov_1.158954_g657_i0	PRJNA401346	678	558	1.158954	6.46696332	Clostridioides difficile	1496	Bacteria	Bacteria	219	5.0299999999999985e-68	NR	WP_207385409.1	1496	g657	i0	59.7	1	186	70	98.9	3	6	557	22	204	WP_207385409.1 hypothetical protein [Clostridioides difficile]	diamond	558	219	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
32257140	32257140	PRJNA401346_P_NODE_2158_length_340_cov_0.917563_g2137_i0	PRJNA401346	2158	340	0.917563	3.1197142	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	79	5.52e-17	NR	MBR3952735.1	2485925	g2137	i0	90.5	0.370588235294118	42	4	37.1	0	338	213	10	51	MBR3952735.1 ribbon-helix-helix protein, CopG family [Oscillospiraceae bacterium]	diamond	126	79	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32793305	32793305	PRJNA401346_P_NODE_4680_length_246_cov_1.037838_g4659_i0	PRJNA401346	4680	246	1.037838	2.55308148	Clostridia bacterium	2044939	Bacteria	Bacteria	60.5	7.12e-10	NR	MBR6050302.1	2044939	g4659	i0	43.7	0.865853658536585	71	34	86.6	1	246	34	16	80	MBR6050302.1 hypothetical protein [Clostridia bacterium]	diamond	213	60.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia 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);;