metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA793147" 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
778089	778089	PRJNA793147_P_NODE_54821_length_232_cov_0.883436_g54555_i0	PRJNA793147	54821	232	0.883436	2.04957152	uncultured Bacilli bacterium	224209	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2729058681\|emb\|OZ006981.1\|	224209	g54555	i0	100	0.487068965517241	29	0	13	0	4	32	1192946	1192918	MAG: uncultured Bacilli bacterium isolate pooled_contig_21585_metaflye_circ MAG genome assembly, chromosome: 1	blastn	113	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli				uncultured Bacilli bacterium
778166	778166	PRJNA793147_P_NODE_58581_length_229_cov_0.900000_g58315_i0	PRJNA793147	58581	229	0.9	2.061	Enterococcus casseliflavus	37734	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|2913646542\|gb\|CP181086.1\|	37734	g58315	i0	99.563	19.9868995633188	229	1	100	0	1	229	29866	29638	Enterococcus casseliflavus strain B6 chromosome, complete genome	blastn	4577	418	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
2491458	2491458	PRJNA793147_P_NODE_56742_length_230_cov_0.894410_g56476_i0	PRJNA793147	56742	230	0.89441	2.057143	Bacillus	1386	Bacteria	Bacteria	420	4.89e-113	NTclustered	gi\|2263617782\|gb\|CP099801.1\|	2026186	g56476	i0	99.565	100	230	1	100	0	1	230	4048101	4048330	Bacillus paranthracis strain SSBC101 chromosome, complete genome	blastn	23000	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
3329325	3329325	PRJNA793147_P_NODE_56703_length_230_cov_0.894410_g56437_i0	PRJNA793147	56703	230	0.89441	2.057143	Streptococcus pseudopneumoniae	257758	Bacteria	Bacteria	392	1.07e-104	NTclustered	gi\|341932553\|gb\|CP002925.1\|	1054460	g56437	i0	97.391	99.4	230	6	100	0	1	230	679813	680042	Streptococcus pseudopneumoniae IS7493, complete genome	blastn	22862	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pseudopneumoniae
3329338	3329338	PRJNA793147_P_NODE_57203_length_230_cov_0.894410_g56937_i0	PRJNA793147	57203	230	0.89441	2.057143	Staphylococcus epidermidis	1282	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|2709261975\|dbj\|AP028322.1\|	1282	g56937	i0	100	99.4608695652174	230	0	100	0	1	230	525921	525692	Staphylococcus epidermidis KSE124-2 DNA, complete genome	blastn	22876	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3767657	3767657	PRJNA793147_P_NODE_42083_length_260_cov_1.293194_g41817_i0	PRJNA793147	42083	260	1.293194	3.3623044	root	1	Root_unresolved	Root_unresolved	470	5.519999999999998e-128	NTclustered	gi\|1572539325\|emb\|LR027876.1\|	1280	g41817	i0	99.231	603.707692307692	260	2	100	0	1	260	343046	343305	Staphylococcus aureus strain JKD6009 genome assembly, chromosome: 1	blastn	156964	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4606502	4606502	PRJNA793147_P_NODE_53724_length_233_cov_0.878049_g53458_i0	PRJNA793147	53724	233	0.878049	2.04585417	Bacillus paranthracis	2026186	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2273391384\|gb\|CP101135.1\|	2026186	g53458	i0	100	100	233	0	100	0	1	233	339693	339925	Bacillus paranthracis strain Bt C4 chromosome, complete genome	blastn	23300	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
5881584	5881584	PRJNA793147_P_NODE_51745_length_234_cov_1.715152_g51479_i0	PRJNA793147	51745	234	1.715152	4.01345568	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	348	2.3900000000000001e-91	NTclustered	gi\|2318985229\|gb\|CP107204.1\|	1898203	g51479	i0	93.562	466.5	233	15	99	0	2	234	51880	51648	MAG: Lachnospiraceae bacterium isolate KR001_MFL_0129 chromosome, complete genome	blastn	109161	348	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
5881667	5881667	PRJNA793147_P_NODE_55525_length_231_cov_0.888889_g55259_i0	PRJNA793147	55525	231	0.888889	2.05333359	Staphylococcus arlettae	29378	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|2045437297\|gb\|CP075522.1\|	29378	g55259	i0	100	6	231	0	100	0	1	231	2406674	2406444	Staphylococcus arlettae strain Colony298 chromosome	blastn	1386	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus arlettae
6319965	6319965	PRJNA793147_P_NODE_46465_length_247_cov_1.438202_g46199_i0	PRJNA793147	46465	247	1.438202	3.55235894	Bacillales	1385	Bacteria	Bacteria	455	1.4600000000000002e-123	NTclustered	gi\|353167274\|gb\|JN656228.1\|	1423	g46199	i0	100	124.493927125506	246	0	99	0	2	247	280	35	Bacillus subtilis strain p185 16S ribosomal RNA gene, partial sequence	blastn	30750	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
6320001	6320001	PRJNA793147_P_NODE_54385_length_232_cov_0.883436_g54119_i0	PRJNA793147	54385	232	0.883436	2.04957152	Enterococcus	1350	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g54119	i0	100	100	232	0	100	0	1	232	2180619	2180388	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	23200	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
8431106	8431106	PRJNA793147_P_NODE_46107_length_248_cov_1.284916_g45841_i0	PRJNA793147	46107	248	1.284916	3.18659168	Enterococcus faecalis	1351	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1633278540\|gb\|CP028836.1\|	1351	g45841	i0	99.597	100.975806451613	248	1	100	0	1	248	76988	77235	Enterococcus faecalis strain FC plasmid unnamed1, complete sequence	blastn	25042	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
8431139	8431139	PRJNA793147_P_NODE_48187_length_242_cov_1.485549_g47921_i0	PRJNA793147	48187	242	1.485549	3.59502858	uncultured Clostridium sp.	59620	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|1899225382\|gb\|MT967846.1\|	59620	g47921	i0	93.802	189.111570247934	242	15	100	0	1	242	2697	2456	Uncultured Clostridium sp. clone asv_345_2923 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45765	364	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
8869141	8869141	PRJNA793147_P_NODE_4987_length_825_cov_4.907407_g4764_i0	PRJNA793147	4987	825	4.907407	40.48610775	Clostridium	1485	Bacteria	Bacteria	54.7	0.023	NTclustered	gi\|2425298477\|gb\|CP114763.1\|	1492	g4764	i0	100	0.738181818181818	29	0	4	0	674	702	3511036	3511064	Clostridium butyricum strain LV1 chromosome 1, complete sequence	blastn	609	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
8869163	8869163	PRJNA793147_P_NODE_53867_length_233_cov_0.878049_g53601_i0	PRJNA793147	53867	233	0.878049	2.04585417	Acetivibrio	35829	Bacteria	Bacteria	315	2.41e-81	NTclustered	gi\|2729058706\|emb\|OZ007006.1\|	172733	g53601	i0	93.396	460.854077253219	212	14	91	0	22	233	735767	735978	MAG: uncultured Eubacteriales bacterium isolate metabat2_pooled_hifiasm.126 MAG genome assembly, chromosome: 1	blastn	107379	315	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			uncultured Eubacteriales bacterium
12695568	12695568	PRJNA793147_P_NODE_39150_length_269_cov_1.245000_g38884_i0	PRJNA793147	39150	269	1.245	3.34905	Enterococcus	1350	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2275345118\|gb\|OM574793.1\|	1351	g38884	i0	100	114.996282527881	269	0	100	0	1	269	37462	37194	Enterococcus faecalis strain HEB2 plasmid pEfae-HEB2-2, complete sequence	blastn	30934	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
13531872	13531872	PRJNA793147_P_NODE_58331_length_229_cov_0.900000_g58065_i0	PRJNA793147	58331	229	0.9	2.061	Bacillus paranthracis	2026186	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|2273391384\|gb\|CP101135.1\|	2026186	g58065	i0	100	99.6026200873362	229	0	100	0	1	229	1210265	1210493	Bacillus paranthracis strain Bt C4 chromosome, complete genome	blastn	22809	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
14806654	14806654	PRJNA793147_P_NODE_50932_length_235_cov_0.867470_g50666_i0	PRJNA793147	50932	235	0.86747	2.0385545	Mammaliicoccus sciuri	1296	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|2624849680\|gb\|CP120194.1\|	1296	g50666	i0	100	91.7829787234043	235	0	100	0	1	235	1811147	1811381	Mammaliicoccus sciuri strain Dog009_1 chromosome, complete genome	blastn	21569	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus sciuri
15244353	15244353	PRJNA793147_P_NODE_43152_length_257_cov_0.920213_g42886_i0	PRJNA793147	43152	257	0.920213	2.36494741	Staphylococcus	1279	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g42886	i0	99.611	42	257	1	100	0	1	257	161688	161432	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10794	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
17356427	17356427	PRJNA793147_P_NODE_51434_length_235_cov_0.867470_g51168_i0	PRJNA793147	51434	235	0.86747	2.0385545	Staphylococcus epidermidis	1282	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g51168	i0	100	100.251063829787	235	0	100	0	1	235	640690	640924	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	23559	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18629570	18629570	PRJNA793147_P_NODE_47175_length_245_cov_1.409091_g46909_i0	PRJNA793147	47175	245	1.409091	3.45227295	Candidatus Limiplasma sp.	2952930	Bacteria	Bacteria	281	2.59e-71	NTclustered	gi\|2621780202\|emb\|OY776489.1\|	2952930	g46909	i0	87.755	366.2	245	25	99	5	3	244	44885	44643	MAG: Candidatus Limiplasma sp. isolate f42c1da1-e33c-4644-afb9-aff4e64e7ad6 genome assembly, chromosome: 1	blastn	89719	281	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Candidatus Limiplasma	Candidatus Limiplasma sp.
19067597	19067597	PRJNA793147_P_NODE_41115_length_263_cov_1.221649_g40849_i0	PRJNA793147	41115	263	1.221649	3.21293687	Staphylococcus	1279	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g40849	i0	100	109	263	0	100	0	1	263	40	302	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	28667	486	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
19904322	19904322	PRJNA793147_P_NODE_22656_length_350_cov_1.088968_g22390_i0	PRJNA793147	22656	350	1.088968	3.811388	Gemella haemolysans	1379	Bacteria	Bacteria	625	1.5499999999999995e-174	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g22390	i0	98.857	507.528571428571	350	4	100	0	1	350	11070	10721	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	177635	625	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
19904396	19904396	PRJNA793147_P_NODE_26696_length_322_cov_1.687747_g26430_i0	PRJNA793147	26696	322	1.687747	5.43454534	Enterococcus faecalis	1351	Bacteria	Bacteria	595	1.1099999999999995e-165	NTclustered	gi\|1963812418\|emb\|LR962775.1\|	1351	g26430	i0	100	100	322	0	100	0	1	322	368513	368834	Enterococcus faecalis isolate 28099_2#75 genome assembly, chromosome: 1	blastn	32200	595	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
20342467	20342467	PRJNA793147_P_NODE_61056_length_227_cov_0.911392_g60790_i0	PRJNA793147	61056	227	0.911392	2.06885984	Streptococcus	1301	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2814310616\|gb\|CP065478.1\|	1308	g60790	i0	100	498.590308370044	227	0	100	0	1	227	1409672	1409898	Streptococcus thermophilus strain 4134 chromosome, complete genome	blastn	113180	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
21180630	21180630	PRJNA793147_P_NODE_53357_length_233_cov_0.878049_g53091_i0	PRJNA793147	53357	233	0.878049	2.04585417	Enterococcus faecalis	1351	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|1963785454\|emb\|LR962428.1\|	1351	g53091	i0	100	100.150214592275	233	0	100	0	1	233	1722820	1723052	Enterococcus faecalis isolate 28157_4#173 genome assembly, chromosome: 1	blastn	23335	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
22893609	22893609	PRJNA793147_P_NODE_54938_length_232_cov_0.883436_g54672_i0	PRJNA793147	54938	232	0.883436	2.04957152	Enterococcus	1350	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|1963786246\|emb\|LR962497.1\|	1351	g54672	i0	100	100	232	0	100	0	1	232	382209	381978	Enterococcus faecalis isolate 28099_2#139 genome assembly, chromosome: 1	blastn	23200	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
22893610	22893610	PRJNA793147_P_NODE_55038_length_232_cov_0.883436_g54772_i0	PRJNA793147	55038	232	0.883436	2.04957152	Bacillus	1386	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|2170506091\|dbj\|AP022878.1\|	1396	g54772	i0	100	24	232	0	100	0	1	232	37928	37697	Bacillus cereus MRY14-0060 plasmid pMRY14-0060_1 DNA, complete sequence	blastn	5568	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
25004695	25004695	PRJNA793147_P_NODE_61940_length_226_cov_0.917197_g61674_i0	PRJNA793147	61940	226	0.917197	2.07286522	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	292	1.0899999999999999e-74	NTclustered	gi\|2189452932\|gb\|CP091718.1\|	2485925	g61674	i0	90	520.08407079646	230	17	100	6	1	226	1766913	1767140	MAG: Oscillospiraceae bacterium isolate nC33_bin.8.fa chromosome	blastn	117539	292	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
25442680	25442680	PRJNA793147_P_NODE_48160_length_242_cov_1.630058_g47894_i0	PRJNA793147	48160	242	1.630058	3.94474036	Enterococcus	1350	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1963838897\|emb\|LR962850.1\|	1351	g47894	i0	100	100	242	0	100	0	1	242	2345566	2345807	Enterococcus faecalis isolate 27688_1#342 genome assembly, chromosome: 1	blastn	24200	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis

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