metadata: contig_metadata: 8 rows where bioproject = "PRJNA1082072", tax_phylum = "Bacillota" and tax

8 rows where bioproject = "PRJNA1082072", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"

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
2292519	2292519	PRJNA1082072_P_NODE_1042_length_337_cov_1.166667_g1035_i0	PRJNA1082072	1042	337	1.166667	3.93166779	Staphylococcus	1279	Bacteria	Bacteria	623	5.369999999999999e-174	NTclustered	gi\|443907020\|gb\|KC329827.1\|	1282	g1035	i0	100	163.967359050445	337	0	100	0	1	337	475	139	Staphylococcus epidermidis strain 14F 16S ribosomal RNA gene, partial sequence	blastn	55257	623	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25243512	25243512	PRJNA1082072_P_NODE_900_length_354_cov_1.096085_g893_i0	PRJNA1082072	900	354	1.096085	3.8801409	Staphylococcus	1279	Bacteria	Bacteria	189	2.45e-43	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g893	i0	79.286	79.0423728813559	280	50	78	7	70	345	1073843	1074118	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	27981	189	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
26846254	26846254	PRJNA1082072_P_NODE_1921_length_260_cov_1.647059_g1914_i0	PRJNA1082072	1921	260	1.647059	4.2823534	Clostridium perfringens	1502	Bacteria	Bacteria	65.9	1.1e-11	NR	WP_395252126.1	1502	g1914	i0	88.9	0.415384615384615	36	4	41.5	0	153	260	1	36	WP_395252126.1 hypothetical protein, partial [Clostridium perfringens]	diamond	108	65.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
28393870	28393870	PRJNA1082072_P_NODE_2266_length_249_cov_0.875000_g2259_i0	PRJNA1082072	2266	249	0.875	2.17875	Gemmiger sp. An5	2049027	Bacteria	Bacteria	68.2	4.4e-11	NR	WP_087182640.1	1965639	g2259	i0	64.2	2.46987951807229	53	19	63.9	0	161	3	599	651	WP_087182640.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Gemmiger sp. An50]	diamond	615	68.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Gemmiger	Gemmiger sp. An50
31132898	31132898	PRJNA1082072_P_NODE_2115_length_251_cov_0.865169_g2108_i0	PRJNA1082072	2115	251	0.865169	2.17157419	Bacillati	1783272	Bacteria	Bacteria	120	1.86e-29	NR	MCI6848192.1	2049044	g2108	i0	68.7	11.7370517928287	83	26	99.2	0	249	1	278	360	MCI6848192.1 pyruvate, phosphate dikinase [Erysipelotrichaceae bacterium]	diamond	2946	120	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
31268219	31268219	PRJNA1082072_P_NODE_1755_length_272_cov_1.221106_g1748_i0	PRJNA1082072	1755	272	1.221106	3.32140832	Ruminiclostridium sp.	2053608	Bacteria	Bacteria	43.1	0.0376	NR	MBR5533222.1	2053608	g1748	i0	40.7	0.650735294117647	59	35	65.1	0	196	20	197	255	MBR5533222.1 MATE family efflux transporter [Ruminiclostridium sp.]	diamond	177	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium sp.
31955385	31955385	PRJNA1082072_P_NODE_2137_length_251_cov_0.865169_g2130_i0	PRJNA1082072	2137	251	0.865169	2.17157419	Bacilli	91061	Bacteria	Bacteria	42.4	0.0463	NR	CKF71294.1	1313	g2130	i0	34.8	1.42231075697211	69	35	70.5	2	75	251	20	88	CKF71294.1 succinate-semialdehyde dehydrogenase [Streptococcus pneumoniae]	diamond	357	42.7	0.992974238875878	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
32533818	32533818	PRJNA1082072_P_NODE_2959_length_241_cov_0.916667_g2952_i0	PRJNA1082072	2959	241	0.916667	2.20916747	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	44.3	0.0103	NR	MCR4960309.1	1898203	g2952	i0	34.2	0.946058091286307	76	38	79.7	3	210	19	263	338	MCR4960309.1 MBOAT family protein [Lachnospiraceae bacterium]	diamond	228	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium

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