metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA825466" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA825466" 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
820470	820470	PRJNA825466_P_NODE_4841_length_357_cov_1.309859_g4740_i0	PRJNA825466	4841	357	1.309859	4.67619663	Gemella haemolysans	1379	Bacteria	Bacteria	505	2.16e-138	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g4740	i0	95.584	543.49299719888	317	10	89	2	41	357	11110	11422	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	194027	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
820495	820495	PRJNA825466_P_NODE_9701_length_290_cov_6.281106_g9600_i0	PRJNA825466	9701	290	6.281106	18.2152074	uncultured Streptococcaceae bacterium	208546	Bacteria	Bacteria	442	1.3599999999999998e-119	NTclustered	gi\|2033130571\|gb\|MZ130667.1\|	208546	g9600	i0	94.863	105.744827586207	292	0	96	1	8	284	450	159	Uncultured Streptococcaceae bacterium clone sp10 16S ribosomal RNA gene, partial sequence	blastn	30666	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae		uncultured Streptococcaceae bacterium
1228081	1228081	PRJNA825466_P_NODE_14901_length_258_cov_2.291892_g14800_i0	PRJNA825466	14901	258	2.291892	5.91308136	Staphylococcus	1279	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g14800	i0	100	483.957364341085	258	0	100	0	1	258	708050	708307	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	124861	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
2503658	2503658	PRJNA825466_P_NODE_23962_length_245_cov_0.895349_g23861_i0	PRJNA825466	23962	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g23861	i0	100	80.9836734693878	245	0	100	0	1	245	724881	724637	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	19841	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
3780094	3780094	PRJNA825466_P_NODE_7123_length_317_cov_1.262295_g7022_i0	PRJNA825466	7123	317	1.262295	4.00147515	Bacillales	1385	Bacteria	Bacteria	477	4.129999999999998e-130	NTclustered	gi\|2851089043\|gb\|CP085014.1\|	200991	g7022	i0	94.249	735.738170347003	313	17	98	1	1	312	11401	11713	Planococcus rifietoensis strain SLM-623 chromosome, complete genome	blastn	233229	481	0.991683991683992	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus rifietoensis
3780096	3780096	PRJNA825466_P_NODE_7583_length_311_cov_74.684874_g7482_i0	PRJNA825466	7583	311	74.684874	232.26995814	root	1	Root_unresolved	Root_unresolved	490	5.1999999999999985e-134	NTclustered	gi\|764699802\|gb\|KP005667.1\|	853	g7482	i0	95.695	97.1157556270096	302	7	97	2	4	304	47	343	Faecalibacterium prausnitzii strain CRC_320 16S ribosomal RNA gene, partial sequence	blastn	30203	492	0.995934959349594	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
3780101	3780101	PRJNA825466_P_NODE_9483_length_292_cov_1.584475_g9382_i0	PRJNA825466	9483	292	1.584475	4.626667	root	1	Root_unresolved	Root_unresolved	496	1.04e-135	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g9382	i0	97.26	117.428082191781	292	8	100	0	1	292	626	335	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	34289	501	0.99001996007984	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3780105	3780105	PRJNA825466_S_NODE_1803_length_245_cov_0.895349_g1797_i0	PRJNA825466	1803	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1797	i0	99.592	100	245	1	100	0	1	245	2125514	2125270	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24500	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8473349	8473349	PRJNA825466_P_NODE_26427_length_243_cov_0.905882_g26326_i0	PRJNA825466	26427	243	0.905882	2.20129326	butyrate-producing bacterium SS3/4	245014	Bacteria	Bacteria	163	9.7e-36	NTclustered	gi\|291561105\|emb\|FP929062.1\|	245014	g26326	i0	79.399	0.958847736625514	233	46	95	2	12	243	2404972	2405203	Clostridiales sp. SS3/4 draft genome	blastn	233	163	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			butyrate-producing bacterium SS3/4
8881208	8881208	PRJNA825466_P_NODE_2427_length_460_cov_2.229974_g2326_i0	PRJNA825466	2427	460	2.229974	10.2578804	Staphylococcus	1279	Bacteria	Bacteria	850	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g2326	i0	100	474.45652173913	460	0	100	0	1	460	750861	750402	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	218250	850	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8881209	8881209	PRJNA825466_P_NODE_25187_length_244_cov_0.900585_g25086_i0	PRJNA825466	25187	244	0.900585	2.1974274	Staphylococcus	1279	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2724399046\|gb\|CP128355.1\|	3051183	g25086	i0	100	2	244	0	100	0	1	244	1733588	1733831	Staphylococcus hsinchuensis strain H164 chromosome, complete genome	blastn	488	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hsinchuensis
11024121	11024121	PRJNA825466_P_NODE_14749_length_259_cov_1.645161_g14648_i0	PRJNA825466	14749	259	1.645161	4.26096699	Staphylococcus epidermidis	1282	Bacteria	Bacteria	473	4.25e-129	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g14648	i0	99.614	100	259	1	100	0	1	259	638613	638355	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25900	473	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11024162	11024162	PRJNA825466_P_NODE_28249_length_241_cov_0.916667_g28148_i0	PRJNA825466	28249	241	0.916667	2.20916747	Jeotgalicoccus sp. ATCC 8456	946435	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|1949519824\|gb\|CP066224.1\|	946435	g28148	i0	99.17	1	241	2	100	0	1	241	2084720	2084480	Jeotgalicoccus sp. ATCC 8456 chromosome, complete genome	blastn	241	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. ATCC 8456
11024199	11024199	PRJNA825466_S_NODE_1969_length_242_cov_0.911243_g1963_i0	PRJNA825466	1969	242	0.911243	2.20520806	Clostridium manihotivorum	2320868	Bacteria	Bacteria	368	1.91e-97	NTclustered	gi\|1554469089\|gb\|CP025746.1\|	2320868	g1963	i0	94.191	0.995867768595041	241	14	99	0	1	241	6343583	6343823	Clostridium manihotivorum strain CT4 chromosome, complete genome	blastn	241	368	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium manihotivorum
13573965	13573965	PRJNA825466_P_NODE_1711_length_533_cov_2.073913_g1612_i0	PRJNA825466	1711	533	2.073913	11.05395629	Brevibacillus sp. 7WMA2	2683193	Bacteria	Bacteria	302	4.71e-77	NTclustered	gi\|1810936193\|gb\|CP048799.1\|	2683193	g1612	i0	78.632	5.1031894934334	468	91	93	5	36	494	1418934	1419401	Brevibacillus sp. 7WMA2 chromosome, complete genome	blastn	2720	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus sp. 7WMA2
13574010	13574010	PRJNA825466_P_NODE_28931_length_241_cov_0.916667_g28830_i0	PRJNA825466	28931	241	0.916667	2.20916747	Staphylococcus kloosii	29384	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1370550804\|gb\|CP027846.1\|	29384	g28830	i0	100	96.1078838174274	241	0	100	0	1	241	53745	53985	Staphylococcus kloosii strain ATCC 43959 chromosome, complete genome	blastn	23162	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus kloosii
13981960	13981960	PRJNA825466_P_NODE_23031_length_246_cov_0.890173_g22930_i0	PRJNA825466	23031	246	0.890173	2.18982558	Exiguobacterium	33986	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2047031806\|gb\|CP075897.1\|	41170	g22930	i0	100	7.96747967479675	246	0	100	0	1	246	1184519	1184274	Exiguobacterium acetylicum strain SI17 chromosome, complete genome	blastn	1960	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
13981984	13981984	PRJNA825466_P_NODE_8091_length_306_cov_2.090129_g7990_i0	PRJNA825466	8091	306	2.090129	6.39579474	Bacilli	91061	Bacteria	Bacteria	523	5.0299999999999986e-144	NTclustered	gi\|2842821156\|gb\|CP168672.1\|	1625	g7990	i0	98.973	133.59477124183	292	3	95	0	8	299	261558	261267	Fructilactobacillus sanfranciscensis strain FUA 30088 chromosome	blastn	40880	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
15256200	15256200	PRJNA825466_P_NODE_9152_length_295_cov_2.184685_g9051_i0	PRJNA825466	9152	295	2.184685	6.44482075	root	1	Root_unresolved	Root_unresolved	449	8.310000000000001e-122	NTclustered	gi\|2791978901\|gb\|PQ223219.1\|	1522	g9051	i0	94.881	123.057627118644	293	5	96	1	6	288	758	466	[Clostridium] innocuum strain D9-N-15-8 16S ribosomal RNA gene, partial sequence	blastn	36302	449	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
16123058	16123058	PRJNA825466_P_NODE_5253_length_348_cov_1.072727_g5152_i0	PRJNA825466	5253	348	1.072727	3.73308996	Anaerocolumna sedimenticola	2696063	Bacteria	Bacteria	556	5.73e-154	NTclustered	gi\|1802166926\|gb\|CP048000.1\|	2696063	g5152	i0	95.442	501.462643678161	351	12	100	4	1	348	618797	618448	Anaerocolumna sedimenticola strain CBA3638 chromosome, complete genome	blastn	174509	556	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerocolumna	Anaerocolumna sedimenticola
16530798	16530798	PRJNA825466_P_NODE_21413_length_247_cov_0.885057_g21312_i0	PRJNA825466	21413	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	366	7.02e-97	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g21312	i0	98.551	21.1619433198381	207	3	85	0	40	246	2068343	2068137	Staphylococcus aureus strain WH3018 chromosome	blastn	5227	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19079772	19079772	PRJNA825466_P_NODE_25015_length_244_cov_0.900585_g24914_i0	PRJNA825466	25015	244	0.900585	2.1974274	Streptococcus	1301	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|991821723\|gb\|CP013237.1\|	1309	g24914	i0	100	37.4180327868852	244	0	100	0	1	244	1974600	1974357	Streptococcus mutans strain NG8 isolate Dental Plaque chromosome, complete genome	blastn	9130	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mutans
22497197	22497197	PRJNA825466_P_NODE_29578_length_233_cov_2.175000_g29477_i0	PRJNA825466	29578	233	2.175	5.06775	Gracilibacillus salinarum	2932255	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2221911765\|gb\|CP095071.1\|	2932255	g29477	i0	100	0.120171673819742	28	0	12	0	181	208	4781136	4781163	Gracilibacillus salinarum strain SSPM10-3 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus salinarum
22905709	22905709	PRJNA825466_S_NODE_1758_length_245_cov_0.895349_g1752_i0	PRJNA825466	1758	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g1752	i0	100	23	245	0	100	0	1	245	611972	612216	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	5635	453	1	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);;