metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJDB14275" and tax

21 rows where analysis = "blastn", bioproject = "PRJDB14275" 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
1282869	1282869	PRJDB14275_P_NODE_4942_length_228_cov_1.169312_g4883_i0	PRJDB14275	4942	228	1.169312	2.66603136	Salinicoccus halodurans	407035	Bacteria	Bacteria	339	1.3899999999999998e-88	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g4883	i0	93.478	117.5	230	11	99	3	1	226	1914372	1914601	Salinicoccus halodurans strain H3B36, complete genome	blastn	26790	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
1282892	1282892	PRJDB14275_P_NODE_6962_length_171_cov_0.924242_g6903_i0	PRJDB14275	6962	171	0.924242	1.58045382	Streptococcus oralis	1303	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|1878158384\|gb\|CP054134.1\|	1891914	g6903	i0	100	100	171	0	100	0	1	171	602122	601952	Streptococcus oralis subsp. oralis strain SN51445 chromosome	blastn	17100	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
2558498	2558498	PRJDB14275_P_NODE_7823_length_158_cov_1.016807_g7764_i0	PRJDB14275	7823	158	1.016807	1.60655506	Staphylococcus epidermidis	1282	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2180327910\|gb\|CP090991.1\|	1282	g7764	i0	100	108.721518987342	158	0	100	0	1	158	5918	5761	Staphylococcus epidermidis strain 52B plasmid pSE52B-2, complete sequence	blastn	17178	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2558502	2558502	PRJDB14275_P_NODE_8503_length_150_cov_1.054054_g8444_i0	PRJDB14275	8503	150	1.054054	1.581081	Salinicoccus halodurans	407035	Bacteria	Bacteria	239	8.74e-59	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g8444	i0	95.364	626.546666666667	151	6	100	1	1	150	375034	374884	Salinicoccus halodurans strain H3B36, complete genome	blastn	93982	239	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
3834794	3834794	PRJDB14275_P_NODE_4944_length_228_cov_0.962963_g4885_i0	PRJDB14275	4944	228	0.962963	2.19555564	Dolosigranulum pigrum	29394	Bacteria	Bacteria	416	6.259999999999998e-112	NTclustered	gi\|2020672664\|gb\|CP040417.1\|	29394	g4885	i0	99.561	44.0043859649123	228	1	100	0	1	228	575267	575494	Dolosigranulum pigrum strain KPL3077 chromosome	blastn	10033	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
3834827	3834827	PRJDB14275_P_NODE_8004_length_155_cov_1.750000_g7945_i0	PRJDB14275	8004	155	1.75	2.7125	Finegoldia magna	1260	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g7945	i0	100	14.6064516129032	155	0	100	0	1	155	182624	182470	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	2264	287	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
6084256	6084256	PRJDB14275_P_NODE_5085_length_222_cov_2.322404_g5026_i0	PRJDB14275	5085	222	2.322404	5.15573688	Abiotrophia	46123	Bacteria	Bacteria	392	1.0199999999999999e-104	NTclustered	gi\|1848537030\|gb\|CP053988.1\|	46125	g5026	i0	99.537	505.220720720721	216	0	97	1	8	222	863627	863412	Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome	blastn	112159	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Abiotrophia	Abiotrophia defectiva
7660932	7660932	PRJDB14275_P_NODE_6947_length_171_cov_1.242424_g6888_i0	PRJDB14275	6947	171	1.242424	2.12454504	Staphylococcus epidermidis	1282	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2505659350\|gb\|CP118842.1\|	1282	g6888	i0	100	99.9824561403509	171	0	100	0	1	171	151667	151497	Staphylococcus epidermidis strain 7049 chromosome, complete genome	blastn	17097	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8935608	8935608	PRJDB14275_P_NODE_6548_length_179_cov_1.157143_g6489_i0	PRJDB14275	6548	179	1.157143	2.07128597	Finegoldia magna	1260	Bacteria	Bacteria	303	3.79e-78	NTclustered	gi\|1848608259\|gb\|CP054000.1\|	1260	g6489	i0	97.207	5.9776536312849204	179	5	100	0	1	179	598205	598027	Finegoldia magna strain FDAARGOS_764 chromosome, complete genome	blastn	1070	303	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
11486511	11486511	PRJDB14275_P_NODE_5030_length_224_cov_1.983784_g4971_i0	PRJDB14275	5030	224	1.983784	4.44367616	Salinicoccus halodurans	407035	Bacteria	Bacteria	375	1.04e-99	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g4971	i0	96.875	8.97767857142857	224	7	100	0	1	224	550437	550214	Salinicoccus halodurans strain H3B36, complete genome	blastn	2011	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
12460323	12460323	PRJDB14275_P_NODE_7530_length_162_cov_1.308943_g7471_i0	PRJDB14275	7530	162	1.308943	2.12048766	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g7471	i0	100	100	162	0	100	0	1	162	1472066	1472227	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	16200	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12460331	12460331	PRJDB14275_P_NODE_830_length_836_cov_5.494354_g789_i0	PRJDB14275	830	836	5.494354	45.93279944	Streptococcus	1301	Bacteria	Bacteria	1485	0	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g789	i0	99.27	335.648325358852	822	6	98	0	1	822	903377	902556	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	280602	1496	0.992647058823529	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
14036649	14036649	PRJDB14275_P_NODE_4712_length_237_cov_7.338384_g4653_i0	PRJDB14275	4712	237	7.338384	17.39197008	Salinicoccus halodurans	407035	Bacteria	Bacteria	368	1.86e-97	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g4653	i0	97.664	406.177215189873	214	5	90	0	1	214	374500	374287	Salinicoccus halodurans strain H3B36, complete genome	blastn	96264	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
15008937	15008937	PRJDB14275_P_NODE_4092_length_271_cov_1.275862_g4033_i0	PRJDB14275	4092	271	1.275862	3.45758602	Staphylococcus	1279	Bacteria	Bacteria	477	3.4599999999999986e-130	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g4033	i0	98.519	99.6309963099631	270	4	99	0	1	270	2402505	2402236	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	27000	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17860478	17860478	PRJDB14275_P_NODE_6835_length_173_cov_1.208955_g6776_i0	PRJDB14275	6835	173	1.208955	2.09149215	Finegoldia magna	1260	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|1848608259\|gb\|CP054000.1\|	1260	g6776	i0	100	6	173	0	100	0	1	173	197842	197670	Finegoldia magna strain FDAARGOS_764 chromosome, complete genome	blastn	1038	320	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
20107642	20107642	PRJDB14275_P_NODE_6116_length_189_cov_0.806667_g6057_i0	PRJDB14275	6116	189	0.806667	1.52460063	Staphylococcus	1279	Bacteria	Bacteria	331	1.86e-86	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g6057	i0	98.413	101	189	2	100	1	1	189	2173095	2173282	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	19089	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
20107676	20107676	PRJDB14275_P_NODE_8296_length_152_cov_0.867257_g8237_i0	PRJDB14275	8296	152	0.867257	1.31823064	Staphylococcus	1279	Bacteria	Bacteria	265	1.47e-66	NTclustered	gi\|2359411665\|gb\|CP110784.1\|	29388	g8237	i0	98.026	30.1315789473684	152	3	100	0	1	152	2095245	2095396	Staphylococcus capitis strain CCSM0123 chromosome, complete genome	blastn	4580	265	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
23933554	23933554	PRJDB14275_P_NODE_6599_length_177_cov_2.376812_g6540_i0	PRJDB14275	6599	177	2.376812	4.20695724	Bacillati	1783272	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|560878811\|emb\|HF678775.1\|	1371	g6540	i0	100	100	177	0	100	0	1	177	515	339	Marinococcus halophilus partial 16S rRNA gene, isolate BDV4_S4_08a	blastn	17700	327	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus halophilus
24234464	24234464	PRJDB14275_P_NODE_4340_length_256_cov_1.792627_g4281_i0	PRJDB14275	4340	256	1.792627	4.58912512	Anaerococcus sp. WGS1529	3366812	Bacteria	Bacteria	457	4.22e-124	NTclustered	gi\|2831325273\|gb\|CP171112.1\|	3366812	g4281	i0	98.828	86.67578125	256	3	100	0	1	256	663735	663990	Anaerococcus sp. WGS1529 chromosome, complete genome	blastn	22189	457	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1529
24234484	24234484	PRJDB14275_P_NODE_6080_length_189_cov_2.760000_g6021_i0	PRJDB14275	6080	189	2.76	5.2164	Gemella haemolysans	1379	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g6021	i0	99.471	311.587301587302	189	1	100	0	1	189	9702	9514	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	58890	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
25207218	25207218	PRJDB14275_P_NODE_7540_length_162_cov_1.000000_g7481_i0	PRJDB14275	7540	162	1	1.62	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2873239904\|gb\|CP176713.1\|	1280	g7481	i0	100	89.6481481481482	162	0	100	0	1	162	1456	1295	Staphylococcus aureus strain GTVSS-008 plasmid pCFSAN137043_1, complete sequence	blastn	14523	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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