metadata: contig_metadata: 17 rows where bioproject = "PRJNA400171" and tax

17 rows where bioproject = "PRJNA400171" 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
1688525	1688525	PRJNA400171_S_NODE_2602_length_248_cov_2.684932_g2512_i0	PRJNA400171	2602	248	2.684932	6.65863136	Staphylococcus epidermidis	1282	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g2512	i0	99.194	487.016129032258	248	2	100	0	1	248	1785375	1785622	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	120780	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7458921	7458921	PRJNA400171_S_NODE_6946_length_171_cov_2.992958_g6856_i0	PRJNA400171	6946	171	2.992958	5.11795818	Staphylococcus	1279	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g6856	i0	100	547.87134502924	171	0	100	0	1	171	969467	969637	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	93686	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
10617715	10617715	PRJNA400171_S_NODE_589_length_403_cov_3.114973_g499_i0	PRJNA400171	589	403	3.114973	12.55334119	Paenibacillus sp. FSL H8-	58172	Bacteria	Bacteria	69.3	1.1e-10	NR	WP_341154791.1	2954671	g499	i0	62.7	1.16873449131514	51	19	38	0	392	240	147	197	WP_341154791.1 dockerin type I domain-containing protein [Paenibacillus sp. FSL H8-0034]	diamond	471	69.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H8-0034
17658534	17658534	PRJNA400171_S_NODE_3454_length_223_cov_2.891753_g3364_i0	PRJNA400171	3454	223	2.891753	6.44860919	Staphylococcus	1279	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3364	i0	100	531.484304932735	223	0	100	0	1	223	748662	748440	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	118521	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18932485	18932485	PRJNA400171_S_NODE_7895_length_162_cov_2.774436_g7805_i0	PRJNA400171	7895	162	2.774436	4.49458632	Staphylococcus	1279	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|2521585500\|gb\|CP127567.1\|	1280	g7805	i0	98.765	542.246913580247	162	2	100	0	1	162	466308	466147	Staphylococcus aureus strain C888 chromosome, complete genome	blastn	87844	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
22757933	22757933	PRJNA400171_S_NODE_6778_length_173_cov_2.701389_g6688_i0	PRJNA400171	6778	173	2.701389	4.67340297	Streptococcus	1301	Bacteria	Bacteria	270	3.69e-68	NTclustered	gi\|1825984613\|gb\|CP050270.1\|	1309	g6688	i0	94.828	416.635838150289	174	7	100	2	1	173	2616	2788	Streptococcus mutans strain S4 chromosome, complete genome	blastn	72078	270	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mutans
22757934	22757934	PRJNA400171_S_NODE_7338_length_167_cov_3.094203_g7248_i0	PRJNA400171	7338	167	3.094203	5.16731901	Bacteria	2	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|379994767\|gb\|JQ661013.1\|	1409	g7248	i0	100	101	167	0	100	0	1	167	197	31	Bacillus sp. strain g53_37F 16S ribosomal RNA gene, partial sequence	blastn	16867	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
23365770	23365770	PRJNA400171_S_NODE_2499_length_251_cov_2.576577_g2409_i0	PRJNA400171	2499	251	2.576577	6.46720827	Bacillati	1783272	Bacteria	Bacteria	105	6.38e-26	NR	WP_332277687.1	1396	g2409	i0	91.7	2.199203187251	48	4	57.4	0	146	3	61	108	WP_332277687.1 DNA methyltransferase, partial [Bacillus cereus]	diamond	552	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27265141	27265141	PRJNA400171_S_NODE_443_length_441_cov_3.012136_g354_i0	PRJNA400171	443	441	3.012136	13.28351976	Syntrophomonas sp.	2053627	Bacteria	Bacteria	74.3	4.86e-13	NR	MEN6462707.1	2053627	g354	i0	36.7	1	147	74	95.9	8	439	17	38	171	MEN6462707.1 hypothetical protein [Syntrophomonas sp.]	diamond	441	74.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae	Syntrophomonas	Syntrophomonas sp.
27328414	27328414	PRJNA400171_S_NODE_4623_length_201_cov_2.668605_g4533_i0	PRJNA400171	4623	201	2.668605	5.36389605	uncultured Blautia sp.	765821	Bacteria	Bacteria	89.4	7.18e-19	NR	WP_294436031.1	765821	g4533	i0	66.7	7.80597014925373	66	22	98.5	0	198	1	333	398	WP_294436031.1 PBSX family phage terminase large subunit [uncultured Blautia sp.]	diamond	1569	89.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	uncultured Blautia sp.
28086022	28086022	PRJNA400171_S_NODE_5625_length_186_cov_11.171975_g5535_i0	PRJNA400171	5625	186	11.171975	20.7798735	Staphylococcus aureus	1280	Bacteria	Bacteria	47.8	4.47e-5	NR	MCS4580470.1	1280	g5535	i0	77.5	0.645161290322581	40	9	64.5	0	177	58	1	40	MCS4580470.1 hypothetical protein [Staphylococcus aureus]	diamond	120	47.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28086023	28086023	PRJNA400171_S_NODE_805_length_366_cov_84.540059_g715_i0	PRJNA400171	805	366	84.540059	309.41661594	Criibacterium bergeronii	1871336	Bacteria	Bacteria	130	2.61e-36	NR	RDY20310.1	1871336	g715	i0	98	0.80327868852459	98	2	80.3	0	296	3	1	98	RDY20310.1 hypothetical protein BBG48_010870, partial [Criibacterium bergeronii]	diamond	294	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Criibacterium	Criibacterium bergeronii
28559882	28559882	PRJNA400171_S_NODE_4207_length_208_cov_2.782123_g4117_i0	PRJNA400171	4207	208	2.782123	5.78681584	Symbiobacteriaceae bacterium	2602712	Bacteria	Bacteria	79.7	2.25e-15	NR	HYF95174.1	2602712	g4117	i0	52.2	8.16346153846154	69	33	99.5	0	208	2	340	408	HYF95174.1 DEAD/DEAH box helicase [Symbiobacteriaceae bacterium]	diamond	1698	79.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae		Symbiobacteriaceae bacterium
28749177	28749177	PRJNA400171_S_NODE_6587_length_175_cov_3.116438_g6497_i0	PRJNA400171	6587	175	3.116438	5.4537665	Symbiobacteriaceae bacterium	2602712	Bacteria	Bacteria	77.4	8.7e-15	NR	HYF95174.1	2602712	g6497	i0	62.5	6.73714285714286	56	21	96	0	3	170	754	809	HYF95174.1 DEAD/DEAH box helicase [Symbiobacteriaceae bacterium]	diamond	1179	77.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae		Symbiobacteriaceae bacterium
28812004	28812004	PRJNA400171_S_NODE_4008_length_212_cov_2.628415_g3918_i0	PRJNA400171	4008	212	2.628415	5.5722398	Paenibacillus sabuli	2772509	Bacteria	Bacteria	47.4	5.84e-4	NR	WP_317890144.1	2772509	g3918	i0	36.4	0.933962264150943	66	41	92	1	2	196	666	731	WP_317890144.1 RNA polymerase recycling motor HelD [Paenibacillus sabuli]	diamond	198	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sabuli
32478486	32478486	PRJNA400171_S_NODE_319_length_499_cov_75.921277_g231_i0	PRJNA400171	319	499	75.921277	378.84717223	Criibacterium bergeronii	1871336	Bacteria	Bacteria	130	1.31e-35	NR	RDY20310.1	1871336	g231	i0	98	0.589178356713427	98	2	58.9	0	296	3	1	98	RDY20310.1 hypothetical protein BBG48_010870, partial [Criibacterium bergeronii]	diamond	294	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Criibacterium	Criibacterium bergeronii
32887852	32887852	PRJNA400171_S_NODE_700_length_381_cov_3.568182_g610_i0	PRJNA400171	700	381	3.568182	13.59477342	Syntrophothermus lipocalidus	86170	Bacteria	Bacteria	87.8	9.09e-18	NR	WP_013174397.1	86170	g610	i0	54.2	3.11023622047244	83	36	65.4	2	126	374	1	81	WP_013174397.1 HNH endonuclease [Syntrophothermus lipocalidus]	diamond	1185	87.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae	Syntrophothermus	Syntrophothermus lipocalidus

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