metadata: contig_metadata: 26 rows where bioproject = "PRJNA474911", tax_kingdom = "Bacillati" and tax

26 rows where bioproject = "PRJNA474911", tax_kingdom = "Bacillati" 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
2372563	2372563	PRJNA474911_P_NODE_4422_length_276_cov_2.093023_g4295_i0	PRJNA474911	4422	276	2.093023	5.77674348	Staphylococcus	1279	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g4295	i0	100	497.003623188406	276	0	100	0	1	276	2166337	2166612	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	137173	510	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
4274600	4274600	PRJNA474911_P_NODE_4704_length_265_cov_1.911765_g4577_i0	PRJNA474911	4704	265	1.911765	5.06617725	Staphylococcus hominis	1290	Bacteria	Bacteria	483	7.249999999999998e-132	NTclustered	gi\|1854288993\|gb\|CP054550.1\|	1290	g4577	i0	99.621	448.316981132075	264	1	99	0	2	265	1094342	1094079	Staphylococcus hominis strain FDAARGOS_661 chromosome, complete genome	blastn	118804	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
4925210	4925210	PRJNA474911_P_NODE_4584_length_270_cov_1.531100_g4457_i0	PRJNA474911	4584	270	1.5311	4.13397	Bacillota	1239	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|2722736583\|dbj\|AP031486.1\|	1260	g4457	i0	100	102.988888888889	270	0	100	0	1	270	632031	631762	Finegoldia magna NBRC 113804 DNA, complete genome: sequence1	blastn	27807	499	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
4925224	4925224	PRJNA474911_P_NODE_7424_length_206_cov_1.579310_g7297_i0	PRJNA474911	7424	206	1.57931	3.2533786	Gemella	1378	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g7297	i0	100	905.902912621359	206	0	100	0	1	206	10307	10512	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	186616	381	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
6200196	6200196	PRJNA474911_P_NODE_3945_length_297_cov_1.084746_g3818_i0	PRJNA474911	3945	297	1.084746	3.22169562	Latilactobacillus	2767885	Bacteria	Bacteria	545	1.04e-150	NTclustered	gi\|1031621101\|gb\|KU317787.1\|	1599	g3818	i0	99.663	169.986531986532	297	1	100	0	1	297	326	30	Lactobacillus sakei strain HC2 16S ribosomal RNA gene, partial sequence	blastn	50486	545	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Latilactobacillus	Latilactobacillus sakei
6200200	6200200	PRJNA474911_P_NODE_5925_length_231_cov_1.223529_g5798_i0	PRJNA474911	5925	231	1.223529	2.82635199	Streptococcus	1301	Bacteria	Bacteria	422	1.37e-113	NTclustered	gi\|2890261556\|gb\|CP177179.1\|	1304	g5798	i0	99.567	558.125541125541	231	1	100	0	1	231	17595	17365	Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome	blastn	128927	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
7475065	7475065	PRJNA474911_P_NODE_2326_length_406_cov_1.527536_g2200_i0	PRJNA474911	2326	406	1.527536	6.20179616	Finegoldia	150022	Bacteria	Bacteria	745	0	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g2200	i0	99.754	379.85960591133	406	1	100	0	1	406	164170	163765	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	154223	745	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
8100723	8100723	PRJNA474911_P_NODE_8067_length_202_cov_1.361702_g7940_i0	PRJNA474911	8067	202	1.361702	2.75063804	Streptococcus sp. D7B5	3038077	Bacteria	Bacteria	285	1.59e-72	NTclustered	gi\|2484075149\|gb\|CP121467.1\|	3038077	g7940	i0	92.118	8.76732673267327	203	14	100	2	1	202	1177012	1177213	Streptococcus sp. D7B5 chromosome, complete genome	blastn	1771	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. D7B5
8750027	8750027	PRJNA474911_P_NODE_6387_length_220_cov_2.012579_g6260_i0	PRJNA474911	6387	220	2.012579	4.4276738	Gemella	1378	Bacteria	Bacteria	407	3.61e-109	NTclustered	gi\|158147915\|emb\|AM779079.1\|	1379	g6260	i0	100	106	220	0	100	0	1	220	227	8	Gemella haemolysans partial 16S rRNA gene, strain F15	blastn	23320	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
10651327	10651327	PRJNA474911_P_NODE_8029_length_202_cov_3.531915_g7902_i0	PRJNA474911	8029	202	3.531915	7.1344683	Macrococcus sp. 21M1142	3395467	Bacteria	Bacteria	141	3.65e-29	NTclustered	gi\|2899131459\|gb\|CP179724.1\|	3395469	g7902	i0	80.423	179.668316831683	189	33	92	4	1	186	1823773	1823586	Macrococcus sp. 21M1142 chromosome, complete genome	blastn	36293	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus sp. 21M1142
12576045	12576045	PRJNA474911_P_NODE_3550_length_316_cov_2.313725_g3424_i0	PRJNA474911	3550	316	2.313725	7.311371	Veillonella	29465	Bacteria	Bacteria	573	5.109999999999998e-159	NTclustered	gi\|1835309918\|emb\|LR778174.1\|	29466	g3424	i0	99.367	494.721518987342	316	2	100	0	1	316	96938	96623	Veillonella parvula strain SKV38 genome assembly, chromosome: 1	blastn	156332	573	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
12576049	12576049	PRJNA474911_P_NODE_4710_length_265_cov_1.598039_g4583_i0	PRJNA474911	4710	265	1.598039	4.23480335	Lactobacillales	186826	Bacteria	Bacteria	267	7.949999999999999e-67	NTclustered	gi\|2889339564\|gb\|CP177124.1\|	2739	g4583	i0	96.296	379.249056603774	162	6	61	0	104	265	580706	580867	Vagococcus salmoninarum strain 2022-01 chromosome, complete genome	blastn	100501	267	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus salmoninarum
13850695	13850695	PRJNA474911_P_NODE_3071_length_345_cov_1.679577_g2945_i0	PRJNA474911	3071	345	1.679577	5.79454065	Veillonella	29465	Bacteria	Bacteria	638	1.97e-178	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g2945	i0	100	266.773913043478	345	0	100	0	1	345	80363	80707	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	92037	638	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
18299190	18299190	PRJNA474911_P_NODE_5555_length_239_cov_2.056180_g5428_i0	PRJNA474911	5555	239	2.05618	4.9142702	Clostridium thermarum	1716543	Bacteria	Bacteria	337	5.299999999999998e-88	NTclustered	gi\|1685740129\|gb\|CP040924.1\|	1716543	g5428	i0	92.083	991.083682008368	240	18	100	1	1	239	156924	157163	Clostridium thermarum strain SYSU GA15002 chromosome, complete genome	blastn	236869	337	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium thermarum
18299202	18299202	PRJNA474911_P_NODE_8135_length_202_cov_0.907801_g8008_i0	PRJNA474911	8135	202	0.907801	1.83375802	Staphylococcus hominis	1290	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|1373834430\|emb\|LT963438.1\|	1290	g8008	i0	99.505	91.4356435643564	202	1	100	0	1	202	2210104	2209903	Staphylococcus hominis isolate Staphylococcus hominis J11 genome assembly, chromosome: I	blastn	18470	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
18948555	18948555	PRJNA474911_P_NODE_5495_length_241_cov_1.350000_g5368_i0	PRJNA474911	5495	241	1.35	3.2535	Streptococcus	1301	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g5368	i0	99.585	544.033195020747	241	1	100	0	1	241	163288	163048	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	131112	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
20223407	20223407	PRJNA474911_P_NODE_4156_length_286_cov_1.422222_g4029_i0	PRJNA474911	4156	286	1.422222	4.06755492	Veillonella	29465	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g4029	i0	100	696.755244755245	286	0	100	0	1	286	1701	1416	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	199272	529	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
20223425	20223425	PRJNA474911_P_NODE_8456_length_194_cov_2.225564_g8329_i0	PRJNA474911	8456	194	2.225564	4.31759416	Abiotrophia	46123	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|1848537030\|gb\|CP053988.1\|	46125	g8329	i0	100	548.046391752577	194	0	100	0	1	194	863421	863614	Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome	blastn	106321	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Abiotrophia	Abiotrophia defectiva
20849262	20849262	PRJNA474911_P_NODE_7377_length_207_cov_0.876712_g7250_i0	PRJNA474911	7377	207	0.876712	1.81479384	Staphylococcus epidermidis	1282	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2709261975\|dbj\|AP028322.1\|	1282	g7250	i0	100	83.8067632850242	207	0	100	0	1	207	1026320	1026526	Staphylococcus epidermidis KSE124-2 DNA, complete genome	blastn	17348	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20849264	20849264	PRJNA474911_P_NODE_7937_length_203_cov_0.901408_g7810_i0	PRJNA474911	7937	203	0.901408	1.82985824	Lachnoanaerobaculum umeaense	617123	Bacteria	Bacteria	364	2e-96	NTclustered	gi\|1721134208\|emb\|LR699010.1\|	617123	g7810	i0	99.02	497.812807881773	204	1	100	1	1	203	1657920	1657717	Lachnoanaerobaculum umeaense isolate MGYG-HGUT-02522 genome assembly, chromosome: 1	blastn	101056	364	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum umeaense
21498902	21498902	PRJNA474911_P_NODE_3157_length_339_cov_2.323741_g3031_i0	PRJNA474911	3157	339	2.323741	7.87748199	Veillonella	29465	Bacteria	Bacteria	616	9.05e-172	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g3031	i0	99.41	544.106194690266	339	2	100	0	1	339	886405	886067	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	184452	621	0.99194847020934	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
21498917	21498917	PRJNA474911_P_NODE_617_length_827_cov_2.088773_g520_i0	PRJNA474911	617	827	2.088773	17.27415271	root	1	Root_unresolved	Root_unresolved	1373	0	NTclustered	gi\|198385243\|gb\|EU918661.1\|	1280	g520	i0	99.866	97.5417170495768	746	1	90	0	82	827	1920	1175	Staphylococcus aureus strain 8797 transposon Tn916-like tetracycline resistance protein (tetM) gene, complete cds	blastn	80667	1373	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
22124089	22124089	PRJNA474911_P_NODE_6758_length_212_cov_4.728477_g6631_i0	PRJNA474911	6758	212	4.728477	10.02437124	Tumebacillus algifaecis	1214604	Bacteria	Bacteria	364	2.109999999999999e-96	NTclustered	gi\|1229072455\|gb\|CP022657.1\|	1214604	g6631	i0	97.653	1049.08490566038	213	4	100	1	1	212	27691	27903	Tumebacillus algifaecis strain THMBR28, complete genome	blastn	222406	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Tumebacillus	Tumebacillus algifaecis
24048982	24048982	PRJNA474911_P_NODE_3839_length_301_cov_0.941667_g3712_i0	PRJNA474911	3839	301	0.941667	2.83441767	Bacillales	1385	Bacteria	Bacteria	409	1.44e-109	NTclustered	gi\|1185663818\|gb\|CP020814.1\|	199441	g3712	i0	91.864	743.594684385382	295	20	97	4	10	301	3535388	3535095	Halalkalibacter krulwichiae strain AM31D chromosome, complete genome	blastn	223822	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halalkalibacter	Halalkalibacter krulwichiae
26918093	26918093	PRJNA474911_P_NODE_7002_length_209_cov_0.864865_g6875_i0	PRJNA474911	7002	209	0.864865	1.80756785	Streptococcus rubneri	1234680	Bacteria	Bacteria	139	3.039999999999999e-38	NR	WP_195563958.1	1234680	g6875	i0	100	0.976076555023923	68	0	97.6	0	207	4	245	312	WP_195563958.1 hypothetical protein [Streptococcus rubneri]	diamond	204	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus rubneri
32036117	32036117	PRJNA474911_P_NODE_7938_length_203_cov_0.901408_g7811_i0	PRJNA474911	7938	203	0.901408	1.82985824	Candidatus Mediterraneibacter norwichensis	2838680	Bacteria	Bacteria	47	6.74e-4	NR	HIV52785.1	2838680	g7811	i0	51	1.49261083743842	49	24	72.4	0	7	153	257	305	HIV52785.1 L-lactate dehydrogenase [Candidatus Mediterraneibacter norwichensis]	diamond	303	47	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Candidatus Mediterraneibacter norwichensis

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