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

9 rows where analysis = "diamond", bioproject = "PRJNA451191" 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
27329090	27329090	PRJNA451191_P_NODE_39123_length_228_cov_1.143713_g38852_i0	PRJNA451191	39123	228	1.143713	2.60766564	Fusibacter sp.	2004507	Bacteria	Bacteria	43.5	0.0153	NR	HSN66110.1	2004507	g38852	i0	44.8	0.789473684210526	29	16	38.2	0	122	36	162	190	HSN66110.1 reverse transcriptase family protein [Fusibacter sp.]	diamond	180	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriales Family XII. Incertae Sedis	Fusibacter	Fusibacter sp.
28718352	28718352	PRJNA451191_P_NODE_51467_length_205_cov_0.902778_g51196_i0	PRJNA451191	51467	205	0.902778	1.8506949	Eubacterium brachy ATCC 33	35517	Bacteria	Bacteria	42.4	0.0318	NR	ESE30890.1	1321814	g51196	i0	34.6	0.760975609756098	52	32	73.2	1	38	187	8	59	ESE30890.1 putative ATP-dependent DNA helicase RecG [Eubacterium brachy ATCC 33089]	diamond	156	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		[Eubacterium] brachy
28812653	28812653	PRJNA451191_P_NODE_27148_length_273_cov_1.174528_g26877_i0	PRJNA451191	27148	273	1.174528	3.20646144	Cohnella caldifontis	3027471	Bacteria	Bacteria	45.4	0.00587	NR	WP_276354092.1	3027471	g26877	i0	40.3	0.681318681318681	62	37	68.1	0	214	29	517	578	WP_276354092.1 CPBP family glutamic-type intramembrane protease [Cohnella caldifontis]	diamond	186	45.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella caldifontis
28970901	28970901	PRJNA451191_P_NODE_47648_length_209_cov_0.878378_g47377_i0	PRJNA451191	47648	209	0.878378	1.83581002	Neobacillus jeddahensis	1461580	Bacteria	Bacteria	43.5	0.00456	NR	WP_096911866.1	1461580	g47377	i0	38.3	0.674641148325359	47	28	67.5	1	171	31	67	112	WP_096911866.1 DUF1360 domain-containing protein [Neobacillus jeddahensis]	diamond	141	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus jeddahensis
30424028	30424028	PRJNA451191_P_NODE_48933_length_208_cov_0.884354_g48662_i0	PRJNA451191	48933	208	0.884354	1.83945632	Oceanobacillus massiliensis	1465765	Bacteria	Bacteria	124	7.92e-33	NR	WP_337019773.1	1465765	g48662	i0	89.7	1.96153846153846	68	7	98.1	0	206	3	89	156	WP_337019773.1 stage IV sporulation protein A, partial [Oceanobacillus massiliensis]	diamond	408	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus massiliensis
30518413	30518413	PRJNA451191_P_NODE_42233_length_219_cov_1.607595_g41962_i0	PRJNA451191	42233	219	1.607595	3.52063305	Clostridia bacterium	2044939	Bacteria	Bacteria	42	0.0417	NR	MBQ3415788.1	2044939	g41962	i0	37.7	0.726027397260274	53	31	72.6	1	18	176	158	208	MBQ3415788.1 class B sortase [Clostridia bacterium]	diamond	159	42	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30613077	30613077	PRJNA451191_P_NODE_48413_length_208_cov_0.884354_g48142_i0	PRJNA451191	48413	208	0.884354	1.83945632	Ectobacillus panaciterrae	363872	Bacteria	Bacteria	41.6	0.0232	NR	WP_028402115.1	363872	g48142	i0	41	0.879807692307692	61	29	86.5	3	17	196	2	56	WP_028402115.1 fluoride efflux transporter CrcB [Ectobacillus panaciterrae]	diamond	183	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ectobacillus	Ectobacillus panaciterrae
31877593	31877593	PRJNA451191_P_NODE_45557_length_211_cov_0.866667_g45286_i0	PRJNA451191	45557	211	0.866667	1.82866737	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	60.1	1.91e-8	NR	MBS3812162.1	2094029	g45286	i0	67.4	0.611374407582938	43	14	61.1	0	156	28	362	404	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	129	60.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32636543	32636543	PRJNA451191_P_NODE_54860_length_202_cov_0.921986_g54589_i0	PRJNA451191	54860	202	0.921986	1.86241172	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	48.5	2.03e-4	NR	MBS3812162.1	2094029	g54589	i0	40.4	0.772277227722772	52	31	77.2	0	190	35	718	769	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	156	48.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales 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);;