metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
2330579	2330579	PRJNA195897_P_NODE_2162_length_345_cov_1.986486_g2129_i0	PRJNA195897	2162	345	1.986486	6.8533767	root	1	Root_unresolved	Root_unresolved	612	1.19e-170	NTclustered	gi\|152002890\|gb\|EF990662.1\|	1308	g2129	i0	98.559	239.489855072464	347	3	100	2	1	345	20	366	Streptococcus thermophilus strain T1 16S ribosomal RNA gene, partial sequence	blastn	82624	612	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
2330589	2330589	PRJNA195897_P_NODE_5702_length_204_cov_1.000000_g5669_i0	PRJNA195897	5702	204	1	2.04	Bacillati	1783272	Bacteria	Bacteria	71.3	4.91e-8	NTclustered	gi\|552063405\|gb\|CP006766.1\|	1399116	g5669	i0	95.556	3.1078431372549	45	0	21	2	140	182	1344820	1344864	Lactococcus lactis subsp. lactis KLDS 4.0325 chromosome, complete genome	blastn	634	71.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
2330592	2330592	PRJNA195897_P_NODE_7362_length_184_cov_1.155556_g7329_i0	PRJNA195897	7362	184	1.155556	2.12622304	Dolosigranulum	29393	Bacteria	Bacteria	335	1.3899999999999996e-87	NTclustered	gi\|2020688450\|gb\|CP040410.1\|	29394	g7329	i0	99.457	148.826086956522	184	1	100	0	1	184	898535	898352	Dolosigranulum pigrum strain KPL3264 chromosome	blastn	27384	335	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
2330595	2330595	PRJNA195897_P_NODE_8102_length_176_cov_1.637795_g8069_i0	PRJNA195897	8102	176	1.637795	2.8825192	Dolosigranulum	29393	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g8069	i0	100	541.573863636364	176	0	100	0	1	176	427339	427514	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	95317	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
4883270	4883270	PRJNA195897_P_NODE_2144_length_348_cov_1.257525_g2111_i0	PRJNA195897	2144	348	1.257525	4.376187	Staphylococcus	1279	Bacteria	Bacteria	599	9.389999999999997e-167	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g2111	i0	97.701	525.005747126437	348	8	100	0	1	348	783634	783287	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	182702	599	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
8019338	8019338	PRJNA195897_P_NODE_1947_length_368_cov_2.282132_g1914_i0	PRJNA195897	1947	368	2.282132	8.39824576	Bacillus mycoides	1405	Bacteria	Bacteria	60.2	2.09e-4	NTclustered	gi\|2049754127\|gb\|CP036116.1\|	1405	g1914	i0	100	1.33423913043478	32	0	9	0	158	189	74393	74362	Bacillus mycoides strain JAS481 plasmid p124	blastn	491	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
11258498	11258498	PRJNA195897_P_NODE_11829_length_163_cov_1.175439_g11796_i0	PRJNA195897	11829	163	1.175439	1.91596557	Streptococcus	1301	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g11796	i0	99.387	328.055214723926	163	1	100	0	1	163	1569364	1569526	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	53473	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
12533945	12533945	PRJNA195897_P_NODE_4590_length_224_cov_1.097143_g4557_i0	PRJNA195897	4590	224	1.097143	2.45760032	Dolosigranulum	29393	Bacteria	Bacteria	403	4.7699999999999995e-108	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g4557	i0	99.107	475.044642857143	224	2	100	0	1	224	428238	428461	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	106410	403	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
13119719	13119719	PRJNA195897_P_NODE_10091_length_167_cov_0.881356_g10058_i0	PRJNA195897	10091	167	0.881356	1.47186452	Lactococcus lactis	1358	Bacteria	Bacteria	71.3	3.87e-8	NTclustered	gi\|552063405\|gb\|CP006766.1\|	1399116	g10058	i0	100	3.67664670658683	38	0	23	0	126	163	1344866	1344829	Lactococcus lactis subsp. lactis KLDS 4.0325 chromosome, complete genome	blastn	614	71.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
13119735	13119735	PRJNA195897_P_NODE_12031_length_163_cov_0.912281_g11998_i0	PRJNA195897	12031	163	0.912281	1.48701803	Peptoniphilus genitalis	3036303	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|2246887130\|gb\|CP097885.1\|	3036303	g11998	i0	92.638	222.300613496933	163	12	100	0	1	163	291792	291954	Peptoniphilus genitalis strain SAHP1 chromosome, complete genome	blastn	36235	235	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus genitalis
13808703	13808703	PRJNA195897_P_NODE_10291_length_166_cov_1.333333_g10258_i0	PRJNA195897	10291	166	1.333333	2.21333278	root	1	Root_unresolved	Root_unresolved	54.7	0.004	NTclustered	gi\|2579552595\|gb\|CP134494.1\|	129985	g10258	i0	100	0.385542168674699	29	0	17	0	92	120	987199	987171	Mesobacillus jeotgali strain PS1 chromosome, complete genome	blastn	64	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus jeotgali
13808704	13808704	PRJNA195897_P_NODE_1451_length_439_cov_2.010256_g1418_i0	PRJNA195897	1451	439	2.010256	8.82502384	Bacillus	1386	Bacteria	Bacteria	795	0	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g1418	i0	99.317	1254.83371298405	439	3	100	0	1	439	12758	13196	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	550872	795	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
14395081	14395081	PRJNA195897_P_NODE_5792_length_203_cov_0.831169_g5759_i0	PRJNA195897	5792	203	0.831169	1.68727307	Lactococcus lactis	1358	Bacteria	Bacteria	73.1	1.36e-8	NTclustered	gi\|552063405\|gb\|CP006766.1\|	1399116	g5759	i0	95.652	3.16256157635468	46	0	22	2	7	50	1344819	1344864	Lactococcus lactis subsp. lactis KLDS 4.0325 chromosome, complete genome	blastn	642	73.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
15668779	15668779	PRJNA195897_P_NODE_3293_length_269_cov_3.481818_g3260_i0	PRJNA195897	3293	269	3.481818	9.36609042	Streptococcus mitis	28037	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2886510793\|emb\|OZ217345.1\|	28037	g3260	i0	100	339	269	0	100	0	1	269	19802	19534	Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1	blastn	91191	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
16357703	16357703	PRJNA195897_P_NODE_10733_length_165_cov_2.241379_g10700_i0	PRJNA195897	10733	165	2.241379	3.69827535	Streptococcus	1301	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g10700	i0	100	336	165	0	100	0	1	165	625483	625319	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	55440	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
16943213	16943213	PRJNA195897_P_NODE_10494_length_166_cov_0.888889_g10461_i0	PRJNA195897	10494	166	0.888889	1.47555574	Streptococcus mitis	28037	Bacteria	Bacteria	263	5.9e-66	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g10461	i0	95.181	98.8072289156626	166	8	100	0	1	166	737598	737433	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	16402	263	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
18906747	18906747	PRJNA195897_P_NODE_6875_length_189_cov_1.485714_g6842_i0	PRJNA195897	6875	189	1.485714	2.80799946	Anaerococcus	165779	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g6842	i0	100	38.2857142857143	189	0	100	0	1	189	436	248	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	7236	350	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
20181343	20181343	PRJNA195897_P_NODE_10476_length_166_cov_0.888889_g10443_i0	PRJNA195897	10476	166	0.888889	1.47555574	Lactiplantibacillus	2767842	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2739945079\|emb\|OZ061611.1\|	1590	g10443	i0	100	100.006024096386	166	0	100	0	1	166	1446246	1446411	Lactiplantibacillus plantarum isolate Lactiplantibacillus plantarum CIRM-BIA2453 genome assembly, chromosome: 1	blastn	16601	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
20181356	20181356	PRJNA195897_P_NODE_4616_length_223_cov_1.385057_g4583_i0	PRJNA195897	4616	223	1.385057	3.08867711	root	1	Root_unresolved	Root_unresolved	412	7.88e-111	NTclustered	gi\|289541377\|gb\|GU395995.1\|	29394	g4583	i0	100	103	223	0	100	0	1	223	749	527	Dolosigranulum pigrum strain 33929-06 16S ribosomal RNA gene, partial sequence	blastn	22969	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
20767487	20767487	PRJNA195897_P_NODE_1477_length_434_cov_1.353247_g1444_i0	PRJNA195897	1477	434	1.353247	5.87309198	Ezakiella coagulans	46507	Bacteria	Bacteria	686	0	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g1444	i0	95.392	444.827188940092	434	15	100	5	1	431	159781	160212	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	193055	686	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
20767513	20767513	PRJNA195897_P_NODE_3477_length_260_cov_1.156398_g3444_i0	PRJNA195897	3477	260	1.156398	3.0066348	Lactobacillus iners	147802	Bacteria	Bacteria	414	2.62e-111	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g3444	i0	95.385	431.811538461538	260	12	100	0	1	260	2411	2152	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	112271	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
20767535	20767535	PRJNA195897_P_NODE_6437_length_194_cov_1.434483_g6404_i0	PRJNA195897	6437	194	1.434483	2.78289702	Ezakiella coagulans	46507	Bacteria	Bacteria	265	1.98e-66	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g6404	i0	96.835	394.448453608247	158	5	81	0	37	194	159113	159270	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	76523	265	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
22042572	22042572	PRJNA195897_P_NODE_1138_length_498_cov_10.795100_g1107_i0	PRJNA195897	1138	498	10.7951	53.759598	Clostridium perfringens	1502	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2029167656\|gb\|CP073070.1\|	1502	g1107	i0	100	0.168674698795181	28	0	6	0	384	411	1708194	1708167	Clostridium perfringens strain 19TSBNCP chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
24007272	24007272	PRJNA195897_P_NODE_1739_length_392_cov_1.638484_g1706_i0	PRJNA195897	1739	392	1.638484	6.42285728	Bacillus	1386	Bacteria	Bacteria	638	2.2599999999999997e-178	NTclustered	gi\|2798377728\|gb\|CP168764.1\|	1392	g1706	i0	96.154	1344.14030612245	390	15	99	0	1	390	29620	29231	Bacillus anthracis strain Z03-J001 chromosome, complete genome	blastn	526903	643	0.992223950233281	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
24007276	24007276	PRJNA195897_P_NODE_4079_length_237_cov_1.382979_g4046_i0	PRJNA195897	4079	237	1.382979	3.27766023	Bacillus	1386	Bacteria	Bacteria	322	1.47e-83	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g4046	i0	99.435	871.915611814346	177	1	75	0	61	237	13537	13361	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	206644	322	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
24592177	24592177	PRJNA195897_P_NODE_10440_length_166_cov_0.888889_g10407_i0	PRJNA195897	10440	166	0.888889	1.47555574	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	63.9	6.42e-6	NTclustered	gi\|2189452932\|gb\|CP091718.1\|	2485925	g10407	i0	95.122	0.5	41	1	25	1	68	108	1587903	1587864	MAG: Oscillospiraceae bacterium isolate nC33_bin.8.fa chromosome	blastn	83	63.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
25281374	25281374	PRJNA195897_P_NODE_1840_length_380_cov_2.978852_g1807_i0	PRJNA195897	1840	380	2.978852	11.3196376	root	1	Root_unresolved	Root_unresolved	680	0	NTclustered	gi\|529813127\|gb\|KF306379.1\|	1292	g1807	i0	98.947	119	380	4	100	0	1	380	1482	1103	Staphylococcus warneri strain y357 16S ribosomal RNA gene, partial sequence	blastn	45220	686	0.991253644314869	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri

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