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

17 rows where bioproject = "PRJNA922890" 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
2527602	2527602	PRJNA922890_P_NODE_45342_length_289_cov_1.327273_g44932_i0	PRJNA922890	45342	289	1.327273	3.83581897	Finegoldia	150022	Bacteria	Bacteria	523	4.7199999999999987e-144	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g44932	i0	99.308	36.9377162629758	289	2	100	0	1	289	460757	461045	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	10675	523	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
3803906	3803906	PRJNA922890_P_NODE_21763_length_409_cov_2.376471_g21353_i0	PRJNA922890	21763	409	2.376471	9.71976639	Streptococcus	1301	Bacteria	Bacteria	747	0	NTclustered	gi\|1686100242\|gb\|MK330590.1\|	1305	g21353	i0	99.513	323.58924205379	411	0	100	2	1	409	3006	2596	Streptococcus sanguinis strain 4416_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	132348	750	0.996	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
3804093	3804093	PRJNA922890_P_NODE_83503_length_228_cov_0.905660_g83093_i0	PRJNA922890	83503	228	0.90566	2.0649048	Finegoldia	150022	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g83093	i0	100	387.40350877193	228	0	100	0	1	228	163793	164020	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	88328	422	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
7275844	7275844	PRJNA922890_P_NODE_23946_length_389_cov_1.315625_g23536_i0	PRJNA922890	23946	389	1.315625	5.11778125	root	1	Root_unresolved	Root_unresolved	63.9	4.51e-10	NR	MFG1541693.1	1280	g23536	i0	44.6	2.5681233933162	112	40	76.3	4	92	388	1	103	MFG1541693.1 hypothetical protein [Staphylococcus aureus]	diamond	999	64.3	0.993779160186625	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8904744	8904744	PRJNA922890_P_NODE_38167_length_313_cov_1.016393_g37757_i0	PRJNA922890	38167	313	1.016393	3.18131009	Finegoldia	150022	Bacteria	Bacteria	573	5.049999999999998e-159	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g37757	i0	99.681	346.025559105431	313	1	100	0	1	313	873661	873349	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	108306	573	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
9826011	9826011	PRJNA922890_P_NODE_52328_length_270_cov_1.223881_g51918_i0	PRJNA922890	52328	270	1.223881	3.3044787	Geobacillus genomosp. 3	1921421	Bacteria	Bacteria	494	3.4199999999999996e-135	NTclustered	gi\|558500226\|gb\|CP006254.2\|	1921421	g51918	i0	99.63	15.5703703703704	270	1	100	0	1	270	331975	331706	Geobacillus genomosp. 3 strain JF8, complete sequence	blastn	4204	494	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus genomosp. 3
16554513	16554513	PRJNA922890_P_NODE_75733_length_232_cov_0.883436_g75323_i0	PRJNA922890	75733	232	0.883436	2.04957152	Peptoniphilus	162289	Bacteria	Bacteria	407	3.84e-109	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g75323	i0	98.283	337.85775862069	233	3	100	1	1	232	601755	601523	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	78383	407	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
17829566	17829566	PRJNA922890_P_NODE_81694_length_229_cov_0.900000_g81284_i0	PRJNA922890	81694	229	0.9	2.061	Bacillus	1386	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|2886602039\|gb\|CP177035.1\|	1428	g81284	i0	100	100	229	0	100	0	1	229	658922	658694	Bacillus thuringiensis strain MPB08 chromosome, complete genome	blastn	22900	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
21300228	21300228	PRJNA922890_P_NODE_53177_length_268_cov_1.180905_g52767_i0	PRJNA922890	53177	268	1.180905	3.1648254	Geobacillus genomosp. 3	1921421	Bacteria	Bacteria	457	4.45e-124	NTclustered	gi\|558500226\|gb\|CP006254.2\|	1921421	g52767	i0	97.388	14.3880597014925	268	7	100	0	1	268	2009779	2009512	Geobacillus genomosp. 3 strain JF8, complete sequence	blastn	3856	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus genomosp. 3
22575660	22575660	PRJNA922890_P_NODE_73538_length_233_cov_0.878049_g73128_i0	PRJNA922890	73538	233	0.878049	2.04585417	Clostridiales bacterium	1898207	Bacteria	Bacteria	409	1.07e-109	NTclustered	gi\|2318934473\|gb\|CP107216.1\|	1898207	g73128	i0	98.283	1	233	4	100	0	1	233	1019567	1019799	MAG: Clostridiales bacterium isolate KR001_HIC_0007 chromosome, complete genome	blastn	233	409	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
22929771	22929771	PRJNA922890_P_NODE_71598_length_234_cov_0.872727_g71188_i0	PRJNA922890	71598	234	0.872727	2.04218118	Bacillus	1386	Bacteria	Bacteria	433	6.41e-117	NTclustered	gi\|2798377728\|gb\|CP168764.1\|	1392	g71188	i0	100	99.9401709401709	234	0	100	0	1	234	3658567	3658800	Bacillus anthracis strain Z03-J001 chromosome, complete genome	blastn	23386	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
25124651	25124651	PRJNA922890_P_NODE_73500_length_233_cov_0.878049_g73090_i0	PRJNA922890	73500	233	0.878049	2.04585417	Blautia wexlerae	418240	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2250075743\|gb\|CP098409.1\|	418240	g73090	i0	100	498.227467811159	233	0	100	0	1	233	1336297	1336065	Blautia wexlerae strain NB2B-9-FAA chromosome	blastn	116087	431	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia wexlerae
27031834	27031834	PRJNA922890_P_NODE_73002_length_233_cov_0.890244_g72592_i0	PRJNA922890	73002	233	0.890244	2.07426852	Bacteria	2	Bacteria	Bacteria	42.7	0.0298	NR	MBQ7274017.1	1898207	g72592	i0	41.3	1.66094420600858	63	36	81.1	1	195	7	10	71	MBQ7274017.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Clostridiales bacterium]	diamond	387	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29550770	29550770	PRJNA922890_P_NODE_81930_length_229_cov_0.900000_g81520_i0	PRJNA922890	81930	229	0.9	2.061	Paenibacillus sp. 1	198340	Bacteria	Bacteria	52.4	6.36e-6	NR	WP_119803096.1	1675787	g81520	i0	39.7	1.87336244541485	73	42	95.6	1	225	7	38	108	WP_119803096.1 DUF2589 domain-containing protein [Paenibacillus sp. 1011MAR3C5]	diamond	429	52.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
30688052	30688052	PRJNA922890_P_NODE_84933_length_212_cov_5.762238_g84523_i0	PRJNA922890	84933	212	5.762238	12.21594456	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	79.3	6.21e-17	NR	WP_252129996.1	1590	g84523	i0	90.2	3.45283018867925	41	4	58	0	212	90	92	132	WP_252129996.1 hemoglobin alpha subunit family protein, partial [Lactiplantibacillus plantarum]	diamond	732	79.7	0.994981179422836	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
31636452	31636452	PRJNA922890_P_NODE_69396_length_235_cov_0.879518_g68986_i0	PRJNA922890	69396	235	0.879518	2.0668673	Lactiplantibacillus sp. E932	2952565	Bacteria	Bacteria	46.6	1.04e-4	NR	MCM8651632.1	2952565	g68986	i0	60.5	0.485106382978723	38	9	48.5	1	203	90	1	32	MCM8651632.1 hypothetical protein [Lactiplantibacillus sp. E932]	diamond	114	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus sp. E932
31699812	31699812	PRJNA922890_P_NODE_75837_length_232_cov_0.883436_g75427_i0	PRJNA922890	75837	232	0.883436	2.04957152	Romboutsia ilealis	1115758	Bacteria	Bacteria	51.2	3.13e-5	NR	WP_304576584.1	1115758	g75427	i0	39.7	0.75	58	35	75	0	2	175	219	276	WP_304576584.1 hypothetical protein [Romboutsia ilealis]	diamond	174	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis

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