metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA720429" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA720429" 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
5813587	5813587	PRJNA720429_P_NODE_4985_length_241_cov_1.684524_g4928_i0	PRJNA720429	4985	241	1.684524	4.05970284	Gemelliphila asaccharolytica	502393	Bacteria	Bacteria	155	1.86e-43	NR	WP_066129019.1	502393	g4928	i0	87.3	21.6224066390042	79	10	98.3	0	239	3	174	252	WP_066129019.1 glycine--tRNA ligase [Gemelliphila asaccharolytica]	diamond	5211	155	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemelliphila	Gemelliphila asaccharolytica
27778772	27778772	PRJNA720429_P_NODE_4544_length_244_cov_0.900585_g4487_i0	PRJNA720429	4544	244	0.900585	2.1974274	Peptoniphilus lacydonensis	1673725	Bacteria	Bacteria	157	2.38e-46	NR	WP_288151060.1	1673725	g4487	i0	100	0.983606557377049	80	0	98.4	0	242	3	111	190	WP_288151060.1 methionine ABC transporter permease [Peptoniphilus lacydonensis]	diamond	240	157	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus lacydonensis
29873025	29873025	PRJNA720429_P_NODE_4631_length_243_cov_1.800000_g4574_i0	PRJNA720429	4631	243	1.8	4.374	Pseudalkalibacillus	2893058	Bacteria	Bacteria	74.3	5.55e-14	NR	WP_257350261.1	163879	g4574	i0	53.3	2.74074074074074	75	34	92.6	1	243	19	107	180	WP_257350261.1 ComF family protein [Pseudalkalibacillus decolorationis]	diamond	666	74.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Pseudalkalibacillus	Pseudalkalibacillus decolorationis
30252288	30252288	PRJNA720429_P_NODE_4552_length_244_cov_0.900585_g4495_i0	PRJNA720429	4552	244	0.900585	2.1974274	Effusibacillus	1502725	Bacteria	Bacteria	72.4	8.51e-14	NR	WP_096182519.1	1348429	g4495	i0	64	1.20491803278689	50	18	61.5	0	9	158	103	152	WP_096182519.1 8-oxo-dGTP diphosphatase [Effusibacillus lacus]	diamond	294	72.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Effusibacillus	Effusibacillus lacus
30936866	30936866	PRJNA720429_P_NODE_4734_length_243_cov_0.905882_g4677_i0	PRJNA720429	4734	243	0.905882	2.20129326	Scopulibacillus darangshiensis	442528	Bacteria	Bacteria	72.4	1.31e-12	NR	WP_132746929.1	442528	g4677	i0	63.6	0.679012345679012	55	20	67.9	0	3	167	670	724	WP_132746929.1 ribonuclease R [Scopulibacillus darangshiensis]	diamond	165	72.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Sporolactobacillaceae	Scopulibacillus	Scopulibacillus darangshiensis
31315981	31315981	PRJNA720429_P_NODE_3815_length_248_cov_0.880000_g3758_i0	PRJNA720429	3815	248	0.88	2.1824	Granulicatella elegans	137732	Bacteria	Bacteria	147	3.42e-41	NR	WP_006702678.1	137732	g3758	i0	96.4	1.00403225806452	83	2	99.2	1	247	2	126	208	WP_006702678.1 ADP-ribosylglycohydrolase family protein [Granulicatella elegans]	diamond	249	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans

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