metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA893346" 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
5971133	5971133	PRJNA893346_P_NODE_15065_length_401_cov_0.939024_g14577_i0	PRJNA893346	15065	401	0.939024	3.76548624	Gemella sanguinis	84135	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g14577	i0	100	0.0723192019950125	29	0	7	0	170	198	560221	560249	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
6347325	6347325	PRJNA893346_P_NODE_9725_length_506_cov_1.399538_g9241_i0	PRJNA893346	9725	506	1.399538	7.08166228	Lactobacillus	1578	Bacteria	Bacteria	62.1	8.22e-5	NTclustered	gi\|1785991537\|gb\|CP039261.1\|	33959	g9241	i0	89.796	1.52766798418972	49	4	9	1	286	333	1635908	1635860	Lactobacillus johnsonii strain DC22.2 chromosome, complete genome	blastn	773	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus johnsonii
7246628	7246628	PRJNA893346_P_NODE_39946_length_241_cov_0.916667_g39456_i0	PRJNA893346	39946	241	0.916667	2.20916747	Enterococcus faecium	1352	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2890913812\|gb\|CP127427.1\|	1352	g39456	i0	100	0.348547717842324	28	0	12	0	29	56	16368	16341	Enterococcus faecium strain ER05745.5 plasmid pER05745_5B.2, complete sequence	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
12722764	12722764	PRJNA893346_P_NODE_34110_length_250_cov_0.870056_g33620_i0	PRJNA893346	34110	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g33620	i0	100	100	250	0	100	0	1	250	2021575	2021824	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25000	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17820804	17820804	PRJNA893346_P_NODE_3234_length_908_cov_3.742515_g2854_i0	PRJNA893346	3234	908	3.742515	33.9820362	root	1	Root_unresolved	Root_unresolved	1677	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g2854	i0	100	58.0770925110132	908	0	100	0	1	908	2428193	2427286	Staphylococcus aureus strain WH9628 chromosome	blastn	52734	1677	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
18719788	18719788	PRJNA893346_P_NODE_31715_length_260_cov_1.604278_g31225_i0	PRJNA893346	31715	260	1.604278	4.1711228	Anaerococcus nagyae	1755241	Bacteria	Bacteria	453	5.5600000000000005e-123	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g31225	i0	100	327.261538461538	245	0	95	0	16	260	122130	121886	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	85088	453	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
19994535	19994535	PRJNA893346_P_NODE_15076_length_400_cov_3.125382_g14588_i0	PRJNA893346	15076	400	3.125382	12.501528	Sutcliffiella horikoshii	79883	Bacteria	Bacteria	63.9	1.77e-5	NTclustered	gi\|1198028747\|gb\|CP020880.1\|	79883	g14588	i0	100	0.085	34	0	9	0	80	113	3029447	3029414	Sutcliffiella horikoshii strain 20a chromosome, complete genome	blastn	34	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Sutcliffiella	Sutcliffiella horikoshii
22920863	22920863	PRJNA893346_P_NODE_21778_length_329_cov_2.054688_g21289_i0	PRJNA893346	21778	329	2.054688	6.75992352	root	1	Root_unresolved	Root_unresolved	575	1.4899999999999995e-159	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g21289	i0	98.765	29.4133738601824	324	3	98	1	1	324	2427005	2427327	Staphylococcus aureus strain WH9628 chromosome	blastn	9677	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
25469986	25469986	PRJNA893346_P_NODE_31700_length_260_cov_1.647059_g31210_i0	PRJNA893346	31700	260	1.647059	4.2823534	Staphylococcus	1279	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g31210	i0	100	23.7269230769231	260	0	100	0	1	260	2186446	2186187	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	6169	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri

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