metadata: contig_metadata: 8 rows where bioproject = "PRJNA1263632" and tax

8 rows where bioproject = "PRJNA1263632" 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
363766	363766	PRJNA1263632_P_NODE_7161_length_247_cov_0.885057_g7143_i0	PRJNA1263632	7161	247	0.885057	2.18609079	Clostridia bacterium	2044939	Bacteria	Bacteria	81.6	1.72e-18	NR	MEG1510266.1	2044939	g7143	i0	78.7	5.19838056680162	47	10	57.1	0	178	38	3	49	MEG1510266.1 zinc-ribbon domain-containing protein [Clostridia bacterium]	diamond	1284	81.6	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
4882020	4882020	PRJNA1263632_P_NODE_2404_length_391_cov_2.959119_g2386_i0	PRJNA1263632	2404	391	2.959119	11.57015529	Listeria	1637	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2611946659\|gb\|CP137276.1\|	1639	g2386	i0	96.875	8.82097186700767	32	0	8	1	81	112	2548517	2548487	Listeria monocytogenes strain FV3 chromosome, complete genome	blastn	3449	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
11257317	11257317	PRJNA1263632_P_NODE_3189_length_343_cov_3.262963_g3171_i0	PRJNA1263632	3189	343	3.262963	11.19196309	root	1	Root_unresolved	Root_unresolved	628	1.1799999999999997e-175	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g3171	i0	99.708	98.8250728862974	343	1	100	0	1	343	2463318	2463660	Staphylococcus aureus strain WH9628 chromosome	blastn	33897	628	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
24006006	24006006	PRJNA1263632_P_NODE_6799_length_249_cov_0.875000_g6781_i0	PRJNA1263632	6799	249	0.875	2.17875	Staphylococcus	1279	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g6781	i0	99.598	97.8473895582329	249	1	100	0	1	249	60603	60355	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	24364	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
27326807	27326807	PRJNA1263632_P_NODE_1583_length_476_cov_1.751861_g1565_i0	PRJNA1263632	1583	476	1.751861	8.33885836	Clostridia bacterium	2044939	Bacteria	Bacteria	191	5.4599999999999995e-56	NR	MBP3800546.1	2044939	g1565	i0	62.8	0.913865546218487	145	54	91.4	0	436	2	125	269	MBP3800546.1 50S ribosomal protein L3 [Clostridia bacterium]	diamond	435	191	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27755369	27755369	PRJNA1263632_P_NODE_4904_length_285_cov_1.070755_g4886_i0	PRJNA1263632	4904	285	1.070755	3.05165175	Bacteria	2	Bacteria	Bacteria	53.5	9.16e-6	NR	NLP48504.1	1898207	g4886	i0	44.7	2.55789473684211	85	39	89.5	4	284	30	267	343	NLP48504.1 phosphonopyruvate decarboxylase [Clostridiales bacterium]	diamond	729	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
31210844	31210844	PRJNA1263632_P_NODE_7375_length_246_cov_0.890173_g7357_i0	PRJNA1263632	7375	246	0.890173	2.18982558	Clostridium botulinum	1491	Bacteria	Bacteria	47.4	8.34e-4	NR	NFE93591.1	1491	g7357	i0	36.3	1.95121951219512	80	48	95.1	2	5	238	40	118	NFE93591.1 hypothetical protein [Clostridium botulinum]	diamond	480	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
32666014	32666014	PRJNA1263632_P_NODE_2260_length_404_cov_1.740181_g2242_i0	PRJNA1263632	2260	404	1.740181	7.03033124	Clostridia bacterium	2044939	Bacteria	Bacteria	145	4.96e-39	NR	MBP3800546.1	2044939	g2242	i0	59.8	0.905940594059406	122	49	90.6	0	3	368	282	403	MBP3800546.1 50S ribosomal protein L3 [Clostridia bacterium]	diamond	366	145	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia 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);;