metadata: contig_metadata: 35 rows where bioproject = "PRJNA397733" and tax

35 rows where bioproject = "PRJNA397733" 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
2355314	2355314	PRJNA397733_S_NODE_13962_length_163_cov_23.462687_g13874_i0	PRJNA397733	13962	163	23.462687	38.24417981	Streptococcus	1301	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g13874	i0	100	316.288343558282	163	0	100	0	1	163	902334	902496	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	51555	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3630685	3630685	PRJNA397733_S_NODE_1083_length_653_cov_38.153846_g1021_i0	PRJNA397733	1083	653	38.153846	249.14461438	Streptococcus	1301	Bacteria	Bacteria	1168	0	NTclustered	gi\|2179899321\|gb\|CP046523.1\|	1303	g1021	i0	98.93	342.179173047473	654	6	100	1	1	653	208195	207542	Streptococcus oralis strain SOD chromosome, complete genome	blastn	223443	1175	0.994042553191489	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3630687	3630687	PRJNA397733_S_NODE_1563_length_516_cov_38.591376_g1482_i0	PRJNA397733	1563	516	38.591376	199.13150016	Streptococcus	1301	Bacteria	Bacteria	948	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g1482	i0	100	351.872093023256	513	0	99	0	4	516	1571613	1571101	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	181566	953	0.994753410283316	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3630689	3630689	PRJNA397733_S_NODE_2883_length_365_cov_41.232143_g2795_i0	PRJNA397733	2883	365	41.232143	150.49732195	Bacillati	1783272	Bacteria	Bacteria	652	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g2795	i0	98.904	546.054794520548	365	4	100	0	1	365	836623	836259	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	199310	656	0.99390243902439	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8732683	8732683	PRJNA397733_S_NODE_1967_length_452_cov_26.955083_g1880_i0	PRJNA397733	1967	452	26.955083	121.83697516	Streptococcus	1301	Bacteria	Bacteria	747	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g1880	i0	96.659	348.809734513274	449	15	99	0	1	449	1571165	1571613	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	157662	752	0.993351063829787	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
10007986	10007986	PRJNA397733_S_NODE_10448_length_186_cov_77.050955_g10360_i0	PRJNA397733	10448	186	77.050955	143.3147763	Streptococcus	1301	Bacteria	Bacteria	339	1.0899999999999998e-88	NTclustered	gi\|909639866\|dbj\|LC068581.1\|	28037	g10360	i0	99.462	102.94623655914	186	1	100	0	1	186	492	677	Streptococcus mitis gene for 16S rRNA, partial sequence, strain: Ora-20	blastn	19148	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
11283131	11283131	PRJNA397733_S_NODE_13989_length_163_cov_3.940299_g13901_i0	PRJNA397733	13989	163	3.940299	6.42268737	Staphylococcus	1279	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g13901	i0	100	100	163	0	100	0	1	163	2335676	2335838	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	16300	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12558624	12558624	PRJNA397733_S_NODE_1570_length_513_cov_34.485537_g1489_i0	PRJNA397733	1570	513	34.485537	176.91080481	Staphylococcus	1279	Bacteria	Bacteria	913	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1489	i0	99.209	538.791423001949	506	4	99	0	1	506	748929	748424	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	276400	913	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12558627	12558627	PRJNA397733_S_NODE_4750_length_279_cov_4.292000_g4662_i0	PRJNA397733	4750	279	4.292	11.97468	Veillonella	29465	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g4662	i0	100	618.853046594982	279	0	100	0	1	279	1031185	1031463	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	172660	516	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
13165884	13165884	PRJNA397733_S_NODE_12591_length_171_cov_4.126761_g12503_i0	PRJNA397733	12591	171	4.126761	7.05676131	Anaerococcus nagyae	1755241	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g12503	i0	100	346.362573099415	171	0	100	0	1	171	122144	121974	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	59228	316	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
13165888	13165888	PRJNA397733_S_NODE_7691_length_217_cov_9.356383_g7603_i0	PRJNA397733	7691	217	9.356383	20.30335111	Gemella haemolysans	1379	Bacteria	Bacteria	399	5.939999999999999e-107	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g7603	i0	100	679.741935483871	216	0	99	0	1	216	11549	11764	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	147504	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
13833397	13833397	PRJNA397733_S_NODE_5011_length_271_cov_3.975207_g4923_i0	PRJNA397733	5011	271	3.975207	10.77281097	Veillonella	29465	Bacteria	Bacteria	492	1.24e-134	NTclustered	gi\|2592626561\|gb\|CP103397.1\|	39777	g4923	i0	100	594.557195571956	266	0	98	0	1	266	1148769	1148504	Veillonella atypica strain G765s_culture10 chromosome, complete genome	blastn	161125	496	0.991935483870968	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
13833399	13833399	PRJNA397733_S_NODE_6871_length_230_cov_24.865672_g6783_i0	PRJNA397733	6871	230	24.865672	57.1910456	root	1	Root_unresolved	Root_unresolved	425	1.05e-114	NTclustered	gi\|2301668455\|gb\|OP432291.1\|	29466	g6783	i0	100	100	230	0	100	0	1	230	932	703	Veillonella parvula strain Granada 16S ribosomal RNA gene, partial sequence	blastn	23000	425	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
14441030	14441030	PRJNA397733_S_NODE_10112_length_189_cov_16.993750_g10024_i0	PRJNA397733	10112	189	16.99375	32.1181875	Granulicatella elegans	137732	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g10024	i0	94.18	479.010582010582	189	11	100	0	1	189	104706	104518	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	90533	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
14441032	14441032	PRJNA397733_S_NODE_1332_length_569_cov_19.857407_g1258_i0	PRJNA397733	1332	569	19.857407	112.98864583	Streptococcus oralis	1303	Bacteria	Bacteria	544	7.6e-150	NTclustered	gi\|288522\|emb\|X68427.1\|	1303	g1258	i0	92.593	230.736379613357	378	28	66	0	1	378	1084	1461	S.oralis gene for 23S rRNA	blastn	131289	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15714810	15714810	PRJNA397733_S_NODE_10993_length_182_cov_3.725490_g10905_i0	PRJNA397733	10993	182	3.72549	6.7803918	Veillonella rogosae	423477	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|2446175566\|gb\|CP117967.1\|	423477	g10905	i0	100	604.456043956044	182	0	100	0	1	182	1145085	1145266	Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome	blastn	110011	337	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
15714811	15714811	PRJNA397733_S_NODE_13773_length_164_cov_14.177778_g13685_i0	PRJNA397733	13773	164	14.177778	23.25155592	Lactobacillus crispatus	47770	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|1543693276\|gb\|CP026503.1\|	47770	g13685	i0	98.171	429.731707317073	164	3	100	0	1	164	77500	77337	Lactobacillus crispatus strain AB70 chromosome, complete genome	blastn	70476	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
16382335	16382335	PRJNA397733_S_NODE_13033_length_169_cov_1.885714_g12945_i0	PRJNA397733	13033	169	1.885714	3.18685666	root	1	Root_unresolved	Root_unresolved	313	5.859999999999999e-81	NTclustered	gi\|568816648\|gb\|KF169798.1\|	1280	g12945	i0	100	1053.54437869822	169	0	100	0	1	169	2763	2931	Staphylococcus aureus strain 40850 class B mec gene cluster, partial sequence	blastn	178049	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16382336	16382336	PRJNA397733_S_NODE_1613_length_506_cov_29.601677_g1489_i1	PRJNA397733	1613	506	29.601677	149.78448562	Staphylococcus	1279	Bacteria	Bacteria	852	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1489	i1	97.036	546.264822134387	506	15	100	0	1	506	748929	748424	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	276410	852	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
16989610	16989610	PRJNA397733_S_NODE_12274_length_173_cov_6.722222_g12186_i0	PRJNA397733	12274	173	6.722222	11.62944406	Gemella haemolysans	1379	Bacteria	Bacteria	318	1.3e-82	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g12186	i0	100	57.2138728323699	172	0	99	0	2	173	9911	9740	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	9898	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
16989613	16989613	PRJNA397733_S_NODE_6954_length_229_cov_4.100000_g6866_i0	PRJNA397733	6954	229	4.1	9.389	Anaerococcus nagyae	1755241	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g6866	i0	99.563	264.694323144105	229	1	100	0	1	229	122868	123096	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	60615	418	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
18263775	18263775	PRJNA397733_S_NODE_10775_length_184_cov_2.800000_g10687_i0	PRJNA397733	10775	184	2.8	5.152	Granulicatella elegans	137732	Bacteria	Bacteria	326	8.37e-85	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g10687	i0	98.901	18.820652173913	182	2	99	0	3	184	105842	106023	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	3463	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
18263779	18263779	PRJNA397733_S_NODE_6135_length_243_cov_11.135514_g6047_i0	PRJNA397733	6135	243	11.135514	27.05929902	Gemella haemolysans	1379	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g6047	i0	98.354	439.991769547325	243	4	100	0	1	243	9764	9522	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	106918	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
18931391	18931391	PRJNA397733_S_NODE_1075_length_657_cov_32.356688_g1013_i0	PRJNA397733	1075	657	32.356688	212.58344016	Staphylococcus	1279	Bacteria	Bacteria	1214	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1013	i0	100	541.059360730594	657	0	100	0	1	657	2278366	2277710	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	355476	1214	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20813732	20813732	PRJNA397733_S_NODE_10977_length_182_cov_4.921569_g10889_i0	PRJNA397733	10977	182	4.921569	8.95725558	Granulicatella elegans	137732	Bacteria	Bacteria	265	1.83e-66	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g10889	i0	96.296	346.010989010989	162	4	88	2	1	161	105353	105193	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	62974	265	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
23364204	23364204	PRJNA397733_S_NODE_4219_length_297_cov_45.899254_g4131_i0	PRJNA397733	4219	297	45.899254	136.32078438	Streptococcus sp. oral taxon E98	712682	Bacteria	Bacteria	544	3.7299999999999996e-150	NTclustered	gi\|285205523\|gb\|GU431396.1\|	712682	g4131	i0	99.663	100.013468013468	297	1	100	0	1	297	337	41	Streptococcus sp. oral taxon E98 clone HK024 16S ribosomal RNA gene, partial sequence	blastn	29704	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. oral taxon E98
24031657	24031657	PRJNA397733_S_NODE_11819_length_176_cov_39.523810_g11731_i0	PRJNA397733	11819	176	39.52381	69.5619056	root	1	Root_unresolved	Root_unresolved	326	7.92e-85	NTclustered	gi\|1851774573\|gb\|MT585552.1\|	1304	g11731	i0	100	100	176	0	100	0	1	176	296	121	Streptococcus salivarius strain 868 16S ribosomal RNA gene, partial sequence	blastn	17600	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
24638525	24638525	PRJNA397733_S_NODE_1340_length_567_cov_19.650558_g1264_i0	PRJNA397733	1340	567	19.650558	111.41866386	Gemella haemolysans	1379	Bacteria	Bacteria	839	0	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g1264	i0	93.474	497.767195767196	567	34	99	3	1	565	735763	735198	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	282234	839	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
27281864	27281864	PRJNA397733_S_NODE_14443_length_161_cov_2.946970_g14355_i0	PRJNA397733	14443	161	2.94697	4.7446217	root	1	Root_unresolved	Root_unresolved	114	1.5599999999999998e-31	NR	WP_407812873.1	1280	g14355	i0	98.1	119.496894409938	53	1	98.8	0	159	1	9	61	WP_407812873.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	19239	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27850074	27850074	PRJNA397733_S_NODE_5144_length_267_cov_26.327731_g5056_i0	PRJNA397733	5144	267	26.327731	70.29504177	root	1	Root_unresolved	Root_unresolved	173	9.44e-54	NR	MDK0657390.1	1502	g5056	i0	98.9	75.2696629213483	87	1	97.8	0	267	7	25	111	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	20097	174	0.994252873563218	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
28370199	28370199	PRJNA397733_S_NODE_14726_length_160_cov_2.099237_g14638_i0	PRJNA397733	14726	160	2.099237	3.3587792	Oscillospiraceae	216572	Bacteria	Bacteria	40.4	0.0345	NR	WP_240286090.1	216572	g14638	i0	33.3	0.61875	33	22	61.9	0	100	2	55	87	WP_240286090.1 MULTISPECIES: hypothetical protein [Oscillospiraceae]	diamond	99	40.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae
31466041	31466041	PRJNA397733_S_NODE_3176_length_347_cov_134.204403_g3088_i0	PRJNA397733	3176	347	134.204403	465.68927841	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	124	1.29e-34	NR	WP_222114562.1	283734	g3088	i0	98.8	1.45244956772334	84	1	72.6	0	71	322	1	84	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	504	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
31482856	31482856	PRJNA397733_S_NODE_8916_length_201_cov_6.000000_g8828_i0	PRJNA397733	8916	201	6	12.06	root	1	Root_unresolved	Root_unresolved	128	5.969999999999999e-37	NR	MDN8740502.1	1280	g8828	i0	98.4	63.0597014925373	64	1	95.5	0	200	9	14	77	MDN8740502.1 Hsp70 family protein [Staphylococcus aureus]	diamond	12675	129	0.992248062015504	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32368662	32368662	PRJNA397733_S_NODE_10859_length_183_cov_5.045455_g10771_i0	PRJNA397733	10859	183	5.045455	9.23318265	root	1	Root_unresolved	Root_unresolved	113	2.5299999999999993e-31	NR	MBG9491866.1	1428	g10771	i0	96.7	62.9508196721311	60	2	98.4	0	182	3	13	72	MBG9491866.1 hypothetical protein [Bacillus thuringiensis]	diamond	11520	113	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
32856406	32856406	PRJNA397733_S_NODE_7300_length_224_cov_2.471795_g7212_i0	PRJNA397733	7300	224	2.471795	5.5368208	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0285	NR	MBQ2512842.1	2044939	g7212	i0	52.9	0.455357142857143	34	14	45.5	1	33	134	204	235	MBQ2512842.1 amidohydrolase family protein [Clostridia bacterium]	diamond	102	42.7	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);;