metadata: contig_metadata: 16 rows where bioproject = "PRJNA1044115" and tax

16 rows where bioproject = "PRJNA1044115" 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
1008798	1008798	PRJNA1044115_P_NODE_31121_length_264_cov_1.225131_g30937_i0	PRJNA1044115	31121	264	1.225131	3.23434584	Streptococcus	1301	Bacteria	Bacteria	472	1.5599999999999998e-128	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g30937	i0	98.864	538.825757575758	264	3	100	0	1	264	1468700	1468963	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	142250	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
2721825	2721825	PRJNA1044115_P_NODE_23723_length_298_cov_3.413333_g23539_i0	PRJNA1044115	23723	298	3.413333	10.17173234	Lactobacillus iners	147802	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g23539	i0	100	519.097315436242	298	0	100	0	1	298	3004	3301	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	154691	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
3559536	3559536	PRJNA1044115_P_NODE_44103_length_204_cov_5.389313_g43919_i0	PRJNA1044115	44103	204	5.389313	10.99419852	Staphylococcus	1279	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|1679580126\|dbj\|LC481680.1\|	1283	g43919	i0	100	110	204	0	100	0	1	204	209	412	Staphylococcus haemolyticus NGB-R38 gene for 16S ribosomal RNA, partial sequence	blastn	22440	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
7386577	7386577	PRJNA1044115_P_NODE_32106_length_260_cov_1.176471_g31922_i0	PRJNA1044115	32106	260	1.176471	3.0588246	Lysinibacillus	400634	Bacteria	Bacteria	200	8e-47	NTclustered	gi\|2733040913\|gb\|CP155468.1\|	1714840	g31922	i0	83.721	123.623076923077	215	32	82	3	48	260	4413611	4413824	Lysinibacillus telephonicus strain FSL R5-0572 chromosome, complete genome	blastn	32142	200	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus telephonicus
9936930	9936930	PRJNA1044115_P_NODE_18288_length_341_cov_2.417910_g18104_i0	PRJNA1044115	18288	341	2.41791	8.2450731	Streptococcus	1301	Bacteria	Bacteria	630	3.2499999999999986e-176	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g18104	i0	100	544.143695014663	341	0	100	0	1	341	162881	163221	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	185553	630	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
9936949	9936949	PRJNA1044115_P_NODE_21948_length_310_cov_3.675105_g21764_i0	PRJNA1044115	21948	310	3.675105	11.3928255	Bacillales	1385	Bacteria	Bacteria	556	5.03e-154	NTclustered	gi\|2505679996\|gb\|CP118820.1\|	1282	g21764	i0	99.032	535.941935483871	310	3	100	0	1	310	2418196	2418505	Staphylococcus epidermidis strain 7057 chromosome, complete genome	blastn	166142	556	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20572481	20572481	PRJNA1044115_P_NODE_22717_length_305_cov_1.732759_g22533_i0	PRJNA1044115	22717	305	1.732759	5.28491495	Lactobacillus iners	147802	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|1818008110\|gb\|CP049223.1\|	147802	g22533	i0	100	493.737704918033	305	0	100	0	1	305	55825	56129	Lactobacillus iners strain C0094A1 chromosome, complete genome	blastn	150590	564	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
21410850	21410850	PRJNA1044115_P_NODE_33517_length_254_cov_2.066298_g33333_i0	PRJNA1044115	33517	254	2.066298	5.24839692	Streptococcus	1301	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|1654254190\|emb\|LR594049.1\|	1302	g33333	i0	99.606	344.007874015748	254	1	100	0	1	254	641127	640874	Streptococcus gordonii strain NCTC10231 genome assembly, chromosome: 1	blastn	87378	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
21410864	21410864	PRJNA1044115_P_NODE_40797_length_243_cov_1.411765_g40613_i0	PRJNA1044115	40797	243	1.411765	3.43058895	Streptococcus	1301	Bacteria	Bacteria	394	3.16e-105	NTclustered	gi\|1780487221\|gb\|CP046335.1\|	28037	g40613	i0	95.885	99.9753086419753	243	10	100	0	1	243	455301	455059	Streptococcus mitis strain FDAARGOS_684 chromosome, complete genome	blastn	24294	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
21848257	21848257	PRJNA1044115_P_NODE_21698_length_312_cov_2.184100_g21514_i0	PRJNA1044115	21698	312	2.1841	6.814392	Streptococcus oralis	1303	Bacteria	Bacteria	542	1.42e-149	NTclustered	gi\|1708318049\|gb\|CP034442.1\|	1458253	g21514	i0	98.077	348.076923076923	312	4	100	2	1	312	1028681	1028990	Streptococcus oralis subsp. dentisani strain F0392 chromosome, complete genome	blastn	108600	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22685687	22685687	PRJNA1044115_P_NODE_5478_length_674_cov_3.633943_g5309_i0	PRJNA1044115	5478	674	3.633943	24.49277582	Staphylococcus	1279	Bacteria	Bacteria	1212	0	NTclustered	gi\|2866855000\|gb\|CP064560.1\|	1282	g5309	i0	99.255	543.413946587537	671	5	99	0	1	671	962776	962106	Staphylococcus epidermidis strain UMCG361 chromosome, complete genome	blastn	366261	1212	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23961221	23961221	PRJNA1044115_P_NODE_6799_length_599_cov_2.406844_g6626_i0	PRJNA1044115	6799	599	2.406844	14.41699556	root	1	Root_unresolved	Root_unresolved	1107	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g6626	i0	100	43.3722871452421	599	0	100	0	1	599	2427100	2426502	Staphylococcus aureus strain WH9628 chromosome	blastn	25980	1107	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
24397652	24397652	PRJNA1044115_P_NODE_40060_length_244_cov_1.532164_g39876_i0	PRJNA1044115	40060	244	1.532164	3.73848016	Staphylococcus epidermidis	1282	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1821213593\|gb\|CP043803.1\|	1282	g39876	i0	100	26.0614754098361	244	0	100	0	1	244	41124	41367	Staphylococcus epidermidis strain SESURV_p3_1362 plasmid unnamed2	blastn	6359	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
26877277	26877277	PRJNA1044115_P_NODE_29841_length_269_cov_1.408163_g29657_i0	PRJNA1044115	29841	269	1.408163	3.78795847	Enterococcus faecalis	1351	Bacteria	Bacteria	115	2.04e-31	NR	WP_375855466.1	1351	g29657	i0	72.7	0.981412639405205	88	24	98.1	0	266	3	1	88	WP_375855466.1 hypothetical protein [Enterococcus faecalis]	diamond	264	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
28930065	28930065	PRJNA1044115_P_NODE_36248_length_250_cov_0.881356_g36064_i0	PRJNA1044115	36248	250	0.881356	2.20339	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	42.4	0.049	NR	MCR4696246.1	1898203	g36064	i0	36.4	0.66	55	35	66	0	171	7	178	232	MCR4696246.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	165	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32280045	32280045	PRJNA1044115_P_NODE_40239_length_244_cov_0.912281_g40055_i0	PRJNA1044115	40239	244	0.912281	2.22596564	Paenibacillus solisilvae	2486751	Bacteria	Bacteria	42	0.0231	NR	WP_379191403.1	2486751	g40055	i0	31.7	0.504098360655738	41	28	50.4	0	20	142	73	113	WP_379191403.1 TM2 domain-containing protein [Paenibacillus solisilvae]	diamond	123	42	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus solisilvae

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