metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1134759" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1134759" 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
27386614	27386614	PRJNA1134759_P_NODE_48743_length_253_cov_0.866667_g48567_i0	PRJNA1134759	48743	253	0.866667	2.19266751	Sediminibacillus albus	407036	Bacteria	Bacteria	94.7	3.61e-22	NR	WP_093216320.1	407036	g48567	i0	52.6	0.924901185770751	78	36	92.5	1	252	19	68	144	WP_093216320.1 RNA 2',3'-cyclic phosphodiesterase [Sediminibacillus albus]	diamond	234	94.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Sediminibacillus	Sediminibacillus albus
27596667	27596667	PRJNA1134759_P_NODE_55044_length_244_cov_0.912281_g54868_i0	PRJNA1134759	55044	244	0.912281	2.22596564	Bacillaceae	186817	Bacteria	Bacteria	97.8	7.93e-22	NR	WP_276703522.1	301148	g54868	i0	54.3	3.98360655737705	81	37	99.6	0	2	244	139	219	WP_276703522.1 M16 family metallopeptidase [Caldibacillus debilis]	diamond	972	97.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus debilis
27891470	27891470	PRJNA1134759_P_NODE_55025_length_244_cov_0.912281_g54849_i0	PRJNA1134759	55025	244	0.912281	2.22596564	Salibacterium salarium	284579	Bacteria	Bacteria	133	8.549999999999999e-38	NR	WP_125556713.1	284579	g54849	i0	72.5	0.983606557377049	80	22	98.4	0	242	3	31	110	WP_125556713.1 DUF6884 domain-containing protein [Salibacterium salarium]	diamond	240	133	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salibacterium	Salibacterium salarium
29490856	29490856	PRJNA1134759_P_NODE_52190_length_248_cov_0.891429_g52014_i0	PRJNA1134759	52190	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	43.5	0.0208	NR	WP_031585911.1	416586	g52014	i0	43.8	2.12903225806452	48	26	58.1	1	64	207	433	479	WP_031585911.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Selenomonas bovis]	diamond	528	43.5	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas bovis
29564993	29564993	PRJNA1134759_P_NODE_17590_length_383_cov_0.738710_g17414_i0	PRJNA1134759	17590	383	0.73871	2.8292593	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	173	2.2299999999999996e-47	NR	MBS3812162.1	2094029	g17414	i0	77.2	0.994778067885117	127	29	99.5	0	3	383	61	187	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	381	173	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
30038740	30038740	PRJNA1134759_P_NODE_11031_length_471_cov_2.130653_g10855_i0	PRJNA1134759	11031	471	2.130653	10.03537563	Planococcus shixiaomingii	3058393	Bacteria	Bacteria	64.7	7.75e-9	NR	WP_301723276.1	3058393	g10855	i0	31.8	0.961783439490446	151	99	93.6	2	31	471	169	319	WP_301723276.1 hypothetical protein [Planococcus shixiaomingii]	diamond	453	64.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus shixiaomingii
30323680	30323680	PRJNA1134759_P_NODE_55052_length_244_cov_0.912281_g54876_i0	PRJNA1134759	55052	244	0.912281	2.22596564	Bacillus songklensis	1069116	Bacteria	Bacteria	91.3	4.13e-20	NR	WP_377915312.1	1069116	g54876	i0	71.7	0.737704918032787	60	17	73.8	0	1	180	78	137	WP_377915312.1 transporter substrate-binding domain-containing protein [Bacillus songklensis]	diamond	180	91.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus songklensis
30733816	30733816	PRJNA1134759_P_NODE_9274_length_510_cov_2.372998_g9098_i0	PRJNA1134759	9274	510	2.372998	12.1022898	Planococcus shixiaomingii	3058393	Bacteria	Bacteria	52	2.66e-4	NR	WP_301723276.1	3058393	g9098	i0	28.2	0.917647058823529	156	96	88.2	4	478	29	9	154	WP_301723276.1 hypothetical protein [Planococcus shixiaomingii]	diamond	468	52	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus shixiaomingii
31112811	31112811	PRJNA1134759_P_NODE_50835_length_250_cov_0.881356_g50659_i0	PRJNA1134759	50835	250	0.881356	2.20339	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	53.1	8.59e-6	NR	MBS3812162.1	2094029	g50659	i0	64.1	0.468	39	11	43.2	1	138	245	690	728	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	117	53.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32505027	32505027	PRJNA1134759_P_NODE_53499_length_246_cov_0.901734_g53323_i0	PRJNA1134759	53499	246	0.901734	2.21826564	Bacillales bacterium	1904864	Bacteria	Bacteria	64.3	3.78e-11	NR	HET7578327.1	1904864	g53323	i0	93.8	0.390243902439024	32	2	39	0	97	2	1	32	HET7578327.1 DUF3870 domain-containing protein [Bacillales bacterium]	diamond	96	64.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales 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);;