metadata: contig_metadata: 21 rows where bioproject = "PRJNA1264536" and tax

21 rows where bioproject = "PRJNA1264536" 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
2329326	2329326	PRJNA1264536_P_NODE_4702_length_250_cov_0.881356_g4628_i0	PRJNA1264536	4702	250	0.881356	2.20339	Faecalibacterium	216851	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2094528058\|gb\|CP065382.1\|	853	g4628	i0	100	39.052	250	0	100	0	1	250	1955882	1956131	Faecalibacterium prausnitzii strain Fp944 chromosome, complete genome	blastn	9763	462	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
2914632	2914632	PRJNA1264536_P_NODE_5163_length_245_cov_0.906977_g5089_i0	PRJNA1264536	5163	245	0.906977	2.22209365	Clostridia bacterium	2044939	Bacteria	Bacteria	140	4.91e-39	NR	MBP3463663.1	2044939	g5089	i0	82.7	0.991836734693878	81	14	99.2	0	1	243	16	96	MBP3463663.1 sporulation transcription factor Spo0A [Clostridia bacterium]	diamond	243	140	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
4191037	4191037	PRJNA1264536_P_NODE_4884_length_248_cov_0.891429_g4810_i0	PRJNA1264536	4884	248	0.891429	2.21074392	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2318943546\|gb\|CP107201.1\|	2485925	g4810	i0	100	1.98790322580645	248	0	100	0	1	248	302940	302693	MAG: Oscillospiraceae bacterium isolate KR001_HAM_0045 chromosome, complete genome	blastn	493	459	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
5467275	5467275	PRJNA1264536_P_NODE_5065_length_246_cov_0.901734_g4991_i0	PRJNA1264536	5065	246	0.901734	2.21826564	Oscillospiraceae	216572	Bacteria	Bacteria	164	6.3699999999999985e-47	NR	WP_291223707.1	2049027	g4991	i0	100	2.96341463414634	81	0	98.8	0	245	3	255	335	WP_291223707.1 ribosome biogenesis GTPase Der [Gemmiger sp.]	diamond	729	164	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Gemmiger	Gemmiger sp.
8706810	8706810	PRJNA1264536_P_NODE_3747_length_282_cov_0.856459_g3673_i0	PRJNA1264536	3747	282	0.856459	2.41521438	Faecalibacterium	216851	Bacteria	Bacteria	394	3.75e-105	NTclustered	gi\|2094528058\|gb\|CP065382.1\|	853	g3673	i0	100	245.560283687943	213	0	79	0	70	282	355362	355150	Faecalibacterium prausnitzii strain Fp944 chromosome, complete genome	blastn	69248	394	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
9292070	9292070	PRJNA1264536_P_NODE_4608_length_251_cov_0.876404_g4534_i0	PRJNA1264536	4608	251	0.876404	2.19977404	Clostridium manihotivorum	2320868	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1554469089\|gb\|CP025746.1\|	2320868	g4534	i0	100	0.111553784860558	28	0	11	0	24	51	1835404	1835431	Clostridium manihotivorum strain CT4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium manihotivorum
10568040	10568040	PRJNA1264536_P_NODE_5429_length_243_cov_0.917647_g5355_i0	PRJNA1264536	5429	243	0.917647	2.22988221	Faecalitalea cylindroides	39483	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|295098739\|emb\|FP929041.1\|	717960	g5355	i0	99.588	13.6913580246914	243	1	100	0	1	243	917485	917727	Eubacterium cylindroides T2-87 draft genome	blastn	3327	444	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Faecalitalea	Faecalitalea cylindroides
18215663	18215663	PRJNA1264536_P_NODE_5235_length_245_cov_0.860465_g5161_i0	PRJNA1264536	5235	245	0.860465	2.10813925	Bacillus sp. FJAT-42376	2014076	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1519589463\|gb\|CP033906.1\|	2014076	g5161	i0	100	0.114285714285714	28	0	11	0	34	61	1125341	1125368	Bacillus sp. FJAT-42376 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FJAT-42376
22040595	22040595	PRJNA1264536_P_NODE_5378_length_243_cov_0.917647_g5304_i0	PRJNA1264536	5378	243	0.917647	2.22988221	Blautia wexlerae	418240	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2921375364\|gb\|CP136550.1\|	1121115	g5304	i0	99.588	5.86008230452675	243	1	100	0	1	243	3974127	3974369	Blautia wexlerae DSM 19850 chromosome, complete genome	blastn	1424	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia wexlerae
26662071	26662071	PRJNA1264536_P_NODE_3861_length_276_cov_1.497537_g3787_i0	PRJNA1264536	3861	276	1.497537	4.13320212	Clostridium perfringens	1502	Bacteria	Bacteria	109	8.920000000000001e-27	NR	MDJ8942383.1	1502	g3787	i0	72.2	1.91304347826087	90	25	97.8	0	276	7	26	115	MDJ8942383.1 hypothetical protein [Clostridium perfringens]	diamond	528	109	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
26820908	26820908	PRJNA1264536_P_NODE_5001_length_247_cov_0.896552_g4927_i0	PRJNA1264536	5001	247	0.896552	2.21448344	Ruminiclostridium sp.	2053608	Bacteria	Bacteria	46.2	0.0021	NR	MBQ8613087.1	2053608	g4927	i0	74.1	0.631578947368421	27	7	32.8	0	167	247	1	27	MBQ8613087.1 sugar phosphate isomerase/epimerase [Ruminiclostridium sp.]	diamond	156	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium sp.
27421780	27421780	PRJNA1264536_P_NODE_3303_length_306_cov_1.193133_g3229_i0	PRJNA1264536	3303	306	1.193133	3.65098698	Veillonella sp.	1926307	Bacteria	Bacteria	155	7.989999999999998e-47	NR	WP_366512514.1	1926307	g3229	i0	73	0.980392156862745	100	27	98	0	3	302	6	105	WP_366512514.1 hypothetical protein [Veillonella sp.]	diamond	300	155	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp.
27706109	27706109	PRJNA1264536_P_NODE_5104_length_246_cov_0.901734_g5030_i0	PRJNA1264536	5104	246	0.901734	2.21826564	Roseburia inulinivorans	360807	Bacteria	Bacteria	165	7.84e-51	NR	MFR8426660.1	360807	g5030	i0	100	1.97560975609756	81	0	98.8	0	244	2	17	97	MFR8426660.1 hypothetical protein [Roseburia inulinivorans]	diamond	486	165	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia inulinivorans
27769110	27769110	PRJNA1264536_P_NODE_5384_length_243_cov_0.917647_g5310_i0	PRJNA1264536	5384	243	0.917647	2.22988221	Clostridia bacterium	2044939	Bacteria	Bacteria	149	1.55e-39	NR	MBQ9850949.1	2044939	g5310	i0	92.5	0.987654320987654	80	6	98.8	0	242	3	411	490	MBQ9850949.1 ABC transporter permease [Clostridia bacterium]	diamond	240	149	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28084494	28084494	PRJNA1264536_P_NODE_5365_length_243_cov_0.917647_g5291_i0	PRJNA1264536	5365	243	0.917647	2.22988221	Enterococcus dispar	44009	Bacteria	Bacteria	74.3	5.03e-15	NR	WP_281738482.1	44009	g5291	i0	53.4	0.901234567901235	73	33	90.1	1	233	15	1	72	WP_281738482.1 hypothetical protein [Enterococcus dispar]	diamond	219	74.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus dispar
28210723	28210723	PRJNA1264536_P_NODE_4406_length_253_cov_0.866667_g4332_i0	PRJNA1264536	4406	253	0.866667	2.19266751	Intestinibacter bartlettii	261299	Bacteria	Bacteria	110	3.5600000000000003e-29	NR	WP_032089836.1	261299	g4332	i0	98.3	0.687747035573123	58	1	68.8	0	176	3	1	58	WP_032089836.1 hypothetical protein [Intestinibacter bartlettii]	diamond	174	110	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Intestinibacter	Intestinibacter bartlettii
28937198	28937198	PRJNA1264536_P_NODE_5328_length_244_cov_0.912281_g5254_i0	PRJNA1264536	5328	244	0.912281	2.22596564	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	154	3.14e-41	NR	MBE6951924.1	2485925	g5254	i0	100	0.995901639344262	81	0	99.6	0	1	243	434	514	MBE6951924.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	243	154	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
29000619	29000619	PRJNA1264536_P_NODE_4328_length_253_cov_0.866667_g4254_i0	PRJNA1264536	4328	253	0.866667	2.19266751	Clostridia bacterium	2044939	Bacteria	Bacteria	138	7.99e-37	NR	MCI9246102.1	2044939	g4254	i0	78.3	0.984189723320158	83	18	98.4	0	251	3	122	204	MCI9246102.1 aminoacyl-histidine dipeptidase [Clostridia bacterium]	diamond	249	138	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29000621	29000621	PRJNA1264536_P_NODE_5148_length_245_cov_0.906977_g5074_i0	PRJNA1264536	5148	245	0.906977	2.22209365	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	129	1.9e-35	NR	MBE6943191.1	2485925	g5074	i0	77.5	0.979591836734694	80	18	98	0	1	240	100	179	MBE6943191.1 ECF transporter S component [Oscillospiraceae bacterium]	diamond	240	129	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
29694543	29694543	PRJNA1264536_P_NODE_3950_length_272_cov_1.336683_g3876_i0	PRJNA1264536	3950	272	1.336683	3.63577776	Bacilli bacterium	1903720	Bacteria	Bacteria	145	3.12e-42	NR	MEG2609380.1	1903720	g3876	i0	100	0.772058823529412	70	0	77.2	0	15	224	99	168	MEG2609380.1 helix-turn-helix domain-containing protein [Bacilli bacterium]	diamond	210	145	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
32223695	32223695	PRJNA1264536_P_NODE_5198_length_245_cov_0.906977_g5124_i0	PRJNA1264536	5198	245	0.906977	2.22209365	Faecalibacterium sp.	1971605	Bacteria	Bacteria	175	1.48e-50	NR	MFR7837035.1	1971605	g5124	i0	100	0.991836734693878	81	0	99.2	0	244	2	343	423	MFR7837035.1 beta-glucuronidase [Faecalibacterium sp.]	diamond	243	175	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium sp.

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