metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1237888" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1237888" 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
26775337	26775337	PRJNA1237888_S_NODE_2621_length_251_cov_5.311881_g2571_i0	PRJNA1237888	2621	251	5.311881	13.33282131	root	1	Root_unresolved	Root_unresolved	169	2.46e-52	NR	MDK0657390.1	1502	g2571	i0	98.8	80.3426294820717	83	1	99.2	0	249	1	31	113	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	20166	170	0.994117647058824	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
27660483	27660483	PRJNA1237888_S_NODE_7564_length_159_cov_14.790909_g7514_i0	PRJNA1237888	7564	159	14.790909	23.51754531	root	1	Root_unresolved	Root_unresolved	63.9	3.95e-10	NR	QHG77622.1	1280	g7514	i0	90.6	24	53	5	100	0	1	159	27	79	QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus]	diamond	3816	64.3	0.993779160186625	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28639319	28639319	PRJNA1237888_S_NODE_7147_length_163_cov_1.807018_g7097_i0	PRJNA1237888	7147	163	1.807018	2.94543934	root	1	Root_unresolved	Root_unresolved	63.5	8.6e-12	NR	WP_369599335.1	1590	g7097	i0	100	112.306748466258	27	0	49.7	0	163	83	33	59	WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	18306	63.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
29694055	29694055	PRJNA1237888_S_NODE_5310_length_179_cov_1.584615_g5260_i0	PRJNA1237888	5310	179	1.584615	2.83646085	Staphylococcus warneri	1292	Bacteria	Bacteria	129	1.12e-33	NR	MDU6255230.1	1292	g5260	i0	100	0.988826815642458	59	0	98.9	0	1	177	17	75	MDU6255230.1 hypothetical protein [Staphylococcus warneri]	diamond	177	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
30484257	30484257	PRJNA1237888_S_NODE_4913_length_186_cov_1.138686_g4863_i0	PRJNA1237888	4913	186	1.138686	2.11795596	Staphylococcus warneri	1292	Bacteria	Bacteria	124	3.36e-31	NR	MDU6255006.1	1292	g4863	i0	98.4	0.983870967741935	61	1	98.4	0	184	2	202	262	MDU6255006.1 ATP-dependent helicase [Staphylococcus warneri]	diamond	183	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
30484259	30484259	PRJNA1237888_S_NODE_6773_length_165_cov_1.060345_g6723_i0	PRJNA1237888	6773	165	1.060345	1.74956925	Staphylococcus epidermidis	1282	Bacteria	Bacteria	54.7	7.7300000000000005e-07	NR	MBM6202820.1	1282	g6723	i0	52.7	2.98181818181818	55	22	98.2	2	2	163	38	89	MBM6202820.1 hypothetical protein [Staphylococcus epidermidis]	diamond	492	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
31197092	31197092	PRJNA1237888_S_NODE_6555_length_166_cov_1.333333_g6505_i0	PRJNA1237888	6555	166	1.333333	2.21333278	root	1	Root_unresolved	Root_unresolved	85.5	4.06e-18	NR	HJG39255.1	29385	g6505	i0	74.1	2.92771084337349	54	14	97.6	0	3	164	24	77	HJG39255.1 transposase [Staphylococcus saprophyticus]	diamond	486	85.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saprophyticus
31716931	31716931	PRJNA1237888_S_NODE_6857_length_165_cov_0.896552_g6807_i0	PRJNA1237888	6857	165	0.896552	1.4793108	Veillonella sp. VA142	741834	Bacteria	Bacteria	112	5.9899999999999985e-28	NR	WP_126939084.1	741834	g6807	i0	100	0.981818181818182	54	0	98.2	0	3	164	225	278	WP_126939084.1 tRNA 2-thiouridine(34) synthase MnmA [Veillonella sp. VA142]	diamond	162	112	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp. VA142
32128419	32128419	PRJNA1237888_S_NODE_7178_length_163_cov_1.254386_g7128_i0	PRJNA1237888	7178	163	1.254386	2.04464918	Staphylococcus warneri	1292	Bacteria	Bacteria	103	2.45e-26	NR	MDU6255014.1	1292	g7128	i0	94.3	0.975460122699387	53	3	97.5	0	161	3	66	118	MDU6255014.1 hypothetical protein [Staphylococcus warneri]	diamond	159	103	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri

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