metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA401346" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA401346" 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
2356526	2356526	PRJNA401346_P_NODE_5962_length_215_cov_1.084416_g5941_i0	PRJNA401346	5962	215	1.084416	2.3314944	Staphylococcus	1279	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g5941	i0	98.14	538.413953488372	215	4	100	0	1	215	748752	748538	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	115759	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6792030	6792030	PRJNA401346_P_NODE_6806_length_207_cov_1.746575_g6785_i0	PRJNA401346	6806	207	1.746575	3.61541025	Staphylococcus pasteuri	45972	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g6785	i0	100	20.4154589371981	207	0	100	0	1	207	469796	470002	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	4226	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
12559780	12559780	PRJNA401346_P_NODE_8650_length_201_cov_0.914286_g8629_i0	PRJNA401346	8650	201	0.914286	1.83771486	Finegoldia	150022	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g8629	i0	100	7.52238805970149	201	0	100	0	1	201	578326	578526	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	1512	372	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
13834584	13834584	PRJNA401346_P_NODE_3631_length_274_cov_1.948357_g3610_i0	PRJNA401346	3631	274	1.948357	5.33849818	Exiguobacterium	33986	Bacteria	Bacteria	499	7.48e-137	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g3610	i0	99.635	826.091240875912	274	0	100	1	1	274	40983	40711	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	226349	499	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
15717018	15717018	PRJNA401346_P_NODE_7153_length_206_cov_0.882759_g7132_i0	PRJNA401346	7153	206	0.882759	1.81848354	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	359	9.47e-95	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g7132	i0	98.058	5.36407766990291	206	4	100	0	1	206	1990918	1991123	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	1105	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
25307249	25307249	PRJNA401346_P_NODE_8720_length_201_cov_0.914286_g8699_i0	PRJNA401346	8720	201	0.914286	1.83771486	Staphylococcus	1279	Bacteria	Bacteria	359	9.2e-95	NTclustered	gi\|2006240191\|gb\|CP071508.1\|	1283	g8699	i0	99	51.636815920398	200	2	99	0	2	201	1894593	1894792	Staphylococcus haemolyticus strain 7b chromosome, complete genome	blastn	10379	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus

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