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

13 rows where analysis = "blastn", bioproject = "PRJNA807836" 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	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
807264	807264	PRJNA807836_S_NODE_30721_length_242_cov_0.911243_g30445_i0	PRJNA807836	30721	242	0.911243	2.20520806	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g30445	i0	98.347	36.2520661157025	242	4	100	1	242	731174	731415	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	8773	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
1222958	1222958	PRJNA807836_S_NODE_27761_length_250_cov_0.870056_g27485_i0	PRJNA807836	27761	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g27485	i0	99.6	100	250	1	100	1	250	130321	130072	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25000	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2082961	2082961	PRJNA807836_S_NODE_28002_length_249_cov_0.875000_g27726_i0	PRJNA807836	28002	249	0.875	2.17875	Staphylococcus epidermidis	1282	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g27726	i0	100	100	249	0	100	1	249	194655	194903	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	24900	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7601071	7601071	PRJNA807836_S_NODE_28766_length_247_cov_0.885057_g28490_i0	PRJNA807836	28766	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g28490	i0	100	99.417004048583	247	0	100	1	247	2146603	2146849	Staphylococcus epidermidis strain 9 chromosome	blastn	24556	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12702475	12702475	PRJNA807836_S_NODE_23850_length_274_cov_2.970149_g23574_i0	PRJNA807836	23850	274	2.970149	8.13820826	root	1	Root_unresolved	Root_unresolved	507	4.47e-139	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g23574	i0	100	180	274	0	100	1	274	1143	1416	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	49320	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
16525715	16525715	PRJNA807836_S_NODE_14653_length_369_cov_1.800676_g14377_i0	PRJNA807836	14653	369	1.800676	6.64449444	Bacillales	1385	Bacteria	Bacteria	682	0	NTclustered	gi\|2811887514\|gb\|CP170250.1\|	1282	g14377	i0	100	535.021680216802	369	0	100	1	369	794116	793748	Staphylococcus epidermidis strain PS21 chromosome, complete genome	blastn	197423	682	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17800466	17800466	PRJNA807836_S_NODE_10434_length_464_cov_1.984655_g10158_i0	PRJNA807836	10434	464	1.984655	9.2087992	Bacillati	1783272	Bacteria	Bacteria	857	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10158	i0	100	528.709051724138	464	0	100	1	464	749103	748640	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	245321	857	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
19074557	19074557	PRJNA807836_S_NODE_11015_length_446_cov_2.024129_g10739_i0	PRJNA807836	11015	446	2.024129	9.02761534	Staphylococcus	1279	Bacteria	Bacteria	822	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10739	i0	100	473.437219730942	445	0	99	2	446	750833	750389	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	211153	822	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20349330	20349330	PRJNA807836_S_NODE_26676_length_254_cov_4.988950_g26400_i0	PRJNA807836	26676	254	4.98895	12.671933	Staphylococcus	1279	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g26400	i0	100	539.535433070866	254	0	100	1	254	748685	748432	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	137042	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23759801	23759801	PRJNA807836_S_NODE_28139_length_249_cov_0.869318_g27863_i0	PRJNA807836	28139	249	0.869318	2.16460182	Staphylococcus simulans	1286	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2313006690\|gb\|CP094709.1\|	1286	g27863	i0	100	23.9759036144578	249	0	100	1	249	339121	338873	Staphylococcus simulans strain IVB6174 chromosome, complete genome	blastn	5970	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus simulans
23759855	23759855	PRJNA807836_S_NODE_31059_length_241_cov_0.916667_g30783_i0	PRJNA807836	31059	241	0.916667	2.20916747	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g30783	i0	100	96.9502074688797	241	0	100	1	241	447823	448063	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	23365	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
24174613	24174613	PRJNA807836_S_NODE_29819_length_244_cov_0.900585_g29543_i0	PRJNA807836	29819	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|2634222066\|gb\|CP136423.1\|	476272	g29543	i0	100	0.237704918032787	29	0	12	52	80	2395561	2395533	Blautia hydrogenotrophica DSM 10507 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hydrogenotrophica
25033734	25033734	PRJNA807836_S_NODE_30720_length_242_cov_0.911243_g30444_i0	PRJNA807836	30720	242	0.911243	2.20520806	Abyssicoccus albus	1817405	Bacteria	Bacteria	363	8.869999999999999e-96	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g30444	i0	94.118	0.983471074380165	238	14	98	5	242	1657186	1656949	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	238	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus

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