metadata: contig_metadata: 27 rows where bioproject = "PRJNA672101" and tax

27 rows where bioproject = "PRJNA672101" 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
1918020	1918020	PRJNA672101_S_NODE_19342_length_288_cov_4.646512_g19311_i0	PRJNA672101	19342	288	4.646512	13.38195456	Streptococcus mitis	28037	Bacteria	Bacteria	505	1.7e-138	NTclustered	gi\|927035354\|gb\|CP012646.1\|	28037	g19311	i0	98.264	100.260416666667	288	5	100	0	1	288	848924	849211	Streptococcus mitis strain KCOM 1350 (= ChDC B183), complete genome	blastn	28875	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
4993748	4993748	PRJNA672101_S_NODE_12004_length_332_cov_2.972973_g11973_i0	PRJNA672101	12004	332	2.972973	9.87027036	Streptococcus	1301	Bacteria	Bacteria	569	6.979999999999998e-158	NTclustered	gi\|2886510793\|emb\|OZ217345.1\|	28037	g11973	i0	100	92.7710843373494	308	0	93	0	25	332	1940091	1939784	Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1	blastn	30800	569	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
4993754	4993754	PRJNA672101_S_NODE_17324_length_298_cov_3.053333_g17293_i0	PRJNA672101	17324	298	3.053333	9.09893234	Bacillati	1783272	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g17293	i0	100	510.761744966443	298	0	100	0	1	298	748995	748698	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	152207	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7020382	7020382	PRJNA672101_S_NODE_14206_length_317_cov_1.893443_g14175_i0	PRJNA672101	14206	317	1.893443	6.00221431	Clostridium sp. HCS.1	3238594	Bacteria	Bacteria	176	1.69e-39	NTclustered	gi\|2915616244\|gb\|CP170704.1\|	3238594	g14175	i0	85.976	19.2429022082019	164	23	52	0	108	271	3294369	3294532	Clostridium sp. HCS.1 chromosome, complete genome	blastn	6100	176	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. HCS.1
7543363	7543363	PRJNA672101_S_NODE_18286_length_293_cov_3.500000_g18255_i0	PRJNA672101	18286	293	3.5	10.255	Bacillus	1386	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1368337268\|gb\|CP026678.1\|	1396	g18255	i0	100	6.02047781569966	28	0	10	0	75	102	1747367	1747394	Bacillus cereus strain TG1-6 chromosome, complete genome	blastn	1764	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
7543376	7543376	PRJNA672101_S_NODE_25666_length_261_cov_6.484043_g25635_i0	PRJNA672101	25666	261	6.484043	16.92335223	Clostridia	186801	Bacteria	Bacteria	202	2.2299999999999996e-47	NTclustered	gi\|1243915026\|emb\|LT907978.1\|	39488	g25635	i0	81.467	283.302681992337	259	36	97	11	8	261	276294	276043	[Eubacterium] hallii isolate EH1 genome assembly, chromosome: I	blastn	73942	202	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerobutyricum	Anaerobutyricum hallii
8295192	8295192	PRJNA672101_S_NODE_22887_length_272_cov_4.256281_g22856_i0	PRJNA672101	22887	272	4.256281	11.57708432	Staphylococcus epidermidis	1282	Bacteria	Bacteria	496	9.59e-136	NTclustered	gi\|1518959137\|gb\|CP033782.1\|	1282	g22856	i0	99.631	99.6323529411765	271	1	99	0	2	272	1994494	1994224	Staphylococcus epidermidis strain FDAARGOS_529 chromosome, complete genome	blastn	27100	496	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8295379	8295379	PRJNA672101_S_NODE_34967_length_219_cov_7.842466_g34936_i0	PRJNA672101	34967	219	7.842466	17.17500054	Bacillus sp. Y1	352858	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g34936	i0	100	1113.01369863014	219	0	100	0	1	219	704794	704576	Bacillus sp. Y1 chromosome, complete genome	blastn	243750	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
8295439	8295439	PRJNA672101_S_NODE_8467_length_362_cov_3.048443_g8436_i0	PRJNA672101	8467	362	3.048443	11.03536366	Finegoldia magna	1260	Bacteria	Bacteria	647	0	NTclustered	gi\|2722736583\|dbj\|AP031486.1\|	1260	g8436	i0	98.895	6.95027624309392	362	4	100	0	1	362	338510	338149	Finegoldia magna NBRC 113804 DNA, complete genome: sequence1	blastn	2516	647	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
10094174	10094174	PRJNA672101_S_NODE_4948_length_408_cov_5.913433_g4917_i0	PRJNA672101	4948	408	5.913433	24.12680664	Streptococcus	1301	Bacteria	Bacteria	686	0	NTclustered	gi\|2288405307\|gb\|CP076703.1\|	1335	g4917	i0	100	490.120098039216	371	0	91	0	1	371	19024	19394	Streptococcus equinus strain S1 chromosome, complete genome	blastn	199969	686	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
12120993	12120993	PRJNA672101_S_NODE_14290_length_316_cov_15.534979_g14259_i0	PRJNA672101	14290	316	15.534979	49.09053364	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	405	1.97e-108	NTclustered	gi\|2318985229\|gb\|CP107204.1\|	1898203	g14259	i0	90.127	459.939873417722	314	28	99	2	4	316	51734	51423	MAG: Lachnospiraceae bacterium isolate KR001_MFL_0129 chromosome, complete genome	blastn	145341	405	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
12644840	12644840	PRJNA672101_S_NODE_70_length_1227_cov_42.414211_g61_i0	PRJNA672101	70	1227	42.414211	520.42236897	Clostridium	1485	Bacteria	Bacteria	1903	0	NTclustered	gi\|2260370548\|gb\|CP099799.1\|	1504	g61	i0	95.195	950.980440097799	1207	52	98	4	23	1227	232214	233416	Clostridium septicum strain RMA 8861 chromosome, complete genome	blastn	1166853	1903	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium septicum
13396112	13396112	PRJNA672101_S_NODE_31671_length_244_cov_2.678363_g31640_i0	PRJNA672101	31671	244	2.678363	6.53520572	Streptococcus sanguinis	1305	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1854466684\|gb\|CP054570.1\|	1305	g31640	i0	99.18	99.9754098360656	244	2	100	0	1	244	2001815	2001572	Streptococcus sanguinis strain FDAARGOS_770 chromosome, complete genome	blastn	24394	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
15194093	15194093	PRJNA672101_S_NODE_18512_length_292_cov_2.776256_g18481_i0	PRJNA672101	18512	292	2.776256	8.10666752	root	1	Root_unresolved	Root_unresolved	523	4.769999999999998e-144	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g18481	i0	98.973	126.215753424658	292	3	100	0	1	292	380	671	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	36855	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17220111	17220111	PRJNA672101_S_NODE_3934_length_430_cov_3.747899_g3903_i0	PRJNA672101	3934	430	3.747899	16.1159657	Anaerococcus sp. WGS1596	3366806	Bacteria	Bacteria	219	3.869999999999999e-52	NTclustered	gi\|2831295055\|gb\|CP170995.1\|	3366806	g3903	i0	78.036	0.9	387	57	86	12	9	379	1562769	1563143	Anaerococcus sp. WGS1596 chromosome, complete genome	blastn	387	219	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1596
19017243	19017243	PRJNA672101_S_NODE_8855_length_358_cov_6.792982_g8824_i0	PRJNA672101	8855	358	6.792982	24.31887556	Veillonella	29465	Bacteria	Bacteria	651	0	NTclustered	gi\|2326448795\|gb\|CP110418.1\|	423477	g8824	i0	99.441	49.231843575419	358	2	100	0	1	358	1690242	1690599	Veillonella rogosae strain KCOM 3468 chromosome, complete genome	blastn	17625	651	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
19768611	19768611	PRJNA672101_S_NODE_13996_length_318_cov_5.085714_g13965_i0	PRJNA672101	13996	318	5.085714	16.17257052	Vagococcus carniphilus	218144	Bacteria	Bacteria	100	1.05e-16	NTclustered	gi\|1898528070\|gb\|CP060720.1\|	218144	g13965	i0	75.455	1.93710691823899	220	47	69	5	82	299	672347	672133	Vagococcus carniphilus strain ATCC BAA-640 chromosome, complete genome	blastn	616	100	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus carniphilus
20291939	20291939	PRJNA672101_S_NODE_27916_length_253_cov_1.283333_g27885_i0	PRJNA672101	27916	253	1.283333	3.24683249	Streptococcus	1301	Bacteria	Bacteria	420	5.46e-113	NTclustered	gi\|674114364\|gb\|CP007573.1\|	1328	g27885	i0	99.565	7.25691699604743	230	1	91	0	1	230	168899	168670	Streptococcus anginosus strain SA1, complete genome	blastn	1836	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
21044658	21044658	PRJNA672101_S_NODE_8597_length_361_cov_2.406250_g8566_i0	PRJNA672101	8597	361	2.40625	8.6865625	Anaerococcus nagyae	1755241	Bacteria	Bacteria	634	2.6699999999999993e-177	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g8566	i0	98.338	572.434903047091	361	6	100	0	1	361	121930	121570	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	206649	634	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
23594948	23594948	PRJNA672101_S_NODE_4259_length_422_cov_11.770774_g4228_i0	PRJNA672101	4259	422	11.770774	49.67266628	uncultured Clostridium sp.	59620	Bacteria	Bacteria	643	5.269999999999998e-180	NTclustered	gi\|1899225201\|gb\|MT967673.1\|	59620	g4228	i0	95.739	839.632701421801	399	17	95	0	24	422	2236	1838	Uncultured Clostridium sp. clone asv_172_2236 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	354325	643	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
24868360	24868360	PRJNA672101_S_NODE_7340_length_374_cov_4.112957_g7309_i0	PRJNA672101	7340	374	4.112957	15.38245918	Chryseomicrobium aureum	1441723	Bacteria	Bacteria	658	0	NTclustered	gi\|2831304778\|gb\|CP171117.1\|	1441723	g7309	i0	98.4	87.3823529411765	375	5	100	1	1	374	261131	261505	Chryseomicrobium aureum strain WGS1526 chromosome, complete genome	blastn	32681	658	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Chryseomicrobium	Chryseomicrobium aureum
28692561	28692561	PRJNA672101_S_NODE_15827_length_307_cov_1.470085_g15796_i0	PRJNA672101	15827	307	1.470085	4.51316095	Hydrogenispora ethanolica	1082276	Bacteria	Bacteria	163	8.77e-46	NR	WP_132015865.1	1082276	g15796	i0	71.6	8.96091205211726	102	29	99.7	0	306	1	378	479	WP_132015865.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Hydrogenispora ethanolica]	diamond	2751	163	1	Bacteria	Bacillati	Bacillota				Hydrogenispora	Hydrogenispora ethanolica
28755487	28755487	PRJNA672101_S_NODE_9427_length_353_cov_3.575000_g9396_i0	PRJNA672101	9427	353	3.575	12.61975	Clostridia bacterium	2044939	Bacteria	Bacteria	59.7	1.55e-7	NR	MFA5151318.1	2044939	g9396	i0	34.5	0.713881019830028	84	53	71.4	2	353	102	928	1009	MFA5151318.1 hypothetical protein [Clostridia bacterium]	diamond	252	59.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29639251	29639251	PRJNA672101_S_NODE_13710_length_320_cov_3.380567_g13679_i0	PRJNA672101	13710	320	3.380567	10.8178144	Clostridium botulinum	1491	Bacteria	Bacteria	43.5	0.0329	NR	WP_222652759.1	1491	g13679	i0	51.6	0.871875	93	36	79.7	4	30	284	3	94	WP_222652759.1 hypothetical protein, partial [Clostridium botulinum]	diamond	279	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
31756859	31756859	PRJNA672101_S_NODE_18757_length_291_cov_2.325688_g18726_i0	PRJNA672101	18757	291	2.325688	6.76775208	Eubacteriales bacterium ADMFC1	3385205	Bacteria	Bacteria	49.3	2.93e-4	NR	BFT87137.1	3385205	g18726	i0	33.7	0.917525773195876	89	54	86.6	2	286	35	130	218	BFT87137.1 hypothetical protein ADMFC1_12150 [Eubacteriales bacterium ADMFC1]	diamond	267	49.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium ADMFC1
32610949	32610949	PRJNA672101_S_NODE_29220_length_249_cov_6.238636_g29189_i0	PRJNA672101	29220	249	6.238636	15.53420364	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	160	3.03e-46	NR	HBS92032.1	2049044	g29189	i0	100	0.987951807228916	82	0	98.8	0	3	248	45	126	HBS92032.1 hypothetical protein [Erysipelotrichaceae bacterium]	diamond	246	160	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
32874701	32874701	PRJNA672101_S_NODE_7460_length_373_cov_2.823333_g7429_i0	PRJNA672101	7460	373	2.823333	10.53103209	PVC group	1783257	Bacteria	Bacteria	70.5	3.12e-11	NR	WP_112881966.1	2081970	g7429	i0	38.4	2.67828418230563	112	59	86.1	4	368	48	795	901	WP_112881966.1 UxaA family hydrolase [Paenibacillus montanisoli]	diamond	999	71.2	0.990168539325843	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus montanisoli

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