metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1146366" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1146366" 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
2841128	2841128	PRJNA1146366_S_NODE_2263_length_249_cov_2.181818_g2260_i0	PRJNA1146366	2263	249	2.181818	5.43272682	Staphylococcus auricularis	29379	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g2260	i0	100	479.618473895582	249	0	100	0	1	249	1486313	1486065	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	119425	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
8686806	8686806	PRJNA1146366_S_NODE_1187_length_307_cov_3.628205_g1184_i0	PRJNA1146366	1187	307	3.628205	11.13858935	Staphylococcus	1279	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g1184	i0	100	100	307	0	100	0	1	307	180852	180546	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	30700	568	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8686807	8686807	PRJNA1146366_S_NODE_427_length_401_cov_2.192073_g424_i0	PRJNA1146366	427	401	2.192073	8.79021273	Streptococcus	1301	Bacteria	Bacteria	728	0	NTclustered	gi\|2886508907\|emb\|OZ217344.1\|	28037	g424	i0	99.501	100.980049875312	401	1	100	1	1	401	1190840	1191239	Streptococcus mitis isolate S. mitis E22 genome assembly, chromosome: 1	blastn	40493	728	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
9218333	9218333	PRJNA1146366_S_NODE_648_length_363_cov_2.817241_g645_i0	PRJNA1146366	648	363	2.817241	10.22658483	Finegoldia magna	1260	Bacteria	Bacteria	671	0	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g645	i0	100	6.08264462809917	363	0	100	0	1	363	966697	966335	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	2208	671	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
9961806	9961806	PRJNA1146366_S_NODE_768_length_348_cov_1.850909_g765_i0	PRJNA1146366	768	348	1.850909	6.44116332	Paenibacillus	44249	Bacteria	Bacteria	368	2.88e-97	NTclustered	gi\|1373996327\|gb\|CP028366.1\|	59843	g765	i0	98.558	533.206896551724	208	3	60	0	1	208	422957	422750	Paenibacillus glucanolyticus strain W10507 chromosome	blastn	185556	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
18142027	18142027	PRJNA1146366_S_NODE_1355_length_296_cov_2.394619_g1352_i0	PRJNA1146366	1355	296	2.394619	7.08807224	Dolosigranulum pigrum	29394	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g1352	i0	100	469.341216216216	296	0	100	0	1	296	1791826	1791531	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	138925	547	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
21967150	21967150	PRJNA1146366_S_NODE_2498_length_241_cov_2.321429_g2495_i0	PRJNA1146366	2498	241	2.321429	5.59464389	Anaerococcus nagyae	1755241	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g2495	i0	100	5.21991701244813	241	0	100	0	1	241	1033952	1033712	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	1258	446	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae

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