metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA512103" 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
26824137	26824137	PRJNA512103_P_NODE_27381_length_179_cov_1.346154_g26969_i0	PRJNA512103	27381	179	1.346154	2.40961566	Paenibacillus sp. 1	198340	Bacteria	Bacteria	41.6	0.0378	NR	WP_119801618.1	1675787	g26969	i0	45.5	0.737430167597765	44	21	68.7	1	167	45	118	161	WP_119801618.1 FAD-dependent oxidoreductase [Paenibacillus sp. 1011MAR3C5]	diamond	132	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
26965967	26965967	PRJNA512103_P_NODE_19082_length_222_cov_1.057803_g18670_i0	PRJNA512103	19082	222	1.057803	2.34832266	root	1	Root_unresolved	Root_unresolved	150	1.73e-45	NR	WP_279750363.1	1280	g18670	i0	98.6	92.972972972973	73	1	98.6	0	1	219	10	82	WP_279750363.1 50S ribosomal protein L37Ae, partial [Staphylococcus aureus]	diamond	20640	151	0.993377483443709	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28245500	28245500	PRJNA512103_P_NODE_34906_length_156_cov_2.074766_g34494_i0	PRJNA512103	34906	156	2.074766	3.23663496	Clostridium sp. OF13-4	2293040	Bacteria	Bacteria	55.5	2.83e-8	NR	RHV70535.1	2293040	g34494	i0	61.7	0.903846153846154	47	18	90.4	0	14	154	4	50	RHV70535.1 hypothetical protein DXB05_14070, partial [Clostridium sp. OF13-4]	diamond	141	55.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. OF13-4
31341141	31341141	PRJNA512103_P_NODE_34076_length_163_cov_0.877193_g33664_i0	PRJNA512103	34076	163	0.877193	1.42982459	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	54.7	7.74e-7	NR	MBS3812162.1	2094029	g33664	i0	61.9	0.773006134969325	42	13	71.8	1	130	14	690	731	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	126	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32227052	32227052	PRJNA512103_P_NODE_21098_length_208_cov_0.874214_g20686_i0	PRJNA512103	21098	208	0.874214	1.81836512	Negativicutes bacterium	2499140	Bacteria	Bacteria	43.5	0.00633	NR	MDR3563352.1	2499140	g20686	i0	44.6	0.807692307692308	56	28	80.8	2	12	179	78	130	MDR3563352.1 hypothetical protein [Negativicutes bacterium]	diamond	168	43.5	1	Bacteria	Bacillati	Bacillota	Negativicutes				Negativicutes 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);;