metadata: contig_metadata: 13 rows where bioproject = "PRJNA855894", tax_kingdom = "Bacillati" and tax

13 rows where bioproject = "PRJNA855894", tax_kingdom = "Bacillati" 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
1235042	1235042	PRJNA855894_P_NODE_32081_length_246_cov_0.890173_g31959_i0	PRJNA855894	32081	246	0.890173	2.18982558	Staphylococcus	1279	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g31959	i0	99.593	98.1544715447154	246	1	100	0	1	246	2125659	2125414	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	24146	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
2117586	2117586	PRJNA855894_P_NODE_28482_length_259_cov_1.118280_g28360_i0	PRJNA855894	28482	259	1.11828	2.8963452	Bacillus pseudomycoides	64104	Bacteria	Bacteria	440	4.309999999999998e-119	NTclustered	gi\|753704762\|gb\|CP009651.1\|	64104	g28360	i0	97.297	1205.96525096525	259	7	100	0	1	259	2284185	2284443	Bacillus pseudomycoides strain BTZ chromosome, complete genome	blastn	312345	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pseudomycoides
3393066	3393066	PRJNA855894_P_NODE_34703_length_241_cov_0.916667_g34581_i0	PRJNA855894	34703	241	0.916667	2.20916747	Staphylococcus epidermidis	1282	Bacteria	Bacteria	433	6.63e-117	NTclustered	gi\|2273672934\|gb\|CP101318.1\|	1282	g34581	i0	99.17	5.63485477178423	241	1	100	1	1	241	20109	20348	Staphylococcus epidermidis strain sep1 plasmid pSep1-2, complete sequence	blastn	1358	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3786985	3786985	PRJNA855894_P_NODE_32583_length_245_cov_0.895349_g32461_i0	PRJNA855894	32583	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1042399372\|gb\|KU555869.1\|	28035	g32461	i0	99.592	519.926530612245	245	1	100	0	1	245	944	700	Staphylococcus lugdunensis strain SLG13971-4 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	127382	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lugdunensis
7613058	7613058	PRJNA855894_P_NODE_33606_length_243_cov_0.905882_g33484_i0	PRJNA855894	33606	243	0.905882	2.20129326	Staphylococcus	1279	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g33484	i0	100	90.7366255144033	243	0	100	0	1	243	393303	393061	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	22049	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
9770373	9770373	PRJNA855894_P_NODE_33508_length_243_cov_0.905882_g33386_i0	PRJNA855894	33508	243	0.905882	2.20129326	Anoxybacteroides amylolyticum	294699	Bacteria	Bacteria	420	5.21e-113	NTclustered	gi\|1024277742\|gb\|CP015438.1\|	294699	g33386	i0	98.326	773.835390946502	239	4	98	0	5	243	33725	33963	Anoxybacteroides amylolyticum strain DSM 15939 chromosome, complete genome	blastn	188042	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides amylolyticum
10163496	10163496	PRJNA855894_P_NODE_24728_length_291_cov_0.899083_g24606_i0	PRJNA855894	24728	291	0.899083	2.61633153	Staphylococcus	1279	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g24606	i0	100	545.86941580756	291	0	100	0	1	291	700139	699849	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	158848	538	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12321569	12321569	PRJNA855894_P_NODE_34130_length_242_cov_0.911243_g34008_i0	PRJNA855894	34130	242	0.911243	2.20520806	Enterococcus casseliflavus	37734	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g34008	i0	99.587	20.8057851239669	242	1	100	0	1	242	3017877	3018118	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	5035	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
13988839	13988839	PRJNA855894_P_NODE_29851_length_251_cov_0.865169_g29729_i0	PRJNA855894	29851	251	0.865169	2.17157419	Streptococcus	1301	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2497261172\|gb\|OQ876156.1\|	1306	g29729	i0	99.602	100	251	1	100	0	1	251	271	21	Streptococcus sp. strain PGM706 16S ribosomal RNA gene, partial sequence	blastn	25100	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
21637115	21637115	PRJNA855894_P_NODE_34237_length_242_cov_0.911243_g34115_i0	PRJNA855894	34237	242	0.911243	2.20520806	Lactococcus	1357	Bacteria	Bacteria	279	9.19e-71	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g34115	i0	100	104.545454545455	151	0	100	0	1	151	423965	424115	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	25300	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
22912698	22912698	PRJNA855894_P_NODE_32718_length_245_cov_0.895349_g32596_i0	PRJNA855894	32718	245	0.895349	2.19360505	Streptococcus	1301	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|1539732945\|emb\|LR134283.1\|	1328	g32596	i0	99.59	39.6816326530612	244	1	99	0	1	244	1316897	1316654	Streptococcus anginosus strain NCTC10713 genome assembly, chromosome: 1	blastn	9722	448	0.995535714285714	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
25461669	25461669	PRJNA855894_P_NODE_26720_length_274_cov_1.179104_g26598_i0	PRJNA855894	26720	274	1.179104	3.23074496	Bacillales	1385	Bacteria	Bacteria	289	1.76e-73	NTclustered	gi\|961442200\|gb\|CP013652.1\|	162209	g26598	i0	89.52	744.945255474453	229	23	83	1	44	271	1627	1399	Paenibacillus naphthalenovorans strain 32O-Y chromosome, complete genome	blastn	204115	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus naphthalenovorans
28286563	28286563	PRJNA855894_P_NODE_22986_length_306_cov_1.982833_g22864_i0	PRJNA855894	22986	306	1.982833	6.06746898	Exiguobacterium aurantiacum	33987	Bacteria	Bacteria	47	1.8e-4	NR	WP_233005565.1	33987	g22864	i0	66.7	0.382352941176471	39	13	38.2	0	118	2	26	64	WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum]	diamond	117	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum

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