metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA922890" and tax

11 rows where analysis = "blastn", 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
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

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