metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1108487" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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
7398379	7398379	PRJNA1108487_P_NODE_11506_length_234_cov_2.832298_g11440_i0	PRJNA1108487	11506	234	2.832298	6.62757732	Streptococcus	1301	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g11440	i0	100	305.735042735043	230	0	98	0	5	234	18481	18710	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	71542	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
8673801	8673801	PRJNA1108487_P_NODE_5367_length_306_cov_2.223176_g5301_i0	PRJNA1108487	5367	306	2.223176	6.80291856	Leuconostoc	1243	Bacteria	Bacteria	108	6.01e-19	NTclustered	gi\|2876072957\|gb\|PQ835541.1\|	33964	g5301	i0	86.735	30.1372549019608	98	12	32	1	190	287	839	935	Leuconostoc citreum strain TA107-6 16S ribosomal RNA gene, partial sequence	blastn	9222	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc citreum
9141011	9141011	PRJNA1108487_P_NODE_10748_length_244_cov_0.912281_g10682_i0	PRJNA1108487	10748	244	0.912281	2.22596564	Peptoniphilus harei	54005	Bacteria	Bacteria	339	1.51e-88	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g10682	i0	91.803	92.9754098360656	244	19	100	1	1	244	1597033	1596791	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	22686	339	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
9141018	9141018	PRJNA1108487_P_NODE_1368_length_570_cov_1.686117_g1303_i0	PRJNA1108487	1368	570	1.686117	9.6108669	Caproiciproducens sp. CPB-2	3030017	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|2663189403\|gb\|CP142860.1\|	3030017	g1303	i0	96.875	0.056140350877193	32	1	6	0	95	126	2282982	2282951	Caproiciproducens sp. CPB-2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae	Caproiciproducens	Caproiciproducens sp. CPB-2
10416884	10416884	PRJNA1108487_P_NODE_8609_length_252_cov_0.871508_g8543_i0	PRJNA1108487	8609	252	0.871508	2.19620016	Mesobacillus jeotgali	129985	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2324479551\|gb\|CP109811.1\|	129985	g8543	i0	100	0.119047619047619	30	0	12	0	113	142	2718346	2718375	Mesobacillus jeotgali strain SBJS01 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus jeotgali
12499422	12499422	PRJNA1108487_P_NODE_4650_length_324_cov_3.474104_g4584_i0	PRJNA1108487	4650	324	3.474104	11.25609696	Streptococcus	1301	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g4584	i0	100	322	324	0	100	0	1	324	1570711	1570388	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	104328	599	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15048287	15048287	PRJNA1108487_P_NODE_5712_length_298_cov_2.297778_g5646_i0	PRJNA1108487	5712	298	2.297778	6.84737844	Bacteria	2	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g5646	i0	100	475.580536912752	298	0	100	0	1	298	756	459	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	141723	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
17598251	17598251	PRJNA1108487_P_NODE_10794_length_244_cov_0.912281_g10728_i0	PRJNA1108487	10794	244	0.912281	2.22596564	Bacillus	1386	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2170494957\|dbj\|AP022874.1\|	1396	g10728	i0	96.875	3.9344262295082	32	1	13	0	22	53	2378771	2378802	Bacillus cereus MRY14-0057 DNA, complete genome	blastn	960	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
18872159	18872159	PRJNA1108487_P_NODE_5775_length_297_cov_1.294643_g5709_i0	PRJNA1108487	5775	297	1.294643	3.84508971	Streptococcus	1301	Bacteria	Bacteria	544	3.7299999999999996e-150	NTclustered	gi\|1943213388\|gb\|CP065706.1\|	1303	g5709	i0	99.663	316.902356902357	297	1	100	0	1	297	198564	198860	Streptococcus oralis strain FDAARGOS_886 chromosome, complete genome	blastn	94120	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
19339299	19339299	PRJNA1108487_P_NODE_5156_length_311_cov_1.613445_g5090_i0	PRJNA1108487	5156	311	1.613445	5.01781395	Pusillibacter faecalis	2714358	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2025056735\|dbj\|AP023420.1\|	2714358	g5090	i0	100	0.0932475884244373	29	0	9	0	68	96	150612	150584	Pusillimonas faecalis MM59 DNA, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pusillibacter	Pusillibacter faecalis
21422625	21422625	PRJNA1108487_P_NODE_437_length_949_cov_3.004566_g388_i0	PRJNA1108487	437	949	3.004566	28.51333134	Bacillati	1783272	Bacteria	Bacteria	84.2	3.4e-11	NTclustered	gi\|1967464082\|gb\|CP035727.2\|	257985	g388	i0	87.5	7.67860906217071	72	9	8	0	498	569	6034978	6034907	Bacillus thuringiensis serovar andalousiensis strain NRRL B-23139 chromosome	blastn	7287	84.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
21422626	21422626	PRJNA1108487_P_NODE_4797_length_320_cov_2.141700_g4731_i0	PRJNA1108487	4797	320	2.1417	6.85344	Staphylococcus	1279	Bacteria	Bacteria	592	1.4299999999999996e-164	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g4731	i0	100	461.05	320	0	100	0	1	320	708481	708162	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	147536	592	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
22697533	22697533	PRJNA1108487_P_NODE_10398_length_245_cov_0.906977_g10332_i0	PRJNA1108487	10398	245	0.906977	2.22209365	Anaerococcus	165779	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g10332	i0	98.776	407.261224489796	245	3	100	0	1	245	180522	180766	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	99779	436	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis

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