metadata: contig_metadata: 19 rows where bioproject = "PRJNA753112" and tax

19 rows where bioproject = "PRJNA753112" 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
1201471	1201471	PRJNA753112_P_NODE_14001_length_363_cov_1.789655_g13659_i0	PRJNA753112	14001	363	1.789655	6.49644765	Streptococcus	1301	Bacteria	Bacteria	604	2.1099999999999991e-168	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g13659	i0	96.694	332.223140495868	363	12	100	0	1	363	951289	951651	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	120597	604	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3753359	3753359	PRJNA753112_P_NODE_29343_length_252_cov_0.871508_g29001_i0	PRJNA753112	29343	252	0.871508	2.19620016	Lactococcus	1357	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g29001	i0	100	99.9960317460317	252	0	100	0	1	252	728575	728826	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	25199	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
6305559	6305559	PRJNA753112_P_NODE_18465_length_316_cov_1.279835_g18123_i0	PRJNA753112	18465	316	1.279835	4.0442786	Streptococcus	1301	Bacteria	Bacteria	579	1.0999999999999999e-160	NTclustered	gi\|2890261556\|gb\|CP177179.1\|	1304	g18123	i0	99.684	121.927215189873	316	1	100	0	1	316	14967	15282	Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome	blastn	38529	584	0.991438356164384	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
7579641	7579641	PRJNA753112_P_NODE_32386_length_245_cov_0.906977_g32044_i0	PRJNA753112	32386	245	0.906977	2.22209365	Geobacillus	129337	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2529051051\|gb\|CP128453.1\|	1422	g32044	i0	100	29.9632653061224	245	0	100	0	1	245	3339226	3338982	Geobacillus stearothermophilus strain EF60045 chromosome, complete genome	blastn	7341	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
8382368	8382368	PRJNA753112_P_NODE_28707_length_253_cov_1.450000_g28365_i0	PRJNA753112	28707	253	1.45	3.6685	Paenibacillus sp. FSL R5-0912	1536771	Bacteria	Bacteria	457	4.16e-124	NTclustered	gi\|2709743304\|gb\|CP150226.1\|	1536771	g28365	i0	99.209	1123.56126482213	253	2	100	0	1	253	3493357	3493105	Paenibacillus sp. FSL R5-0912 chromosome, complete genome	blastn	284261	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0912
15230356	15230356	PRJNA753112_P_NODE_9672_length_436_cov_911.421488_g9330_i0	PRJNA753112	9672	436	911.421488	3973.79768768	FCB group	1783270	Bacteria	Bacteria	65.8	5.41e-6	NTclustered	gi\|2504358668\|gb\|CP116033.1\|	1517	g9330	i0	97.368	3.78669724770642	38	1	9	0	12	49	807200	807163	Thermoanaerobacterium thermosaccharolyticum strain MJ1 chromosome, complete genome	blastn	1651	65.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
16504558	16504558	PRJNA753112_P_NODE_25593_length_269_cov_4.239796_g25251_i0	PRJNA753112	25593	269	4.239796	11.40505124	Streptococcus	1301	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g25251	i0	100	336	269	0	100	0	1	269	902422	902690	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	90384	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
18580800	18580800	PRJNA753112_P_NODE_24775_length_274_cov_1.184080_g24433_i0	PRJNA753112	24775	274	1.18408	3.2443792	root	1	Root_unresolved	Root_unresolved	72.8	9.77e-13	NR	BAS27306.1	1555112	g24433	i0	48.3	1.88321167883212	87	43	94.2	2	17	274	218	303	BAS27306.1 hypothetical protein LIP_1457 [Limnochorda pilosa]	diamond	516	72.8	1	Bacteria	Bacillati	Bacillota	Limnochordia	Limnochordales	Limnochordaceae	Limnochorda	Limnochorda pilosa
18580802	18580802	PRJNA753112_P_NODE_24935_length_273_cov_1.170000_g24593_i0	PRJNA753112	24935	273	1.17	3.1941	Gemella haemolysans	1379	Bacteria	Bacteria	499	7.45e-137	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g24593	i0	99.634	414.769230769231	273	1	100	0	1	273	9541	9813	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	113232	499	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
19053425	19053425	PRJNA753112_P_NODE_31795_length_246_cov_0.901734_g31453_i0	PRJNA753112	31795	246	0.901734	2.21826564	Heyndrickxia	2837504	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2860284610\|gb\|CP174177.1\|	1398	g31453	i0	100	29	246	0	100	0	1	246	1789218	1789463	Heyndrickxia coagulans strain MRD030 chromosome	blastn	7134	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia coagulans
20328148	20328148	PRJNA753112_P_NODE_30216_length_249_cov_2.528409_g29874_i0	PRJNA753112	30216	249	2.528409	6.29573841	Staphylococcus	1279	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g29874	i0	100	475.465863453815	249	0	100	0	1	249	762192	762440	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	118391	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
21131333	21131333	PRJNA753112_P_NODE_12317_length_386_cov_1.884984_g11975_i0	PRJNA753112	12317	386	1.884984	7.27603824	Gemella haemolysans	1379	Bacteria	Bacteria	708	0	NTclustered	gi\|1829987927\|gb\|CP050965.1\|	1379	g11975	i0	99.741	481.652849740933	386	1	100	0	1	386	1542013	1541628	Gemella haemolysans strain FDAARGOS_740 chromosome	blastn	185918	708	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
21603607	21603607	PRJNA753112_P_NODE_11977_length_392_cov_3.576803_g11635_i0	PRJNA753112	11977	392	3.576803	14.02106776	Bacillales	1385	Bacteria	Bacteria	719	0	NTclustered	gi\|691218329\|gb\|CP009046.1\|	1282	g11635	i0	99.745	511.02806122449	392	1	100	0	1	392	639858	640249	Staphylococcus epidermidis strain SEI, complete genome	blastn	200323	719	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24153266	24153266	PRJNA753112_P_NODE_25739_length_269_cov_1.173469_g25397_i0	PRJNA753112	25739	269	1.173469	3.15663161	Staphylococcus	1279	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g25397	i0	99.628	100	269	1	100	0	1	269	2092594	2092862	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	26900	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
27084552	27084552	PRJNA753112_P_NODE_29302_length_252_cov_0.871508_g28960_i0	PRJNA753112	29302	252	0.871508	2.19620016	Bacilli bacterium	1903720	Bacteria	Bacteria	66.6	1.57e-10	NR	MEG0407679.1	1903720	g28960	i0	53	0.785714285714286	66	30	78.6	1	53	250	144	208	MEG0407679.1 hypothetical protein [Bacilli bacterium]	diamond	198	66.6	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27621707	27621707	PRJNA753112_P_NODE_13724_length_367_cov_1.054422_g13382_i0	PRJNA753112	13724	367	1.054422	3.8697287399999998	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	46.2	0.00865	NR	MBE6951160.1	2485925	g13382	i0	32.9	0.596730245231608	73	48	59.7	1	327	109	17	88	MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	219	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28568711	28568711	PRJNA753112_P_NODE_19207_length_310_cov_1.468354_g18865_i0	PRJNA753112	19207	310	1.468354	4.5518974	Firmicutes bacterium ADurb.Bin193	1852885	Bacteria	Bacteria	48.9	4.62e-4	NR	OQB13730.1	1852885	g18865	i0	54.3	0.338709677419355	35	16	33.9	0	7	111	181	215	OQB13730.1 MAG: KWG Leptospira [Firmicutes bacterium ADurb.Bin193]	diamond	105	48.9	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium ADurb.Bin193
30432441	30432441	PRJNA753112_P_NODE_27313_length_260_cov_1.668449_g26971_i0	PRJNA753112	27313	260	1.668449	4.3379674	Tissierellales bacterium	2053631	Bacteria	Bacteria	46.2	0.00266	NR	MCT4662835.1	2053631	g26971	i0	42.9	0.646153846153846	56	31	64.6	1	6	173	64	118	MCT4662835.1 ATPase, T2SS/T4P/T4SS family [Tissierellales bacterium]	diamond	168	46.2	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales			Tissierellales bacterium
32718003	32718003	PRJNA753112_P_NODE_34560_length_231_cov_2.936709_g34218_i0	PRJNA753112	34560	231	2.936709	6.78379779	Gudongella	2692382	Bacteria	Bacteria	81.6	2.69e-16	NR	MCR3955806.1	2692384	g34218	i0	52.1	2.81818181818182	73	35	94.8	0	222	4	192	264	MCR3955806.1 lysophospholipase [Gudongella sp.]	diamond	651	82	0.995121951219512	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Gudongella	Gudongella sp.

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